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

[Dario Nuevo]

So I tried to verify the upgrade consequences - I cloned my physical
server into a VM and made the distribution upgrade from Oneiric to
Precise.

First let me state (and this has nothing to do with this bug *g), that
the upgrade experience as really a pain in the a*s! Incredible..
AppArmor gets re-enabled which breaks a lot of stuff, you get prompted
for a MySQL password change 5 times, Apache doesn't work anymore (have
to figure that out) and so on - *major* annoyances to say it friendly
;-(

Conclusion
--------------
Anyway.. my conclusion is positive: The configuration I provided in comment #34 (see there) still works with the newest packages in Precise without any relinking and/or downgrading! At least in my case..

The "generic error"
------------------------
It didn't work out of the box - I DID GET the "generic error" message directly after the upgrading.
Turns out, that it was an error with MySQL. MySQL gets upgraded to 5.5..

It seems that the database variable "open_files_limit" comes with a
default value of 1024 after the upgrade. This is really low and reached
already if you have some databases in my case.

So I inserted one line in /etc/mysql/my.cnf which sets the limit really
high to test it:

[mysqld]
open_files_limit = 999999

Restart mysql at this point..

After that, I finally could send mails through the SMTP with working
sasl auth! So the "generic error" in my case resulted from the fact that
mysql did abort the auth query request with an error message because it
didn't have any resources left.. (this error:
http://dev.mysql.com/doc/refman/5.5/en/not-enough-file-handles.html)

Next step?
--------------
Could please someone who upgraded to Precise and applied the config from comment #34 and still have the "generic error" check this mysql setting in their setup and verify that they really applied everything correctly?

[Appendix]
Versions of key packages in use now (working combination)
postfix 2.9.1-5
mysql-server 5.5.24-0ubuntu0.12.04.1
libsasl2-dev 2.1.25.dfsg1-3ubuntu0.1
libsasl2-modules-sql 2.1.25.dfsg1-3ubuntu0.1
libsasl2-2 2.1.25.dfsg1-3ubuntu0.1
sasl2-bin 2.1.25.dfsg1-3ubuntu0.1

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