Jim Cheetham, 2010-04-06 00:34:
>>> I'm using a sqlite query in a match_domain condition in an ACL for
>>> check_rcpt, but it's failing.
>> I suspect that what's happening is not that the where clause is failing,
>> but the sql return is not a domain list.
>> domainlist active_domains = ${sg { ${sqlite; /etc/exim4/mta.db select name
>> from domains where status="active"; }}{\\n}{:}}
> Ah, indeed -- this seems to be exactly the problem, and solved. Thanks.
even easier and with less cpu cycles (not that it mattes much :) is this:
domainlist active_domains = <\n ${lookup sqlite {/etc/exim4/mta.db
select name from domains where status="active"}}
All the SQL lookups return a LF-separated list. Exim should probably
handle LF as a separator by default, I guess...
--
## List details at http://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
