Tuesday, January 19, 2010

PHP 5.3 and MySQL timeouts

On my dev machine, WinXP SP3, I had PHP 5.2 configured with IIS 5.1 and MySQL 5. Recently upgraded to PHP 5.3  and whooops.. most of my applications stop working.. :?  first the ISAPI was discontinued so I had to go the FastCGI way but for some reason I just could not make it work. The browser will just offer me to download/ save the file. As I was in a hurry I thought $#@*& IIS, lets try Apache. Installed and configured Apache with PHP and the phpinfo page works fine but pages with MySQL connection will still not load... after wasting sometime trying to figure out what was wrong, went to the doorstep of all knowing Google.. and found this


http://bugs.php.net/bug.php?id=45150

Though in the post the user mentions that he faced this problem only in Vista not for XP but may be some recent update/ patch has introduced same feature/ bug in XP as well, as the moment I change the host value in connection strings from "localhost" to "127.0.0.1"  the applications were working fine.

If your pages with MySQL connection are also timing out, check the host value and if they have localhost set as the value, "127.0.0.1" should be used instead of "localhost".

P.S. - am still lost why IIS wont work with PHP.. i even tried the IIS-Aid package and same results..

No comments:

Post a Comment