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

Discussion in 'Installation/Configuration' started by Null, Mar 10, 2006.

  1. Null

    Null New Member

    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
     
  2. falko

    falko Super Moderator

    What's in /etc/hosts?
     
  3. Null

    Null New Member

    its got all the required host atm

    /etc/hosts

    127.0.0.1 megamultihost.com megamultihost localhost megahost.ie megahost
     
  4. falko

    falko Super Moderator

    I'd also add localhost.localdomain.

    Please restart MySQL. Does
    Code:
    mysql -h localhost -u root -p
    work?
     
  5. Null

    Null New Member

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

    falko Super Moderator

    What's the output of
    Code:
    ping -c2 localhost
    ? Do you have a firewall that prevents pings? Your firewall must allow pings.
     
  7. fbnewtz

    fbnewtz New Member

    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
     
  8. fbnewtz

    fbnewtz New Member

    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
     
  9. ginoitalo

    ginoitalo ISPConfig Developer

    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:
     
    Last edited: Mar 25, 2007
  10. till

    till Super Moderator

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

Share This Page