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

go to bug id or search bugs for

Bug #46767 FastCGI Error is returned when connecting to a MySQL server with PHP 5.3 RC1
Submitted: 2008-12-05 15:17 UTC Modified: 2009-06-23 10:12 UTC
Votes:2
Avg. Score:4.5 ± 0.5
Reproduced:2 of 2 (100.0%)
Same Version:2 (100.0%)
Same OS:1 (50.0%)
From: peaceable_whale at hotmail dot com Assigned: mysql (profile)
Status: Closed Package: MySQLi related
PHP Version: 5.3.0RC1 OS: win32 only
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: peaceable_whale at hotmail dot com
New email:
PHP Version: OS:

 

 [2008-12-05 15:17 UTC] peaceable_whale at hotmail dot com 
Description:
------------
Server: IIS 5.1 with the official FastCGI plugin installed

When connecting to a MySQL server with PHP 5.3 Alpha 3, the following error is returned:

FastCGI Error
The FastCGI Handler was unable to process the request.

Error Details:

    * The FastCGI process exceeded configured activity timeout
    * Error Number: 258 (0x80070102).
    * Error Description: The wait operation timed out.

HTTP Error 500 - Server Error.
Internet Information Services (IIS)

PHP 5.2.7 on the same system does not have the problem.

Reproduce code:
---------------
Install phpMyAdmin and use it to login to a MySQL server, client API is not a concern because both MySQL and MySQLi yield the same error.

Expected result:
----------------
View the database successfully

Actual result:
--------------
Error returned

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2008-12-06 06:42 UTC] peaceable_whale at hotmail dot com 
The error can be reproduced with all PHP-Windows versions--VC6 TS and NTS, VC9 TS and NTS. I suspect it is mysqlnd related.
 [2009-02-02 13:16 UTC] peaceable_whale at hotmail dot com 
Continue to have this problem in PHP 5.3.0 Beta 1; Reproducible in IIS 7.
 [2009-02-02 13:25 UTC] pajoye@php.net 
I suppose you have mysql 5.1 right?
 [2009-02-02 13:26 UTC] peaceable_whale at hotmail dot com 
Yes, MySQL 5.1.30.
 [2009-02-02 13:29 UTC] pajoye@php.net 
Then be sure that the libmysql provided with php is first in your PATH.

We do not support the libmysql 5.1, so never ever use it with PHP binaries.
 [2009-02-02 13:32 UTC] peaceable_whale at hotmail dot com 
Well, mysqlnd is in use as it is turned on by default in the Windows builds:

mysqli

MysqlI Support	enabled
Client API library version 	mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.21 $
Active Persistent Links 	0
Inactive Persistent Links 	0
Active Links 	0 

mysqlnd

mysqlnd	enabled
Version 	mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.21 $
Command buffer size 	2048
Read buffer size 	32768
Collecting statistics 	Yes
Collecting memory statistics 	No
 [2009-02-02 13:33 UTC] pajoye@php.net 
oh my bad, right.

So not related (it must be the 1st report in weeks not related to 5.1 =)

> assigned to mysql
 [2009-02-02 13:35 UTC] peaceable_whale at hotmail dot com 
Thanks for changing it to Assigned :)
 [2009-02-02 13:43 UTC] johannes@php.net 
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc. If the script requires a 
database to demonstrate the issue, please make sure it creates 
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.

Does a simple mysql_connect() or mysqli_connect() work? Do simple queries work? Do other applications than phpMyAdmin work?
 [2009-02-02 14:06 UTC] peaceable_whale at hotmail dot com 
No. The error occurs once the script connects to a database.

Test case:

<?php
$mysqli=new mysqli(HOST,USERNAME,PASSWORD);
$connection_closed=$mysqli->close();
echo $connection_closed?"Database connection has been closed successfully":"An error occurred when closing database connection";
?>
 [2009-03-26 04:47 UTC] peaceable_whale at hotmail dot com 
The problem persists in RC1.
 [2009-05-10 07:50 UTC] peaceable_whale at hotmail dot com 
Don't have the problem in RC2. Perhaps it has been fixed.
 [2009-06-23 10:12 UTC] pajoye@php.net 
resolved in latest rc.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed May 07 11:01:29 2025 UTC