----- Reply message ----- From: "Carson Longhorn" <875...@bugs.launchpad.net> To: <emun...@mgebm.net> Subject: [Bug 875440] Re: Cannot authenticate with saslauthd and mysql Date: Sat, Jun 23, 2012 01:21
The fix from Devin appears to have worked for me: # cat /etc/postfix/sasl/smtpd.conf pwcheck_method: saslauthd mech_list: plain login cram-md5 digest-md5 log_level: 7 allow_plaintext: true auxprop_plugin: sql sql_engine: mysql sql_hostnames: 127.0.0.1 sql_user: <user> sql_passwd: <pass> sql_database: <db> sql_select: select crypt from users where id='%u@%r' and enabled = 1 -- You received this bug notification because you are subscribed to the bug report. https://bugs.launchpad.net/bugs/875440 Title: Cannot authenticate with saslauthd and mysql Status in “cyrus-sasl2” package in Ubuntu: Confirmed Bug description: Upgraded from Natty to Oneiric and now I can no longer authenticate for out going mail using saslauthd. Initial server setup was done following these instructions (http://flurdy.com/docs/postfix/). With mysql logging enabled, user credentials are never selected with a login attempt. /var/log/auth.log with intermittently show: postfix/smtpd[4930]: sql auxprop plugin using mysql engine with login attempts and /var/log/mail.log shows: SASL LOGIN authentication failed: no mechanism available Every time. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/cyrus-sasl2/+bug/875440/+subscriptions -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to 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-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
