Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 10th March 2006, 16:31
Null Null is offline
Junior Member
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 10th March 2006, 18:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

What's in /etc/hosts?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 10th March 2006, 20:04
Null Null is offline
Junior Member
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 11th March 2006, 10:59
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

I'd also add localhost.localdomain.

Please restart MySQL. Does
Code:
mysql -h localhost -u root -p
work?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 11th March 2006, 19:07
Null Null is offline
Junior Member
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes mysql -h localhost -u root -p works fine I've tried re-installing mysql and can't find a problem with it
Reply With Quote
  #6  
Old 11th March 2006, 21:06
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

What's the output of
Code:
ping -c2 localhost
? Do you have a firewall that prevents pings? Your firewall must allow pings.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 30th July 2006, 00:13
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 2 Times in 2 Posts
Default 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
Reply With Quote
  #8  
Old 30th July 2006, 05:11
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 2 Times in 2 Posts
Default 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
Reply With Quote
  #9  
Old 25th March 2007, 23:42
ginoitalo ginoitalo is offline
Junior Member
 
Join Date: Mar 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Last edited by ginoitalo; 25th March 2007 at 23:44.
Reply With Quote
  #10  
Old 26th March 2007, 08:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
 
Default

Please make sure that your password does not contain any special chars that might be interpreted by a shell as commands.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistic not working mzo Installation/Configuration 49 20th April 2011 12:19
error 2003: Can't connect to MySQL server jorge Installation/Configuration 1 2nd March 2006 06:25
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
Email - Ueb-Miau mazhar Installation/Configuration 5 21st December 2005 10:01
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 02:30


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


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