Re: [Exim] local domains pgsql lookup misbehaving

Top Page
Delete this message
Reply to this message
Author: Paul Slootman
Date:  
To: exim-users
Subject: Re: [Exim] local domains pgsql lookup misbehaving
On Thu 06 Nov 2003, Nico Erfurth wrote:
> Paul Slootman wrote:
>
> >exim 4.24:
> >
> >I wanted to get the list of local domains also from the database, or at
> >least some of the local domains. I had this:
> >
> >domainlist VIRTUAL_DOMAINS = pgsql;SELECT DISTINCT domain FROM users;
>
> domainlist VIRTUAL_DOMAINS = pgsql;SELECT 1 from users where \
>                                    domain='$domain' LIMIT 1

>
> should work.


This is hardly a 'domainlist' type of value, though?

> >It clearly shows that the lookup resulted in pruts.net and wurtel.net.
> >And then states that gps.nl matched "+VIRTUAL_DOMAINS" ?!
> >
> >What am I doing wrong here?
>
> The lookup;-style checks for SOMETHING to be returned, NOT for the value
> itself. The above should work.


So exim has no way of obtaining a LIST of local domains at startup from
a postgresql database? Because what you suggest will only work for an
individual lookup at a time; I want it to set the domainlist
local_domains...


thanks,
Paul Slootman