[Exim] condition in director

Page principale
Supprimer ce message
Répondre à ce message
Auteur: o.cook
Date:  
À: exim-users
Sujet: [Exim] condition in director
I'm trying to get a condition for a director to work as follows.

1) Do an SQL query.
2) If no rows are returned, don't run the director, or
If one or more rows is returned, run the director.

I'm using:

condition = ${if {lookup mysql {MYSQL_AUTORESP}{$value}} {yes}{no}}

where MYSQL_AUTORESP is:

SELECT id FROM autoresponder WHERE address="${local_part}@${domain}"

The error i'm getting is:

marley:/usr/exim# sendmail -bt
> ollie

LOG: 0 MAIN PANIC DIE
failed to expand condition"${if {lookup mysql {SELECT id FROM
autoresponder WHERE address="${local_part}@${domain}"}{$value}} {yes}{no}}"
for uservacation_director director: "lookup mysql {SELECT id FROM
autoresponder WHERE address="ollie@???"" is not a number

Would anyone be kind enough to point me in the correct direction. I had a
look at the specification, but couldn't work this one out myself...

Regards,

Ollie