View Single Post
  #14  
Old 4th November 2011, 11:43
ande ande is offline
Junior Member
 
Join Date: Jan 2008
Location: Freiburg, Germany
Posts: 29
Thanks: 5
Thanked 0 Times in 0 Posts
Default

It appears that both amavis and postfix (trivial-rewrite and smtp) are sometimes not able to access MySQL. I turned on -v for smtp and trivial-rewrite:

Quote:
>>> START Client host RESTRICTIONS <<<
Nov 4 11:38:57 eins postfix/smtpd[8001]: generic_checks: name=check_client_access
Nov 4 11:38:57 eins postfix/smtpd[8001]: check_namadr_access: name unknown addr 95.86.108.61
Nov 4 11:38:57 eins postfix/smtpd[8001]: check_domain_access: unknown
Nov 4 11:38:57 eins postfix/smtpd[8001]: dict_mysql_get_active: found active connection to host 127.0.0.1
Nov 4 11:38:57 eins postfix/smtpd[8001]: warning: mysql query failed: MySQL server has gone away
Nov 4 11:38:57 eins postfix/smtpd[8001]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
Nov 4 11:38:57 eins postfix/smtpd[8001]: check_table_result: mysql:/etc/postfix/mysql-virtual_client.cf 451 4.3.5 Server configuration error unknown
Nov 4 11:38:57 eins postfix/smtpd[8001]: NOQUEUE: reject: RCPT from unknown[95.86.108.61]: 451 4.3.5 <unknown[95.86.108.61]>: Client host rejected: Server configuration error; from=<heuer@xxx.de> to=<heuer@forum-vauban.de> proto=ESMTP helo=<95.86.108.61>
Nov 4 11:38:57 eins postfix/smtpd[8001]: generic_checks: name=check_client_access status=2
Nov 4 11:38:57 eins postfix/smtpd[8001]: > unknown[95.86.108.61]: 451 4.3.5 <unknown[95.86.108.61]>: Client host rejected: Server configuration error
Nov 4 11:38:57 eins postfix/trivial-rewrite[8114]: connection closed fd 129
Nov 4 11:38:57 eins postfix/smtpd[8001]: smtp_get: EOF
Port 3306 is open (needed for replication) and socket might be as well functioning.

Might it be that Postfix thinks a connection is still open while MySQL already closed it?

Last edited by ande; 4th November 2011 at 11:45.
Reply With Quote