How to recover the administrator password

Symptoms

You have lost the administrator password and the users are stored in the OpenKM database. If OpenKM is connected to LDAP (Active Directory), you should ask your LDAP administrator to reset it.

Solution

You can reset the administrator password and set it to the default from the database. Log in to the OpenKM database, usually named "okmdb", and then execute the query:

OpenKM v7.1

update OKM_USER set USR_PASSWORD='$2a$10$Z5R69bZZgX9z3tU9zjSYyuwE4iAA8Tk58xCnZ8t86Rb3WEg48dNoC' where USR_ID='okmAdmin';

OpenKM v6.4

UPDATE OKM_USER SET USR_PASSWORD='21232f297a57a5a743894a0e4a801fc3' WHERE USR_ID='okmAdmin';

After the query is executed, the password of the "okmAdmin" user will be "admin".

Properties

Keywords