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

go to bug id or search bugs for

Bug #30719 can't connect to MySQL after a number of requests
Submitted: 2004-11-08 15:56 UTC Modified: 2004-11-09 11:04 UTC
From: it at videinfra dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.3.9 OS: W2K,WinXp, Win 2003 Srv
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: it at videinfra dot com
New email:
PHP Version: OS:

 

 [2004-11-08 15:56 UTC] it at videinfra dot com 
Description:
------------
I simultaneously run one, absolutely indentical script on two different servers, one running Linux and another Windows. The script on both machines connects to the remote MySQL server on another Linux machine. The PHP script on Linux machine works fine, while the script on Windows machine gives an error - Can't connect to MySQL server on '10.0.1.4' (10048) - after a number of requests. 

I believe that this implies a bug in PHP on Windows, because as seen from the test described above, MySQL connection limit COULD NOT BE THE CAUSE, since the script on the Linux machine continues working with the same database without any problem. Also, PHP configuration files on both platforms are identical.

 

Reproduce code:
---------------
<?
$conn = mysql_connect ( '10.0.1.4', 'root', '') 
or die("Could not connect: " . mysql_error()); mysql_select_db('lub2', $conn); $res = mysql_query("SELECT title FROM pages_lv0 WHERE id = 1", $conn) 
or die("Invalid query: " . mysql_error()); 
mysql_close($conn);
echo "ok";
?>

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-11-08 20:29 UTC] tony2001@php.net 
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. 

Thank you for your interest in PHP.

Duplicate of #30666.
 [2004-11-09 11:04 UTC] it at videinfra dot com 
I submit the same problem, because to my knowledge it is a bug in PHP, a critical one that blocks us from the normal work. Could you please explain how do you judge that this problem is not a bug in PHP? We spent time checking the configuratiom and then conducting a series of test to understand the problem before we submit a bug here. We got a brief reply that the cause of the issue is the MySQL configuration. That just couldn't be the case if you read my previous post carefully.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Apr 20 11:01:27 2024 UTC