OpenKM installation 6.3.9 error

[shinus]

Once installed I started the OpenKM service from the services, I have used mysql database, but gives me this error below on the webpage while trying to open the localhost page: using edge browser, win10 OS

Application error
Class:
org.apache.jasper.JasperException
Message:
An exception occurred processing JSP page [/login_desktop.jsp] at line [230] 227:
Date:
Fri Jun 12 11:03:48 AST 2020

Attached screenshot and also the OpenKM log file. Using mysql version : mysql-installer-community-8.0.20.0

Please help to solve

[shinus]

after reading some posts, i uninstalled and reinstalled mysql with selecting option to classic MySQL (5.x), while installing.

I get now cannot connect to mysql error as attached in the screenshot;
also deleted all log files and restarted openkm service. captured all the new logs here , that is attached too.. can someone help..thanks a lot

[shinus]

and also have checked the table in mysql, and user openkm, which has all the prvileges to the specified table.please see screenshot

Code: Select all

CREATE DATABASE okmdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
CREATE USER openkm@localhost IDENTIFIED BY '#####';
GRANT ALL ON okmdb.* TO openkm@localhost WITH GRANT OPTION;

### is the password provided during the installation; just changed it here in the post

[shinus]

Connection to the database verified from the cli interface as user openkm (tried changing the localhost to IP value in the server.xml) but its not solving.

Code: Select all

mysql -h localhost -u openkm -p###### okmdb
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 38
Server version: 8.0.20 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Password above hashed -its the same password as in the tomcat installation, also updated in the mysql workbench for the openkm user with the same password:

still chrome,edge all giving no connection error

[shinus]

Finally I have solved this issue:clearing all the repository folder, after stopping the openkm service, surprisingly its not listed in wiki?or is it?
changed the openkm.cfg file with below ("none" to "create")

Code: Select all

hibernate.hbm2ddl=create

i have seen this value goes back to none..but it works..

[jllort]

It's quite difficult to explain how to solve issues in the first startup because might be several reasons why is not working.

When the application fails to get the connection to the database at the first startup you must delete the repository folder, set to hibernate.hbm2ddl=create and start again. This is the clean status you got before the first startup and what requires the application to build everything from scratch.

We will try to explain in the documentation ( I think we have explained in some section but maybe will be better in the OS installation sections , I have added in each OS section https://docs.openkm.com/kcenter/view/ok ... romscratch)