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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
