vacation notification

Looks like a nice MySQL error :)

It could be a permissions issue in /var/lib/mysql[/data] ?

problem solved.

I have made svn upin the postfixadmin directory, so when I tried to create the  new table vacation_notification there was a problem related to the fact table vacation has been changed in order to colaborate with table notification. So I deleted the actual table notification and I created the new one, after that i could create table vacation_notification.

Thanks anyway

Hi
Here I'm again.
Now I am in face of the real problem configuring virtual vacation.
The mail does not arrive to destination. The localuser receive the mail but the sender never receive the mail send by vacation.pl the debug logs shows that

====== 2007/10/08 12:18:22 ======
[STRIP RECIPIENTS]:  | <168296.68108.qm@web27701.mail.ukl.yahoo.com> | filier@exemple.com
====== 2007/10/08 12:18:22 ======
[FOUND VACATION]:  | <168296.68108.qm@web27701.mail.ukl.yahoo.com> | tes456@yahoo.es | filier@exemple.com | filier@exemple.com

Thanks In advance.

I'd need to see more logs, I'm afraid.

Hy I know am late here are other logs..
Oct 11 15:37:05 mail postfix/pipe[5423]: 0CD7D374A1: to=<user@mydomain>, relay=dovecot, delay=0.12, delays=0.07/0.01/0/0.03, dsn=2.0.0, status=sent (delivered via dovecot service)
Oct 11 15:37:05 mail dovecot: imap-login: Login: user=<user2@mydomain>, method=PLAIN,
Oct 11 15:37:05 mail postfix/pipe[5424]: 0CD7D374A1: to=<user#mydomain@autoreply.mydomain>, orig_to=<user@mydomain>, relay=vacation, delay=0.24, delays=0.07/0.02/0/0.15, dsn=2.0.0, status=sent (delivered via vacation service)
Oct 11 15:37:05 mail postfix/qmgr[3399]: 0CD7D374A1: removed.

Thanks

I works now , but there is a bug. when I desactivate vacation the script vacation.php adds a second coma insted of removing the firstone to the register goto in the table alias. that's why it was not working for me. I would like to fix it myself but I am not a programmer.
Thanks

I think the problem is here a piece from vacation.php
.
.
// add the goto record back in...
$comma = '';
if(strlen($tGoto) > 1) {
$comma = ',';
}
$goto = $tGoto . $comma . $vacation_goto;

$result = db_query ("UPDATE $table_alias SET goto='$goto',modified=NOW() WHERE address='$USERID_USERNAME'");
if ($result['rows'] != 1)
{
$error = 1;
$tMessage = $PALANG['pUsersVacation_result_error'];
}
.
.
Anyone could take a look? if a user deactivate vacation the goto field should return to normal. actualy this is wath happen:

mysql> select * from alias where address='user@mydomain';
+-----------------+-----------------+---------------------+---------------------+---------------------+--------+
| address | goto | domain | created | modified | active |
+--------------------------+------------------------------+---------------------+---------------------+--------+
| user@mydomain | user@mydomain,, | mydomain | 2007-09-23 06:06:39 | 2007-10-11 18:58:45 | 1 |
+--------------------------+------------------------------+---------------------+---------------------+--------+

but normally thr goto field should be like this:

+-----------------+-----------------+---------------------+---------------------+---------------------+--------+
| address | goto | domain | created | modified | active |
+--------------------------+------------------------------+---------------------+---------------------+--------+
| user@mydomain | user@mydomain | mydomain | 2007-09-23 06:06:39 | 2007-10-11 18:58:45 | 1 |
+--------------------------+------------------------------+---------------------+---------------------+--------+

Any Idea?
Thanks

Thanks for catching the goto comma bug :)
David

You are welcome
:-)