#1  
Old 1st November 2011, 13:25
aurelius aurelius is offline
Member
 
Join Date: Oct 2008
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 1st November 2011, 14:15
aurelius aurelius is offline
Member
 
Join Date: Oct 2008
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

problem solved, the downgrade did the trick
Reply With Quote
  #3  
Old 1st November 2011, 14:47
aurelius aurelius is offline
Member
 
Join Date: Oct 2008
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 2nd November 2011, 18:18
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,732 Times in 2,569 Posts
Default

What's the output of
Code:
netstat -tap
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 2nd November 2011, 18:20
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,248 Times in 4,113 Posts
Default

One question in addition to falkos question: Is this a single or multiserver system?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 2nd November 2011, 19:12
aurelius aurelius is offline
Member
 
Join Date: Oct 2008
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 [::]op3s [::]:* LISTEN 1676/couriertcpd
tcp6 0 0 [::]op3 [::]:* 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.nlop3 5ED001C4.cm-7-1a.d:1031 TIME_WAIT -
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending email issue lezelf Installation/Configuration 15 9th August 2011 11:20
deb lenny 64 - mysql-virtual_client.cf: table lookup prob Turbanator General 6 18th October 2010 17:09
Need help get mail to work (can't recieve and apperently can't send) omega13a Installation/Configuration 19 20th August 2009 21:06
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 12:20
Virtual users... Ubuntu 8.04 spaceuser HOWTO-Related Questions 12 19th June 2008 08:04


All times are GMT +2. The time now is 17:47.


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