大家帮我看看我的sasl认证错误

xiao2

1. Feb 17 12:34:44 iiuy saslauthd[88262]: pam_sm_authenticate called.
   
2. Feb 17 12:34:44 iiuy saslauthd[88262]: dbuser changed.
   
3. Feb 17 12:34:44 iiuy saslauthd[88262]: dbpasswd changed.
   
4. Feb 17 12:34:44 iiuy saslauthd[88262]: host changed.
   
5. Feb 17 12:34:44 iiuy saslauthd[88262]: database changed.
   
6. Feb 17 12:34:44 iiuy saslauthd[88262]: table changed.
   
7. Feb 17 12:34:44 iiuy saslauthd[88262]: usercolumn changed.
   
8. Feb 17 12:34:44 iiuy saslauthd[88262]: passwdcolumn changed.
   
9. Feb 17 12:34:44 iiuy saslauthd[88262]: crypt changed.
   
10. Feb 17 12:34:44 iiuy saslauthd[88262]: db_connect  called.
    
11. Feb 17 12:34:44 iiuy saslauthd[88262]: returning 0 .
    
12. Feb 17 12:34:44 iiuy saslauthd[88262]: db_checkpasswd called.
    
13. Feb 17 12:34:44 iiuy saslauthd[88262]: pam_mysql: where clause =
    
14. Feb 17 12:34:44 iiuy saslauthd[88262]: SELECT password FROM virtual_users WHERE id='iiuy'
    
15. Feb 17 12:34:44 iiuy saslauthd[88262]: pam_mysql: select returned more than one result
    
16. Feb 17 12:34:44 iiuy saslauthd[88262]: returning 7 after db_checkpasswd.
    
17. Feb 17 12:34:44 iiuy saslauthd[88262]: do_auth         : auth failure: [user=iiuy] [service=smtp] [realm=iiuy.8866.org] [mech=pam] [reason=PAM auth error]

复制代码

xiao2

ding

xiao2

大哥们帮忙看看啊

jacobzhu

原帖由 "xiao2" 发表：
pam_mysql: select returned more than one result

确认一下是不是有重复

platinum

我的也是如此，不知道为什么

xiao2

我确认了，没有重复

rocklv

pam_mysql: select returned more than one result

这个情况很复杂，我是重装了N遍，才搞定。

个人觉得是编译有问题

我参考的这里

http://cngnu.org/technology/Postfix_I.html