httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vic Feria" <danzm...@comcast.net>
Subject RE: [users@httpd] Apache,php to mysql problem
Date Thu, 18 May 2006 22:47:21 GMT
In your mysql setting increase the time-out period. With your application,
include a timing cycle that pings the server every certain time less than
the timeout period. That should remind MySQL server that you are still there
and "alive".

Note this part of the MySQL Manual:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html


-----Original Message-----
From: Vasiliy Boulytchev [mailto:vasiliy@linuxspecial.com] 
Sent: Thursday, May 18, 2006 2:02 PM
To: users@httpd.apache.org
Subject: [users@httpd] Apache,php to mysql problem



Ladies and Gents,

	Thank you so much for your patience, I will describe my problem in
as 
much detail as I can...

	Diagram:
			

        		    Internet			
			X			
			XXXXX mysql server			
			X
		LVS Load Balancer
		    x      x
		   X        X
		  X          X
		 OH1        OH2


	Problem:
	Apache 2.2 on Server OH2, just stopped connecting to the mysql5 
databases on mysql server.  Pages just time out.

	For now, things are OK, since I disabled web requests going to OH2
in 
the load balancer, however, this problem needs to be addressed quickly :)

	Things I have tried:

	1.)	I am able to connect to mysql server via command line...
such as
		mysql -H mysqlserver -u username -p databasename -P 3307

	2.)	I did tcpdumps from both ends, and packets are arriving at
both 
destinations.  I am able to verify that packet streams look alike.  I 
turned on the bad server for a second in LVS, tcpdumped a sample stream, 
saved it, reloaded LVS, and captured a good connection attempt.

	3.)	I am able to ping the mysql server from OH2, i am able to
telnet to 
port 3307, so I have pretty much established that the problem is not 
network connectivity.  I have also looked over iptables just for grins.

	Nothing useful is being logged to the apache logs :(


PLEASE HELP!

THANKS!

-- 
Vasiliy Boulytchev
CIT Internet
www.citinternet.com

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info. To
unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: 5/17/2006
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: 5/17/2006
 


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message