postfix不能收信原因 sql查询怎么改？？

zuxi_sui

Jul 24 12:30:49 mail authdaemond: received auth request, service=pop3, authtype=login
Jul 24 12:30:49 mail authdaemond: authmysql: trying this module
Jul 24 12:30:49 mail authdaemond: SQL query: SELECT username, password, "", '2525', '2525', concat('/mail/mailbox/',maildir), concat('/mail/mailbox/',maildir), "", username, "" FROM mailbox WHERE username = "test"
Jul 24 12:30:49 mail authdaemond: zero rows returned
Jul 24 12:30:49 mail authdaemond: no password available to compare
Jul 24 12:30:49 mail authdaemond: authmysql: REJECT - try next module
Jul 24 12:30:49 mail authdaemond: FAIL, all modules rejected

红色部分是出现问题的原因，usrname应该是test@test.com
，不知道怎么改啊。？？help help

ruochen

password_query = select username as user,password from mailbox where username = '%u' and active='1'
user_query = select maildir as home,500 as uid,501 as gid from mailbox where username='%u' and active='1'

ruochen

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

用%n或者%u实验吧
最初这块和密码加密的问题，调试了很久

zuxi_sui

原来foxmail需要把pop帐号填写完全，这样就不会那么查询了。
不过现在又有新问题了。

Jul 24 12:59:10 mail authdaemond: SQL query: SELECT username, password, "", '2525', '2525', concat('/mail/mailbox/',maildir), "", "", name, "" FROM mailbox WHERE username = "suigq@test.com"
Jul 24 12:59:10 mail authdaemond: password matches successfully
Jul 24 12:59:10 mail pop3d: chdir Maildir: No such file or directory

scyzxp

原帖由 zuxi_sui 于 2008-7-24 13:05 发表
原来foxmail需要把pop帐号填写完全，这样就不会那么查询了。
不过现在又有新问题了。

Jul 24 12:59:10 mail authdaemond: SQL query: SELECT username, password, "", '2525', '2525', concat('/mail/mailb ...

哎哎，authlib配置有问题，建议兄弟把authdaemon的debug模式打开

ruochen

原帖由 zuxi_sui 于 2008-7-24 13:05 发表
原来foxmail需要把pop帐号填写完全，这样就不会那么查询了。
不过现在又有新问题了。

Jul 24 12:59:10 mail authdaemond: SQL query: SELECT username, password, "", '2525', '2525', concat('/mail/mailb ...

你已经标记出来了
定位不到maildir的目录或者权限不对