Re: [Exim] mysql lookup

Góra strony
Delete this message
Reply to this message
Autor: Dan Egli
Data:  
Dla: palmeida
CC: Exim User's Mailing List
Temat: Re: [Exim] mysql lookup
Paulo Almeida wrote:
> I've upgrade exim 3 to exim 4.30.
> Users are stored in a mysql database.
> Everything works fine, except a little problem that i can't resolve.
> When a message it's sent to an existent user, exim returns the follow
> message to the sender:
>
> [...]
>  unknow_user@???
>     Failed to expand group string "${lookup mysql{ SELECT gid FROM users
> WHERE id='${local_part}'}{$value}fail}" for the maildir_home
> transport:
>  "lookup" failed and "fail" requested: retry timeout exceeded

>
> How can i change this to anything else like "Delivery to the following
> recipients failed - unknow_user@???"?
>
> Thanks
> Paulo
>
>
> [MY ROUTER]
> local_user:
> debug_print = "R: local_user for $local_part@$domain"
> driver = accept
> transport = maildir_home
>
>
> [MY TRANSPORT]
> maildir_home:
>   debug_print = "T: maildir_home for $local_part@$domain"
>   driver = appendfile
>   directory = ${lookup mysql{ SELECT maildir FROM users \
>                 WHERE id='${local_part}'}{$value}fail}
>   user = ${lookup mysql{ SELECT uid FROM users \
>                 WHERE id='${local_part}'}{$value}fail}
>   group = ${lookup mysql{ SELECT gid FROM users \
>                 WHERE id='${local_part}'}{$value}fail}
>   delivery_date_add
>   envelope_to_add
>   return_path_add
>   maildir_format

>


Can you provice us with a sample listing from your database? Is it
always this one user or any user?