phpBB - MySQL max_questions problem (Fix won't work)

[Aaron_H]

Hi all,

In order to minimise any potential mySQL max_questions problems in the future. I decided to try and install the workaround (by using the rotating user account code) on my newly installed phpBB forums.
(Workaround: http://forum.powweb.com/showthread.php?t=23735)

I basically edited the default config.php file for my phpBB2 installation so it read like this (obviously changing the password ;) and setting the right usernames)

$dbms = 'mysql4';

$dbhost = 'mysql06.powweb.com';
$dbname = 'db_name;
#$dbuser = 'user1';
$db_user_array[] = "user1";
$db_user_array[] = "user2";
$db_user_array[] = "user3";
$db_user = $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ];
$dbpasswd = 'password';

$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

After saving this file and reuploading the changed file and trying to run my forums, I was given an error similar to this:


Warning: mysql_connect(): Access denied for user 'bruce_h'@'66.152.98.42' (using password: YES) in /www/s/shenmueunive/htdocs/forums/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/s/shenmueunive/htdocs/forums/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /www/s/shenmueunive/htdocs/forums/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

-Where it says "Access denied for user 'bruce_h'.."...
after a few refreshes this name has changed to things like "eddie", "james", "root"..
(none of these have been the usernames specified in my config.php file)
often the ip address has slightly changed (usually the last few digits), from things like .42 -> 46, 47 etc...

Could someone please tell me a workaround/how to fix this problem?

Also, since the database appears to be trying to connect on a different ip (server?), using usernames that were not specified, maybe this could lead to a potential security fault on the servers?

Any help would be appreciated.
-Regards,

Aaron.

[Pig]

If you read this thread, it looks like they edited a different file than you.
http://forum.powweb.com/showthread.php?s=&threadid=28309

That may or may not help.

[tbonekkt]

Do all three of the usernames have the same password?

[Aaron_H]

Thanks for that. It seems to have worked. :)

[Added: Yes they did, like "Pig" said, I had just been editing the wrong file. :)]