Bug#680478: libsasl2-modules-sql:i386: upgrade from Squeeze to Wheezy breaks due to MySQL changes

[Russell Coker]

Package: libsasl2-modules-sql
Version: 2.1.25.dfsg1-4+b1
Severity: normal

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=680476

I've just filed the above bug for the release notes, but it would be good
if this could be fixed in time for Wheezy instead.

Currently if you upgrade a working SASL - MySQL system from Squeeze to Wheezy
then it stops working.

In the configuration file (/etc/postfix/sasl/smtp.conf or equivalent for
other MTAs) the "auxprop_plugin: mysql" line has to be removed and replaced
with the following two lines due to a change in the way SQL plugins are
managed:

auxprop_plugin: sql
sql_engine: mysql

Also the SQL query needs to have "%u" replaced with "%u@%r" because we now
have user and realm provided separately.

It would be good if the postinst could at least inform the user of such
problems and ideal if it could offer to make the needed configuration changes
for the user.

-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 3.2.0-2-686-pae (SMP w/1 CPU core)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash

Versions of packages libsasl2-modules-sql:i386 depends on:
ii  libc6             2.13-33
ii  libmysqlclient18  5.5.24+dfsg-4
ii  libpq5            9.1.4-2
ii  libsasl2-modules  2.1.25.dfsg1-4+b1
ii  libsqlite3-0      3.7.13-1

libsasl2-modules-sql:i386 recommends no packages.

libsasl2-modules-sql:i386 suggests no packages.

-- no debconf information