Page 1 of 1
reset okmAdmin password
PostPosted:Sun Jun 26, 2011 9:38 am
by padideh2
Hi
how can I reset my akmAdmin password ?
thank you so much
Ali
Re: reset okmAdmin password
PostPosted:Mon Jun 27, 2011 8:28 am
by pavila
OpenKM passwords are encoded using MD5, so create a new one and update the corresponding OKM_USER table column (USR_PASSWORD). By default, it is stored in a HSQL database. You can use a fronted like Aqua Database Studio, or use default one from HSQL. Refer to HSQL documentation for more info.
Re: reset okmAdmin password
PostPosted:Mon Jun 27, 2011 8:45 am
by jllort
1-Stop jboss.
2-Go to jboss-4.2.3.GA/server/default/data/hypersonic
3-Edit openkm.script file
4- look for something like INSERT INTO OKM_USER VALUES('okmAdmin','Administrator' and replace with INSERT INTO OKM_USER VALUES('okmAdmin','Administrator','21232f297a57a5a743894a0e4a801fc3','
admin@noreply.com','T')
5- start jboss, the password of okmAdmin now is admin
Re: reset okmAdmin password
PostPosted:Mon Jun 27, 2011 8:51 am
by padideh2
I'll try it
thank you so much
Re: reset okmAdmin password
PostPosted:Mon Jun 27, 2011 5:45 pm
by padideh2
thank you
In hypersonic directory I just found "OKM_APP.script"
and it was exactly like what you said
INSERT INTO OKM_USER VALUES('okmAdmin','Administrator','21232f297a57a5a743894a0e4a801fc3','
it@Domain.com',TRUE)
but the password is not admin
thanks
Re: reset okmAdmin password
PostPosted:Thu Jun 30, 2011 9:21 pm
by jllort
if you've got okm_app could be and older version of openkm
The '21232f297a57a5a743894a0e4a801fc3' is the password crypted in md5 'admin" sure ! you must only change the 'XXXXXX' password for that '21232f297a57a5a743894a0e4a801fc3' ( I've given to you the insert used in OpenKM 5.x if you've got older could be different ).
have you logged ?
do you know whic openkm version you've got ? if not put here your OpenKM.cfg
Re: reset okmAdmin password
PostPosted:Sun Jul 03, 2011 3:46 pm
by padideh2
I found nothing in openkm.cfg about version but the directory name was "jboss-4.2.3.GA"
but if you need it here it is:
Code: Select all# Default configuration values
#
# repository.config=repository.xml
# repository.home=repository
# system.user=system
# default.user.role=UserRol
# default.admin.role=AdminRol
# principal.adapter=com.openkm.core.UsersRolesPrincipalAdapter
# max.file.size=5
# max.search.results=25
# system.demo=off
restrict.file.mime=off
restrict.file.extension=*~,*.bak,._*
#system.ocr=/usr/bin/tesseract
system.openoffice=/usr/lib/openoffice
system.img2pdf=/usr/bin/convert
system.pdf2swf=/usr/bin/pdf2swf
system.antivir=/usr/bin/clamscan
#hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=none
#application.url=http://localhost:8080/OpenKM/com.openkm.frontend.Main/index.jsp
max.file.size=060520010
#principal.adapter=com.openkm.principal.DatabasePrincipalAdapter
#notify.twitter.user=openkm
#notify.twitter.password=****
#subscription.message.body=Prueba.vm
thank you so much
Re: reset okmAdmin password
PostPosted:Mon Jul 04, 2011 5:52 pm
by pavila
You can see the version at Help > About OpenKM.