On 12/05/06, oleg@??? <oleg@???> wrote:
> Good day! I am storing all my clients id and aliases in mysql database. I
> would like to have *@domain.name in aliases so if an adress for a
> specified domain have that line , to catch all non-existent adresses. I
> have read in the
> "The Exim Specification, 6.6 Default values in single-key lookups" that i
> can use something like that:
>
> mysql_users_aliases:
> driver = redirect
> file_transport = address_file
> pipe_transport = address_pipe
> data = ${lookup mysql{ SELECT id FROM users \
> WHERE id='${quote_mysql:${local_part}@${domain}}' }} \n \
> ${lookup mysql*@{SELECT sendto FROM aliases \
> WHERE (username='$local_part' AND domainname='$domain')}}
Not sure how that was meant to work....
I use 2 separate routers for this - the specific one first, then fall
through to a second which specifically looks for a '*' entry in the
mysql aliases table.
Peter
--
Peter Bowyer
Email: peter@???