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 Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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 Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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 Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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 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 Howtoforge Staff HowtoForge Supporter ISPConfig Developer

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

Share This Page