From: Lista de discussao (listasalpor.com.br)
Date: Thu Apr 10 2003 - 22:45:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello.

I have a trouble about mysql and postfix.

I had compile the mysql support with postfix. and i put the follow into my main.cf:

local_recipient_maps=mysql:/etc/postfix/mysql-relays.cf

and the /etc/postfix/mysql-relays.cf content is:

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'

I had no way to solut the trouble

Tnx a lot.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]