Page 1 of 1

Application error: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open co

PostPosted:Wed Mar 23, 2022 11:47 am
by moinuddin1997
I have installed OpenKM as per the video. A

After successful installation, when i type localhost:8080/OpenKM

I am receiving the following application error.
Code: Select all
Application error
Class: org.apache.jasper.JasperException
Message: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
I attached log file server xml and openkm xml file for reference.
I would appreciate it if any one can help to fix this error.

Thank you.
Date: Wed Mar 23 14:36:53 EET 2022

Re: Application error: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open co

PostPosted:Sat Mar 26, 2022 10:55 am
by jllort
Error is clear, the application is not able to connect with database:
Code: Select all
<Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" validationQuery="select 1" username="openkm" password="OLm6Pl.2#X6t" driverClassName="com.mysql.cj.jdbc.Driver" url="jdbc:mysql://localhost:3306/okmdb?useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=UTF8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC"/>
<Resource name="mail/OpenKM" auth="Container" type="javax.mail.Session" mail.smtp.host="localhost" mail.from="testing@openkm.com"/>
Check with standard client if you are able to connect to database and check suggested configuration from our documentation https://docs.openkm.com/kcenter/view/ok ... riadb.html

Re: Application error: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open co

PostPosted:Tue Jul 11, 2023 3:52 am
by malbororole
My issue was that system.pdf.force.ocr was set to true. I'm not sure I understand everything, but it's functioning now.