Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
From: "Vic Feria" <danzman1@comcast.net>
To: <users@httpd.apache.org>,
	<vasiliy@linuxspecial.com>
Date: Thu, 18 May 2006 17:47:21 -0500
Organization: POGEE Technologies, Inc.
Message-ID: <002d01c67acd$06555da0$0800a8c0@DANZMAN>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="windows-1250"
Content-Transfer-Encoding: quoted-printable
In-Reply-To: <446CC48B.8090801@linuxspecial.com>
Importance: Normal
Subject: RE: [users@httpd] Apache,php to mysql problem

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]=20
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=20
much detail as I can...

	Diagram:
		=09

        		    Internet		=09
			X		=09
			XXXXX mysql server		=09
			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=20
databases on mysql server.  Pages just time out.

	For now, things are OK, since I disabled web requests going to OH2
in=20
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=20
destinations.  I am able to verify that packet streams look alike.  I=20
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=20
port 3307, so I have pretty much established that the problem is not=20
network connectivity.  I have also looked over iptables just for grins.

	Nothing useful is being logged to the apache logs :(


PLEASE HELP!

THANKS!

--=20
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

--=20
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
=20

--=20
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
=20


---------------------------------------------------------------------
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