LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 10-31-2010, 05:41 PM   #1
razzera
Member
 
Registered: Dec 2009
Posts: 105

Rep: Reputation: 15
mysql system error: 111


this has now been solved however PLEASE read the text bellow and then tell me what the problem could be. i solved it by changeing $sql_host="sql.myserver.com"; to $sql_host="sqlserverIP";

why would this change anyting and how could this happen all of a sudden??

ORIGINAL POST

Hello

I have 2 (let's call them A & B)webservers and 1 mysql server runnning all on debian. both webservers use the mysql server for all websites on them. Today i noticed server A had this message "FATAL ERROR: Connection to database server failed.Lost connection to MySQL server at 'reading initial communication packet', system error: 111"

I thougt it was a problem on the mysql server however the sql server is up and running and server B dont have this error and displays all websites thats hosted on it fine without any mysql errors. Why is server A displaying this message ? this error was not there yesterday and i have not done any changes to it.

Last edited by razzera; 10-31-2010 at 06:07 PM.
 
Old 10-31-2010, 08:51 PM   #2
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

Lots of potential reasons, including temporary "network hiccough".

Here's the mysql page on the subject:
http://dev.mysql.com/doc/refman/5.0/...onnection.html
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
curl: (7) socket error: 111 thomas2004ch Linux - Newbie 1 09-11-2009 10:57 PM
ping -c 4 172.1.8.111 hangs my system venkatesh111 Programming 0 05-13-2006 01:14 AM
ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111) eantoranz Ubuntu 4 09-06-2005 02:47 PM
socket error 111 Muzica Linux - Software 0 02-13-2004 08:35 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 12:54 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration