1. 설정

vi /etc/courier/authdaemonrc

DEBUG_LOGIN=3

으로 변경

2. 기록파일 확인

vi /etc/rsyslog.conf

vi /etc/rsyslog.d/50-default.conf

-->

mail.*                          -/var/log/mail.log

mail.info                       -/var/log/mail.info

mail.warn                       -/var/log/mail.warn

mail.err                        /var/log/mail.err

*.=debug;\

        auth,authpriv.none;\

        news.none;mail.none     -/var/log/debug

3. 테스트

telnet localhost pop3

user xxxxxxxxxx

pass 11111

4. 기록확인

cd /var/log

ls -lt

-rw-r----- 1 syslog            adm  2443812 2011-09-14 18:09 mail.info

-rw-r----- 1 syslog            adm   460065 2011-09-14 18:09 syslog

-rw-r----- 1 syslog            adm   581361 2011-09-14 18:09 mail.warn

-rw-r----- 1 syslog            adm   204119 2011-09-14 18:09 auth.log

mail.info  -> 오류 내용 

pop3d: authentication error: Input/output error

syslog  오류

Sep 14 18:05:27 actrun2-DB authdaemond: received auth request, service=pop3, authtype=login

Sep 14 18:05:27 actrun2-DB authdaemond: authmysql: trying this module

Sep 14 18:05:27 actrun2-DB authdaemond: authmysqllib: connected. Versions: header 50137, client 50141, server 50141

Sep 14 18:05:27 actrun2-DB authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/data/vmail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", name, "" FROM mail_users WHERE email = 'xxxxxxxxxx'

Sep 14 18:05:27 actrun2-DB authdaemond: mysql_query failed, reconnecting: Unknown column 'name' in 'field list'

Sep 14 18:05:27 actrun2-DB authdaemond: authmysqllib: connected. Versions: header 50137, client 50141, server 50141

Sep 14 18:05:27 actrun2-DB authdaemond: mysql_query failed second time, giving up: Unknown column 'name' in 'field list'

Sep 14 18:05:27 actrun2-DB authdaemond: authmysql: TEMPFAIL - no more modules will be tried

Sep 14 18:05:27 actrun2-DB pop3d: LOGIN FAILED, user=xxxxxxxxxx, ip=[::1]

mysql query 가 엉망이다.

vi /etc/courier/authmysqlrc

#MYSQL_NAME_FIELD  name  <-- 막을것

MYSQL_QUOTA_FIELD quota

/etc/init.d/courier-authdaemon restart

다시 해보니

Sep 14 19:16:12 actrun2-DB postfix/anvil[16662]: statistics: max cache size 4 at Sep 14 19:12:51

Sep 14 19:16:16 actrun2-DB pop3d: Connection, ip=[::1]

Sep 14 19:16:20 actrun2-DB authdaemond: received auth request, service=pop3, authtype=login

Sep 14 19:16:20 actrun2-DB authdaemond: authmysql: trying this module

Sep 14 19:16:20 actrun2-DB authdaemond: authmysqllib: connected. Versions: header 50137, client 50141, server 50141

Sep 14 19:16:20 actrun2-DB authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/data/vmail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM mail_users WHERE email = 'xxxxxxxxxx'

Sep 14 19:16:20 actrun2-DB authdaemond: password matches successfully

Sep 14 19:16:20 actrun2-DB authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/data/vmail, address=xxxxxxxxxx, fullname=<null>, maildir=xxxxxxxxxx/xxxxxxxxxx/, quota=10485760, options=<null>

Sep 14 19:16:20 actrun2-DB authdaemond: authmysql: clearpasswd=<null>, passwd=HCV7qLZivVBFk

Sep 14 19:16:20 actrun2-DB authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/data/vmail, address=xxxxxxxxxx, fullname=<null>, maildir=xxxxxxxxxx/xxxxxxxxxx/, quota=10485760, options=<null>

Sep 14 19:16:20 actrun2-DB authdaemond: Authenticated: clearpasswd=1111, passwd=HCV7qLZivVBFk

Sep 14 19:16:20 actrun2-DB pop3d: chdir xxxxxxxxxx/xxxxxxxxxx/: No such file or directory