Upgrading broke my postfix+sasl+mysql auth, cripling my SMTP service. Because libsasl2-2 that was upgraded from 2.1.23 to 2.1.25.
I upgraded Debian Squeeze to Wheezy and most of it worked within acceptable parameters. There were problems, but nothing big, except that it killed my SMTP service. Upgrades, the gift that keeps on giving.
Many people offered that downgrading would fix things, but that can’t be the best solution. So I didn’t.
The update triggered the following error:
SASL LOGIN authentication failed: no mechanism available
This was fixed by commenting the “auxprop_plugin: mysql” line, ie not specifying the plugin. Thanks Marcel.
That yielded the following errors
sql plugin couldn't connect to any host
warning: SASL PLAIN authentication failed: generic failure
(gotta love “generic failure”. Generic: “characteristic of or relating to a class or group of things; not specific.” Not being able to connect to the database isn’t what I’d report as a “generic failure”)
This is where it gets a bit ludicrous. There is no changelog around and google didn’t help much either, until I got to reading the very long thread on the Ubuntu launchpad where “dbileck” mentioned sql_passw changing to sql_passwd. So a parameter changing, adding a “d” and breaking all reverse compatability.
Now, in all honesty, http://www.postfix.org/SASL_README.html#auxprop_sql has the correct parameter & not the old sql_passw, but a small note, mentioning the extra “d” would’ve helped a lot!
In the end, these are the changes to /etc/postfix/sasl/smtpd.conf that fixed it.
- auxprop_plugin: mysql
- sql_passw: XXX
+ sql_passwd: XXX
Oh, the pleasure of introducing small undocumented changes in config files.
And now I’m a happy camper again, my network scanner is able to mail documents again!
Edit: haha, a bit of a brain bubble, instead of Squeeze, I wrote Jesse. I’m guessing a short moment of confusion because I run “Jessie”, the current testing version on my laptop! No worries or weirdness though, a “simple” case of upgrade from Squeeze to Wheezy.