Difference between revisions of "Migration from 5.0.4 to 5.1.8"

From OpenKM Documentation
Jump to: navigation, search
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''' > '''Database query''' and execute these sentences in order to export users and roles:
+
== OpenKM 5.0 stuff ==
 +
* Make a backup!
 +
* Log into OpenKM 5.0 and go to '''Administration''' > '''Database query''' and execute these sentences in order to export users and roles:
  
 
<source lang="sql">
 
<source lang="sql">
Line 11: Line 13:
 
</source>
 
</source>
  
−
* Stop JBoss
+
* Copy the output of these sentences to a secure place.
−
* Make a backup!
+
* Stop JBoss.
−
* Delete $JBOSS_HOME/server/default/lib/hibernate-annotations.jar
+
 
−
* Remove TiffTextExtractor from $JBOSS_HOME/repository.xml and $JBOSS_HOME/repository/workspaces/default/workspace.xml
+
== OpenKM 5.1 stuff ==
−
* Replace $JBOSS_HOME/server/default/deploy/OpenKM.war with the WAR from OpenKM 5.1.8
+
* Start JBoss.
−
* Start JBoss again
+
* Copy or move the $JBOSS_50_HOME/repository.xml file and $JBOSS_50_HOME/repository directory to $JBOSS_51_HOME
 +
* Start JBoss.
 +
* Log into OpenKM 5.1 and go to '''Administration''' > '''Database query''' and execute the output of the previous stored SQL sentences.
 +
* Now your users and roles from the old OpenKM 5.0.4 has been restored in OpenKM 5.1.8

Revision as of 14:06, 31 August 2011


Nota advertencia.png This migration process is under beta state and the SQL sentences are generated for MySQL. In case of other database may need some changes.

OpenKM 5.0 stuff

  • Make a backup!
  • Log into OpenKM 5.0 and go to Administration > Database query and execute these sentences in order to export users and roles:
SELECT CONCAT('INSERT INTO OKM_USER (USR_ID, USR_NAME, USR_PASSWORD, USR_EMAIL, USR_ACTIVE) VALUES (''', USR_ID, ''', ''', USR_NAME, ''', ''', USR_PASSWORD, ''', ''', USR_EMAIL, ''', ''', IF(USR_ACTIVE IS TRUE,'T', 'F'), ''');') from OKM_USER;
SELECT CONCAT('INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES (''', ROL_ID, ''', ''', IF(ROL_ACTIVE IS TRUE, 'T', 'F'), ''');') from OKM_ROLE;
SELECT CONCAT('INSERT INTO OKM_USER_ROLE (UR_USER, UR_ROLE) VALUES (''', UR_USER, ''', ''', UR_ROLE, ''');') from OKM_USER_ROLE;
  • Copy the output of these sentences to a secure place.
  • Stop JBoss.

OpenKM 5.1 stuff

  • Start JBoss.
  • Copy or move the $JBOSS_50_HOME/repository.xml file and $JBOSS_50_HOME/repository directory to $JBOSS_51_HOME
  • Start JBoss.
  • Log into OpenKM 5.1 and go to Administration > Database query and execute the output of the previous stored SQL sentences.
  • Now your users and roles from the old OpenKM 5.0.4 has been restored in OpenKM 5.1.8
Retrieved from "https://www.openkm.com/wiki/index.php?title=Migration_from_5.0.4_to_5.1.8&oldid=4919"