6.0.0-beta1
8/11/25

[#9029] Vacation not updating postfixadmin tables correctly
Summary Vacation not updating postfixadmin tables correctly
Queue Vacation
Queue Version 3.2.1
Type Bug
State Not A Bug
Priority 2. Medium
Owners
Requester lorenzettoluca (at) provincia (dot) treviso (dot) it
Created 05/17/2010 (5565 days ago)
Due
Updated 11/13/2013 (4289 days ago)
Assigned 07/01/2011 (5155 days ago)
Resolved 11/13/2013 (4289 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
11/13/2013 03:58:59 AM Michael Slusarz Comment #10
State ⇒ Not A Bug
Reply to this comment
Vacation no longer exists.  Marking as not a bug.
07/01/2011 08:21:09 PM Jan Schneider State ⇒ Assigned
 
02/17/2011 04:28:42 PM razor (at) meganet (dot) net Comment #9 Reply to this comment
just a tip i ended up using INGO with dovecot sieve and it sets up the 
vacation/forwards with not issues and it doesnt touch the mysql DB as 
it would with postfixadmin driver.
so thats one way to get around it and probably why this project isn't 
moving forward.

02/16/2011 05:09:18 PM razor (at) meganet (dot) net Comment #8 Reply to this comment
what is the latest on this i can also confirm that the vacation module 
is not updating the postfixadmin alias table.
12/27/2010 08:23:11 AM lorenzettoluca (at) provincia (dot) treviso (dot) it Comment #7 Reply to this comment
Hi,
i just patched my vacation 3.2 with you patch but i get
Fatal error: Class 'Forwards_Driver' not found in 
/var/www/horde/vacation/lib/Driver/luxpa.php on line 16

I've installed also forwards but does not change...

12/24/2010 10:21:04 PM horde (at) iotti (dot) biz Comment #6
New Attachment: horde-forwards.3.2.postfixadmin.2.patch Download
Reply to this comment
I created a driver for the forwards modules too, which takes into 
account the issues posed by the interaction with vacation and 
postfixadmin (a vacation set is internally a special forward, but the 
user is not supposed to know this. So in my opinion the forwards 
module should not show tha vacation forward, if any, and should not 
remove it handles othars forwardings). You can find my driver in the 
atachment.
12/24/2010 10:14:51 PM horde (at) iotti (dot) biz Comment #5
New Attachment: horde-vacation.3.2.postfixadmin.virtualvacation.3.patch Download
Reply to this comment
I can confirm the issue: the postfixadmin driver included in 
vacation-3.2.1 does not touch the alias table, which is required in a 
postfixadmin setup for mail to be handled by the reply script.
I created a driver called luxpa which does that. I have maintained my 
own version of this driver for years now, and so did many other Horde 
and PA users. So having support for postfixadmin has always been quite 
a common request, and it would be nice to have some working support in 
the stock ditribution.
See the attachment for my driver. The status is it works on my systems.
11/15/2010 06:47:37 PM marcos (dot) olivos (at) yahoo (dot) cl Comment #4 Reply to this comment
I have the same trouble with vacation 3.2.1 and postfixadmin 2.3.1.
the alias table for postfixadmin is not updated, so the "vacation" 
postfix transport is not called.



10/21/2010 04:53:29 PM Jan Schneider Comment #3
State ⇒ Feedback
Reply to this comment
I'm not sure what to say. The current implementation seems to work for 
anybody else, and I personally don't use postfixadmin at all. I have 
no idea if this depends on the version or some setup. And I don't want 
to break the driver for everybody else.
05/18/2010 07:11:02 AM lorenzettoluca (at) provincia (dot) treviso (dot) it Comment #2 Reply to this comment
I created 2 stored procedures in mysql to be called by postfixadmin 
query_set and query_unset with

CALL BackVacation(\U)

and

CALL GoVacation(\U,\S,\M,\D)

------------------
CREATE DEFINER=`root`@`localhost` PROCEDURE `BackVacation`( IN vemail 
VARCHAR( 255 ) )
BEGIN
DELETE FROM vacation WHERE email = vemail;

UPDATE alias SET goto = vemail WHERE address = vemail;

END
--------------------
CREATE DEFINER=`root`@`localhost` PROCEDURE `GoVacation`( IN vemail 
VARCHAR( 255 ) , IN vsubject VARCHAR( 255 ) , IN vbody TEXT, IN 
vdomain VARCHAR( 255 ) )
BEGIN
REPLACE INTO vacation( email, subject, body, domain, created, active ) 
VALUES (vemail, vsubject, vbody, vdomain, NOW() , 1);

UPDATE alias SET goto = CONCAT( goto, CONCAT( CONCAT( ", ", goto ) , 
"@autoreply.provincia.treviso.it" ) ) WHERE address = vemail;

END
---------------


the only problem i have is in customsql.php lines 91 and 137 because 
call of a stored procedure does not return the affected rows
05/17/2010 09:18:53 AM lorenzettoluca (at) provincia (dot) treviso (dot) it Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Vacation not updating postfixadmin tables correctly
Queue ⇒ Vacation
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
Hi,

while setting an user in vacation state with vacation 3.2.1 the alias 
table of postfixadmin is not updated. I get the entry on the vacation 
table but the user alias is not set to "user@domain, 
user@domain@autoreply.domain", as is set by the function of 
postfixadmin autoresponder. So on web interface the users thinks to be 
in vacation but there are not emails sent back to the sender.


Saved Queries