View Single Post
  #4  
Old 18th August 2010, 18:18
Nicram Nicram is offline
Member
 
Join Date: Mar 2010
Location: PL
Posts: 60
Thanks: 22
Thanked 10 Times in 8 Posts
Send a message via ICQ to Nicram Send a message via AIM to Nicram Send a message via Yahoo to Nicram Send a message via Skype™ to Nicram
Default

Well thank You for reply
Well yes, i deleted the postfix from the CentOS repo and installed it manually like at tutorial already, step by step But it still do not work :/

I have find out with google that to fix those:
Code:
Aug 18 17:59:09 hosting postfix/smtpd[20283]: sql_select option missing
Aug 18 17:59:09 hosting postfix/smtpd[20283]: auxpropfunc error no mechanism available
i had to delete libsql* from /usr/lib/sasl2/ and /usr/lib64/sasl2 folders. And yes, it did help so there are no those errors anymore in /var/log/messages but there are still problems sending email, here is the log (messages):
Code:
Aug 18 17:59:15 hosting saslauthd[7129]: do_auth         : auth failure: [user=myname] [service=smtp] [realm=mydomain.com] [mech=pam] [reason=PAM auth error]
Well i'm closer to know... That i know nothing :S
i added debug into /etc/pam.d/smtp at end of the lines, and this is what /vat/log/secure gives me:
Code:
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - option debug is set to ""
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_close_db() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_sm_authenticate() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_open_db() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_open_db() returning 0.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_check_passwd() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_format_string() called
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_quick_escape() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - SELECT password FROM mail_user WHERE email = 'myname'
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - SELECT returned no result.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_check_passwd() returning 1.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_sql_log() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_sql_log() returning 0.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_converse() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_open_db() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_check_passwd() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_format_string() called
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - pam_mysql_quick_escape() called.
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - SELECT password FROM mail_user WHERE email = 'myname'
Aug 18 19:49:18 hosting saslauthd[26844]: pam_mysql - SELECT returned no result.
I dream about day, that someone will take all those devs, and learn them what KISS is all about :S

Last edited by Nicram; 18th August 2010 at 20:59.
Reply With Quote