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

[Tim Mann]

Hi. I've very new to Ubuntu but came across this exact same problem when
setting up a mail server. I've been following the Flurdy tutorial line
by line from a fresh server install. When I got to the SASL step I got
the magic 'mech not available message'.

I carried out the following edits:

(This is the original file on the Flurdy site):

pwcheck_method: saslauthd
mech_list: plain login cram-md5 digest-md5
log_level: 7
allow_plaintext: true
auxprop_plugin: mysql
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: mail
sql_passw: mailPASSWORD
sql_database: maildb
sql_select: select crypt from users where id='%u@%r' and enabled = 1

I changed this file to:

pwcheck_method: saslauthd
mech_list: plain login pam
log_level: 7
allow_plaintext: true
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: mail
sql_passwd: mailPASSWORD
sql_database: maildb
sql_select: select crypt from users where id='%u@%r' and enabled = 1

(database name and pw are from the sample not my own!)

Note the changes to the 3 lines 'mech_list', 'auxprop_plugin' changed to
'sql' rather than 'mysql' and 'sql_passw' changed to 'sql_passwd'.

Before I changed this last one I was getting 'generic error'.

After the above changes I restarted both post fix and saslauthd. It then
worked fine. I don't have TLS yet as I haven't got to that part of the
doc. But as I said this is using 12.04 from a clean install and
following that tutorial line by line. I hope this is of use to someone.

-- 
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