Page 1 of 1

migrating from 6.2.3 to 6.2.4

PostPosted:Wed Jun 19, 2013 9:51 am
by doozy
Hi,

Think I am experiencing the same error with TS.
On folder/node, if I change security rights for say user A with recursive rights, removing all rights of read, write, delete and security.
User A is still able to access the folder and files. So, this may be the error and version 6.2.4 is the update to it.

I follow migration instruction. Can anyone tell me if I am doing correctly - step by step.

Make a backup!!! (i zip the whole openkm directory)
Stop Tomcat (easy)
Edit OpenKM.cfg and set hibernate.hbm2ddl to update (edited)
Replace the OpenKM.war (downloaded, delete old one, rename downloaded file openkm.zip to openkm.war
Run from your preferred SQL client these queries:
DROP TABLE OKM_OMR; (i am using default database, did not do anything to this step. don't know how to execute a query also
Start Tomcat again (started with ease)
Go to Administration > Database Query, and remove obsolete configuration properties: (copy and paste into query, select JDBC type and click SEND
DELETE FROM OKM_CONFIG WHERE CFG_KEY='kea.model.file';
DELETE FROM OKM_CONFIG WHERE CFG_KEY='kea.stopwords.file';
DELETE FROM OKM_CONFIG WHERE CFG_KEY='kea.automatic.keyword.extraction.number';
DELETE FROM OKM_CONFIG WHERE CFG_KEY='kea.automatic.keyword.extraction.restriction';
Enjoy OpenKM 6.2.4! (problem now is before I restart, do i need to change hibernate.hbm2ddl back to NONE? anyway, did not change and restarted. checked openkm version is still stating 6.2.3. delete the folders as listed below after i have stop tomcat. restart but now there is user error after the rebuild. )
If you have any weird problem try to stop Tomcat, delete these folders:
$TOMCAT_HOME/webapps/OpenKM
$TOMCAT_HOME/work/Catalina/localhost
And start Tomcat again.

Re: migrating from 6.2.3 to 6.2.4

PostPosted:Wed Jun 19, 2013 12:00 pm
by okmuser
Replace the OpenKM.war (downloaded, delete old one, rename downloaded file openkm.zip to openkm.war <--

download the zip file
http://sourceforge.net/projects/openkm/ ... p/download

delete OpenKM.war

and unzip on file where your current OpenKM.war is.

No need to rename any files and no need to change OpenKM.cfg back to 'none'

What is your database server?

Re: migrating from 6.2.3 to 6.2.4

PostPosted:Wed Jun 19, 2013 2:01 pm
by doozy
Hi okmuser,

thank you for the reply.

firstly, i was not sure how to upgrade. now i saw the new build 6.2.4 is available to download.
what i did was to export the data to local drive and uninstall 6.2.3. thereafter, I installed the new version and import the data back.
what i discovered was the user data is gone. i have to re-generate all users again. Can you share how we can safely update in future?
Do I just download the .war file and replace it leaving all files and folder intact? If I need to reinstall somewhere, how can I save all information? Please share.

Secondly, the database I am using is default that come with the bundle. Not sure what it is... Can explain?

Re: migrating from 6.2.3 to 6.2.4

PostPosted:Thu Jun 20, 2013 9:48 am
by jllort
You "I installed the new version and import the data back" ? simply you should replace .war file In migration guide http://wiki.openkm.com/index.php/Migration_Guide is well explained how doing it. Anyway I suggest make some backup before doing it to prevent some mistake during the process.