Re: [Exim] local_domains & MySQL trouble

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: james
CC: exim-users
Subject: Re: [Exim] local_domains & MySQL trouble
On Sat, 20 Jul 2002 james@??? wrote:

> # This doesn't work:
> domainlist local_domains = \
>   ${lookup mysql {SELECT domain FROM domains \
>     WHERE type="local" }}


*How* doesn't it work? Have you run tests with debugging? What was the
output?

> # This does:
> domainlist local_domains = grickle.org : anti.grickle.org


So, does the result of that lookup yield "grickle.org : anti.grickle.org"?

> mysql> SELECT domain FROM domains
>     -> WHERE type="local";
> +------------------+
> | domain           |
> +------------------+
> | grickle.org      |
> | anti.grickle.org |
> +------------------+


Looks like your lookup won't yield a colon separated list...

Find out how the list is separated, then read about the $sg{ expansion
item.

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