[Exim] condition in director

トップ ページ
このメッセージを削除
このメッセージに返信
著者: o.cook
日付:  
To: exim-users
題目: [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