Postfix 又出错啦！！！！authentication error: Input/output error

Question

本帖最后由 shyboy8688 于 2011-05-26 14:52 编辑

哪位大哥帮我分析分析，环境是 postfix+extmail,extmail上发邮件已经没问题了，但是我想用outlook连，但是就报这个错误：

May 26 14:49:57 weixin pop3d: Connection, ip=[61.172.240.238]
May 26 14:49:58 weixin authdaemond: received auth request, service=pop3, authtype=login
May 26 14:49:58 weixin authdaemond: authmysql: trying this module
May 26 14:49:58 weixin authdaemond: authmysqllib: connected. Versions: header 50077, client 50077, server 50077
May 26 14:49:58 weixin authdaemond: SQL query: SELECT username,password,"",uidnumber,gidnumber,
May 26 14:49:58 weixin authdaemond: mysql_query failed, reconnecting: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
May 26 14:49:58 weixin authdaemond: authmysqllib: connected. Versions: header 50077, client 50077, server 50077
May 26 14:49:58 weixin authdaemond: mysql_query failed second time, giving up: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
May 26 14:49:58 weixin authdaemond: authmysql: TEMPFAIL - no more modules will be tried
May 26 14:49:58 weixin pop3d: LOGIN FAILED, user=liguoxi@nenxun.com, ip=[61.172.240.238]
May 26 14:49:58 weixin pop3d: authentication error: Input/output error

[root@mail docs]# vim /usr/lib/sasl2/smtpd.conf                           

#pwcheck_method: saslauthd
pwcheck_method: authdaemond
log_level: 3
mech_list: PLAIN LOGIN
authdaemond_path:/usr/local/courier-authlib/var/spool/authdaemon/socket
~                                                                           

这一段到底是啥意思：May 26 14:49:58 weixin authdaemond: mysql_query failed, reconnecting: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
？？

Answer 1

应该是数据库连接配置错误，检查authmysqlrc文件里的配置。