For a while now, I am working on a mailserver setup using postfix, maildrop, imap and mysql. Most of it is working fine now, but I'm not able to authenticate my users with the use of a mysql database. As a local user I can be authenticated.... It seems to be a problem reported a couple of times but none of them have any followups which reveal an answer to my problem.... maybe you can help.
THE STORY IN A LITTLE MORE DETAIL: if I telnet and LOGIN as a local user I get accepted $ telnet localhost imap Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. * OK Courier-IMAP ready. Copyright 1998-2002 Double Precision, Inc. See COPYING for distribution information. a LOGIN onno password a OK LOGIN Ok. but If I telnet and LOGIN as a user from the mysql database I'm not accepted $ telnet localhost imap Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. * OK Courier-IMAP ready. Copyright 1998-2002 Double Precision, Inc. See COPYING for distribution information. a LOGIN test test a NO Login failed. I have changed the DEBUG_LOGIN=2 paramter in etc/imapd and I find in /var/log/maillog Jan 13 17:14:25 fire imapd: Connection, ip=[::ffff:127.0.0.1] Jan 13 17:14:33 fire imapd: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=LOGIN Jan 13 17:14:33 fire imapd: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], username=test Jan 13 17:14:33 fire imapd: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], password=test Jan 13 17:14:38 fire imapd: LOGIN FAILED, ip=[::ffff:127.0.0.1] I have also setup the logging for mysql and although it logs all other database actions it doesn't show any sign of imap trying to access the mysql database. I have tried verius authmysqlrc options. Using the socket, using the port, different usernames, servernames etc.... all with no change in the result. If you've got any ideas, let me know (see below for some the fine details) grz, Onno THE FINE DETAILS: OS: RedHat 7.3 Kernel: 2.4.18 courier-imap-1.6.2-1.7.3 (build as rpm from source) mysql: 3.23.49 (rpm build by RedHat) gcc: 2.96-113 AUTHDAEMONRC: authmodulelist="authcustom authcram authuserdb authldap authpam authmysql" authmodulelistorig="authcustom authcram authuserdb authldap authmysql authpam" daemons=5 version="authdaemond.mysql" authdaemonvar=/var/run/authdaemon.courier-imap AUTHMYSQLRC: MYSQL_SERVER localhost MYSQL_USERNAME root MYSQL_PASSWORD ***** #MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_PORT 3306 #MYSQL_OPT 0 MYSQL_DATABASE maildb MYSQL_USER_TABLE users MYSQL_CLEAR_PWFIELD clear MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD id MYSQL_HOME_FIELD home #MYSQL_MAILDIR_FIELD maildir mysql: db -> maildb table -> users mysql> select id,clear,uid,gid,home,maildir from users +------+-------+-----+-----+------------------+---------------+ | id | clear | uid | gid | home | maildir | +------+-------+-----+-----+------------------+---------------+ | test | test | 502 | 502 | /home/vmail/test | test/Maildir/ | +------+-------+-----+-----+------------------+---------------+ 1 row in set (0.00 sec) __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
