Re: [Exim] mysql lookup for relay_domains

Top Pagina
Delete this message
Reply to this message
Auteur: Philip Hazel
Datum:  
Aan: Nancy Pettigrew
CC: exim-users
Onderwerp: Re: [Exim] mysql lookup for relay_domains
On Thu, 13 Jul 2000, Nancy Pettigrew wrote:

> Is this syntactically correct? (The Domains table just has a list of all
> the domains to relay for...)
>
> relay_domains = ${lookup mysql{select Domain from Domains}{$value}fail}


No. What you want is

relay_domains = mysql;select Domain from Domains

However, the query isn't right; it should be looking up the domain you
are interested in. Try

relay_domains = mysql;select Domain from Domains where Domain="$key"

The value of $key is the name of the domain you are testing.

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