How to update a "tomcat bundle" installation (with HSQLDB)?

[fschmitt]

Hi, i didn't find any information about how to update a "tomcat bundle" installation of OpenKM.

I've still got a 6.2.3 tomcat installation running (with HSQLDB as RDBMS) on a debian linux server. Now, i want to update it to 6.3.0.

Replacing the OpenKM.war as described in the Migration Guide obviously doen't change anything. So i've downloaded a new tomcat bundle, and i assume i'll have to modify some files of that bundle to make it work with my current documents. But which files have to get modified? How to i migrate the HSQLDB database and the document repository to the new tomcat bundle? Any help would be greatly appreciated!

[jllort]

I suggest think about migrate to mysql if you're on production ( for doing it you must do fresh installation -> export repository http://wiki.openkm.com/index.php/Repository_export and import http://wiki.openkm.com/index.php/Repository_import)

If you want to upgrade ( HSQL are dangerous databases, because if your system halt incorrectly ( uncontrole power down ) the database can be damaged in some circunstances and believeme me, in almost cases is not possible to recover ). First do a backup ( always you should get one, at least one per week, daily is the normal ). Then follow the migration guide and migrate step by step

from 6.2.3 to 6.2.4, then 6.2.5, and then to 6.2.6, then 6.3.0 and then 6.3.1 ( http://wiki.openkm.com/index.php/Migration_Guide )

In some cases you'll see execute from database client with application stopped, here you got two option:
1- do as is indicated, with openkm stopped using some database client like datastudio ( aquafold ) you can connect to hypersonic HSQL and execute it )
2- for example for migration from 6.2.3 to 6.2.4 ( execute the changes from administration / database query with 6.2.3 started, then stop, replace OpenKM.war and continue with other database changes ). The idea is easy, use previous version of openkm as database client ( for sql what we indicate application must be stopped ) and after be applied, stop openkm and continue with the other changes, replace war etc.... ( that also will go right )

[fschmitt]

Thanks jllort for your help! You're right, i will think about migrating to MySQL. But there's another point - how do i upgrade OpenKM installation that was installed as "tomcat bundle"? In this case, it seems putting the new OpenKM.war into the integrated tomcat doesn't have any effect. Do i have to create a new, parallel tomcat bundle installation, or can i "overwrite" the current installation? And what about my document repository - do i need to migrate the documents manually (how?)? Do you think i should drop the "tomcat bundle" installation, just use the OpenKM.war to install in a already existing tomcat?

[jllort]

With all OpenKM ways to install application ( bundle or with installer etc... ) you get, after completing all steps, exactly the same. A folder called tomcat or similar into what are OpenKM.cfg file ( what you need to change to indicate an upgrade ) and webapps ( into what you can find your OpenKM.war file ). Anyway before starting, remember, do a backup !