Re: [courier-users] authdaemond.mysql failure to authenticate

[Lindsay H. <fmo...@fm...>]

I always find it useful to temporarily turn on MySQL query tracking for
this kind of problem.  

in the [mysqld] section of my.cnf, set something like:

log = /var/log/mysql.log

and restart mysqld

This will show you exactly the query that pop3d is using to try to
authenticate.  Be sure to turn this logging off when you're done.  /var
can fill up pretty fast on a busy mail server!

On Sun, 2007-09-23 at 17:08 +0300, Christos Sintoris wrote:
> Hi,
> 
> I have setup postfix and courier using mysql auth. Postfix works fine,
> but when i try to connect to courier-pop, i get the following error:
> 
> Sep 23 15:53:04 charlie courierpop3login: Connection,
> ip=[::ffff:xx.xx.17.108]
> Sep 23 15:53:04 charlie courierpop3login: LOGIN: DEBUG:
> ip=[::ffff:xx.xx.17.108], command=CAPA
> Sep 23 15:53:12 charlie courierpop3login: LOGIN: DEBUG:
> ip=[::ffff:xx.xx.17.108], command=USER
> Sep 23 15:53:12 charlie courierpop3login: LOGIN: DEBUG:
> ip=[::ffff:xx.xx.17.108], command=PASS
> Sep 23 15:53:12 charlie courierpop3login: LOGIN: DEBUG:
> ip=[::ffff:xx.xx.17.108], use...@ch...
> Sep 23 15:53:12 charlie courierpop3login: LOGIN: DEBUG:
> ip=[::ffff:xx.xx.17.108], password=password
> Sep 23 15:53:12 charlie courierpop3login: authdaemon: starting client module
> Sep 23 15:53:12 charlie authdaemond.mysql: failed to connect to mysql
> server (server=127.0.0.1., userid=courier.)
> Sep 23 15:53:12 charlie courierpop3login: authdaemon: TEMPFAIL - no more
> modules will be tried
> Sep 23 15:53:17 charlie courierpop3login: LOGIN FAILED,
> ip=[::ffff:xx.xx.17.108]
> 
> Testing the mysql credentials from a terminal works just fine:
> charlie:~# mysql -u courier -p -h 127.0.0.1
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 112 to server version:
> 5.0.22-Debian_0ubuntu6.06.3
> 
> my authmysqlrc file looks like that: (and is clean of spaces or tabs)
> MYSQL_SERVER 127.0.0.1
> MYSQL_USERNAME courier
> MYSQL_PASSWORD obscure
> MYSQL_PORT 3306
> MYSQL_SOCKET /var/run/mysqld/mysqld.sock
> MYSQL_DATABASE mailinfo
> MYSQL_USER_TABLE mail_users
> MYSQL_CRYPT_PWFIELD password_enc
> MYSQL_UID_FIELD uid
> MYSQL_GID_FIELD gid
> MYSQL_LOGIN_FIELD username
> MYSQL_HOME_FIELD homedir
> MYSQL_MAILDIR_FIELD maildir

-- 
Lindsay Haisley       | "In an open world,    |     PGP public key
FMP Computer Services |    who needs Windows  |      available at
512-259-1190          |      or Gates"        | http://pubkeys.fmp.com
http://www.fmp.com    |                       |