Difference between revisions of "Migration from 5.0.4 to 5.1.8"
From OpenKM Documentation
| Line 3: | Line 3: | ||
{{Warning|This migration process is under beta state and the SQL sentences are generated for MySQL. In case of other database may need some changes.}} | {{Warning|This migration process is under beta state and the SQL sentences are generated for MySQL. In case of other database may need some changes.}} | ||
| − | * Login into Administration and execute these sentences in order to export users and roles: | + | * Login into '''Administration''' > '''Database query''' and execute these sentences in order to export users and roles: |
<source lang="sql"> | <source lang="sql"> | ||
| − | SELECT CONCAT('INSERT INTO OKM_ROLE ( | + | SELECT CONCAT('INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES (''', ROL_ID, ', ''', IF(ROL_ACTIVE IS TRUE, 'T', 'F'), ''');') from OKM_ROLE; |
</source> | </source> | ||
Revision as of 12:54, 31 August 2011
 |
This migration process is under beta state and the SQL sentences are generated for MySQL. In case of other database may need some changes. |
- Login into Administration > Database query and execute these sentences in order to export users and roles:
SELECT CONCAT('INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES (''', ROL_ID, ', ''', IF(ROL_ACTIVE IS TRUE, 'T', 'F'), ''');') from OKM_ROLE;
- Stop JBoss
- Make a backup!
- Delete $JBOSS_HOME/server/default/lib/hibernate-annotations.jar
- Remove TiffTextExtractor from $JBOSS_HOME/repository.xml and $JBOSS_HOME/repository/workspaces/default/workspace.xml
- Replace $JBOSS_HOME/server/default/deploy/OpenKM.war with the WAR from OpenKM 5.1.8
- Start JBoss again
