Please enter your MySQL server:localhost The MySQL server you specified cannot be rea

Hey Folks

Just installed ISPconfig and got to the point of telling it the MySQL server.

I get this wehn I enter local host.

Please enter your MySQL server:localhost
The MySQL server you specified cannot be reached!

I can connect to the MySQl with administrator and other programs just not this one

netstat -tap output is

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 megamultihost.com:61865 *:* LISTEN 5981/wish
tcp 0 0 *:mysql *:* LISTEN 7364/mysqld-max
tcp 0 0 *:ircd *:* LISTEN 6083/ircd
tcp 0 0 *:netbios-ssn *:* LISTEN 5288/smbd
tcp 0 0 *:sunrpc *:* LISTEN 2796/portmap
tcp 0 0 *:http *:* LISTEN 5453/httpd
tcp 0 0 *:2710 *:* LISTEN 5512/upsd
tcp 0 0 *:ipp *:* LISTEN 4552/cupsd
tcp 0 0 *:9080 *:* LISTEN 5250/python
tcp 0 0 *:9081 *:* LISTEN 5250/python
tcp 0 0 *:https *:* LISTEN 5453/httpd
tcp 0 0 *:microsoft-ds *:* LISTEN 5288/smbd
tcp 0 0 *:9021 *:* LISTEN 5250/python

cheers Jeff

 

What's in /etc/hosts?

 

its got all the required host atm

/etc/hosts

127.0.0.1 megamultihost.com megamultihost localhost megahost.ie megahost

 

I'd also add localhost.localdomain.

Please restart MySQL. Does

Code:

mysql -h localhost -u root -p

work?

 

Yes mysql -h localhost -u root -p works fine I've tried re-installing mysql and can't find a problem with it

 

What's the output of

Code:

ping -c2 localhost

? Do you have a firewall that prevents pings? Your firewall must allow pings.

 

Same Problem

I have the same problem as above. Everything was going great minus the Ruby installation issues, which I solved. Now I cannot connect to mysql either for some reason.

Please enter your MySQL server:localhost
The MySQL server you specified cannot be reached!


Here is the output from Ping:

/etc/mysql# ping -c2 localhost
PING localhost.localdomain (127.0.0.1) 56(84) bytes of data.
From localhost.localdomain (127.0.0.1) icmp_seq=1 Destination Port Unreachable
From localhost.localdomain (127.0.0.1) icmp_seq=2 Destination Port Unreachable

--- localhost.localdomain ping statistics ---
2 packets transmitted, 0 received, +2 errors, 100% packet loss, time 999ms


Here is the output of restarting mysql:

/etc/mysql# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.


Please let me know if I am missing anything here.

Thanks,

Fred

 

Fixed:

My problem was relating to ipchains. My machine was setup to block everything besides the ports that were specifically opened. Once I cleared that up everything worked just fine.

Fred

 

I'm having a similar issue on ubuntu 6.10, the ispconfig can't connect to mysql....

Code:

root@ubuntu:/var/log# ping -c2 localhost
PING localhost (127.0.0.1) 56(84) bytes of data.

root@ubuntu:/var/log# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 *:mysql                 *:*                     LISTEN     9750/mysqld

root@ubuntu:/var/log# cat /etc/hosts
127.0.0.1       localhost
127.0.0.1       ubuntu ubuntu.server.com localhost.localdomain

root@ubuntu:/var/log# mysql -uroot -hlocalhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.24a-Debian_9ubuntu0.1

Is this a ipchains firewall issue? What exactly in ipchains needed to be fixed, and where is the config file for that? sorry, I've never used them before