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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs