• Delete okmAdmin user

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
OpenKM has many interesting features, but requires some configuration process to show its full potential.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #47103  by mamad
 
Hi guys,
By a mistake i deleted the okmAdmin user from administration panel inside openkm
I cant login now with the default username and password(okmAdmin : admin) and dont have another user.Its very weird that we can delete the main user of openkm while we dont have another admin user.
How fix it now ?
I try to insert a new user manually at OKM_USER table but it not works and i faced with the Authentication error.
here is the query i used :
Code: Select all
insert into okmdb.OKM_USER
(USR_ID,USR_NAME,USR_PASSWORD,USR_EMAIL,USR_ACTIVE)
values
('okmAdmin','Administrator','21232f297a57a5a743894a0e4a801fc3','none@nomail.com','T')
Im using openkm6.3 community edition (im using the pre-configured linux (ova)and i have all development tools like eclipse,database,etc.)
 #47104  by mamad
 
i solved my problem by executing also the following query:
Code: Select all
INSERT INTO OKM_USER_CONFIG (UC_USER,UC_HOME_PATH,UC_HOME_NODE,UC_HOME_TYPE,UC_PROFILE) VALUES ('okmAdmin','/okm:root','643d4fd7-ba76-46a6-abf1-cf2fa278f97d','okm:folder',1);
I think the openkm needs a little change in administration settings to doesnt permit users to delete the only admin user !!

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.