Re: [Exim] 2 mysql lookups in local_domains?

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: William X Walsh
CC: exim-users
Subject: Re: [Exim] 2 mysql lookups in local_domains?
On Sun, 26 Aug 2001, William X Walsh wrote:

> Is this possible? My initial experiment (below) failed, everything
> was lookup deferred.
>
> local_domains = elrond.dso.net:localhost:mysql;select domain_name from
> domain where domain_name='$key':mysql;select domain_name from
> other_domains where domain_name='$key'


1. Why did it defer? Did it give any clues? What you you get if you run

exim -d9 -bt xxx@domain

where domain is (or is not) in one or other of the tables?

2. I am not an SQL expert, but isn't there some way to write a single
query that does this?

-- 
Philip Hazel            University of Cambridge Computing Service,
ph10@???      Cambridge, England. Phone: +44 1223 334714.