about Migrating from 6.2.2 to 6.2.3

[jamieLee]

OpenKM: Community version 6.2.2 build 7815
OS:Cent OS

According to http://wiki.openkm.com/index.php/Migrat ... 2_to_6.2.3 , I follow this step of runnig from your preferred SQL client these queries.

How to use SQL client to connect HSQL and execute these queries (ALTER TABLE OKM_NODE_MAIL ALTER COLUMN NML_CONTENT clob) ?

Thanks

[pavila]

HSQL brings with a client which can be used to connect to the database. I don't remeber its name but is included in the HSQL download page. Anyway you shoud not use HSQL for production.

[jamieLee]

I used the following migrating steps, but I logged in OpenKM and the version was still 6.2.2

1. Stop Tomcat
2. Edit OpenKM.cfg and set hibernate.hbm2ddl to update
3. Replace the OpenKM.war
4. Start Tomcat again

Is there something missing?

Thanks

[jllort]

Yes, delete folder OpenKM and folder localhost ( is explained in migration guide also ).

[bill_mcgonigle]

OpenKM: Community version 6.2.2 build 7815
OS:Cent OS

According to http://wiki.openkm.com/index.php/Migrat ... 2_to_6.2.3 , I follow this step of runnig from your preferred SQL client these queries.

How to use SQL client to connect HSQL and execute these queries (ALTER TABLE OKM_NODE_MAIL ALTER COLUMN NML_CONTENT clob) ?

Thanks

This was sort of a pain. Steps for upgrading with hsql (assume OpenKM root is /usr/local/openkm):

0. Backups.

1. Download a current hsqldb release from:
http://sourceforge.net/projects/hsqldb/files/hsqldb/

2. Unzip it. Find hsqldb/lib/sqltool.jar and move it to /usr/local/openkm/lib/

3. Create a sqltool.rc file. On linux it appears to insist on being in the home directory. The docs say that --rcFile can change this, but it didn't appear to. Add this to $HOME/sqltool.rc:

Code: Select all

urlid okmdb
url jdbc:hsqldb:file:/usr/local/openkm/repository/okmdb;shutdown=true
username SA
password
transiso TRANSACTION_READ_COMMITTED

4. Now, from /usr/local/openkm, run:

Code: Select all

java -cp lib/hsqldb.jar -jar lib/sqltool.jar okmdb

This will get you into a command-line sql shell. Type \dt to list the tables and make sure they look like OKM_ tables.

5. Insert the update code required by the upgrade procedure.

6. Type \q to quit

7. Proceed with rest of upgrade.