#47283 [Bgs]: mysql_connect call crashes web server
ID: 47283 User updated by: darren at misterdoom dot com Reported By: darren at misterdoom dot com Status: Bogus Bug Type: MySQL related Operating System: win32 only - Vista Home Premium PHP Version: 5.2.8 Assigned To: pajoye New Comment: I used the PHP supplied DLLS. The PHP extensions directory is in the path information, the MySQL DLL was visible. This problem happened with IIS 7, not just Apache. Thinking about it logically, if the DLL was not visible or the incorrect DLL with the 5.2.8 install, it would have still not been visible or correct with the 5.2.5 install, which is working. This is a bug, not bogus. Previous Comments: [2009-02-10 18:40:45] paj...@php.net Do not ever use DLLs from mysql but only the one we provide with PHP. Be sure that PHP's install directory (where the libmysql.dll is) is first in your path for apache. Not a php bug bogus. [2009-02-10 10:44:18] tony2...@php.net Pierre, you seem to know what's wrong there - is this some lib version incompatibility? [2009-02-06 22:44:57] darren at misterdoom dot com Yes, I am running MySql 5.1.11. I have un-installed PHP 5.2.8 as I needed to continue working on my web site. I now have PHP 5.2.5 installed, and the problem does not occur. [2009-02-06 13:46:53] paj...@php.net And you have installed mysql 5.1 right? [2009-02-06 13:25:57] ka...@php.net Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to Open. Thank you for helping us make PHP better. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/47283 -- Edit this bug report at http://bugs.php.net/?id=47283edit=1
#47283 [Bgs]: mysql_connect call crashes web server
ID: 47283 User updated by: darren at misterdoom dot com Reported By: darren at misterdoom dot com Status: Bogus Bug Type: MySQL related Operating System: win32 only - Vista Home Premium PHP Version: 5.2.8 Assigned To: pajoye New Comment: I have read what you said, and it from my understanding, you are saying that my install was either not finding the dll, or finding the incorret dll because the path information is incorrect. It also seemed to relate only to Apache I ask, if that is the case, then why does it work after uninstalling 5.2.8 and installing 5.2.5 without any path information changing? Also, the problem was present in both Apache and IIS 7. I did search for the error, however most of the answers that I could see pointed the error at a bad version of the ISAPI dll. Previous Comments: [2009-02-11 09:26:07] paj...@php.net Please, read again what I said. There is dozen other reports about this exact issue with detailed explanations. Take a look at them. [2009-02-11 09:20:17] darren at misterdoom dot com I used the PHP supplied DLLS. The PHP extensions directory is in the path information, the MySQL DLL was visible. This problem happened with IIS 7, not just Apache. Thinking about it logically, if the DLL was not visible or the incorrect DLL with the 5.2.8 install, it would have still not been visible or correct with the 5.2.5 install, which is working. This is a bug, not bogus. [2009-02-10 18:40:45] paj...@php.net Do not ever use DLLs from mysql but only the one we provide with PHP. Be sure that PHP's install directory (where the libmysql.dll is) is first in your path for apache. Not a php bug bogus. [2009-02-10 10:44:18] tony2...@php.net Pierre, you seem to know what's wrong there - is this some lib version incompatibility? [2009-02-06 22:44:57] darren at misterdoom dot com Yes, I am running MySql 5.1.11. I have un-installed PHP 5.2.8 as I needed to continue working on my web site. I now have PHP 5.2.5 installed, and the problem does not occur. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/47283 -- Edit this bug report at http://bugs.php.net/?id=47283edit=1
#47283 [Fbk-Opn]: mysql_connect call crashes web server
ID: 47283
User updated by: darren at misterdoom dot com
Reported By: darren at misterdoom dot com
-Status: Feedback
+Status: Open
Bug Type: MySQL related
Operating System: win32 only - Vista Home Premium
PHP Version: 5.2.8
New Comment:
Yes, I am running MySql 5.1.11.
I have un-installed PHP 5.2.8 as I needed to continue working on my web
site. I now have PHP 5.2.5 installed, and the problem does not occur.
Previous Comments:
[2009-02-06 13:46:53] paj...@php.net
And you have installed mysql 5.1 right?
[2009-02-06 13:25:57] ka...@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32
Once you have generated a backtrace, please submit it to this bug
report and change the status back to Open. Thank you for helping
us make PHP better.
[2009-02-02 21:59:46] darren at misterdoom dot com
Description:
I have a really strange problem. I've recently re-installed my computer
and set up IIS7, PHP and MySQL so that I could carry on working on my
website.
I did a quick test with phpinfo(); and everything seemed to be working
fine. Then set up 2 blank documents and started working on opening a
connection to a database, which is when all the trouble started. On
viewing the page, I would get the following message PHP has encountered
an Access Violation at 01FCAC5A and windows would also produce an error
message stating that IIS had been stopped. If I comment out the
mysql_connect line it worked fine.
I read some things about a possible problem with the php5isapi.dll, so
I installed Apache 2.2.1.1 web server, set up PHP, but got exactly the
same result.
Reproduce code:
---
file 1 (index.php)
?php
require(farq.php);
?
html
head
titleSite Administration/title
?php
// If cookie, redirect
?
/head
body
!-- If no cookie, show form. --
form action=index.php method=post
input name=username maxlength=255
input name=password maxlength=255
input type=submit
/form
/body
/html
File 2 (farq.php)
?php
$conn = mysql_connect('localhost', 'dbuser', 'dbpass') or die ('Error
connecting to mysql');
echo conncected;
mysql_select_db(dbname, $conn) or die (Could not select to main
database);
?
Expected result:
I would expect to see connected followed by a form.
Actual result:
--
in the browser:
Internet Explorer cannot display the webpage
Windows also pops up the alert box:
Apache HTTP Server stopped working and was closed
If I comment out the line $conn = mysql_connect('localhost', 'dbuser',
'dbpass') or die ('Error connecting to mysql'); The page displays
correctly.
--
Edit this bug report at http://bugs.php.net/?id=47283edit=1
#47283 [NEW]: mysql_connect call crashes web server
From: darren at misterdoom dot com
Operating system: Vista Home Premium
PHP version: 5.2.8
PHP Bug Type: *Web Server problem
Bug description: mysql_connect call crashes web server
Description:
I have a really strange problem. I've recently re-installed my computer
and set up IIS7, PHP and MySQL so that I could carry on working on my
website.
I did a quick test with phpinfo(); and everything seemed to be working
fine. Then set up 2 blank documents and started working on opening a
connection to a database, which is when all the trouble started. On viewing
the page, I would get the following message PHP has encountered an Access
Violation at 01FCAC5A and windows would also produce an error message
stating that IIS had been stopped. If I comment out the mysql_connect line
it worked fine.
I read some things about a possible problem with the php5isapi.dll, so I
installed Apache 2.2.1.1 web server, set up PHP, but got exactly the same
result.
Reproduce code:
---
file 1 (index.php)
?php
require(farq.php);
?
html
head
titleSite Administration/title
?php
// If cookie, redirect
?
/head
body
!-- If no cookie, show form. --
form action=index.php method=post
input name=username maxlength=255
input name=password maxlength=255
input type=submit
/form
/body
/html
File 2 (farq.php)
?php
$conn = mysql_connect('localhost', 'dbuser', 'dbpass') or die ('Error
connecting to mysql');
echo conncected;
mysql_select_db(dbname, $conn) or die (Could not select to main
database);
?
Expected result:
I would expect to see connected followed by a form.
Actual result:
--
in the browser:
Internet Explorer cannot display the webpage
Windows also pops up the alert box:
Apache HTTP Server stopped working and was closed
If I comment out the line $conn = mysql_connect('localhost', 'dbuser',
'dbpass') or die ('Error connecting to mysql'); The page displays
correctly.
--
Edit bug report at http://bugs.php.net/?id=47283edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=47283r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=47283r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=47283r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=47283r=fixedcvs
Fixed in CVS and need be documented:
http://bugs.php.net/fix.php?id=47283r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=47283r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=47283r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=47283r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=47283r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=47283r=support
Expected behavior:
http://bugs.php.net/fix.php?id=47283r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=47283r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=47283r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=47283r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47283r=php4
Daylight Savings:http://bugs.php.net/fix.php?id=47283r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=47283r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=47283r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=47283r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=47283r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=47283r=mysqlcfg
