프리이미지
사이트 내 전체검색

authdaemonrc 로그인문제 해결 기록 파일 보기

페이지 정보

작성일11-09-15 10:34

본문

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


게시물 검색