HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   table lookup problem (http://www.howtoforge.com/forums/showthread.php?t=54725)

aurelius 1st November 2011 13:25

table lookup problem
 
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 1st November 2011 14:15

problem solved, the downgrade did the trick

aurelius 1st November 2011 14:47

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

falko 2nd November 2011 18:18

What's the output of
Code:

netstat -tap
?

till 2nd November 2011 18:20

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

aurelius 2nd November 2011 19:12

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 -


All times are GMT +2. The time now is 21:16.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.