"Could not connect to the database.." sometimes

[Ulysses]

Getting the occasional error message "Could not connect to the database - check connection details in configuration.php file" now and then for no apparent reason. Both in and out of the admin area.

 

It's occasional, so I can't replicate it, but is really irritating when it happens.

 

I can't figure out how the details in the configuration.php can be wrong sometimes.

 

Cheers

[Adam]

Hey,

 

Could be server side. IE MySQL down or something....

 

From,

Adam

[Dominic]

Check your max connections setting in my.cnf

[Ulysses]

Check your max connections setting in my.cnf

Thanks Dominic. I had a squiz at it and it's set to 500!

[mysqld]
set-variable = max_connections=500
safe-show-database
old-passwords = 1

From other examples I've seen around the web, it looks pretty basic though.

 

Do you know much about this setting?

[Adam]

Hey,

 

Well its really easy, max-connection = total users server wide that can connect to any MySQL database.

 

What errors are you getting, like wrong username/password, MySQL server not found, etc?

 

From,

Adam

[Ulysses]

Hi Adam,

 

The only error message I am getting (from time to time) is ""Could not connect to the database - check connection details in configuration.php file""

 

Cheers

[Matt]

That message is shown for a login failure or mysql being down. If your login details aren't changing then the MySQL service must keep going down.

 

Matt