Comment 61 for bug 875440

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.