• 注册日期: 2010-01-26
  • 文章数: 11

主题: 关于maillog出错问题

出错日志如下,手动可以连接mysql,mysql日志没有报错,过了5分钟后自动恢复了,请版主给点思路,谢谢!
Sep 20 17:12:50 mail postfix/trivial-rewrite[7163]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (110)
Sep 20 17:12:52 mail postfix/anvil[6973]: statistics: max connection rate 1/60s for (smtp:211.99.188.250) at Sep 20 17:05:20
Sep 20 17:12:52 mail postfix/anvil[6973]: statistics: max connection count 1 for (smtp:211.99.188.250) at Sep 20 17:05:20
Sep 20 17:12:52 mail postfix/anvil[6973]: statistics: max cache size 2 at Sep 20 17:05:44
Sep 20 17:13:13 mail postfix/smtpd[7238]: connect from unknown[220.181.15.29]
Sep 20 17:14:41 mail amavis[5610]: (05610-12) (!)rw_loop: leaving rw loop, no progress
Sep 20 17:15:59 mail postfix/trivial-rewrite[7163]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (110)
Sep 20 17:15:59 mail postfix/trivial-rewrite[7163]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Sep 20 17:16:00 mail postfix/master[2269]: warning: process /usr/libexec/postfix/trivial-rewrite pid 7163 exit status 1
Sep 20 17:16:05 mail postfix/smtpd[7316]: connect from unknown[219.133.41.119]
Sep 20 17:16:22 mail postfix/trivial-rewrite[7241]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (110)
Sep 20 17:16:29 mail postfix/smtpd[7330]: connect from unknown[211.154.3.34]
Sep 20 17:17:32 mail amavis[5610]: (05610-12) (!)rw_loop: leaving rw loop, no progress
Sep 20 17:17:44 mail postfix/smtpd[7359]: connect from unknown[211.154.3.34]
Sep 20 17:18:32 mail amavis[5610]: (05610-12) (!)rw_loop: leaving rw loop, no progress
Sep 20 17:18:32 mail amavis[5610]: (05610-12) Negative SMTP resp. to DATA:
Sep 20 17:18:52 mail amavis[5610]: (05610-12) (!)rw_loop: leaving rw loop, no progress
Sep 20 17:18:53 mail amavis[5610]: (05610-12) (!)rw_loop: leaving rw loop, no progress

  • 注册日期: 2009-12-18
  • 文章数: 156

回复: 关于maillog出错问题

http://www.faqforge.com/linux/controlpa … nnections/

看看是不是这个问题。

  • 注册日期: 2010-01-26
  • 文章数: 11

回复: 关于maillog出错问题

遇到过最大连接数问题,在出现上面日志之前,我已经把最大连接数改为1500了,上面出现的是
Sep 20 17:12:50 mail postfix/trivial-rewrite[7163]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (110)

  • 注册日期: 2009-12-18
  • 文章数: 2,864

回复: 关于maillog出错问题

你在另外一个帖子里说你用的是 iRedMail-0.4.0？
如果是的话，将 postfix main.cf 里的所有 mysql 查询相关的参数前面加上 'proxy:'。如：

# 现有设置
#transport_maps = mysql:/xxx/xxx.cf

# 修改后的：
transport_maps = proxy:mysql:/xxx/xxx/cf

应该可以立即解决你的问题。