table lookup problem

Discussion in 'Installation/Configuration' started by aurelius, Nov 1, 2011.

  1. aurelius

    aurelius Member

    Hello,

    Since I upgraded to Mysql 5.5 I can't start it anymore. The syslog gives this messages.

    Nov 1 13:20:36 slv1 postfix/proxymap[991]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
    Nov 1 13:20:36 slv1 postfix/proxymap[991]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2522]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2523]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2524]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2525]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2526]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2527]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2528]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2529]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2530]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2531]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2532]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2533]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2534]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2535]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2536]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2537]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2538]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2539]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2540]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2541]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2542]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:36 slv1 postfix/trivial-rewrite[2543]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Nov 1 13:20:37 slv1 postfix/smtpd[990]: warning: problem talking to service rewrite: Success
    Nov 1 13:20:37 slv1 postfix/master[909]: warning: process /usr/lib/postfix/trivial-rewrite pid 2522 exit status 1
    Nov 1 13:20:37 slv1 postfix/master[909]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
    Nov 1 13:20:37 slv1 postfix/smtpd[1034]: warning: problem talking to service rewrite: Connection reset by peer
    Nov 1 13:20:37 slv1 postfix/smtpd[1005]: warning: problem talking to service rewrite: Connection reset by peer
    Nov 1 13:20:37 slv1 postfix/smtpd[1038]: warning: problem talking to service rewrite: Success
    Nov 1 13:20:37 slv1 postfix/master[909]: warning: process /usr/lib/postfix/trivial-rewrite pid 2523 exit status 1
    Nov 1 13:20:37 slv1 postfix/master[909]: warning: process /usr/lib/postfix/trivial-rewrite pid 2524 exit status 1
    Nov 1 13:20:37 slv1 postfix/smtpd[1039]: warning: problem talking to service rewrite: Success
    Nov 1 13:20:37 slv1 postfix/smtpd[1016]: warning: problem talking to service rewrite: Connection reset by peer
    Nov 1 13:20:37 slv1 postfix/smtpd[1055]: warning: problem talking to service rewrite: Connection reset by peer
    Nov 1 13:20:37 slv1 postfix/smtpd[1078]: warning: problem talking to service rewrite: Success
    Nov 1 13:20:37 slv1 postfix/master[909]: warning: process /usr/lib/postfix/trivial-rewrite pid 2525 exit status 1
    Nov 1 13:20:37 slv1 postfix/master[909]: warning: process /usr/lib/postfix/trivial-rewrite pid 2526 exit status 1
    Nov 1 13:20:37 slv1 postfix/smtpd[1247]: warning: problem talking to service rewrite: Success
    Nov 1 13:20:37 slv1 postfix/smtpd[1049]: warning: problem talking to service rewrite: Connection reset by peer
    Nov 1 13:20:37 slv1 postfix/smtpd[1227]: warning: problem talking to service rewrite: Connection reset by peer
    Nov 1 13:20:37 slv1 postfix/smtpd[1224]: warning: problem talking to service rewrite: Success
    Nov 1 13:20:37 slv1 postfix/master[909]: warning: process /usr/lib/postfix/trivial-rewrite pid 2527 exit status 1
    Nov 1 13:20:37 slv1 postfix/smtpd[1248]: warning: problem talking to service rewrite: Connection reset by peer
    Nov 1 13:20:37 slv1 postfix/smtpd[1250]: warning: problem talking to service rewrite: Success
    Nov 1 13:20:37 slv1 postfix/master[909]: warning: process /usr/lib/postfix/trivial-rewrite pid 2528 exit status 1
    Nov 1 13:20:37 slv1 postfix/smtpd[1119]: warning: problem talking to service rewrite: Connection reset by peer
    Nov 1 13:20:37 slv1 postfix/smtpd[1353]: warning: problem talking to service rewrite: Success.

    Can this be a problem with mysql 5.5, is it better to downgrade to 5.1

    Thanks, aurelius
     
    aurelius, Nov 1, 2011
    #1
  2. aurelius

    aurelius Member

    problem solved, the downgrade did the trick
     
    aurelius, Nov 1, 2011
    #2
  3. aurelius

    aurelius Member

    there is now another problem. The task list does not cleared anymore after a change. When I do execute /usr/local/ispconfig/server/server.sh I get the error message

    rning: mysql_connect(): [2002] Connection refused (trying to connect via tcp://msr.srvohm.nl:3306) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 78
    PHP Warning: mysql_connect(): Connection refused in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 78
    PHP Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63
    PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64
    PHP Warning: mysql_connect(): [2002] Connection refused (trying to connect via tcp://msr.srvohm.nl:3306) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 78
    PHP Warning: mysql_connect(): Connection refused in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 78
    PHP Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63
    PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

    What is causing this?

    Thanks
     
    aurelius, Nov 1, 2011
    #3
  4. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    netstat -tap
    ?
     
    falko, Nov 2, 2011
    #4
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    One question in addition to falkos question: Is this a single or multiserver system?
     
    till, Nov 2, 2011
    #5
  6. aurelius

    aurelius Member

    Hello,

    It's a multiserver system.

    The output of netstat:

    tcp 0 0 localhost:10024 *:* LISTEN 318/amavisd (master
    tcp 0 0 *:14729 *:* LISTEN 960/perl
    tcp 0 0 localhost:10025 *:* LISTEN 909/master
    tcp 0 0 *:mysql *:* LISTEN 6093/mysqld
    tcp 0 0 *:www *:* LISTEN 341/apache2
    tcp 0 0 *:tproxy *:* LISTEN 341/apache2
    tcp 0 0 *:ftp *:* LISTEN 8589/pure-ftpd (SER
    tcp 0 0 slv1.srvohm.nl:domain *:* LISTEN 326/named
    tcp 0 0 localhost:domain *:* LISTEN 326/named
    tcp 0 0 *:ssh *:* LISTEN 948/sshd
    tcp 0 0 *:smtp *:* LISTEN 909/master
    tcp 0 0 localhost:953 *:* LISTEN 326/named
    tcp 0 0 *:https *:* LISTEN 341/apache2
    tcp 0 0 slv1.srvohm.nl:www ez-in-f85.1e100.n:57969 ESTABLISHED 27303/apache2
    tcp 0 0 localhost:mysql localhost:52567 ESTABLISHED 6093/mysqld
    tcp 0 0 localhost:52567 localhost:mysql ESTABLISHED 25487/amavisd (ch13
    tcp 0 0 localhost:51557 localhost:mysql ESTABLISHED 24305/amavisd (ch16
    tcp 0 0 slv1.srvohm.nl:www 74.125.78.84:63345 ESTABLISHED 28452/apache2
    tcp 0 0 slv1.srvohm.nl:www 66.102.12.94:42324 ESTABLISHED 27267/apache2
    tcp 0 0 slv1.srvohm.nl:www 74.125.78.84:48378 ESTABLISHED 27334/apache2
    tcp 0 0 localhost:mysql localhost:51557 ESTABLISHED 6093/mysqld
    tcp6 0 0 [::]:imaps [::]:* LISTEN 1647/couriertcpd
    tcp6 0 0 [::]:pop3s [::]:* LISTEN 1676/couriertcpd
    tcp6 0 0 [::]:pop3 [::]:* LISTEN 1689/couriertcpd
    tcp6 0 0 [::]:imap2 [::]:* LISTEN 1615/couriertcpd
    tcp6 0 0 [::]:ftp [::]:* LISTEN 8589/pure-ftpd (SER
    tcp6 0 0 [::]:domain [::]:* LISTEN 326/named
    tcp6 0 0 [::]:ssh [::]:* LISTEN 948/sshd
    tcp6 0 0 localhost:953 [::]:* LISTEN 326/named
    tcp6 0 0 slv1.srvohm.nl:pop3 5ED001C4.cm-7-1a.d:1031 TIME_WAIT -
     
    aurelius, Nov 2, 2011
    #6

Share This Page