View Single Post
  #12  
Old 14th January 2011, 14:15
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default

This is getting more and more strange.

Tried to run the same on one of the remotes and got :
Code:
Unable to connect to mysql server Lost connection to MySQL server at 'reading initial communication packet', system error: 111
If I connect to mysql from phpmyadmin - no problem, even using remote connection - got phpmyadmin on one site.

Then I tried
Code:
mysql -h db9.superweb.dk -P 3308 -u root -p
on the master (master is db9.superweb.dk / 92.62.196.69) and no problems conneting. Router is set to external port 3308 - internal port 3306
Tried the same from one of the other servers and got :
Code:
ERROR 2003 (HY000): Can't connect to MySQL server on '92.62.196.69' (111)
In my my.inf :
Code:
[client]
port            = 3308
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3308
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
tried with 3306 and a restart but still the same, exept that ispconfig works, but then phpmyadmin doesnt.

Finally did a ps :
Code:
web:/var/log/mysql# ps -efH | grep mysql
root     21985 14541  0 14:13 pts/1    00:00:00         grep mysql
root     21494     1  0 13:56 pts/1    00:00:00   /bin/sh /usr/bin/mysqld_safe
mysql    21531 21494  0 13:56 pts/1    00:00:00     /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3308 --socket=/var/run/mysqld/mysqld.sock
root     21532 21494  0 13:56 pts/1    00:00:00     logger -p daemon.err -t mysqld_safe -i -t mysqld
web:/var/log/mysql#
I am still lost and have lost ftp connection to the domains also.
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe

Last edited by DKLeader; 14th January 2011 at 15:20. Reason: more info
Reply With Quote