Re: [exim] Exim + MySQL + Aliases

Top Page
Delete this message
Reply to this message
Author: Rich Johnson
Date:  
To: exim-users
Subject: Re: [exim] Exim + MySQL + Aliases

On Feb 13, 2006, at 1:28 PM, Alvaro Marín wrote:

[...snip...]


> In router section, I have this:
>
> mysql_aliases:
>   driver = redirect
>   allow_fail
>   allow_defer
>   data = ${lookup mysql{ SELECT dest FROM aliases \
>             WHERE email='${local_part}@${domain}'}}

>
> And the aliases table is:
>
> +------------------------+-------------------+
> | email                  | dest              |
> +------------------------+-------------------+
> | user@???       | user@???  |
> +------------------------+-------------------+

>
>
> As I've said, I only want Exim to check if the domain of the
> incoming mail is "local" (is in DB), and then use mysql_aliases to
> redirect it to other direction.
>
> What I'am missing?


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?