hi,
i've a director like this:
mysql_user:
driver = smartuser
condition = ${lookup mysql{select domain from mail where
domain='${domain}' and username='${local_part}' and
is_alias='no'}{$value}fail}
transport = mysql_delivery
it happens that some user make a mistake in the To: field
(like 'user@??? - notice the "'")
exim spools this mail and never write an errormessage back.
this is the log:
(1999-11-25 11:50:16 11qwSJ-0003vd-00 failed to expand condition"${lookup
mysql{select domain from mail where domain='${domain}' and
username='${local_part}' and is_alias='no'}{$value}fail}" for mysql_user
director: lookup of "select domain from mail where domain='my_doma.in' and
username=''my_username' and is_alias='no'" gave DEFER: MYSQL: query
failed: You have an error in your SQL syntax near 'my_username' a
nd is_alias='no'' at line 1)
do you know any sollutions?
robert
---
di. robert rotman inode.graz
phone -> ++43-(0)316 811451 ++43-(0)316 811451 <- fax
rotman@??? http://www.graz.inode.at/
--
this letter was written on recycled bytes used by deleted mail.
