Re: cyrus-sasl mysql auth problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Found something else.  I turned on logging in mysql and when I run queries in the mysql client it logs them, so logging is working.  When I use imtest to try to login, it NEVER even connects to the mysql server.  Any suggestions?

On 2/9/07, Jeremiah Towe <jeremiah.towe@xxxxxxxxx> wrote:
Here's my tail /var/log/maillog

Feb  9 15:53:18 localhost imap[2643]: 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

and getting

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 | newtest       | maxyourstats | maxyourstats.com |

/etc/imapd.conf
tls_cert_file: /etc/pki/cyrus-imapd/cyrus-imapd.pem
tls_key_file: /etc/pki/cyrus-imapd/cyrus-imapd.pem
tls_ca_file: /etc/pki/tls/certs/ca-bundle.crt
postmaster: postmaster
configdirectory: /var/lib/imap
partition-default: /var/spool/imap
# admins: cyrus # no admins!
allowanonymouslogin: no
allowplaintext: yes
#sasl_mech_list: PLAIN
servername: blang.maxyourstats.com
autocreatequota: 10000
reject8bit: no
quotawarn: 90
timeout: 30
poptimeout: 10
dracinterval: 0
drachost: localhost
sievedir: /usr/sieve
sendmail: /usr/sbin/sendmail
sieve_maxscriptsize: 32
sieve_maxscripts: 5
#unixhierarchysep: yes
sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: sql
sql_engine: mysql
sasl_auto_transition: no
sasl_sql_hostnames: localhost
sasl_sql_user: user //changed for post
sasl_sql_password: password //changed for post
sasl_sql_database: mail
sasl_sql_statement: select password from accountuser where username = '%u'
sasl_sql_verbose: true
sasl_mech_list: login plain

Any suggestions?  Need any other config files?


[Index of Archives]     [Info Cyrus]     [Squirrel Mail]     [Linux Media]     [Yosemite News]     [gtk]     [KDE]     [Gimp on Windows]     [Steve's Art]

  Powered by Linux