Re: [Exim] Basic Exim+SQL

Top Page
Delete this message
Reply to this message
Author: Steve
Date:  
To: Nico Erfurth
CC: exim-users
Subject: Re: [Exim] Basic Exim+SQL
> domainlist local_domains @:localhost:mysql;select 1 from local_domains \
> where domain='${quote_mysql:$domain}'



Ah... the following works fine!

domainlist local_domains = @:localhost:${lookup mysql{select domain from
local_domains where domain='${quote_mysql:$domain}'}}

ok... another question, I have a table of E-Mail addresses that I need to
bounce (Which also does not work).

In my acl_check_rcpt: section I have the following line...

deny senders = ${lookup mysql {SELECT target FROM bounce}}

I assume here that I will also need to change the query so that only one
item is returned?
Sort of like (Only I'm not sure what to use for $sender)...

deny senders = ${lookup mysql {SELECT target FROM bounce WHERE
target='${quote_mysql:$sender}'}}

Steve