Lost information after restarting the system

[ameisner]

We are using OpenKm with a internet server. The provider had to restart his server an now all informations of users and roles are lost. The files themselves and the folders are not lost.
The hibernatevalue is set to none, but the informations are lost.
Please can you help me?

[jllort]

Which version of OpenKM are you using ?
Are you sure that hibernate.hbm2ddl=none and you've restarted the application, it's really very strange, please confirm it.

[ameisner]

We are using Version 5.0.2.
The value is set to none.
We have no idea!

[jllort]

Upgrade to 5.0.4. ( it's really trivial from 5.0.2 to 5.0.4 ) take a look at migration guide in documentation.
It's first time on any version this problem happens, really very strange. You haven't made any modification in OpenKM ( source code etc.. ).
Put here your OpenKM.cfg

[ameisner]

I´ve informed the provider to post the OpenKm.cfg.

[ameisner]

my config:

hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=none

[jllort]

could you try stopping jboss and starting again to ensure the problem is on stop starting openkm server ... because it's really very strange.
You are not doing anything else during restarting your server ?

[ameisner]

if we stop and start jboss, its ok

but if we restartthe hole server, the users are gone

users are stored in hssql?
may if we start jboss, this hssql file is overwritten

[pavila]

JBoss does not remove himself the hipersonic databases. If your configuration is:

Code: Select all

hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=create

It should work. Otherwise, something weird is happening.

[ameisner]

so should we use

hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=create

or

hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=none ?

[pavila]

Sorry, the create is for initial OpenKM deploy and will create tables in database:

Code: Select all

hibernate.hbm2ddl=create

After the database tables are created, should set to:

Code: Select all

hibernate.hbm2ddl=none

HSQL databases are located at $JBOSS_HOME/server/default/data/hypersonic folder. Check that this folder is not deleted in the server reboot.