Re: [Exim] SQL connection problem with -bh

Top Page
Delete this message
Reply to this message
Author: William Thompson
Date:  
To: Nico Erfurth
CC: exim-users
Subject: Re: [Exim] SQL connection problem with -bh
> >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'


Sorry, nico, I tried that 'short' form and it didn't work. This is in the
domain list "local_domains" and when it expands during a MAIL FROM: command,
$domain is empty thus it doesn't work.