Udv.

Debian woody
MySQL 3.23.49

a problema:

telnet box.hu 110
+OK Hello there.
USER ds
+OK Password required.
PASS jelszo
-ERR Login failed.

box:/home/ds# courierauthtest -s pop3 ds jelszo
Authenticated: module authdaemon
Home directory: /var/spool/postfix/virtual
UID/GID: 5005/4001
Maildir: box.hu/ds/Maildir/
AUTHADDR=ds
AUTHFULLNAME=nevem

Oct 21 01:47:59 box courierpop3login: Connection, ip=[::ffff:195.56.211.142]
Oct 21 01:48:04 box courierpop3login: LOGIN FAILED, ip=[::ffff:195.56.211.142]

It did’t use mysql so i think the problem is in reaching the db..

configok:
#autdaemonrc
##VERSION: $Id: authdaemonrc.in,v 1.8 2001/10/07 02:16:22 mrsam Exp $
##NAME: authmodulelist:0
authmodulelist=”authmysql”
##NAME: authmodulelistorig:1
authmodulelistorig=”authcustom authcram authuserdb authldap authmysql authpam”
##NAME: daemons:0
daemons=5
##NAME: version:0
version=”authdaemond.mysql”
##NAME: authdaemonvar:0

#authmodulelist
authdaemon

#authmysqlrc
##VERSION: $Id: authmysqlrc,v 1.9 2002/01/08 05:01:22 mrsam Exp $
##NAME: LOCATION:0
MYSQL_SERVER 127.0.0.1
MYSQL_USERNAME courier
MYSQL_PASSWORD passwd
##NAME: MYSQL_SOCKET:0
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
##NAME: MYSQL_PORT:0
MYSQL_PORT 3306
##NAME: MYSQL_OPT:0
MYSQL_OPT 0
##NAME: MYSQL_DATABASE:0
MYSQL_DATABASE mail
##NAME: MYSQL_USER_TABLE:0
MYSQL_USER_TABLE users
##NAME: MYSQL_CRYPT_PWFIELD:0
MYSQL_CRYPT_PWFIELD crypt
##NAME: MYSQL_CLEAR_PWFIELD:0
##NAME: MYSQL_DEFAULT_DOMAIN:0
##NAME: MYSQL_UID_FIELD:0
MYSQL_UID_FIELD uid
##NAME: MYSQL_GID_FIELD:0
MYSQL_GID_FIELD gid
##NAME: MYSQL_LOGIN_FIELD:0
MYSQL_LOGIN_FIELD id
##NAME: MYSQL_HOME_FIELD:0
MYSQL_HOME_FIELD home
##NAME: MYSQL_NAME_FIELD:0
MYSQL_NAME_FIELD name
##NAME: MYSQL_MAILDIR_FIELD:0
MYSQL_MAILDIR_FIELD maildir
##NAME: MYSQL_QUOTA_FIELD:0
##NAME: MYSQL_WHERE_CLAUSE:0
MYSQL_WHERE_CLAUSE imapok=1 AND bool1=1 AND bool2=1
##NAME: MYSQL_SELECT_CLAUSE:0
##NAME: MYSQL_CHPASS_CLAUSE:0

#pop3d:
##VERSION: $Id: pop3d.dist.in,v 1.4 2001/07/04 19:32:37 uid26639 Exp $
##NAME: install_prefix:0
prefix=/usr
exec_prefix=/usr
sbindir=”/usr/sbin”
##NAME: PIDFILE:0
PIDFILE=/var/run/courier/pop3d.pid
##NAME: MAXDAEMONS:0
MAXDAEMONS=40
##NAME: MAXPERIP:4
MAXPERIP=4
##NAME: AUTHMODULES:0
AUTHMODULES=”authmysql”
##NAME: AUTHMODULES_ORIG:0
AUTHMODULES_ORIG=””
##NAME: POP3AUTH:1
POP3AUTH=””
##NAME: POP3AUTH_ORIG:0
POP3AUTH_ORIG=”LOGIN CRAM-MD5 CRAM-SHA1″
##NAME: POP3AUTH_TLS:1
POP3AUTH_TLS=””
##NAME: POP3AUTH_TLS_ORIG:0
POP3AUTH_TLS_ORIG=”LOGIN PLAIN”
##NAME: PORT:1
PORT=110
##NAME: ADDRESS:0
ADDRESS=0
##NAME: TCPDOPTS:0
TCPDOPTS=”-nodnslookup -noidentlookup”
##NAME: POP3DSTART:0
POP3DSTART=YES

—
:DS: