Re: [Exim] local domains pgsql lookup misbehaving

Top Page
Delete this message
Reply to this message
Author: Nico Erfurth
Date:  
To: Paul Slootman
CC: exim-users
Subject: Re: [Exim] local domains pgsql lookup misbehaving
Paul Slootman wrote:

> exim 4.24:
> I'm trying to set up a virtual user email system using exim4, postgrsql
> and dovecot for IMAP and POP3 services, as other setups didn't agree
> with me.
>
> I've come quite a long way in the right direction, insofar as what I
> wanted to do now actually works. But then I found that outgoing
> messages were being bounced as being unroutable...
>
> 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.

[....]
> 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.

Nico