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], username=te...@charlie.gr 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