Autoreply Feature throws undelivered mail

Brought to you by: christian_boltz, gingerdog

This project can now be found here.

Autoreply Feature throws undelivered mail

Forum: Postfix Admin Discussion

Created: 2016-09-12

Updated: 2016-09-16

Ben - 2016-09-12

Hi,
I´ve updated to version 3 of postfixadmin and still my problem with autoreply feature persists at debian 8:

Command died with status 255:
"/var/spool/vacation/vacation.pl". Command output: Possible precedence
issue with control flow operator at /usr/share/perl5/Mail/Sender.pm line

2549. DBD::mysql::st execute failed: Unknown column 'activefrom' in 'where clause' at /var/spool/vacation/vacation.pl line 401, <STDIN> line 39. DBD::mysql::st execute failed: Unknown column 'activefrom' in 'where clause' at /var/spool/vacation/vacation.pl line 401, <STDIN> line 39.

How can I solve this?

Regards,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

GingerDog - 2016-09-12

I think your database needs updating - specifcally you're missing an 'activefrom' field in the vacation table.

Running 'upgrade.php' from a web browser may be sufficient to fix it.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ben - 2016-09-12

OK, I´ve done that and I got: Database is up to date.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ben - 2016-09-12

It seems that the problem is my database prefix. after deleting the old tables, which has no prefix, I got
"/var/spool/vacation/vacation.pl". Command output: Possible precedence
issue with control flow operator at /usr/share/perl5/Mail/Sender.pm line

2549. DBD::mysql::st execute failed: Table 'postfix.vacation' doesn't exist at /var/spool/vacation/vacation.pl line 401, <STDIN> line 39. DBD::mysql::st execute failed: Table 'postfix.vacation' doesn't exist at /var/spool/vacation/vacation.pl line 401, <STDIN> line 39.

The question is, why is this program searching for postfix.vacation instead of postfix.adm_vacation? After deleting all table prefixes and restarted all services it works.

Last edit: Ben 2016-09-12
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

GingerDog - 2016-09-12

I'd suggest you edit vacation.pl. I don't think it knows about custom/locally configured table prefixes.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rhys McWilliams - 2016-09-12

Your comment "after deleting the old tables", am I interpreting that correctly as in you've deleted the tables from the database?
If so, then that would be the reason for the table not found error.

You ask "why is this program searching for postfix.vacation instead of postfix.adm_vacation" but haven't mentioned whether you've setup $CONF['database_prefix'] in your config file. If you're expecting the code to look for the table with a prefix of "adm_" then you need to define that as the database_prefix, unless I'm missing something here...

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ben - 2016-09-16

Hi,
I´ve set a table prefix at my config and the correct tables had the prefix adm, but since I´ve removed the table prefix at the table and at the config all is working, so I think, that the problem is a table prefix, which causes the problem, because it is not mentioned when the query should hit the active from table.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.