Postfix/Dovecot -> MySQL server vanishes

Discussion in 'General' started by sjau, Sep 29, 2015.

  1. sjau

    sjau Local Meanie Moderator

    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 "web34@manager.roleplayer.org"
    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 "thorstenberger82@gmail.com"
    Sep 29 19:24:30 manager postfix/cleanup[28649]: warning: 8159A9E43208: virtual_alias_maps map lookup problem for thorstenberger82@gmail.com -- deferring delivery
    Sep 29 19:24:30 manager postfix/cleanup[28649]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "postmaster@manager.roleplayer.org"
    Sep 29 19:24:30 manager postfix/cleanup[28649]: warning: 81C0F9E43208: virtual_alias_maps map lookup problem for postmaster@manager.roleplayer.org -- 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 "thorstenberger82@gmail.com"
    Sep 29 19:32:15 manager postfix/cleanup[5731]: warning: 9C4DD9E43A41: virtual_alias_maps map lookup problem for thorstenberger82@gmail.com -- deferring delivery
    Sep 29 19:32:15 manager postfix/cleanup[5731]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "postmaster@manager.roleplayer.org"
    Sep 29 19:32:15 manager postfix/cleanup[5731]: warning: 9C82D9E43A41: virtual_alias_maps map lookup problem for postmaster@manager.roleplayer.org -- 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 "root@manager.roleplayer.org"
    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 "root@manager.roleplayer.org"
    Sep 29 20:15:05 manager postfix/cleanup[23088]: warning: 0F9919E40CBB: virtual_alias_maps map lookup problem for root@manager.roleplayer.org -- deferring delivery
    Sep 29 20:15:05 manager postfix/cleanup[23088]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "postmaster@manager.roleplayer.org"
    Sep 29 20:15:05 manager postfix/cleanup[23088]: warning: 1037E9E40CBB: virtual_alias_maps map lookup problem for postmaster@manager.roleplayer.org -- 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 "root@manager.roleplayer.org"
    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 "root@manager.roleplayer.org"
    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]
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    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?
     

Share This Page