List:General Discussion« Previous MessageNext Message »
From:Leif B. Kristensen Date:March 16 2003 6:20pm
Subject:Re: broken database? or?
View as plain text  
On Sun, 16 Mar 2003 12:04:37 -0500, joe <joehark@stripped> wrote:

>I have recently moved onto a new server. For a brief period after the move 
>I could access the mySQL database using GUI clients such as mysqlf and 
>sqlyog. And the web site that it supported was accessible in various 
>browsers (msie, mozilla, opera, etc.)
>
>Now the PHP-based forum that the MySQL serves is down. When I try to open 
>it in the browser I get four error error messages that say MySQL has 
>problems with login in, passwords, etc.

Joe,
your PHP scripts are probably out of date, using global variables. As of
PHP 4.2, the setting register_globals = off as default, and this made a
lot of PHP scripts all but obsolete overnight. You can verify for
yourself what the PHP settings are if you upload a little code to your
webserver:

<html>
<body>
<?php phpinfo(); ?>
</body>
</html>

Save this as phpinfo.php on the document root, then point your browser
to it. You'll get all kinds of useful information.

I have not found documentation with a comprehensive explanation of how
scripts should be rewritten, but there's a lot of information out there
if you know what to look for. See especially
<url:http://www.php.net/manual/en/security.registerglobals.php>.

By the way, replies belong to the list, not to you personally. Please
remove your address from the Reply-To field when addressing mail lists.

regards,
-- 
Leif Biberg Kristensen
http://solumslekt.org/
Thread
Re: comment with "foreign key" text causes innodb CREATE TABLE failureHeikki Tuuri15 Mar