Forgot Admin Password and e-mail not accessible

Administration
1

Hi , Is there any way to retrive the admin password form database? I’ve forgot the admin password, and my admin e-mail is not accessible. So cant use the forgot password option. Is there any way to retrive it? I can access phpmyadmin but dont know which table to access.

Thanks

2

Topon,

These things happen! You can’t retrieve the password, as it is hashed, but you can reset it using the following SQL:

UPDATE gibbonPerson SET password=md5(‘newPassword’), passwordStrong=‘’, passwordStrongSalt=‘’ WHERE gibbonPersonID=1;

Replace the word newPassword with your chosen password.

The first user created by the installer has gibbonPersonID=1.

Not that the md5 hashing used above is not secure, but it is only for temporary use. Once you log in, the password is salted and hashed with SHA1, which is more secure.

Hope this helps.

Thanks,

Ross

3

Thanks

4
Topon,

These things happen! You can’t retrieve the password, as it is hashed, but you can reset it using the following SQL:

UPDATE gibbonPerson SET password=md5(‘newPassword’), passwordStrong=‘’, passwordStrongSalt=‘’ WHERE gibbonPersonID=1;

Replace the word newPassword with your chosen password.

The first user created by the installer has gibbonPersonID=1.

Not that the md5 hashing used above is not secure, but it is only for temporary use. Once you log in, the password is salted and hashed with SHA1, which is more secure.

Hope this helps.

Thanks,

Ross

Hi Ross ! I don’t know why but i’m not being allowed to log in. I tried to change my password like this but I think i’m doing something wrong. Also the login page is saying i have made multiple login attempts. :confused:

5

I know, I know you must be laughing at my comments but I was able to login after resetting my password using your comments on another thread:

You can go into your database and locate your record in gibbonPerson. Set an MD5 hashed password string into the password field, and then sent passwordStrong and passwordStrongSalt to blank.

But now I am not admin somehow :open_mouth:

6

Okay done. Went to GibbonRole and changed to 001

7

Hi flygye12, I never laugh at someone trying to learn something, but I am impressed with the speed at which you are working. Glad to hear you’ve worked this one out. In terms of the password reset method you are trying above, you need to type the plain text password into the values box, and then use the dropdown to the left of it to select MD5. You’ve tried to do both things in one go, which you can do in SQL directly, but not in phpMyAdmin. Hope that makes sense! Ross