Hi there I'm having an issue that mysql keeps disappearing for postfix/dovecot: Code: Sep 29 19:24:30 manager postfix/proxymap[26072]: warning: mysql query failed: MySQL server has gone away Sep 29 19:24:30 manager postfix/trivial-rewrite[26082]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 19:24:30 manager postfix/proxymap[26072]: warning: mysql query failed: MySQL server has gone away Sep 29 19:24:30 manager postfix/trivial-rewrite[26082]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "[email protected]" Sep 29 19:24:30 manager postfix/trivial-rewrite[26082]: warning: transport_maps lookup failure Sep 29 19:24:30 manager postfix/trivial-rewrite[26082]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 19:24:30 manager postfix/trivial-rewrite[26082]: warning: virtual_mailbox_domains lookup failure Sep 29 19:24:30 manager postfix/proxymap[26072]: warning: mysql query failed: MySQL server has gone away Sep 29 19:24:30 manager postfix/cleanup[28649]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "[email protected]" Sep 29 19:24:30 manager postfix/cleanup[28649]: warning: 8159A9E43208: virtual_alias_maps map lookup problem for [email protected] -- deferring delivery Sep 29 19:24:30 manager postfix/cleanup[28649]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "[email protected]" Sep 29 19:24:30 manager postfix/cleanup[28649]: warning: 81C0F9E43208: virtual_alias_maps map lookup problem for [email protected] -- deferring delivery Sep 29 19:32:15 manager postfix/proxymap[5732]: warning: mysql query failed: MySQL server has gone away Sep 29 19:32:15 manager postfix/trivial-rewrite[5733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 19:32:15 manager postfix/trivial-rewrite[5733]: warning: virtual_mailbox_domains lookup failure Sep 29 19:32:15 manager postfix/proxymap[5732]: warning: mysql query failed: MySQL server has gone away Sep 29 19:32:15 manager postfix/cleanup[5731]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "[email protected]" Sep 29 19:32:15 manager postfix/cleanup[5731]: warning: 9C4DD9E43A41: virtual_alias_maps map lookup problem for [email protected] -- deferring delivery Sep 29 19:32:15 manager postfix/cleanup[5731]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "[email protected]" Sep 29 19:32:15 manager postfix/cleanup[5731]: warning: 9C82D9E43A41: virtual_alias_maps map lookup problem for [email protected] -- deferring delivery Sep 29 19:32:27 manager postfix/smtpd[8454]: warning: mysql query failed: MySQL server has gone away Sep 29 19:32:27 manager postfix/smtpd[8454]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem Sep 29 19:33:01 manager postfix/smtpd[8454]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem Sep 29 19:48:00 manager postfix/smtpd[11250]: warning: unknown[93.174.93.28]: SASL LOGIN authentication failed: UGFzc3dvcmQ6 Sep 29 19:57:35 manager postfix/smtpd[4421]: warning: unknown[95.215.0.203]: SASL LOGIN authentication failed: UGFzc3dvcmQ6 Sep 29 20:02:14 manager postfix/smtpd[18948]: warning: hostname uranus.dnsracks.com does not resolve to address 184.154.53.180 Sep 29 20:02:36 manager postfix/smtpd[18948]: warning: hostname hosted-by.hostgrad.ru does not resolve to address 185.40.4.33 Sep 29 20:02:38 manager postfix/smtpd[18948]: warning: unknown[185.40.4.33]: SASL LOGIN authentication failed: UGFzc3dvcmQ6 Sep 29 20:12:19 manager postfix/smtp[22457]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111) Sep 29 20:12:19 manager postfix/smtp[22457]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem Sep 29 20:12:19 manager postfix/smtp[22457]: warning: 076529E44A0B: flush service failure Sep 29 20:15:05 manager postfix/proxymap[23076]: warning: mysql query failed: MySQL server has gone away Sep 29 20:15:05 manager postfix/trivial-rewrite[23077]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:15:05 manager postfix/proxymap[23076]: warning: mysql query failed: MySQL server has gone away Sep 29 20:15:05 manager postfix/trivial-rewrite[23077]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "[email protected]" Sep 29 20:15:05 manager postfix/trivial-rewrite[23077]: warning: transport_maps lookup failure Sep 29 20:15:05 manager postfix/proxymap[23076]: warning: mysql query failed: MySQL server has gone away Sep 29 20:15:05 manager postfix/cleanup[23088]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "[email protected]" Sep 29 20:15:05 manager postfix/cleanup[23088]: warning: 0F9919E40CBB: virtual_alias_maps map lookup problem for [email protected] -- deferring delivery Sep 29 20:15:05 manager postfix/cleanup[23088]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "[email protected]" Sep 29 20:15:05 manager postfix/cleanup[23088]: warning: 1037E9E40CBB: virtual_alias_maps map lookup problem for [email protected] -- deferring delivery Sep 29 20:21:30 manager postfix/smtpd[25472]: warning: hostname 155.133.19.233.ptr1-vnet.pl does not resolve to address 155.133.19.233 Sep 29 20:21:32 manager postfix/smtpd[25472]: warning: unknown[155.133.19.233]: SASL LOGIN authentication failed: UGFzc3dvcmQ6 Sep 29 20:26:08 manager postfix/smtpd[27823]: warning: unknown[93.174.93.28]: SASL LOGIN authentication failed: UGFzc3dvcmQ6 Sep 29 20:29:50 manager postfix/proxymap[30367]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111) Sep 29 20:29:50 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*" Sep 29 20:29:50 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*" Sep 29 20:29:50 manager postfix/proxymap[30367]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111) Sep 29 20:29:50 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:29:50 manager postfix/trivial-rewrite[30369]: warning: virtual_mailbox_domains lookup failure Sep 29 20:29:50 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:29:50 manager postfix/trivial-rewrite[30369]: warning: virtual_mailbox_domains lookup failure Sep 29 20:29:50 manager postfix/smtpd[30366]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111) Sep 29 20:29:50 manager postfix/smtpd[30366]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem Sep 29 20:30:04 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:30:04 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "[email protected]" Sep 29 20:30:04 manager postfix/trivial-rewrite[30369]: warning: transport_maps lookup failure Sep 29 20:30:04 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:30:04 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "[email protected]" Sep 29 20:30:04 manager postfix/trivial-rewrite[30369]: warning: transport_maps lookup failure Sep 29 20:30:04 manager postfix/trivial-rewrite[30369]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:30:04 manager postfix/trivial-rewrite[30369]: warning: virtual_mailbox_domains lookup failure Sep 29 20:37:24 manager postfix/proxymap[32513]: warning: mysql query failed: MySQL server has gone away Sep 29 20:37:24 manager postfix/trivial-rewrite[32517]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:37:24 manager postfix/trivial-rewrite[32517]: warning: virtual_mailbox_domains lookup failure Sep 29 20:45:57 manager postfix/proxymap[6927]: warning: mysql query failed: MySQL server has gone away Sep 29 20:45:57 manager postfix/trivial-rewrite[7095]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:45:57 manager postfix/trivial-rewrite[7095]: warning: virtual_mailbox_domains lookup failure Sep 29 20:45:57 manager postfix/trivial-rewrite[7095]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem Sep 29 20:45:57 manager postfix/trivial-rewrite[7095]: warning: virtual_mailbox_domains lookup failure It happens all the time and I have no idea why.[/code]
Can't connect to MySQL server on '127.0.0.1' (111) = mysql refuses the connection. Can you access mysql with user/password from /etc/postfix/mysql-virtual_domains.cf?
