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

[Eric Munson]

----- Reply message -----
From: "Carson Longhorn" <875440 at bugs.launchpad.net>
To: <emunson at 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
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