Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2001051

[PHP-WIN] FW: [PHP] Can't connect to mysql after applying MS Hotfix (originally posted to php-general) From: Tyler Longren (tyler.longren <email protected>)
Date: 05/15/01

The original message was posted to php-general...I got no replies...anybody
here know what's up with this?

The code that kills inetinfo.exe in Win2k is @ the end of this message.

> -----Original Message-----
> From: Tyler Longren [mailto:tyler.longren <email protected>]
> Sent: Tuesday, May 15, 2001 3:37 PM
> To: PHP-General
> Subject: [PHP] Can't connect to mysql after applying MS Hotfix
>
>
> Hello everybody,
>
> Lastnight, I was building a site. Multiple SQL queries were being made on
> every page. Everything worked nice and smooth. I downloaded and applied
> the patch for MS01-026 which effects IIS 4.0 and 5.0. I rebooted after
> applying the hotfix, and after that, NONE of my php scripts can connect to
> mysql. It's not a problem with mysql, because I can successfully
> connect to
> mysql through the client and can execute queries.
>
> Anybody know what's up with this?
>
> Also, while playing around lastnight...I wrote some weird code that kills
> inetinfo.exe on Win2k boxes. It's attached if anyone wants to look @ it
> (please do and see if you get the same results).

Code to kill inetinfo.exe:
<?
/*
This was written by Tyler Longren <tyler.longren <email protected>>.
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");
}
?> 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-windows-unsubscribe <email protected>
For additional commands, e-mail: php-windows-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>