llarich Posted August 18, 2006 Share Posted August 18, 2006 I have mySQL 5.0.24 installed(although this has happened on previous mysql 5 versions)I also have php 5.14 and Apache 2.0.59 installed(also, this has happened on previous versions of php and apache) Therefore this bug is not newly introduced by the versions of software.My System is Windows XP.The system is a standalone system for internal use that only 1 or 2 users connect to at a time. Every now and then when a user runs a php script or goes to a php page, I get an error such as the followingWarning: mysqli_connect() [function.mysqli-connect]: (/2003): in C:\ApacheServer\Apache2\htdocs\hfic2\std_includes\dbWrapper.php on line 119Error: Can't connect to MySQL server on 'localhost' (10048) The computer is a dual core 3.2 GHZ intel with 2GB of memory.Any ideas? I was thinking a poor memory configuration issue possibly? Connection use is max 11, traffic is max 556,102, and number of sql queries is max 400 when view with MySQL Administrator.This is not a coding issue as the section of code it is relating to is simply a mysqli_connect line. Quote Link to comment https://forums.phpfreaks.com/topic/17963-occasional-mysqli_connect-error-10048/ Share on other sites More sharing options...
fenway Posted August 18, 2006 Share Posted August 18, 2006 Hard to say... there are too many variables. Quote Link to comment https://forums.phpfreaks.com/topic/17963-occasional-mysqli_connect-error-10048/#findComment-76879 Share on other sites More sharing options...
llarich Posted August 18, 2006 Author Share Posted August 18, 2006 What would normally cause this issue of the connection to disappear? What are some variables you would need to now to narrorw down the possibilities? Quote Link to comment https://forums.phpfreaks.com/topic/17963-occasional-mysqli_connect-error-10048/#findComment-76896 Share on other sites More sharing options...
fenway Posted August 19, 2006 Share Posted August 19, 2006 If it's transient, it's going to be difficult to diagnose.... I guess you could be running out of connections, though the defaults are usually set quite high. Quote Link to comment https://forums.phpfreaks.com/topic/17963-occasional-mysqli_connect-error-10048/#findComment-77082 Share on other sites More sharing options...
llarich Posted August 21, 2006 Author Share Posted August 21, 2006 If I showed you my status and system variables, would you be able to see anything obviously wrong?Thanks Quote Link to comment https://forums.phpfreaks.com/topic/17963-occasional-mysqli_connect-error-10048/#findComment-78225 Share on other sites More sharing options...
fenway Posted August 21, 2006 Share Posted August 21, 2006 Unlikely... just see what the your connection limits are set to, and if the mysql error log has anything revealing. Quote Link to comment https://forums.phpfreaks.com/topic/17963-occasional-mysqli_connect-error-10048/#findComment-78258 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.