Hi all,
Having trouble getting courier+authdaemon+mysql to authenticate users. I've tried everything I can to remove things that might cause problems, such as the where clause and other modules from the list. Nothing is working. All daemons are running (mysql, courier, authdaemon, pop3d, imapd, etc) and configs are as follows: etc/authdaemon -------------- authmodulelist="authmysql authpwd" authmodulelistorig="authcustom authcram authuserdb authmysql authpwd" daemons=5 version="authdaemond.mysql" authdaemonvar=/mnt/daemons/courier/var/authdaemon etc/authmysqlrc --------------- MYSQL_SERVER localhost MYSQL_USERNAME auth MYSQL_PASSWORD 4uth MYSQL_SOCKET /tmp/mysql.sock MYSQL_OPT 0 MYSQL_DATABASE adtaq MYSQL_USER_TABLE auth MYSQL_CLEAR_PWFIELD pass MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELD dir MYSQL_NAME_FIELD name MYSQL_WHERE_CLAUSE and mail=1 SQL Table --------- mysql> describe auth; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | aid | int(4) | | PRI | NULL | auto_increment | | login | varchar(100) | | | | | | pass | varchar(15) | | | | | | dir | varchar(100) | | | | | | ubandwidth | int(4) | YES | | NULL | | | dbandwidth | int(4) | YES | | NULL | | | uid | varchar(7) | | | | | | gid | varchar(7) | | | | | | mail | int(1) | YES | | NULL | | | description | varchar(150) | YES | | NULL | | +-------------+--------------+------+-----+---------+----------------+ Outlook response ---------------- Login failed. Configuration: Account: sanitarium.adtaq.com Server: sanitarium.adtaq.com User name: [EMAIL PROTECTED] Protocol: IMAP Port: 143 Secure(SSL): 0 Code: 800cccd1 The password data in mysql is all cleartext/unencrypted (just for testing). I'm not sure if that is relevent or not, but I wanted to give you all as much info as possible. Thanks for a great product, as well as any help you can send my way. -t ------------------------- Tony Faoro tmf at cyberpunkz dot org 602.380.7691 VOICE 800.861.1834 FAX _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
