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], [EMAIL PROTECTED] > 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 | | ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
