Open Source Document Management System | OpenKM

Hello,

I am currently using OpenKM Community 6.2.2 on a Windows Server 2008 R2 with PostgreSQL database. I am looking to migrate to 6.2.4. I chose to skip 6.2.3 because of the user/role permission problems. Can I migrate straight to 6.2.4 from 6.2.2 ? What has to be done to the database?

The migration notes for 6.2.2 to 6.2.3 shows:
Run from your preferred SQL client these queries:
HSQL
ALTER TABLE OKM_NODE_MAIL ALTER COLUMN NML_CONTENT clob;
MySQL
ALTER TABLE OKM_NODE_MAIL MODIFY NML_CONTENT longtext;

The migration notes for 6.2.3 to 6.2.4 shows:
Run from your preferred SQL client these queries:
DROP TABLE OKM_OMR;
Start Tomcat again
Go to Administration > Database Query, and remove obsolete configuration properties:
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';

Links:
6.2.2 to 6.2.3 Migration Notes = http://wiki.openkm.com/index.php/Migrat ... 2_to_6.2.3
6.2.3 to 6.2.4 Migration Notes = http://wiki.openkm.com/index.php/Migrat ... 3_to_6.2.4

Thank you,

Alex

do you have embeded database or has changed for mysql ?

I'm not using the embedded. It's configured with a postgreSQL database that is running on the same Windows host, but outside of OpenKM.

To migrate directly from 6.2.2 to 6.2.4 :
- stop application
- make sql changes which comes in migration guide related to 6.2.3 ( without change war file and do not start application )
- continue with suggested changes in 6.2.4

Anyway get a backup to prevent some possible mistake in sequence.

Thanks for the response, but I can't seem to get it updating.

I followed the Migrating Guide for 6.2.2 to 6.2.3 without touching the .war file:
1. Stopped Tomcat
2. Copied OpenKM root folder for backup
3. Created backup of okm_app PostgreSQL Database
4. Edited OpenKM.cfg and set hibernate.hbm2ddl to update
5. The following SQL queries don't seem to apply to PostgreSQL
HSQL
ALTER TABLE OKM_NODE_MAIL ALTER COLUMN NML_CONTENT clob;

MySQL
ALTER TABLE OKM_NODE_MAIL MODIFY NML_CONTENT longtext;

Followed Migrating Guide for 6.2.3 to 6.2.4:
1. While Tomcat is still stopped, renamed old OpenKM.war file and copied 6.2.4 community OpenKM.war to same folder
2. Ran the following SQL query, but PostgreSQL said it doesn't exist:
DROP TABLE OKM_OMR;
3. Started Tomcat
4. Ran the following DB queries successfully:
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';



But Help -> About OpenKM still displays Version 6.2.2 instead of 6.2.4 ?

Am I missing something?

you may have to delete the localhost and OpenKM folders as specified in wiki.

and also clear the cache in the browser

Great, that worked. Renamed localhost and OpenKM folders to .bak and cleared history in Internet Explorer and now 6.2.4 is showing up in the About window.

Thanks!