Open Source Document Management System | OpenKM

PostPosted:**Mon Sep 05, 2022 1:10 am**

I started the virtual machine version of OpenKM, after compiling in Eclipse as instructed by video then started Tomcat, accessing http://localhost:8080/OpenKM from browser shows error below:
"An exception occurred processing JSP page [/login_desktop.jsp] at line [230] 227"

I changed OpenKM.cfg so that hibernate.hbm2ddl=create. Restarted Tomcat, but http://localhost:8080/OpenKM now shows
"javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection"
I am able to connect to okmdb in terminal but SHOW TABLES; shows Empty set

PostPosted:**Tue Sep 06, 2022 3:44 am**

Thanks to @saleem55, issue has been fixed. viewtopic.php?p=52810
Edited server.xml
1. changed com.mysql.jdbc.Driver to com.mysql.cj.jdbc.Driver
2. changed url to below

Code: Select all

url="jdbc:mysql://localhost:3306/okmdb?useSSL=false&amp;autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC"/>

Open Source Document Management System | OpenKM

Downloaded VM Install Shows "exception occurred processing JSP page [/login_desktop.jsp]"

Downloaded VM Install Shows "exception occurred processing JSP page [/login_desktop.jsp]"

Re: Downloaded VM Install Shows "exception occurred processing JSP page [/login_desktop.jsp]"