[courier-users] authdaemond.mysql failure to authenticate

[Christos S. <sin...@gm...>]

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

I get the same error regardless of using mysql socket or tcp connection.

Please, any suggestions will be welcome!

Cheers!

Chris