[Exim] auto-reply for mysql transport

Top Page
Delete this message
Reply to this message
Author: ketvin
Date:  
To: exim-users
Subject: [Exim] auto-reply for mysql transport
This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I am setting up auto-responder in my exim box, where the current transport i have is :--

mysql_vacation:
driver = accept
condition = ${if eq{}{${lookup mysql {SELECT home FROM passwd WHERE id='${local_part}\@${domain}' AND vacation=1}}}{no}{yes}}
transport = mysql_vaca
unseen

it grab a path "/path/to/user/" from the mysql databases, it stop running lately.



I need to redesign the thing, is it possible that i create a vacation table in mysql, with user, reply column, so whenever one send mail to me with auto-responder activated, exim will look up the vacation table, get the specific reply for that user, and auto-reply to the sender ?

If it is possible, what should i put in my exim.conf ? thanks !

--