qmail vpopmail dovecot验证问题

zhanghuiyun0978

我的操作系统是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 {
    # [cache_key=<key>] - See cache_key in PAM for explanation.
    # [quota_template=<template>] - %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

zhanghuiyun0978

以下是我登录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"