cyrus-sasl mysql problem
I'm running Fedora. I'm trying to get cyrus-sasl to authenticate through mysql for imap. If I set it to sasl_pwcheck_method: saslauthd it works fine. When I change it, below is what happens and my setup.
Here's my tail /var/log/maillog
Feb 9 15:53:18 localhost imap: badlogin: blang.maxyourstats.com [127.0.0.1] plaintext maxyourstats0001 SASL(-13): user not found: checkpass failed
I get that after running
imtest -a maxyourstats0001 localhost
S: L01 NO Login failed: authentication failure
Authentication failed. generic failure
Security strength factor: 0
Here's some setup info:
mysql> select * from accountuser;
| username | password | prefix | domain_name |
| maxyourstats0001 | testpw | maxyourstats | maxyourstats.com |
# admins: cyrus # no admins!
sasl_sql_user: user //changed for post
sasl_sql_password: password //changed for post
sasl_sql_statement: select password from accountuser where username = '%u'
sasl_mech_list: login plain
I set mysql to log, and when I login with the mysql client and run queries they show up in the log, so logging works. However when I run the imtest command and try to authenticate imap, nothing ever appears in the mysqld.log, so it's like cyrus-imapd isn't even trying to talk to mysql.
Any suggestions? Need any other config files?
For anyone interested I solved my problem. I used saslauthd and set it to use PAM_MYSQL which works fine.
I have the same issue. How did you solved the problem with mysql and pam_mysql?
Originally Posted by robodeath
Hello and welcome to the forums, mami! :)
Please start a new thread of your own with the details of any problems that you are having because this one is over 3 years old.