Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 6th May 2008, 11:31
punkracy punkracy is offline
Junior Member
 
Join Date: May 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default UNKNOWN_USER'@'localhost' configuring postfix

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
Reply With Quote
Sponsored Links
  #2  
Old 7th May 2008, 17:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Please make sure that you have the correct user name and password in the mysql*.cf files.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 8th May 2008, 12:31
punkracy punkracy is offline
Junior Member
 
Join Date: May 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
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
Reply With Quote
  #4  
Old 9th May 2008, 15:31
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
 
Default

Quote:
Originally Posted by punkracy
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/sho...ailbox_domains


Quote:
Originally Posted by punkracy
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
http://www.howtoforge.com/forums/sho...prop_plug_init
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail System Error - Returned Mail tristanlee85 General 16 16th March 2008 10:40
Postfix: connection refused error tosin Server Operation 1 30th October 2007 18:30
Issues with Postfix using "Virtual Users And Domains With Postfix, Courier And MySQL" Kyse HOWTO-Related Questions 15 6th January 2007 16:35
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 16:47
Verify email setup meekish Installation/Configuration 28 27th October 2006 16:36


All times are GMT +2. The time now is 11:08.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.