Page 1 of 1

Accidentally disabled okmAdmin

PostPosted:Wed Apr 19, 2017 11:23 am
by zemmyindrapatih
Dear OpenKM Team,

I'm work as IT and OpenKM Admin in my office.
- We are using OpenKM Community version 6.3.3 zip version.
- OS Windows 7
- Database and configuration still Default.

I got problem, i accidentally disabled the okmAdmin and all other user account except my own account from Administration. Now i already logged out.
I cant configured anything now because my account only have limited permission.

How can i just reenable the okmAdmin. Please HELP ME....
If your support need to pay, how can i pay you to solve this problem quickly.

Thank you for your help.

[SOLVED]

PostPosted:Wed Apr 19, 2017 1:07 pm
by zemmyindrapatih
Thank you Admin, i've found the solution from this post: viewtopic.php?t=12660.

I open "L:\tomcat\repository\okmdb.script" with text editor and find:
Code: Select all
INSERT INTO OKM_USER VALUES('okmAdmin','Administrator','e10adc3949ba59abbe56e057f20f883e','noreply@openkm.com','F');
then i change the 'F' with 'T'
Code: Select all
INSERT INTO OKM_USER VALUES('okmAdmin','Administrator','e10adc3949ba59abbe56e057f20f883e','noreply@openkm.com','T');
After that, i tried to restart OpenKM. Voila the okmAdmin enabled again.


Thank you very much jllort.

Re: Accidentally disabled okmAdmin

PostPosted:Wed Apr 19, 2017 4:34 pm
by jllort
Yes that was the solution. I suggest for production move to MySQL or similar database rather embedded database. In case the database be corrupted is quite difficult or impossible to get it back again. This kind of problems not happens in the same manner in databases like MySQL, PostgreSQL etc.. that's why I suggest in production move to standard database rather embedded one.