Page 1 of 1

Delete okmAdmin user

PostPosted:Sat Dec 01, 2018 6:27 am
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.)

Re: Delete okmAdmin user

PostPosted:Sat Dec 01, 2018 10:50 am
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 !!

Re: Delete okmAdmin user

PostPosted:Sat Dec 01, 2018 11:12 am
by jllort
Add the issue in https://github.com/openkm/document-mana ... tem/issues and we will try to introduce this restriction ( seems it has sense ).