When a user goes to
http://top.level.dom/forum/
the result is a page that says:
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1045 - Access denied for user 'abcd_bb'@'localhost' (using password: YES)
Query:
[READ] Unable to connect to MySQL server
However, when going to
http://top.level.dom/bForum
the result is that that Forum comes up just fine.
So same pc, same OS and both inc/config.php have
$config['database']['hostname'] = 'top.level.dom';
$config['database']['username'] = 'abcd_bb';
$config['database']['password'] = 'Abc5-Bb';
Both databases seem to have the same permissions settings in MySQL.
So why does one work and the other not?
Oh god, NEVER post your database username and password publicly. You have more power if you gain access to that than your ACP.
(2010-07-12, 05:25 PM)pyridine Wrote: [ -> ]Oh god, NEVER post your database username and password publicly. You have more power if you gain access to that than your ACP.
what makes you think those are real?
(2010-07-12, 05:30 PM)chips Wrote: [ -> ] (2010-07-12, 05:25 PM)pyridine Wrote: [ -> ]Oh god, NEVER post your database username and password publicly. You have more power if you gain access to that than your ACP.
what makes you think those are real?
"So same pc, same OS
and both inc/config.php have"
Very little we can do about this. If it's saying it can't connect, it can't connect with the given information. You can't have two forums with exactly the same database details anyway...
(2010-07-12, 05:39 PM)pyridine Wrote: [ -> ] (2010-07-12, 05:30 PM)chips Wrote: [ -> ] (2010-07-12, 05:25 PM)pyridine Wrote: [ -> ]Oh god, NEVER post your database username and password publicly. You have more power if you gain access to that than your ACP.
what makes you think those are real?
"So same pc, same OS and both inc/config.php have"
oh please, read the lines.
(2010-07-12, 05:52 PM)MattRogowski Wrote: [ -> ]Very little we can do about this. If it's saying it can't connect, it can't connect with the given information. You can't have two forums with exactly the same database details anyway...
so what information do you need?
Both forums were running till a few weeks ago when the pc's NIC went bad and had to be replaced.
problem solved
What so it's been like this for a few weeks?? o.O There's still little we can do; it doesn't like the details it's been given, it can't connect to MySQL with them. Try creating new database users with new passwords, assign those users to your database and update the details in config.php, see if it works then.
(2010-07-12, 07:27 PM)MattRogowski Wrote: [ -> ]What so it's been like this for a few weeks?? o.O There's still little we can do; it doesn't like the details it's been given, it can't connect to MySQL with them. Try creating new database users with new passwords, assign those users to your database and update the details in config.php, see if it works then.
I didn't have the time till this week to give it a thorough review.
As I posted , problem has been worked around.
Changing the ini file for the forum that no longer worked so that its database target was "mysql" instead of "mysqli" (thereby matching the working ini) enabled the problem forum.
I have not yet investigated what "mysqli" is supposed to be, why it was chosen and why it stopped working when NIC changed.
mysqli is an extension for MySQLi... that being wrong wouldn't cause this error though, it causes a different one.