cyrus-sasl mysql auth problem

[Jeremiah Towe]

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 at gmail.com> 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 =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/8f8970d1/attachment-0001.html