[agb] - Restoring an AGB and database after removing

I had to remove my AGB and database from my web host due to possible security exploit problems. Carbonize was kind enough to help me convince the web host that the newest version 2.3.1 was in fact secure. I finally got permission to restore my guestbook and database.

So far I have restored my original database (it looks like it's there) and uploaded all my previous files and set permission on the public directory to 777 (per the readme file). When I access the index.php file in my guestbook directory, I get this error:

Warning: mysql_connect(): Access denied for user: 'xxxxxx_agbook1@localhost' (Using password: YES) in /home/mysite/public_html/guestbook/lib/mysql.class.php on line 59
Connection Error
--------------------------------------------------------------------------------

MySQL Error : Connection Error
Error Number: 1045 Access denied for user: 'xxxxxx_agbook1@localhost' (Using password: YES)

I am not a MYSQL or PHP wiz, so I could use some help please.

PS. I searched and found a similar thread, but it didn't seem to apply to my situation as the line number was different and my database is installed (I think).

Thanks in advance for your help!

martin

Sounds like your MySQL details in config.inc.php may be incorrect. Double check them.

Thanks for the reply, Carbonize.

I have checked the database name, username, host, and table names. They all match.

The error on line # 59 I referenced above in the mysql.class.php file shows:

The only thing I can't check is the encrypted password. Where is that located? How do I check it or change it to make sure it matches.

Thanks again for all your help.

martin

try my password reset script - www.carbonize.co.uk/reset.zip

Thanks Carbonize.

I just tried that and received this error:

Could not connect to MySQL because: Access denied for user: 'xxxxxxx_agbook1@localhost' (Using password: YES)

I added my desired username and password into the reset.php file in PSPad, uploaded the file and ran it.

I checked the encrypted password in the config.inc.php file entry:

is different from the data in phpMyAdmin:

Suggestions?

Thanks again!

martin

$GB_DB["pass"] = "xxxxxxxxx" is not encrypted, It is in plaintext. Just put your MySQL password in there.

Thanks again.

My password looks like this = "9fExxxxxjY' in the config.inc.php file and like this = "115b6xxxxd2977ea" in the "book_auth" password field in phpMyAdmin.

Do I just enter the same password in plain text in each location? What keeps someone from getting into the config.inc.php file and gaining access?

Thanks.

martin

You are confusing the guestbook password with the database password. You put your DATABASE password in the config file. The password in your MySQL database is the guestbooks password.

You are right about being confused!!

Where do I get my "Database" password, if it's not the one in the "book_auth" password field? I know what it was in the previous installation. Do I just put that plaintext password in the config.inc.php file like this:

If so, I just tried that and still get the same error message as before:

Warning: mysql_connect(): Access denied for user: 'usatro2_agbook1@localhost' (Using password: YES) in /home/usatro2/public_html/guestbook/lib/mysql.class.php on line 59
Connection Error
--------------------------------------------------------------------------------

MySQL Error : Connection Error
Error Number: 1045 Access denied for user: 'usatro2_agbook1@localhost' (Using password: YES)

Do you have any other scripts installed that use the database? If so they will have the password in them.

No, I do not have any other scripts installed that use MySQL. I can access the MySQL data base and phpMyAdmin from my cPanel.

I know what the password was when I saved the MySQL database prior to deleted the AGB. I restored the database from the backup copy of the database, so it should still be the same, right? But that one doesn't work when I put it in the config.inc.php file.

Suggestions?

Thanks again.

PS. Would it help if I gave you access to my cPanel? I can email you direct if you want to do that.

martin

Email me your cpanel addrsss and details. Or message me.

In case anyone experiences this particular problem, Carbonize fixed it for me.

The problem was when I restored the database and files, it did not create a SQL user.

Thanks Carbonize, you are the best!!!

martin

PS. I'm here with another problem and thought I should post the problem resolution here for others.