PHP Live! Help Desk
Search:
» Help Desk Home » Errors and Troubleshooting » mysql_connect: No route to host
mysql_connect: No route to host

The error indicates some sort of network communication issue with the MySQL server.  The PHP Live! MySQL information that was provided during the initial PHP Live! installation is located at the phplive/web/config.php file.  First, double check that the SQL values are correct within that file.

 


* The following solution source URL: www.cyberciti.biz/tips/no-route-to-host-error-and-solution.html

 

I am getting error that read as No Route to Host. I am trying to ping my ISP gateway as well as DNS server but I am getting this error. How do I solve this problem?

 

This problem indicate networking conflicts or some sort of networking configuration problem.

 

Here are things to check:

Can you ping to your local router interface (such as 192.168.1.254)?

Make sure your card (eth0) is properly configured with correct IP address and router address. Use ifconfig command to configure IP address and route command to setup correct router address. If you prefer to use GUI tools:

  • redhat-config-network - Works on Red Hat and Fedora Linux/Cent OS.
  • network-admin - Debian and Other Linux distribution use this GUI too

Use above two GUI tools to setup correct IP address, DNS address and router address.

 

Make sure firewall is not blocking your access

iptables is default firewall on Linux. Run following command to see what iptables rules are setup:
# /sbin/iptables -L -n

 

You can temporary clear all iptables rules so that you can troubleshoot problem. If you are using Red Hat or Fedora Linux type command:
# /etc/init.d/iptables save
# /etc/init.d/iptables stop

 

If you are using other Linux distribution type following commands:
# iptables -F
# iptables -X
# iptables -t nat -F
# iptables -t nat -X
# iptables -t mangle -F
# iptables -t mangle -X

 

Finally make sure you are using a router and not a proxy server. Proxy servers are good for Internet browsing but not for other work such as ftp, sending ICMP request and so on.

Was this helpful?
could be more helpful? let us know
1 people found this helpful