authdaemonrc 로그인문제 해결 기록 파일 보기
로빈아빠
본문
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
댓글목록
등록된 댓글이 없습니다.