database error?

[petdoctorforum]

Hi,
can anyone help?
I have a VB forum (with a VB advanced frontpage on it); I changed a module on the frontpage, and then because I wanted a photo as part of it, I uploaded to photo to my hosting. However, suddenly on doing this, now I cant access the forum, I just get an error message!

I cant even log into the admin.

Subsequently I have deleted the photo via my hosting incase it was too large and throwing out the forum because of the size of the image...but I still cant access my VB admin and control the forum..
I get automatically generated emails telling me :
Database error in vBulletin : mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'petdoctorforum_c'@'localhost' (using password: YES)/var/www/domains/petdoctorforum.com/docs/includes/class_core.php on line 311 MySQL Error : Error Number : Request Date : Monday, May 10th 2010 @ 02:03:54 PMError Date : Monday, May 10th 2010 @ 02:03:54 PMScript : http://www.petdoctorforum.com/Referrer : http://www.petdoctorforum.com/IP Address : 94.23.18.220Username : Classname : vB_DatabaseMySQL Version :

any suggestions what I can do!?

[JamesAB]

Have you double checked the database information in your config.php file?

If you have a hosting control panel, check that the settings there match and make sure the database username being used has full permissions.

[funmasti]

what is your server configuration ?

[petdoctorforum]

what is your server configuration

im just using a shared host, dont have my own server?

Have you double checked the database information in your config.php file?

If you have a hosting control panel, check that the settings there match and make sure the database username being used has full permissions.

ok, i will give this a try. .....

[petdoctorforum]

hmmm....cant find the config.php file? should this be under the root directory?

[Trevor Hannant]

It's in the 'includes' directory.

[petdoctorforum]

Hi guys,
many thanks for your help so far, sorry that I'm a slow learner.
Ok, my forum is still down, I still cant work it out.

So, Ive located the config.php file, thanks.

What permissions should it be at, is this ok?

----------------------------------------------------------------

Owner Permissions:
Read YES WriteYES Execute NO
Group Permissions:
Read YES Write NO Execute NO
Public Permissions:
Read YES Write NO Execute NO

Numeric Value : 644
------------------------------------------------------------------

ok, the other thing is, I cant actually read this file, so I cant see if it needs changing? even if I set all the permissions to YES, it then appears as a blank page.

So, am I on the right track, whats happening, any suggestions how I can get my website back online!!

[ENF]

Your config.php has entries for:

- Your Database Name
- Your Database Server Address
- Your Database User Name
- Your Database User's Password

That's what they are asking about above, did you check to make sure that information inside config.php is valid?

You may want to check with your host about your database username and password to make sure what they give you matches what is inside the config.php.

Your original error message above, indicates that your database user account, "petdoctorforum_c", does not have access to the database where your forum is. Thus, your password may be wrong or your host has changed something which has caused you to lose access to the database.

[petdoctorforum]

thanks ENF...

well, when I click on my config.php file, when im using my File Manager, (maybe Im doing something wrong?) ...it just jumps me to http://petdoctorforum.com/includes/config.php .... and this is just a blank page?
...so I cant actually seem to access whats inside my config.php file?

(...although it says its not been altered since 1 yr anyway ...on the file manager)

[ENF]

You have to open config.php with a text editor such as wordpad or notepad. It's not a file you can view through a web interface.

If your forum just suddenly stopped working and you didn't change your config.php, then it sounds like your host changed something somewhere. But, regardless you'll need to confirm on your side (config.php) and on the host's side to make sure you can fully resolve the issue.

[petdoctorforum]

You have to open config.php with a text editor such as wordpad or notepad.

.... hmm, ok, thanks.
How do I do that (sorry) ?!!


also, the error message I get is

Database error in vBulletin : mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'petdoctorforum_c'@'localhost' (using password: YES)/var/www/domains/petdoctorforum.com/docs/includes/class_core.php on line 311 MySQL Error : Error Number

so maybe I should look at the includes/class_core.php file ??

[ENF]

so maybe I should look at the includes/class_core.php file ??

99% of the time it's an issue not related to class_core.php; the functions (variables) in that file rely 100% on what's in the config.php. (For connecting to the database)

You need to download that config.php file to your local PC via FTP or find some way to get it so that you can view the contents of the file. If you can get it to you local PC, open it up, verify the contents and if it's all right, you don't need to put a new copy up there. But, if you do need to update the config.php, you'll need to edit it and then upload the new config.php replacing the old one.

Again, your error is specifically targeting the fact that your database user account does not have access to your database. This problem will be resolved between your host company and what's inside the config.php file.

[petdoctorforum]

ENF, i appreciate your assistance, thanks a lot.
I will try what you say! thanks.

[ENF]

ENF, i appreciate your assistance, thanks a lot.
I will try what you say! thanks.

Good luck, I urge you to file a support ticket with your host and explain that you've lost access to your database with the previously given user name and password that resides inside your config.php.

I'm off for the evening, it's 11:15pm here now, so someone can pick up where I've left off if you need further assistance.

[petdoctorforum]

ok, it worked!
i discovered that because i had changed my hosting login password, that had changed my MySQL password, this was recorded on the config.php file. So I changed the password back to the old one, and now the forum works again.
Phew. thanks a lot to all who helped