dovecot mysql_dovecot+mysql认证问题

本帖最后由 qscf_520 于 2010-08-11 14:53 编辑

Aug 11 14:22:07 auth(default): Info: client in: AUTH    1       PLAIN   service=pop3    lip=192.168.1.200       rip=123.16.136.30 lport=110        rport=1645      resp=AHF1c29uZzcAJDEkcGh6MW1ScmokM29rNkJqZWFvSllXREJzRVBaYjVDMA==

Aug 11 14:22:07 auth-worker(default): Info: sql(qusong7,123.16.136.30): query: select username as user,password from mailbox where username = 'qusong7' and active='1'

Aug 11 14:22:07 auth(default): Info: client out: OK     1       user=qusong7

Aug 11 14:22:07 auth(default): Info: master in: REQUEST 2       5080    1

Aug 11 14:22:07 auth-worker(default): Info: sql(qusong7,123.16.136.30): select maildir as home,uidnumber as uid ,gidnumber as gid from mailbox where username='qusong7' and active='1'

[fly][fly]Aug 11 14:22:07 auth(default): Info: master out: USER   2       qusong7 home=/home/domains/gzshenzhen.com/qusong7/Maildir/        uidnumber=1000     mailbox=1000[/fly][/fly]

Aug 11 14:22:07 dovecot: Error: User qusong7 is missing UID (see mail_uid setting)

Aug 11 14:22:07 pop3-login: Info: Internal login failure (auth failed, 1 attempts): user=, method=PLAIN, rip=123.16.136.30, lip=192.168.1.200

Aug 11 14:22:08 auth(default): Info: new auth connection: pid=5081

重新改了配置文件：

[root@mail wiki]# cat /usr/local/dovecot/etc/dovecot-sql.conf

driver = mysql

connect = host=/tmp/mysql.sock dbname=extmail user=root password=12345678

#default_pass_scheme = MD5

default_pass_scheme = PLAIN

#password_query = select username as user,password from mailbox where substring(username,1,instr(username,'@')-1) = '%n' and active='1'

password_query = select username as user,password from mailbox where username = '%u' and active='1'

user_query = select maildir as home,uidnumber as uid ,gidnumber as gid from mailbox where username='%u' and active='1'

作者: qscf_520

发布时间: 2010-08-11