Author: Warren Baker Date: To: exim-users Subject: Re: [exim] sql query vs dsearch
On 14/01/2008, Brent Clark <brentgclarklist@???> wrote: >
> Hi
>
> Im using mysql for my virtual setup, and i recently found that for some
> reason if i on purposely try to send to a supposed unrouteable address,
> then
> the router "dnslookup_relay_to_domains", matches its conditions.
>
> I narrowed it down to my local domains entry
>
> So my question is, whats the difference between
>
> domainlist local_domains = MAIN_LOCAL_DOMAINS :
> dsearch;/etc/exim4/virtual_directory
>
> vs
>
> DOMAINLIST_FULL = SELECT DISTINCT domain FROM user
> domainlist local_domains = MAIN_LOCAL_DOMAINS : DOMAINLIST_FULL
Try "SELECT DISTINCT domain FROM user WHERE domain =
'${quote_mysql:$domain}' so that it will only return a match if the domain
is found.