 |
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
