• My OpenKm Cannot open connection,please help me

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
OpenKM has many interesting features, but requires some configuration process to show its full potential.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #54386  by qmkkx100
 
For some reason, I wanted to use Dbeaver to connect to HSQLDB, the database that comes with Openkm, but there was an error indicating that the connection was occupied, so I cut the okmdb.lck file somewhere else, but when I restarted Openkm, I got the following error:
Code: Select all
Application error
Class: org.apache.jasper.JasperException
Message: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Date: Mon Aug 14 15:30:18 CST 2023
Attached is the log file, please help me, thank you
Attachments
(27.82 KiB) Downloaded 175 times
 #54394  by jllort
 
In the case of embeded databases only one application can be connected at the same time. I suggest using mariadb database or mysql.

Take a look here https://docs.openkm.com/kcenter/view/ok ... riadb.html

If you wish to continue with HSQL, have the option in the administration of the OpenKM to do SQL Queries with the menu option Database Query https://docs.openkm.com/kcenter/view/ok ... query.html

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.