Lost Connection to MySQL server

Post here if you need support installing and setting up the phpCart demo.
All posts are moderated (they won't show up right away)

Lost Connection to MySQL server

Postby dino » 07-27-2010 11:37 AM

I just installed the demo cart to my server. I get the following error messages

Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/hehou/public_html/phpsupercart/Connections/catalog.php on line 9

Fatal error: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/hehou/public_html/phpsupercart/Connections/catalog.php on line 9

What have I done wrong?
dino
Licensed
 
Posts: 17
Joined: 10-28-2004 06:12 AM

Re: Lost Connection to MySQL server

Postby ddaudelin » 07-27-2010 01:53 PM

Hello Dino,

It looks like a problem with the server (not the cart software)... where the IP addresses of the server is not properly defined.

Are you using a hosting service or running the cart software on your own local server?

If it's a hosting service, you should ask them for help. If it's your own local server, it looks like it could be a bind problem, just do a Google search on the following statement and you'll get lots of direction:
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Here is the solution for one fellow with a similar problem:
I eventually got it working by matching the "remote address" in the SSH command to the bind-address value in the my.cnf file on the remote server. For most people, the bind-address value is 127.0.0.1, but I have my MySQL server bound to a local network address (192.168.0.x).


I hope that helps!!

Dennis
ddaudelin
Forum Moderator
 
Posts: 156
Joined: 06-23-2006 09:59 AM


Return to PHPCart Demo Installation Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron