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=16)
-   -   Please enter your MySQL server:localhost The MySQL server you specified cannot be rea (http://www.howtoforge.com/forums/showthread.php?t=3036)

Null 10th March 2006 16:31

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

falko 10th March 2006 18:45

What's in /etc/hosts?

Null 10th March 2006 20:04

Quote:

Originally Posted by falko
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

falko 11th March 2006 10:59

I'd also add localhost.localdomain.

Please restart MySQL. Does
Code:

mysql -h localhost -u root -p
work?

Null 11th March 2006 19:07

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

falko 11th March 2006 21:06

What's the output of
Code:

ping -c2 localhost
? Do you have a firewall that prevents pings? Your firewall must allow pings.

fbnewtz 30th July 2006 00:13

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

fbnewtz 30th July 2006 05:11

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

ginoitalo 25th March 2007 23:42

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 :confused:

till 26th March 2007 08:51

Please make sure that your password does not contain any special chars that might be interpreted by a shell as commands.


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

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