Page 1 of 1

How to make OpenKM to create enbedded DB during installation? (docker)

PostPosted:Tue Nov 30, 2021 4:20 pm
by LauryMenton
I'm trying to install another instance of OpenKM (6.3.9), but it fails to start. It shows the error that OpenKM failed to connect to the DB.

I have another OpenKM (main instance) already running 24/7 on the same machine, using MySQL (container) as its external DB on default port (3306). It works well, no problema at all.

I have set the 'Openkm.cfg' settings as:
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.hbm2ddl=create


My question is how to make OpenKM to create the DB (integrated) on first installation.

Maybe, I have to edit the server.xml file, as it may be trying to connect to an external DB automatically?

Re: How to make OpenKM to create enbedded DB during installation? (docker)

PostPosted:Sat Dec 04, 2021 9:06 am
by jllort
We do not suggest using an embedded sql engine, because in case of disk failure or wrong server shutdown the database may be damaged and is between quite difficult or impossible to recover it.

If you want to go ahead; yes, must modify server.xml before starting the application ( uncomment HQL XML section ) and change the OpenKM.cfg to the right dialect. Anyway, I encourage using MySQL or MariaDB, or other non-embedded SQL engines.

Re: How to make OpenKM to create enbedded DB during installation? (docker)

PostPosted:Thu Jun 30, 2022 10:26 am
by LauryMenton
Sorry for the late reply. Thank you for your responde!