javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection

[agb123]

Hello,

I've just installed OpenKM on Windows 10x64 and got this error javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection. I'm using MySQL 8 and java jdk1.8.0_171

Screenshot_2.png (9.34 KiB) Viewed 20985 times

I'm new to this system, I hope you can help me with it.

Log files.rar

(8.99 KiB) Downloaded 1025 times

Thanks!!

[lnovoa]

Hi!,
The problem is because of the MySQL version.
You have two options:
1.

• Uninstall version 8 and install MySQL 5.7.

• Stop the server and delete the tomcat/repository directory.

• Modify the file Openkm.cfg the property hibernate.hbm2ddl = create.

• Start the tomcat.

2. Follow the steps to the link:
https://docs.openkm.com/kcenter/view/ok ... oting.html

[agb123]

@Inova, thanks a lot, I followed the steps to the first option and it worked perfectly.

[vf20fena]

Im in the virtual machine .ova y compile the tomcat and run catalina.sh every thing is ok and al the en when i try to get in to the portal it saysss:

Code: Select all

avax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection

[jllort]

That's because can not connect to the database, check:
* Mysql is started
* The okmdb exist
* Check the database configuration at server.xml ( into tomcat-XXX/conf folder )

[ckhounesavath]

I am also having the same issue. Please refer to the following:

Code: Select all

Application error
Class: org.apache.jasper.JasperException
Message: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Date: Tue Jan 24 13:57:14 CST 2023

What can I do to resolve this error, but not lose all of my files?

[jllort]

The problem happens because the application is not able to connect with your database. Test the configuration set in the server.conf file to connect with the database and check the connection with a database client.

[raime20]

Hola, me pasa lo mismo, pero estoy utilizando el entorno de virtualización en formato OVA que descargué del sitio oficial de OpenKM

[jllort]

Check if the database is up and the user credentials are working:

* user: openkm
* password: openkm