If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Guest book crashed. Restored Backup. Did Repair.  XML
Forum Index » Advanced Guestbook Forum
Author Message
rrh
Beginner

Joined: 12/09/2005 01:39:30
Messages: 5
Offline

My guest book crashed. I did a restore from a backup. Tried Repair. Still get same error message:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'steelcit_agbook1'@'localhost' (using password: YES) in /home/steelcit/public_html/guest/lib/mysql.class.php on line 30
Connection Error
--------------------------------------------------------------------------------

MySQL Error : Connection Error
Error Number: 1045 Access denied for user 'steelcit_agbook1'@'localhost' (using password: YES)
Date : Wed, August 2, 2006 09:44:55
IP : 24.150.24.211
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1)
Referer : http://www.steelcitysound.com/guest.htm
PHP Version : 5.0.4
OS : Linux
Server : Apache/1.3.33 (Unix) PHP/5.0.4 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.7a
Server Name : www.steelcitysound.com

Any help would be appreciated. Thanks.
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Check that the username and password in config.inc.php is still correct.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
rrh
Beginner

Joined: 12/09/2005 01:39:30
Messages: 5
Offline

Information in config.inc.php is correct.

I should mention when I repaired the database it all came out ok, but still doesn't work.

Thanks.
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Possibly the username/password you were using got deleted during the crash.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
rrh
Beginner

Joined: 12/09/2005 01:39:30
Messages: 5
Offline

How would I restore this information. I reloaded from my computer the config.inc.php file.

Thanks for all your help.
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Recreate the account the same way you originally created it.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
rrh
Beginner

Joined: 12/09/2005 01:39:30
Messages: 5
Offline

It wouldn't let me re-create the account because it alread exists so I deleted the database and user and tried to re-install. Now here is the error message:

Cannot create new database: steelcit_agbook1

MySQL Error : Cannot create new database: steelcit_agbook1
Error Number: 1044 Access denied for user 'steelcit'@'localhost' to database 'steelcit_agbook1'
Date : Thu, August 3, 2006 08:53:01
IP : 24.150.24.211
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1)
Referer : http://www.steelcitysound.com/guest/install.php
PHP Version : 5.0.4
OS : Linux
Server : Apache/1.3.33 (Unix) PHP/5.0.4 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.7a
Server Name : www.steelcitysound.com
 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum