Re: [exim] Exim + MySQL + Aliases

Rich Johnson wrote:

Hi,

Thx for your answer.

> Just a shot in the dark here, but is exim reaching the mysql_aliases
> router?
>
> ''exim -bt -v user@???'' should show the routers attempted.
>
> The query looks well formed to me. If mysql_aliases is reached, what
> query shows up in your mysql query log?

# exim4 -bt -v user@???
user@???
     <-- user@???
   router = dnslookup, transport = remote_smtp
   host domain2.com [XX.XX.XX.XX] MX=0

MySQL logs:

060214  9:42:37      88 Connect     exim@localhost on maildb
                      88 Query       SELECT dest FROM aliases WHERE 
email='user@???'
                      88 Query       SELECT dest FROM aliases WHERE 
email='user@???'
                      88 Query       SELECT domain FROM domains WHERE 
type="local" and domain="domain2.com"

All looks fine but message is in the queue and no logs is given (only
Received one).

Thanks for your help.

Regards,
Alvaro.