LORIS v21 has expired the lorisadmin account (likely due to inactivity?)

[gdevenyi]

I have inherited a LORIS instance that has been lightly used in the past year, and which I have not logged into.

I tried to login today to find:

Could you please provide a step-by-step process to reset the account via system admin level access on the DB/LORIS host.

[ridz1208]

Hi @gdevenyi,

the easiest way to get past that is the following:

1. make sure the Active column in the users MySQL table is set to Y for this user
2. run the following command by replacing the user_name value with the actual name: DELETE FROM user_login_history WHERE UserID='user_name'

FYI, This will obviously wipe all traces of that user in the user_login_history, so if you actually care about that data, let me know and I will find another way to get you in

[gdevenyi]

Self documenting an actual step-by-step:

1. mysql console on DB with root user
2. use lorisdb;
3. UPDATE users SET active = "Y" WHERE UserID = "lorisadmin";
4. DELETE FROM user_login_history WHERE UserID='lorisadmin';

[xlecours]

There is also https://github.com/aces/Loris/blob/main/tools/resetpassword.php

[gdevenyi]

Thanks. The password is known. Its the account that's been locked out.