 | Start a set with this search |
 | Include this search in one of my sets |
 | Exclude this search from one of my sets |
 | Permalink to these results Paste this link in email or IM: |
 | Atom feed for tracking future search results Paste this URL into your reader: |
6 messages in net.sourceforge.lists.courier-usersRe: [courier-users] authdaemond.mysql...| From | Sent On | Attachments |
|---|---|---|
| Christos Sintoris | Sep 23, 2007 7:07 am | |
| Tim Lyth | Sep 23, 2007 7:24 am | |
| Christos Sintoris | Sep 23, 2007 7:34 am | |
| Sam Varshavchik | Sep 23, 2007 10:11 am | |
| Lindsay Haisley | Sep 23, 2007 10:21 am | |
| Christos Sintoris | Sep 23, 2007 1:16 pm |
| Permalink for this message Paste this link in email or IM: |
| Permalink for this thread Paste this link in email or IM: |
| Atom feed for this thread Paste this URL into your reader: |
| Subject: | Re: [courier-users] authdaemond.mysql failure to authenticate | Actions... |
|---|---|---|
| From: | Lindsay Haisley (fmou...@fmp.com) | |
| Date: | Sep 23, 2007 10:21:52 am | |
| List: | net.sourceforge.lists.courier-users | |
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], 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
-- 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 | |