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 |
State ⇒ Not A Bug
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.
is not updating the postfixadmin alias table.
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...
New Attachment: horde-forwards.3.2.postfixadmin.2.patch
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.
New Attachment: horde-vacation.3.2.postfixadmin.virtualvacation.3.patch
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.
the alias table for postfixadmin is not updated, so the "vacation"
postfix transport is not called.
State ⇒ Feedback
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.
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
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Vacation not updating postfixadmin tables correctly
Queue ⇒ Vacation
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
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.