Re: [exim] which config file is being read?

Top Page
Delete this message
Reply to this message
Author: Andy Smith
Date:  
To: exim-users
Subject: Re: [exim] which config file is being read?
Hmm, unfortunately making this change has broken my exim. I see this mysql
error as a result:

2008-09-28 13:55:14 [83097] 1Kjvnu-000LcD-6y == a.smith@???
R=virtual_forward defer (-1): failed to expand "${lookup mysql { select
remote_name from forwarder left join domain_alias on
domain_alias.domain_name = forwarder.domain_name where local_part =
${quote_mysql:$local_part} and (forwarder.domain_name = '$domain' or alias =
'$domain') }}": lookup of "select remote_name from forwarder left join
domain_alias on domain_alias.domain_name = forwarder.domain_name where
local_part = a.smith and (forwarder.domain_name = 'ukgrid.net' or alias =
'ukgrid.net') " gave DEFER: MYSQL: query failed: Unknown column 'a.smith'
in 'where clause'\n

I suppose its a result of the number of curly brackets used in the
statement, but Im not sure how to write this properly. Any suggestions?

thanks a lot Andy.