Bug #8002 ramdom access denied

• Submitted: 19 Jan 2005 8:21
• Modified: 9 Apr 2008 7:51
• Reporter: Pierre-Henry Perret
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Any (FreeNBD 5.2.1)
• CPU Architecture: Any

[19 Jan 2005 8:21] Pierre-Henry Perret

Description:
Desciption of the bug

software context:
System: FreeBSD 5.2.1
sofware installed: PHP5.0 / MySql 4.1 / Apache 2.0
_________________________________________________________________
PHP Warning:  mysql_connect()  Access denied for user:
'scribe@localhost' (Using password: YES) in config.inc.php on line 31
__________________________________________________

the config.inc.php file is :
_______________________________________

<?
/* identifications des serveurs */
$server = getenv("HTTP_HOST");

       //vars used for host serveur
        $dbhost = "localhost";
        $dblogin = "enseigne";
        $dbpass = "c9bv2MrV";
        $dbname = "enseigne";
       //vars pour la bible
        $dbhost2 = "localhost";
        $dblogin2 = "scribe";
        $dbpass2 = "_scribe_";
        $dbname2 = "bible";

/* conexion aux bases de donnée */
$connexion = mysql_connect ($dbhost,$dblogin,$dbpass);
/* conexion aux bases de donnée */
$connex_bible = mysql_connect ($dbhost2,$dblogin2,$dbpass2);

if (!$connexion || !$connex_bible) {
               echo "---> error.";
               exit;
}
/* Etape 2 : connexion à la base */
if (!mysql_select_db ($dbname, $connexion)) {
               echo "---> error";
}
if (!mysql_select_db ($dbname2, $connex_bible)) {
               echo "---> error";
}
?>
________________________________________________________

What is interesting is that this error seams to occur randomly.

Do you have a guess ?
Pierre
© 1995-2005 MySQL AB. All rights reserved.
MySQL.com Home Site Map

How to repeat:
random error

Suggested fix:
I wonder

[19 Jan 2005 8:22] Pierre-Henry Perret

BSD

[10 Jun 2006 20:18] Tor Henning Ueland

I have noticed this problem appearing on 1 PHP application while other works just fines on the same MySQL / PHP,Apache2 server when connecting through the php libraries.

Note that this does happen with Invision Power Board v2.1.6 (ID: 21012) ON PHP 4.4.0-3ubuntu2 And MySQL  (4.1.12-Debian_1ubuntu3.4-log)

But it does NOT happen on the same PHP/MySQL setup when running Invision Power Board 2.0.2 as i still know of.

[9 Apr 2008 7:51] Susanne Ebrecht

This is a duplicate of bug #7209