Open Source Document Management System | OpenKM

I did an install onto a Windows 10 machine.
I created the default user in MySQL, but it defaulted to a "SHA256" auth type, rather than a simple/standard user type. This, I think stopped the creation of the proper tables in MySQL.

So, i deleted the entire Tomcat installation, changed the user auth type in MySQL to Standard (user/pw), and reinstalled OpenKM. I expected the tables to be created, but that didn't happen.
I did try connecting to the MySQL db using the user/pw i created for OpenKM, and i was able to connect and create tables etc. with no problems.

• Any ideas out there on what I'm doing wrong?

• Can i run the table creation and data loading scripts seperately from the command line?

Thanks!

Ah ha.. after working through the batch scripts and install directions i stumbled across this which fixed the problem

Edit the file $TOMCAT_HOME/OpenKM.cfg

hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.hbm2ddl=create

(bolding mine)..

The parameter hibernate.hbm2ddl with value "create" is used to indicate the application must create the database tables structure. When installing OpenKM by default the OpenKM.cfg has this value to "create".

this fix was still required today with the latest community edition

1. go to tomcat root
2. edit OpenKM.cfg
3. update this line hibernate.hbm2ddl=create (the default is none)
4. restart tomcat