reset okmAdmin password

[padideh2]

Hi
how can I reset my akmAdmin password ?
thank you so much
Ali

[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.

[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

[padideh2]

I'll try it
thank you so much

[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

[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

[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

[pavila]

You can see the version at Help > About OpenKM.