Page 1 of 1

How to retreive admin password in OpenKM 5.1.10

PostPosted:Wed Jul 16, 2014 3:35 pm
by hariharan.gopal
Hi,

I have forgotten Admin password. Please help me on how to retrieve it or change the password.

Thanks in advance

Hariharan G

Re: How to retreive admin password in OpenKM 5.1.10

PostPosted:Thu Jul 17, 2014 9:40 am
by jllort
You're using embedded database or other? If you're not sure take a look at OpenKM.cfg and post here.

Re: How to retreive admin password in OpenKM 5.1.10

PostPosted:Thu Mar 05, 2015 9:41 am
by hariharan.gopal
Hi,

here is my OpenKM.cfg
Code: Select all
hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=none
application.url=http://localhost:60320/OpenKM/frontend/index.jsp

Re: How to retreive admin password in OpenKM 5.1.10

PostPosted:Fri Mar 06, 2015 5:44 pm
by jllort
Can no retrieve because is md5 crypted, but you can change by someone know.
Option one
1- backup
2 - Install geany
3 - With openkm stopped try to open the database file, into jboss/server/default I do not remember the exact location because OpenKM 5.x is an older version what we consider deprecated, I remember some folder called data/hypersonic I'm not totally sure. There you will got a file called okm_app.script or similar ( open with geany ).
4- Looking for OKM_USER you'll see sql inserts, one of these should be okmAdmin change password to '21232f297a57a5a743894a0e4a801fc3' this password value is "admin".

Option two
Stop openkm
With some utility like datastudio ( aquafold ) connect to hsql database and then change the password to '21232f297a57a5a743894a0e4a801fc3' this password value is "admin".

Re: How to retreive admin password in OpenKM 5.1.10

PostPosted:Sat Mar 07, 2015 8:38 am
by hariharan.gopal
Thanks jillort. I shall try and give the feedback.

Re: How to retreive admin password in OpenKM 5.1.10

PostPosted:Mon Mar 09, 2015 11:15 pm
by jllort
Take a look at deploy/openkm-ds.xml (I'm not totally sure about the name ) there should the connection url what can inspire you to connect with datastudio.