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 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: 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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Tue Apr 30 23:01:29 2024 UTC