[Bug 875440] Re: Cannot authenticate with saslauthd and mysql

[Panos Asimakopoulos]

I'd like to share my experience with this issue.

I'm also following the Flurdy tutorial for setting up postfix
(http://flurdy.com/docs/postfix/), which used to work perfectly fine on
my Ubuntu 10.04 installation. However on a fresh 12.04 (AMD64)
installation with all recent upgrades I'm experiencing the issue
described in this bug report.

As was mentioned above, with the original setting of "sql_engine:
mysql", mail.log reports "SASL PLAIN authentication failed: no mechanism
available". So change this to: "sql_engine: sql"

Also with "sql_passw: <mailPASSWORD>", mail.log reports "SASL PLAIN
authentication failed: generic failure". So change this to: "sql_passwd:
<mailPASSWORD>"

However I was still getting a "SASL LOGIN authentication failed:
authentication failure" in mail.log and a "PAM (smtp) illegal module
type: host=127.0.0.1" in auth.log. I found out that when I copy-pasted
the contents of /etc/pam.d/smtp from the Flurdy site I had accidentally
created 2 lines per entry in /etc/pam.d/smtp:

(2 lines per entry):
auth required pam_mysql.so user=mail passwd=aPASSWORD 
			host=127.0.0.1 db=maildb table=users usercolumn=id passwdcolumn=crypt crypt=1
account sufficient pam_mysql.so user=mail passwd=aPASSWORD 
			host=127.0.0.1 db=maildb table=users usercolumn=id passwdcolumn=crypt crypt=1

Which I corrected to:

(1 line per entry):
auth required pam_mysql.so user=mail passwd=aPASSWORD host=127.0.0.1 db=maildb table=users usercolumn=id passwdcolumn=crypt crypt=1
account sufficient pam_mysql.so user=mail passwd=aPASSWORD host=127.0.0.1 db=maildb table=users usercolumn=id passwdcolumn=crypt crypt=1

After restarting /etc/init.d/saslauthd restart and /etc/init.d/postfix
restart everything worked as expected.

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to cyrus-sasl2 in Ubuntu.
https://bugs.launchpad.net/bugs/875440

Title:
  Cannot authenticate with saslauthd and mysql

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/cyrus-sasl2/+bug/875440/+subscriptions