Re: [exim] Misunderstanding match_domain and sqlite ...

Top Page
Delete this message
Reply to this message
Author: Jim Cheetham
Date:  
To: exim-users
Subject: Re: [exim] Misunderstanding match_domain and sqlite ...
On Tue, 2010-04-06 at 11:02 +0200, Jakob Hirsch wrote:
> Jim Cheetham, 2010-04-06 00:34:
> >> domainlist active_domains = ${sg { ${sqlite; /etc/exim4/mta.db select name from domains where status="active"; }}{\\n}{:}}


> 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"}}


That is more elegant in the config file; and config file elegance is
IMHO one of Exim's main strengths ...

http://www.exim.org/exim-html-4.69/doc/html/spec_html/ch06.html#SECID53
sort-of mentions the usage.
http://www.exim.org/exim-html-4.69/doc/html/spec_html/ch09.html#SECTsql
mentions that multiple rows come back separated by newline, but sadly
doesn't provide an example of "fixing" this for domain lists.

It took a while to find sg ...
http://www.exim.org/exim-html-4.69/doc/html/spec_html/ch11.html#SECTexpansionitems
I think I have a lot to read, again!

-jim