Reset password

Administration
1

How can i reset my user name and password as it showing

Too many failed logins: please reset password.

2

Hi Anshika, the best approach is to use the Forgot Password? link on the login screen, which will email you a link to reset your password from. Failing this (say email is not set up on your server), you can look at the gibbonPerson table in your database, and use the following SQL:

UPDATE gibbonPerson SET passwordStrongSalt=‘[randomSalt]’, passwordStrong=sha2(CONCAT(‘[randomSalt]’,‘[newPassword]’), 256) WHERE username=‘[username]’;

In this statement replace both instances of [randomSalt] with the same random string, [newPassword] with the desired password and [username] with the intended user’s username.

Cheers,

Ross

3

Good day. After running the password reset SQL above, was successful in login after also setting column failCount to null. This column is also under the table gibbonPerson. Not sure if I needed to do this because of new installation (gibbon and database)

4

Hi Richard,

Glad to hear it works, and yes, setting failCount to 0 (or null) can be useful, depending on why you are resetting the password. The updated query below does just that:

UPDATE gibbonPerson SET passwordStrongSalt=‘[randomSalt]’, passwordStrong=sha2(CONCAT(‘[randomSalt]’,‘[newPassword]’), 256), failCount=0 WHERE username=‘[username]’;

Cheers,

Ross