SQL Connection Error (MySQL username password maybe?)

When trying to connect to:
http://www.motuning.com/guestbook
I get this error:

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

MySQL Error : Connection Error
Error Number: 1045 Access denied for user: 'bdmeyer_agbook1@localhost' (Using password: YES)
Date : Sun, October 17, 2004 11:43:15
IP : 24.211.100.163
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Referer :
PHP Version : 4.3.8
OS : Linux
Server : Apache/1.3.31 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2634a mod_ssl/2.8.19 OpenSSL/0.9.7a PHP-CGI/0.1b
Server Name : www.motuning.com

I believe it is (but not certain) the password that goes here in config.inc.php:

$GB_DB["dbName"] = "changd_agbook1";
$GB_DB["host"] = "localhost";
$GB_DB["user"] = "changd_agbook1";
$GB_DB["pass"] = "SumPasswd";

On a working guestbook I just upgraded, it has what looks like an obfuscated password like:
$GB_DB["pass"] = "s_2wery46dhde2"; (made up)
In a message on this forum someone described to enter 'the password for your sql database.' So I entered it in plain text also. Niether works.
Two things are possible:
1.) I need that password to be obfuscated hash of the correct password. (if so, how do I get the hash?)
2.) I don't have the correct MySQL password entered.

Please note: I am not referring to the test 123 username / passwor combo. I know exactly how to fix that, and this isn't in the admin part. This is just getting to the guestbook period.

I guess there is a third option:
line 30 referenced in the error message is the checksessionID thing discussed in this forumn.

$AUTH = $gb_auth->checkSessionID();

I have deleted relevant cookies and all temp internet files, to no avail.

Any help will be greatly appreciated.
This is from a 2.2 to 2.31 upgrade.

Bruce Meyer

Ok the SQL password shuld be in plaintext in your config file. Looking at the error all I can say is check your information is correct.

Yo usay you upgraded from 2.2 to 2.3.1. Could you do me a favour and download www.carbonize.co.uk/install.zip, upload the install.php from the zip to your guestbook folder and then run it (once you sort out your database access problem). It should upgrade your guestbook database from 2.2 to 2.3.1 but it will give you errors. I would be grateful if you could send me the entire error message so I can fix it. Your guestbook will work fine once done (apart from your SQL problem but until thats fixed you can't use the install.php anyways)

So as I said check the information in the config file. You may have just typo'd a letter somewhere.

Thanks, I have already updated all the tables manually using MyPhpAdmin, created the pics folder, changed the case from upper to lowercase in last-visit, and changed from null etc etc. This is the second one I have done, so I am not concerned about the admin page (as I stated figuring that someone would mistake this for a admin loop error)

Rather, i think i need to change the password for the sql user account accessing the database. I don't see how to change the sql user password in myPhpAdmin. Do you know how to do that?

One thing I have thought of is to delete the user, and then recreate the user with a known password.

Another point, on the other web site with a working Advanced Guestbook 2.31 (that I upgraded by hand), if I change the password to plain text, I get this exact same error, when i go back to the obfuscate hash, it works again. I think the problem is, determining how the hash work, and getting the correct hash put in place. Any ideas?

Ok. Well, everything pointed to it being a sql connection error because of an invalid SQL password. I deleted the account in cpanle SQl admin (not phpMySql) and recreated it with a known password, put in the hash (not plain text) and it works again. Sure would like to know how the has is created, so I could change my sql password at will.

Thx for the help Carbonize

--BadBoo

Carbonize wrote:Ok the SQL password shuld be in plaintext in your config file. Looking at the error all I can say is check your information is correct.

Yo usay you upgraded from 2.2 to 2.3.1. Could you do me a favour and download www.carbonize.co.uk/install.zip, upload the install.php from the zip to your guestbook folder and then run it (once you sort out your database access problem). It should upgrade your guestbook database from 2.2 to 2.3.1 but it will give you errors. I would be grateful if you could send me the entire error message so I can fix it. Your guestbook will work fine once done (apart from your SQL problem but until thats fixed you can't use the install.php anyways)

So as I said check the information in the config file. You may have just typo'd a letter somewhere.

Carbonize, do you still need the error message? Have a 2.2 guestbook that has not yet been upgraded.

Carbonize, do you still need the error message? Have a 2.2 guestbook that has not yet been upgraded.

That's from me.

Ahhhh Amber of the many guestbooks. Yes I would be grateful for the error report. I'll also answer the email thats just arrived from you lol.