PDA

View Full Version : UNKNOWN_USER'@'localhost' configuring postfix


punkracy
6th May 2008, 11:31
Hi,
I've followed "Virtual Users And Domains With Postfix, Courier And MySQL (Ubuntu 7.10)" tutorial. At the end I'm getting following error in:
/var/log/mail.log:
May 4 06:43:13 punkracy postfix/cleanup[22340]: warning: connect to mysql server 127.0.0.1: Access denied for user 'UNKNOWN_USER'@'localhost' (using password: YES)
of course I can connect to db using mysql client and providing correct password. I think that there's a problem with pam. Postfix doesn't read /etc/pam.d/smtpd (I've tried also /etc/pam.d/smtpd)

Because of that he cannot authorize user (check if that user exist in db), so he thinks that there is relay (i think that is because of this)

Do you have any ideas?

Best regards

falko
7th May 2008, 17:56
Please make sure that you have the correct user name and password in the mysql*.cf files.

punkracy
8th May 2008, 12:31
Please make sure that you have the correct user name and password in the mysql*.cf files.
Yes, they are correct for sure. It seems like it (postfix?) don't even use those (or pam) files and values.
I'm also getting following errors:
mail.log
warning: do not list domain punkracy.com in BOTH mydestination and virtual_mailbox_domains
warning: 090E8B40EB7: virtual_alias_maps map lookup problem for postmaster@punkracy.com
and
451 4.3.0 Error: queue file write error


auth.log
May 4 06:31:26 punkracy postfix/smtpd[22303]: sql_select option missing
May 4 06:31:26 punkracy postfix/smtpd[22303]: auxpropfunc error no mechanism available
May 4 06:31:26 punkracy postfix/smtpd[22303]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql

but i'm having select in /etc/postfix/mysql*.cf
query = SELECT ....
and in /etc/postfix/sasl/smtpd.conf
sql_select: select password from users where email = '%u'

Thanks in advance

falko
9th May 2008, 15:31
Yes, they are correct for sure. It seems like it (postfix?) don't even use those (or pam) files and values.
I'm also getting following errors:
mail.log
warning: do not list domain punkracy.com in BOTH mydestination and virtual_mailbox_domains
warning: 090E8B40EB7: virtual_alias_maps map lookup problem for postmaster@punkracy.com
and
451 4.3.0 Error: queue file write error
http://www.howtoforge.com/forums/showthread.php?t=10868&highlight=listed+mydestination+virtual_mailbox_dom ains


auth.log
May 4 06:31:26 punkracy postfix/smtpd[22303]: sql_select option missing
May 4 06:31:26 punkracy postfix/smtpd[22303]: auxpropfunc error no mechanism available
May 4 06:31:26 punkracy postfix/smtpd[22303]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql

but i'm having select in /etc/postfix/mysql*.cf
query = SELECT ....
and in /etc/postfix/sasl/smtpd.conf
sql_select: select password from users where email = '%u'

Thanks in advancehttp://www.howtoforge.com/forums/showthread.php?t=2197&highlight=_sasl_plugin_load+failed+sasl_auxprop_pl ug_init