generic mail problem

Discussion in 'Server Operation' started by Ovidiu, Feb 6, 2013.

  1. Ovidiu

    Ovidiu Active Member

    Running Debian Squeeze, perfect server with ISPCFG3, brand new server, currently busy setting it up and all of a sudden I've got a couple of email problems. My guess is that it is MYSQL related? Please have a look at this partial log, I think its MYSQL but unsure where to start debugging:

    I found a few similar threads and the suggestion was to try if the credentials


    Code:
    mail.warn
    Feb  6 00:01:50 h2118175 postfix/cleanup[22145]: warning: 466874241DD: virtual_alias_maps map lookup problem for [email protected]
    Feb  6 00:01:50 h2118175 postfix/cleanup[22145]: warning: 469E74241DD: virtual_alias_maps map lookup problem for [email protected]
    Feb  6 00:01:50 h2118175 amavis[5825]: (05825-13) (!)FWD via SMTP: <[email protected]> -> <[email protected]>,BODY=7BIT 451 4.3.0 TempFailed, id=05825-13, from MTA([127.0.0.1]:10025): 451 4.3.0 Error: queue file write error
    Feb  6 00:01:50 h2118175 postfix/smtp[22148]: warning: mysql query failed: MySQL server has gone away
    Feb  6 00:01:50 h2118175 postfix/smtp[22148]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Feb  6 00:01:51 h2118175 postfix/qmgr[3890]: warning: private/amavis socket: malformed response
    Feb  6 00:01:51 h2118175 postfix/qmgr[3890]: warning: transport amavis failure -- see a previous warning/fatal/panic logfile record for the problem description
    Feb  6 00:01:51 h2118175 postfix/master[3887]: warning: process /usr/lib/postfix/smtp pid 22148 exit status 1
    Feb  6 00:20:18 h2118175 postgrey[3911]: Couldn't unlink "/var/run/postgrey.pid" [Permission denied]
    Feb  6 00:20:18 h2118175 dovecot: dovecot: Killed with signal 15 (by pid=818 uid=0 code=kill)
    Feb  6 09:02:29 h2118175 postfix/smtpd[21207]: warning: 62.245.48.3: hostname 3.48-245-62.FTTH.rus-com.net verification failed: Name or service not known
    Feb  6 13:02:34 h2118175 postfix/smtpd[26679]: warning: 177.131.173.60: hostname 177-133-173-60.cliente.sumicity.com.br verification failed: Name or service not known
    Feb  6 15:16:36 h2118175 dovecot: dovecot: Killed with signal 15 (by pid=30903 uid=0 code=kill)
    Feb  6 15:16:36 h2118175 postgrey[4137]: Couldn't unlink "/var/run/postgrey.pid" [Permission denied]
    Code:
    mail.err
    Feb  5 15:46:03 h2118175 postfix/trivial-rewrite[10955]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Feb  6 00:01:50 h2118175 postfix/smtp[22148]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    btw. I tried: mysql -u ispconfig -pXXX and it worked while XXX being the password inside: /etc/postfix/mysql-virtual_domains.cf

    Its not the limits on MYSQL connections because I checked: [OK] Highest usage of available connections: 22% (22/100)

    Any other suggestions?
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    maybe just a broken table.

    what shows?

    mysqlrepair -c --database DATABASE
    ?
     
  3. Ovidiu

    Ovidiu Active Member

    I didn't know which DATABASE to check so I checked all. All showed either OK or simply no output to the command: mysqlrepair -c --database DATABASE

    Lets see if that changed anything but I doubt it.
     
  4. Ovidiu

    Ovidiu Active Member

    SOLVED: it was my fault, my MYSQL wait_timeout variable was set too low.
     

Share This Page