OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: --- Mysql + local_recipient_maps = (unknown user: "conla")

From: Andrea Tassinari (andrea.tassinaritiscalinet.it)
Date: Fri Apr 11 2003 - 01:30:24 CDT

At 00.45 11/04/2003 -0300, Lista de discussao wrote:

>user=username
>password=password
>dbname=postfix
>table=mailusertable
>select_field=username
>where_field=mailaddr
>hosts=localhost
>
>the follow row in my mailusertable:
>
>username password mailaddr status
>user1 xxxxx user1domain.com 1
>user2 xxxxx user2domain.com 1
>user3 xxxxx user3domain.com 1
>
>Postfix's local division just put a line in my sys log:
>Apr 9 16:16:16 www postfix/local[10852]: 5E851597C6:
>to=<user2domain.com>, relay=local, delay=0,
>status=bounced (unknown user: "user2">
>
>
>mysql.log :
>
>030410 22:51:16 181 Query select username from postfix where
>mailaddr = 'user2domain.com'
                                                                                     ^^^^^^^^^^
The table's being read is "postfix" not "mailusertable" (as stated in
/etc/postfix/mysql-relays.cf). Do you have other mysql conf files for
postfix? how is the connect and use lines in mysql query log?

Andrea