Web Hosting Forum | Lunarpages

Author Topic: Lost Advanced Guestbook password - How to retrieve it  (Read 50976 times)

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Lost Advanced Guestbook password - How to retrieve it
« on: January 23, 2004, 06:51:53 AM »
I have already contacted support, they can't change/reset  it. They said I could try through the config file or mysql db, OK..where exactly in these files would it be and what would I change? I really don't want to reinstall (I'd probably screw that up to)  

I even tried adding a new user through cpan-mysql with full privileges, Im still not sure why that doesn't/didn't work.

I found some documentation on changing the password, but it might as well be in another language

http://www.mysql.com/doc/en/Resetting_permissions.html

I don't have a clue as to what they are talking about or where I would do this.

Any advice would be appreciated.

thanks
I love the new LPF theme

Offline donovanh

  • Intergalactic Superstar
  • *****
  • Posts: 137
    • http://www.designni.com
Lost Advanced Guestbook password - How to retrieve it
« Reply #1 on: January 23, 2004, 06:59:49 AM »
I think they mean you should change the password for the guestbook rather than reset your mysql permissions.

Does advanced guestbook allow you to retrieve your password?

If not it seems that support has asked you to look for a config file that would store the password, or check in your database to see if it is stored there.

HTH,

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Lost Advanced Guestbook password - How to retrieve it
« Reply #2 on: January 23, 2004, 07:13:13 AM »
Donovahn, it says "resetting permissions" but the article is "How to Reset a Forgotten Root Password" and  according to this article it can be reset (I don't know about retrievel)


Support didnt ask me to look there, they suggested I look there and I have. Its all greek to me.
I love the new LPF theme

Offline MishaPappa

  • Jabba the Hutt
  • *****
  • Posts: 587
Lost Advanced Guestbook password - How to retrieve it
« Reply #3 on: January 23, 2004, 07:30:24 AM »
EJ - drop the direction you are heading with the MySQL root password... I doubt it's relevant...

I'm not specifically familiar with the Advanced Guestbook - is this the one installed from cPanel?  Is there a related website/author link somewhere that the original scripts or installation package can be acquired?  That information would be helpful to pursue analysis of the MySQL database structure and SQL abstraction layer that relates to a user and their password.

Your time right now would well  be spent using phpMyAdmin or any other familiar MySQL admin tool to examine the database tables related to this Advanced Guestbook.  Look for a table that contains user information and possibly a password column.  If you find it, most likely the data will be encrypted from an MD5() function... that's OK.  Use your selected MySQL admin tool to update the column value to "5f4dcc3b5aa765d61d8327deb882cf99" which is the MD5 encrypted version of "password"... make sure you note the original value as a precaution.

See where that takes you!
"I know that you understood what you think I said but I'm not sure you realize that what you heard is not what I meant..."

Andromeda, April 2003 - Sept 2004
Lyra, since Sept 2004

Misha

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Lost Advanced Guestbook password - How to retrieve it
« Reply #4 on: January 23, 2004, 08:09:51 AM »
Quote from: MishaPappa
EJ - drop the direction you are heading with the MySQL root password... I doubt it's relevant...
OK

I'm not specifically familiar with the Advanced Guestbook - is this the one installed from cPanel?
Yes

Is there a related website/author link somewhere that the original scripts or installation package can be acquired?

I got the above tutorial through "mysql account manag." in cpanel, there was a link

That information would be helpful to pursue analysis of the MySQL database structure and SQL abstraction layer that relates to a user and their password.

Your time right now would well  be spent using phpMyAdmin or any other familiar MySQL admin tool to examine the database tables related to this Advanced Guestbook.

Yes thats where I am, I just don't know where to go next. I a bit afraid to start meesing with stuff

 Look for a table that contains user information and possibly a password column.  If you find it, most likely the data will be encrypted from an MD5() function... that's OK.  Use your selected MySQL admin tool to update the column value to "5f4dcc3b5aa765d61d8327deb882cf99" which is the MD5 encrypted version of "password"... make sure you note the original value as a precaution.

Yes I see an encrypted password with my login ID. There is an "edit" area would this be the correct place?  (see I have no idea what Im doing)

I made a  screenshot of where I am http://steelsheen.com/scrnshot.GIF

when I click edit this is what I see  http://steelsheen.com/scrnshot2.GIF


Is this where I need to be?

Thanks for your help Misha
I love the new LPF theme

Offline MishaPappa

  • Jabba the Hutt
  • *****
  • Posts: 587
Lost Advanced Guestbook password - How to retrieve it
« Reply #5 on: January 23, 2004, 08:58:01 AM »
Exactly the right place EJ (best I can tell from your info). :thumb:

Make the change, press the GO button and then open another browser to confirm you can login to your Advanced Guestbook.
"I know that you understood what you think I said but I'm not sure you realize that what you heard is not what I meant..."

Andromeda, April 2003 - Sept 2004
Lyra, since Sept 2004

Misha

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Lost Advanced Guestbook password - How to retrieve it
« Reply #6 on: January 23, 2004, 09:18:00 AM »
OK wish me luck!   :D
I love the new LPF theme

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Lost Advanced Guestbook password - How to retrieve it
« Reply #7 on: January 23, 2004, 09:28:26 AM »
ugh! well its changed it but when I put in "password" it didn't work
I love the new LPF theme

Danielle

  • Guest
Lost Advanced Guestbook password - How to retrieve it
« Reply #8 on: January 23, 2004, 09:31:52 AM »
Hi EJ,

In the password field, did you replace what you had with 5f4dcc3b5aa765d61d8327deb882cf99 as it would be the password field that you would need to put that string in. Just wanted to verify.

Thanks

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Lost Advanced Guestbook password - How to retrieve it
« Reply #9 on: January 23, 2004, 09:33:00 AM »
yes, Miraenda

then I went to login to admin from guestbook and that is where I put "password"  in password field
I love the new LPF theme

Danielle

  • Guest
Lost Advanced Guestbook password - How to retrieve it
« Reply #10 on: January 23, 2004, 09:51:08 AM »
Hi EJ,

I did the same thing to see if I could get this method to work for me.  I also tried a different MD5 password of 1a1dc91c907325c69271ddf0c944bc72 for pass simply to see if that would work.  Neither of them did...

Then I went to the Advanced Guestbook site's forum to look about this issue.  The forum is located at http://proxy2.de/forum/

Here is the post giving you instructions on how to do it:

http://proxy2.de/forum/viewtopic.php?t=1604&highlight=lost+password

Please read the whole post for future reference on how to retrieve it as the last post has an interesting note.

Thanks

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Lost Advanced Guestbook password - How to retrieve it
« Reply #11 on: January 23, 2004, 10:34:35 AM »
OH BLESS YOU, Miraenda! That thread didnt do it but I found another in that forum that did!!! :yey:  :yey:  :yey:  :yey:
I love the new LPF theme

Danielle

  • Guest
Lost Advanced Guestbook password - How to retrieve it
« Reply #12 on: January 23, 2004, 10:41:03 AM »
Hi EJ,

I'm happy that the forum helped and you are able to get into the guestbook now.  :thumb:

Have a Blessed Day

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Lost Advanced Guestbook password - How to retrieve it
« Reply #13 on: January 23, 2004, 10:55:34 AM »
I really think this should be a sticky either in how to's or begginers forum, I can't be the first/only person to ever have this problem (or can I? lol)
I used method one and it worked like a charm.


[Method 1]
Login to cpanel
Go to  "MySQL Databases"
At bottom of page click "Click here to access phpMyAdmin."
Select the Guestbook database.
Select book_auth.
Now choose Browse.
You now see the admin username and password.
Select edit.
Now paste Code:

Code:
773359240eb9a1d9

in the password field and click “GO”.

This will reset your account to:

Your admin name and the password will be: 123

you can then change the password in the admin area

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



[Method 2]
Select the Guestbook database
Now choose on the right side of screen select SQL
Now insert in the Data Entry Field the following lines:

Code:

delete from book_auth;
INSERT INTO book_auth VALUES (1, 'test', '773359240eb9a1d9', '7d8b85294e2e060b83f596a4fc5561ce', 1058460506);


And click "GO"

This will reset your account to:

User name: test
Password: 123
------------------------

I tired this method(2) and couldnt get it to work
I love the new LPF theme

Danielle

  • Guest
Lost Advanced Guestbook password - How to retrieve it
« Reply #14 on: January 23, 2004, 10:57:37 AM »
EJ, good idea, I'll move it to the How-to Forum as a sticky, and change the title maybe to "Lost Advanced Guestbood password - How to retrieve it"

I tried the second method myself (didn't try the first), and was able to get it to work.  The first method is likely easier anyway.

thanks

 

Share |