Debian Squeeze to Wheezy dist-upgrade breaks sasl+mysql

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.

Published by Gert

Person-at-large.

One thought on “Debian Squeeze to Wheezy dist-upgrade breaks sasl+mysql

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: