Re: [Exim] local_domains & MySQL trouble

Inizio della pagina
Delete this message
Reply to this message
Autore: James Harr
Data:  
To: exim-users
CC: ph10
Oggetto: Re: [Exim] local_domains & MySQL trouble
Sorry,

I got it working, I don't think the conversation between me and another
person got posted because I have a nasty habbit of forgetting to use 'reply-
all'.

All I had to do was add "AND domain='${domain}'" since the domainlist's are
all dynamically generated.

Philip Hazel said:
> 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.



James Harr <james@???>
http://www.grickle.org