Re: [Bug 875440] Re: Cannot authenticate with saslauthd and mysql
- Reply message - From: Carson Longhorn 875...@bugs.launchpad.net To: emun...@mgebm.net Subject: [Bug 875440] Re: Cannot authenticate with saslauthd and mysql Date: Sat, Jun 23, 2012 01:21 The fix from Devin appears to have worked for me: # cat /etc/postfix/sasl/smtpd.conf pwcheck_method: saslauthd mech_list: plain login cram-md5 digest-md5 log_level: 7 allow_plaintext: true auxprop_plugin: sql sql_engine: mysql sql_hostnames: 127.0.0.1 sql_user: user sql_passwd: pass sql_database: db sql_select: select crypt from users where id='%u@%r' and enabled = 1 -- You received this bug notification because you are subscribed to the bug report. https://bugs.launchpad.net/bugs/875440 Title: Cannot authenticate with saslauthd and mysql Status in “cyrus-sasl2” package in Ubuntu: Confirmed Bug description: Upgraded from Natty to Oneiric and now I can no longer authenticate for out going mail using saslauthd. Initial server setup was done following these instructions (http://flurdy.com/docs/postfix/). With mysql logging enabled, user credentials are never selected with a login attempt. /var/log/auth.log with intermittently show: postfix/smtpd[4930]: sql auxprop plugin using mysql engine with login attempts and /var/log/mail.log shows: SASL LOGIN authentication failed: no mechanism available Every time. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/cyrus-sasl2/+bug/875440/+subscriptions -- 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
[Bug 875440] Re: Cannot authenticate with saslauthd and mysql
I tried both flavors of sql_passwd and neither worked, I just gave up and switched to dovecot for imap and sasl. -- 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
[Bug 875440] Re: Cannot authenticate with saslauthd and mysql
@Otlay I have that exact setup in my smtp.conf and updated cyrus-sasl packages break for me with the original error. -- 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
[Bug 875440] Re: Cannot authenticate with saslauthd and mysql
@Otlay After poking at the config file for some time I now get Jun 14 13:14:19 machine postfix/smtpd[15252]: connect from localhost[127.0.0.1] Jun 14 13:14:19 machine postfix/smtpd[15252]: setting up TLS connection from localhost[127.0.0.1] Jun 14 13:14:19 machine postfix/smtpd[15252]: Anonymous TLS connection established from localhost[127.0.0.1]: TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits) Jun 14 13:14:19 machine postfix/smtpd[15252]: warning: localhost[127.0.0.1]: SASL LOGIN authentication failed: generic failure And auth.log complains about not being able to connect to my mysql db Using the credentials stored in smtp.conf I am able to login by hand and run the login query and everything works but sasl can't seem to connect. Google is turning up lots of people asking the same question, but I have yet to find an answer. -- 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
[Bug 875440] Re: Cannot authenticate with saslauthd and mysql
I explicitly made the changes in smtpd.conf as suggested in comment #34 and I still see the problem, I am back on 2.1.23. I have not upgraded to Precise because this is still a problem. -- 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
[Bug 875440] Re: Cannot authenticate with saslauthd and mysql
That isn't a solution. I realize that we are not paying for support, but this sort of statement doesn't encourage me to suggest that route to anyone. If the fix truly is to update to the newer version why can this not be done in Onieric? To anyone that this bug is affecting, make sure to click This affects me at the top to up the bug heat, that seems to be the only way to get Canonical to fix something they broke. -- 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