Bug #10930: Can't connect to mysql after running some code that crashes IIS 5
| From: | tyler dot longren at midiowa dot net | Date: | Thu, 17 May 2001 16:08:03 +0000 |
| Subject: | Bug #10930: Can't connect to mysql after running some code that crashes IIS 5 | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-55634@lists.php.net to get a copy of this message | ||
From: tyler.longren@midiowa.net
Operating system: Windows 2000
PHP version: 4.0.5
PHP Bug Type: MySQL related
Bug description: Can't connect to mysql after running some code that crashes IIS 5
After running the code below, PHP 4.0.5 is no longer able to connecto to mysql. I have tested this
at 2 different locations, and the result is the same every time. Also after visiting the website
with this code in it, inetinfo.exe (IIS) crashes.
PHP was installed with php405-installer.exe. The problem occurs on Windows 2000 Professional SP1
& SP2. Windows 2000 server has not been tested. Below is the code that should be pasted into a
webpage, and then visited with any browser. I accidentally caused inetinfo.exe to die with this:
<?
/*
This was written (accidentally) by Tyler Longren <tyler.longren@midiowa.net>.
This was found on accident...thanks to my crappy coding. :)
Date: 05-14-2001
Kills: Inetinfo.exe on Win2k
*/
session_start();
session_register('username');
session_register('password');
header("Location: $PHP_SELF");
if ($formusername) {
mysql_connect("$mysql_host","$mysql_user","$mysql_pass");
mysql_select_db("$mysql_db");
$auth_sql = mysql_query("SELECT * FROM $mysql_user_table WHERE username =
'$formusername' AND password = '$formpassword'");
$user_exists = mysql_num_rows($auth_sql);
if ($user_exists == "1") {
$username = $formusername;
$password = $formpassword;
}
else {
$login_error = "<font face=Arial
size=2><b>Error:</b></font><br><font
face=Arial size=1>Wrong<br>username/password</b></font>";
session_unregister('username');
session_unregister('password');
}
}
else {
mysql_connect("$mysql_host","$mysql_user","$mysql_pass");
mysql_select_db("$mysql_db");
$auth_sql = mysql_query("SELECT * FROM $mysql_user_table WHERE username =
'$username' AND password = '$password'");
$user_exists = mysql_num_rows($auth_sql);
if ($user_exists == "1") {
// blah blah blah!
}
else {
$login_error = "<font face=Arial
size=2><b>Error:</b></font><br><font
face=Arial size=1><b>Wrong<Br>username/password</b></font>";
session_unregister('username');
session_unregister('password');
}
}
if ($login == "no") {
session_destroy();
session_unregister('username');
session_unregister('password');
header("Location: $PHP_SELF");
}
?>
--
Edit Bug report at: http://bugs.php.net/?id=10930&edit=1