Page 1 of 1
Lost information after restarting the system
PostPosted:Fri Apr 29, 2011 10:17 pm
by 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?
Re: Lost information after restarting the system
PostPosted:Sat Apr 30, 2011 9:41 am
by 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.
Re: Lost information after restarting the system
PostPosted:Sat Apr 30, 2011 1:14 pm
by ameisner
We are using Version 5.0.2.
The value is set to none.
We have no idea!
Re: Lost information after restarting the system
PostPosted:Sat Apr 30, 2011 1:18 pm
by 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
Re: Lost information after restarting the system
PostPosted:Sat Apr 30, 2011 1:24 pm
by ameisner
I´ve informed the provider to post the OpenKm.cfg.
Re: Lost information after restarting the system
PostPosted:Mon May 02, 2011 10:03 am
by ameisner
my config:
hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=none
Re: Lost information after restarting the system
PostPosted:Mon May 02, 2011 10:42 am
by 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 ?
Re: Lost information after restarting the system
PostPosted:Mon May 02, 2011 1:25 pm
by 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
Re: Lost information after restarting the system
PostPosted:Wed May 04, 2011 8:03 am
by pavila
JBoss does not remove himself the hipersonic databases. If your configuration is:
Code: Select allhibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=create
It should work. Otherwise, something weird is happening.
Re: Lost information after restarting the system
PostPosted:Mon May 09, 2011 10:33 am
by ameisner
so should we use
hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=create
or
hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=none ?
Re: Lost information after restarting the system
PostPosted:Tue May 10, 2011 7:45 pm
by pavila
Sorry, the
create is for initial OpenKM deploy and will create tables in database:
After the database tables are created, should set to:
HSQL databases are located at $JBOSS_HOME/server/default/data/hypersonic folder. Check that this folder is not deleted in the server reboot.