Re: [exim] Vacation rule frm to date

Startseite
Nachricht löschen
Nachricht beantworten
Autor: Jeremy Harris
Datum:  
To: exim-users
Betreff: Re: [exim] Vacation rule frm to date
On 03/03/2020 13:36, Sławomir Dworaczek via Exim-users wrote:
> uservacation:
>     driver = accept
>     domains = ${lookup mysql{SELECT domains.fqdn AS domain FROM domains,mailboxes,vacations WHERE \
>                    vacations.active=1 AND \
>                    vacations.mailbox_id=mailboxes.id AND \
>                    mailboxes.active=1 AND \
>                    mailboxes.local_part='${quote_mysql:$local_part}' AND \
>                    mailboxes.domain_id=domains.id AND \
>                    domains.active=1 AND \
>                    domains.fqdn='${quote_mysql:$domain}'}}

>
>
> it's possible add start date and end date autoreply ?
> eg. if current date > startdate and current date < stopdate


If you're wanting to do that as part of the mysql
lookup (which seems reasonable) then you're asking
in the wrong place; it's a mysql syntax problem.
--
Cheers,
Jeremy