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
