Author: Nico Erfurth Date: To: William Thompson CC: exim-users Subject: Re: [Exim] SQL connection problem with -bh
William Thompson wrote: > This is exim 4.14
> SQL queries work fine until it hit the data acl.
>
>
>>>>using ACL "acl_check_data"
>>>>processing "deny"
>>>>check sender_domains = +local_domains
>
> LOG: 19D5zI-0000k6-UX failed to expand "localhost : /etc/exim4/localdomains
> : ${lookup mysql{select domain from eximconf.localdomains where
> enabled='yes' } {${sg{$value}{\N\ *\n\N}{ : }}} }" while checking a list:
> lookup of "select domain from eximconf.localdomains where enabled='yes' "
*SIGH* People, please use the "short/commandstyle" form of lookups in lists.
mysql;select 1 from eximconf.localdomains where domain=$domain \
and enabled='yes'
