table lookup problem

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

  1. aurelius

    aurelius New 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
     
  2. aurelius

    aurelius New Member

    problem solved, the downgrade did the trick
     
  3. aurelius

    aurelius New 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
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    What's the output of
    Code:
    netstat -tap
    ?
     
  5. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    One question in addition to falkos question: Is this a single or multiserver system?
     
  6. aurelius

    aurelius New 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 -
     

Share This Page