The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Forgot username and password to advanced guestbook, how do i recover?

Discussion in 'General Discussion' started by AbeFroman, Jun 5, 2003.

  1. AbeFroman

    AbeFroman BANNED

    Joined:
    Feb 16, 2002
    Messages:
    654
    Likes Received:
    1
    Trophy Points:
    0
    I forgot username and password to advanced guestbook, how do i recover?

    cPanel.net Support Ticket Number:
     
  2. redhatguy

    redhatguy Member

    Joined:
    Dec 24, 2002
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    Locate mysql database agbook1 and search for table " book_auth "

    select ID,username,password from book_auth;

    will lists the username and password.

    Make the password field MDS and insert a new username , password to the table.

    Thats it !!! :)

    cPanel.net Support Ticket Number:
     
  3. ssskumar

    ssskumar Member

    Joined:
    May 22, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    could you please make me understand the line,
    "Make the password field MDS..."
    how to do .so...?

    cPanel.net Support Ticket Number:
     
  4. ehpsubrat

    ehpsubrat Member

    Joined:
    Dec 19, 2003
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    To retrive the guestbook password select the guest book db and the table book_auth. While browsing it will show you the user name.
    run this sql command to change the password

    update book_auth set password=PASSWORD('pass') where username='user';

    where 'pass' is your password and 'user' is the user name.
     
  5. Marty

    Marty Well-Known Member

    Joined:
    Oct 10, 2001
    Messages:
    630
    Likes Received:
    1
    Trophy Points:
    18
    Yes, it should be noted that advanced guest book DOES NOT use md5 on the password, but rather used the mysql "Password" function, so that late sql statement would be the correct one.
     
  6. emily

    emily Registered

    Joined:
    Apr 28, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    I'm using phpMyAdmin and I found the book_auth table and the username but don't understand where to run the command to change the password.

    Sorry for the silly question.. obviously I'm better suited for the simple guestbook at this point but it didn't offer the control I wanted :confused:
     
  7. SarcNBit

    SarcNBit Well-Known Member

    Joined:
    Oct 14, 2003
    Messages:
    1,010
    Likes Received:
    3
    Trophy Points:
    38
    There should be a SQL tab with a place to run SQL queries.
     
  8. ehpsubrat

    ehpsubrat Member

    Joined:
    Dec 19, 2003
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    You will find a SQL tab option on the phpmyadmin. Write the command there and bellow you will find the go button to execute it.
     
  9. kokoman

    kokoman Active Member

    Joined:
    Nov 28, 2002
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    BA, Argentina
    Hello, if you are using AGB v2.2 you can put the next string into the password field, leaving blank the username field.

    ') OR ('martin' = 'martin

    then you can change the password directly from the admin panel.

    regards
    Martin
     
  10. ivaserver

    ivaserver Well-Known Member

    Joined:
    Aug 9, 2002
    Messages:
    111
    Likes Received:
    0
    Trophy Points:
    16
    Select the Guestbook database
    Now choose on the right side of screen select SQL
    Now insert in the Data Entry Field the following lines:


    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

    Regards
    Ivaserver
     
Loading...

Share This Page