Page 1 of 1

Sudden failure to connect

Posted: Thu Jul 14, 2011 8:45 pm
by burlington
I installed the version of CMSMS 1.9.4.2 yesterday. This went fine and I have been working on the new website today. No problems.

This evening I can't get access at all either to the site itself or to Admin. Instead I get the following message:

<quote>
Database Connection Failed
Error: Access denied for user '****_admin'@'localhost' (using password: YES) (1045)
Function Performed: CONNECT
Host/DB: localhost/****_cmsms
Database Type: mysql

Fatal error: Attempt to connect to database ****_cmsms on ****_admin@localhost failed in /home/****/public_html/lib/adodb.functions.php on line 85
</quote>

The only thing that has changed on the server since my last visit to the CMSMS site was that I installed Coppermine BUT this was into a separate folder AND using another database.

Any ideas please?

Thanks

Martin

Re: Sudden failure to connect

Posted: Thu Jul 14, 2011 10:30 pm
by Jos
Set a completely new password in your mySQL database, and set it also in the config.php
Then your site should be running again

If then Coppermine is failing, you know what caused it :D

Re: Sudden failure to connect

Posted: Thu Jul 14, 2011 11:03 pm
by burlington
Thanks for your advice Jos

I tried a password but still cannot connect.

I cannot see how Coppermine could have affected CMSMS. It is in it's own discrete folder on the server and has it's own database with no connection to the CMSMS one.

I have asked the website host if they can see any reason for non-connection.

In the meantime I have backed up the whole of CMSMS and if there is no solution then I will just have re-install over the existing, with a new database, and a MySQL import from the backup. I hope it does not come to that though.

Martin

Re: Sudden failure to connect

Posted: Thu Jul 14, 2011 11:15 pm
by Wishbone
Before doing that, you might want to create a PHP script to connect to the database, so that you can see if it's a database issue or a CMS issue.

[SOLVED} Re: Sudden failure to connect

Posted: Fri Jul 15, 2011 5:59 am
by burlington
It looks as though it was a DB issue with the server. The website host has 'fixed the problem' and the URL works fine now.

Thanks for your help.