Auteur: Andy Smith Datum: Aan: exim-users Onderwerp: 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?