Migrating 6.2.2 to 6.2.4 Question

[AthenaAutomation]

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

[jllort]

do you have embeded database or has changed for mysql ?

[AthenaAutomation]

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.

[jllort]

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.

[AthenaAutomation]

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?

[okmuser]

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

and also clear the cache in the browser

[AthenaAutomation]

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!