cyrus-sasl mysql auth problem

[Jeremiah Towe]

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 =3D '%u'
sasl_sql_verbose: true
sasl_mech_list: login plain

Any suggestions?  Need any other config files?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.andrew.cmu.edu/mailman/private/cyrus-sasl/attachments/20=
070209/ab1ec750/attachment.html