qmail vpopmail dovecot驗證問題
我的操作系統是centos 5.2 ,mta是qmail，imap用的dovecot(因courier-imap 0.6.1后不支持vpopmail),webmail用的是squirrelmail,imap設置中巳正確設置為dovecot.以下是我dovecot.conf與dovecot-sql.conf的配置文件內容(僅粘貼了我更改的部分，其它默認。
dovecot.conf
passdb vpopmail {
# - See cache_key in PAM for explanation.
# - %q expands to Maildir++ quota
# (eg. quota_template=quota_rule=*:backend=%q)
#args =
}
userdb vpopmail {
}
user=vpopmail
dovecot-sql.conf
connect = host=/tmp/mysql.sock user=vpopmail password=zfy0978 dbname=vpopmail
default_pass_scheme = PLAIN
password_query = \
SELECT CONCAT(pw_name,'@',pw_domain) AS user,pw_clear_passwd AS password FROM vpopmail WHERE pw_name= '%n' AND pw_domain = '%d'
user_query = \
SELECT pw_dir as home,89 AS uid,89 AS gid FROM vpopmail WHERE pw_name = '%n' AND pw_domain = '%d'
在我用squirrelmail登錄時，老提示用戶名不存在或密碼錯誤 ，以下是錯誤 日誌的詳細內容，提示password mismatch,但實在是找不出它不配配的理由，請高手指點，我是按官方的vpopmail配置更改的
dovecot: Sep 16 11:44:56 Info: auth(default): client in: AUTH 1 PLAIN service=imap secured lip=127.0.0.1 rip=127.0.0.1 lport=143 rport=40375 resp=AHpoYW5nenJAbG9uZ3NoaW5lMTY4LnZpY3AubmV0ADEyMzQ1Ng==
dovecot: Sep 16 11:44:56 Info: auth(default): vpopmail(zhangzr@longshine168.vicp.net,127.0.0.1): lookup user=zhangzr domain=longshine168.vicp.net
dovecot: Sep 16 11:44:56 Info: auth(default): client out: OK 1 user=zhangzr@longshine168.vicp.net
dovecot: Sep 16 11:44:56 Info: auth(default): master in: REQUEST 1 9625 1
dovecot: Sep 16 11:44:56 Info: auth(default): vpopmail(zhangzr@longshine168.vicp.net,127.0.0.1): lookup user=zhangzr domain=longshine168.vicp.net
dovecot: Sep 16 11:44:56 Info: auth(default): master out: USER 1 zhangzr@longshine168.vicp.net uid=89 gid=89 home=/home/vpopmail/domains/longshine168.vicp.net/zhangzr
dovecot: Sep 16 11:44:56 Info: IMAP(zhangzr@longshine168.vicp.net): Effective uid=89, gid=89, home=/home/vpopmail/domains/longshine168.vicp.net/zhangzr
dovecot: Sep 16 11:44:56 Info: IMAP(zhangzr@longshine168.vicp.net): maildir: data=/home/vpopmail/domains/longshine168.vicp.net/zhangzr@longshine168.vicp.net/Maildir
dovecot: Sep 16 11:44:56 Info: IMAP(zhangzr@longshine168.vicp.net): maildir++: root=/home/vpopmail/domains/longshine168.vicp.net/zhangzr@longshine168.vicp.net/Maildir, index=, control=, inbox=/home/vpopmail/domains/longshine168.vicp.net/zhangzr@longshine168.vicp.net/Maildir
dovecot: Sep 16 11:44:56 Info: imap-login: Login: user=<zhangzr@longshine168.vicp.net>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
dovecot: Sep 16 11:44:56 Info: IMAP(zhangzr@longshine168.vicp.net): Disconnected: Logged out bytes=44/298
dovecot: Sep 16 11:44:56 Info: auth(default): new auth connection: pid=9632
dovecot: Sep 16 11:44:57 Info: auth(default): client in: AUTH 1 PLAIN service=imap secured lip=127.0.0.1 rip=127.0.0.1 lport=143 rport=40377 resp=AHpoYW5nenJAbG9uZ3NoaW5lMTY4LnZpY3AubmV0AA==
dovecot: Sep 16 11:44:57 Info: auth(default): vpopmail(zhangzr@longshine168.vicp.net,127.0.0.1): lookup user=zhangzr domain=longshine168.vicp.net
dovecot: Sep 16 11:44:57 Info: auth(default): vpopmail(zhangzr@longshine168.vicp.net,127.0.0.1): Password mismatch
dovecot: Sep 16 11:44:57 Info: auth(default): vpopmail(zhangzr@longshine168.vicp.net,127.0.0.1): MD5-CRYPT() != '$1$2cGmtyvs$8935rOCzquzS7KY/gA0871'
dovecot: Sep 16 11:44:57 Info: auth(default): new auth connection: pid=9633
dovecot: Sep 16 11:44:59 Info: auth(default): client out: FAIL 1 user=zhangzr@longshine168.vicp.net
dovecot: Sep 16 11:44:59 Info: imap-login: Disconnected (auth failed, 1 attempts): user=<zhangzr@longshine168.vicp.net>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
dovecot: Sep 16 11:44:59 Info: auth(default): client in: AUTH 1 PLAIN service=imap secured lip=127.0.0.1 rip=127.0.0.1 lport=143 rport=40378 resp=AHpoYW5nenJAbG9uZ3NoaW5lMTY4LnZpY3AubmV0AA==
dovecot: Sep 16 11:44:59 Info: auth(default): vpopmail(zhangzr@longshine168.vicp.net,127.0.0.1): lookup user=zhangzr domain=longshine168.vicp.net
dovecot: Sep 16 11:44:59 Info: auth(default): vpopmail(zhangzr@longshine168.vicp.net,127.0.0.1): Password mismatch
dovecot: Sep 16 11:44:59 Info: auth(default): vpopmail(zhangzr@longshine168.vicp.net,127.0.0.1): MD5-CRYPT() != '$1$2cGmtyvs$8935rOCzquzS7KY/gA0871'
dovecot: Sep 16 11:44:59 Info: auth(default): new auth connection: pid=9634
dovecot: Sep 16 11:45:01 Info: auth(default): client out: FAIL 1 user=zhangzr@longshine168.vicp.net
dovecot: Sep 16 11:45:01 Info: imap-login: Aborted login (auth failed, 1 attempts): user=<zhangzr@longshine168.vicp.net>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
《解決方案》
qmail vpopmail dovecot 驗證問題
以下是我登錄squirrelmail時，mysql的日誌記錄
080916 11:58:52 38 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `vpopmail` where pw_name = "zhanghy" and pw_domain = "longshine168.vicp.net"
38 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `vpopmail` where pw_name = "zhanghy" and pw_domain = "longshine168.vicp.net"
39 Query replace into lastauth set user='zhanghy', domain='longshine168.vicp.net', remote_ip='imap', timestamp=1221537532
080916 11:58:53 38 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `vpopmail` where pw_name = "zhanghy" and pw_domain = "longshine168.vicp.net"
080916 11:58:55 38 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `vpopmail` where pw_name = "zhanghy" and pw_domain = "longshine168.vicp.net"
