Stop OpenKM
clean all the logs
Share with us the catalina.log and catalina.out file
Did you execute something in the database, like disable all the users ? you can try small change in your OpenKM.xml
You can try to change:
Code: Select allusers-by-username-query="select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active='T'"
authorities-by-username-query="select ur_user, ur_role from OKM_USER_ROLE where ur_user=?"/>
to
Code: Select allusers-by-username-query="select usr_id, usr_password, 1 from OKM_USER"
authorities-by-username-query="select ur_user, ur_role from OKM_USER_ROLE where ur_user=?"/>
or
Code: Select allusers-by-username-query="select 'okmAdmin', '21232f297a57a5a743894a0e4a801fc3', 1"
authorities-by-username-query="select 'okmAdmin', 'ROLE_ADMIN'"/>
Where 21232f297a57a5a743894a0e4a801fc3 is the password "admin".
Also with OpenKM stopped you can try to connect with database okmdb, with a tool like datastudio ( aquafold ).
Finally I encourage migrate to MySQL or other database in production environment. If your HSQL it corrupts for some reason will not be possible recover data in almost cases ( might happens for example with a bad computer power off ). I will try to explain in the documentation how to migrate between databases.