Open Source Document Management System | OpenKM

Why when i install "PostgreSQL - OpenKM 6.2.4" , ( option is: hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.hbm2ddl = create ) at start finish openkm database is established, OpenKM.cfg where the parameter is still create, even if I put it modified to none, restart the tomcat, openkm will still go to rebuild the database.

What you explain is very strange, normally if parameter is not automatically changed to none is caused because has been some error.
Are you sure if you change to none the database is created again ? Anyway I suggest you change to 6.2.5 which has already released last week.

thank you! But here no hmb2ddl error in logs, only one error message: "ERROR com.openkm.util.Update - UnknownHost Exception: update.openkm.com".

I am installed openkm at intranet, not internet. so host exception is normal. There are ways can go to skip this operation "com.openkm.util.Update - update.openkm.com "?

jllort wrote:What you explain is very strange, normally if parameter is not automatically changed to none is caused because has been some error.

Code: Select all

grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log

Are you sure if you change to none the database is created again ? Anyway I suggest you change to 6.2.5 which has already released last week.

This error is not relevant. OpenKM daily connect to update.openkm.com looking for news ( appears at bottom right -> version changes )

Is strange hbm2dll will not be replaces automatically to none. If tables are created and does not appears any error I suggest change manually to none.

I will still be manually changed to none recreate the database and clean repository. catelina.log show "RELOAD hibernate.hbm2ddl = create". Even though I installed the latest version 6.2.5, replaced mysql database the same way and only install using the default embedded database "HSQLDB" after installation hibernate.hbm2ddl will automatically become none. update.openkm.com to the exception, I have the parameters can be set Openkm.cfg update = off to turn off the error, but hbm2ddl = create the problem persists, manually modify none remains useless.

jllort wrote:This error is not relevant. OpenKM daily connect to update.openkm.com looking for news ( appears at bottom right -> version changes )

Is strange hbm2dll will not be replaces automatically to none. If tables are created and does not appears any error I suggest change manually to none.

which PostgreSQL version are you using ?
are you sure after executing grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log you get empty results ? what you explain is strange, the only reason could be while creating DB table structure happens some error and then break the process but should be in log something about it

Both PostgreSQL 8.3 and 9.4 are two versions of this, but the problem is the same as the mysql 5.x , no ERROR in catalina.log

jllort wrote:which PostgreSQL version are you using ?
are you sure after executing grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log you get empty results ? what you explain is strange, the only reason could be while creating DB table structure happens some error and then break the process but should be in log something about it

confirmed you got something strange but I do not know what ... could be security grants with OpenKM.cfg file ?