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

Top Page
Delete this message
Reply to this message
Author: Stephen Gran
Date:  
To: exim-users
Subject: Re: [exim] Misunderstanding match_domain and sqlite ...
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 |                                         |

--------------------------------------------------------------------------