php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #9879 ISAPI Not handleing connections to MySQL correctly
Submitted: 2001-03-20 14:28 UTC Modified: 2001-11-21 10:46 UTC
From: peter at wowpages dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.4pl1 OS: Win NT
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2001-03-20 14:28 UTC] peter at wowpages dot com 
When running php as an isapi filter, php connects and works properly, but does not reuse persistant connections so that each page view results in many, many open connections to MySQL server, which ulitmately results in errors because of too many connections.  We're connecting with code such as this:

$db_link = mysql_pconnect (DB_HOST, USERNAME, PASSWORD) 
		or die ("Could not connect to database");

Where DB_HOST, USERNAME, and PASSWORD are defined as constants. The php version is 4.4pl1, installed with the windows installer, using the php4isapa.dll from the zipfile.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-11-20 19:43 UTC] mfischer@php.net 
Can you try if the problem still persists with latest RC

http://phpuk.org/~james/php-4.1.0RC3-win32.zip

Feedback.
 [2001-11-21 10:46 UTC] peter at wowpages dot com 
I tried the RC releas, and it seems to work fine.  The original code that caused the problem has been modified, but I made a quick page that does a pconnect and does a query.  calling that page many times, then checking the process list in mysql shows sane values.  So it seems resolved.  Thanks very much.
 [2001-11-21 10:46 UTC] mfischer@php.net 
Great, thank you!

Closing.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat May 11 01:01:31 2024 UTC