On Tue, Apr 06, 2010 at 10:34:07AM +1200, Jim Cheetham said:
> On Mon, 2010-04-05 at 17:10 +0100, Stephen Gran wrote:
> > On Mon, Apr 05, 2010 at 09:25:36PM +1200, Jim Cheetham said:
> > > 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.
>
> I hadn't found ${sg before, this will be very useful!
Glad to be of help.
Enjoy,
--
--------------------------------------------------------------------------
| Stephen Gran | Q: Why did the chicken cross the road? |
| steve@??? | A: He was giving it last rites. |
| http://www.lobefin.net/~steve | |
--------------------------------------------------------------------------