https://www.openkm.com/wiki/index.php?title=Migration_from_3.0_to_4.0&feed=atom&action=historyMigration from 3.0 to 4.0 - Revision history2024-03-28T18:10:45ZRevision history for this page on the wikiMediaWiki 1.27.3https://www.openkm.com/wiki/index.php?title=Migration_from_3.0_to_4.0&diff=3618&oldid=prevPavila at 09:20, 14 February 20112011-02-14T09:20:39Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='en'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 09:20, 14 February 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l5" >Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>And will show the parameters needed:</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>And will show the parameters needed:</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryOldConfig''': Path to the old repository configuration file. This is the ''$OLD_JBOSS_HOME/repository.xml'' file by default. Perhaps is different if you changes the '''repository.config''' property in OpenKM.cfg file.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryOldConfig''': Path to the old repository configuration file. This is the ''$OLD_JBOSS_HOME/repository.xml'' file by default. Perhaps is different if you changes the '''repository.config''' property in <ins class="diffchange diffchange-inline">[[</ins>OpenKM.cfg<ins class="diffchange diffchange-inline">]] </ins>file.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryOldHome''': Path to the old repository directory. This is the ''$OLD_JBOSS_HOME/repository'' directory by default. Perhaps is different if you changes the '''repository.home''' property in [[OpenKM.cfg]] file.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryOldHome''': Path to the old repository directory. This is the ''$OLD_JBOSS_HOME/repository'' directory by default. Perhaps is different if you changes the '''repository.home''' property in [[OpenKM.cfg]] file.</div></td></tr>
</table>Pavilahttps://www.openkm.com/wiki/index.php?title=Migration_from_3.0_to_4.0&diff=3617&oldid=prevPavila at 09:20, 14 February 20112011-02-14T09:20:22Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='en'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 09:20, 14 February 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7" >Line 7:</td>
<td colspan="2" class="diff-lineno">Line 7:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryOldConfig''': Path to the old repository configuration file. This is the ''$OLD_JBOSS_HOME/repository.xml'' file by default. Perhaps is different if you changes the '''repository.config''' property in OpenKM.cfg file.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryOldConfig''': Path to the old repository configuration file. This is the ''$OLD_JBOSS_HOME/repository.xml'' file by default. Perhaps is different if you changes the '''repository.config''' property in OpenKM.cfg file.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryOldHome''': Path to the old repository directory. This is the ''$OLD_JBOSS_HOME/repository'' directory by default. Perhaps is different if you changes the '''repository.home''' property in OpenKM.cfg file.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryOldHome''': Path to the old repository directory. This is the ''$OLD_JBOSS_HOME/repository'' directory by default. Perhaps is different if you changes the '''repository.home''' property in <ins class="diffchange diffchange-inline">[[</ins>OpenKM.cfg<ins class="diffchange diffchange-inline">]] </ins>file.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryNewConfig''': Path to the new repository configuration. If you downloaded the JBoss + OpenKM bundle, there is a default ''$NEW_JBOSS_HOME/repository.xml'' file.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* '''RepositoryNewConfig''': Path to the new repository configuration. If you downloaded the JBoss + OpenKM bundle, there is a default ''$NEW_JBOSS_HOME/repository.xml'' file.</div></td></tr>
</table>Pavilahttps://www.openkm.com/wiki/index.php?title=Migration_from_3.0_to_4.0&diff=1916&oldid=prevPavila: Created page with 'Download the migration utility called [http://sourceforge.net/projects/openkm/files/4.0/OKMUtils-4.0.jar/download OKMUtils-4.0.jar]. This is a self-contained JAR with all the req…'2010-04-23T07:48:09Z<p>Created page with 'Download the migration utility called [http://sourceforge.net/projects/openkm/files/4.0/OKMUtils-4.0.jar/download OKMUtils-4.0.jar]. This is a self-contained JAR with all the req…'</p>
<p><b>New page</b></p><div>Download the migration utility called [http://sourceforge.net/projects/openkm/files/4.0/OKMUtils-4.0.jar/download OKMUtils-4.0.jar]. This is a self-contained JAR with all the required dependencies. Can be executed from command line as:<br />
<br />
$ java -Xmx512m -jar OKMUtils-4.0.jar<br />
<br />
And will show the parameters needed:<br />
<br />
* '''RepositoryOldConfig''': Path to the old repository configuration file. This is the ''$OLD_JBOSS_HOME/repository.xml'' file by default. Perhaps is different if you changes the '''repository.config''' property in OpenKM.cfg file.<br />
<br />
* '''RepositoryOldHome''': Path to the old repository directory. This is the ''$OLD_JBOSS_HOME/repository'' directory by default. Perhaps is different if you changes the '''repository.home''' property in OpenKM.cfg file.<br />
<br />
* '''RepositoryNewConfig''': Path to the new repository configuration. If you downloaded the JBoss + OpenKM bundle, there is a default ''$NEW_JBOSS_HOME/repository.xml'' file.<br />
<br />
* '''RepositoryNewHome''': Path to the new repository directory. This is the ''$NEW_JBOSS_HOME/repository'' directory by default. This folder actually does not exists and will be created in the migration process.<br />
<br />
These are the required steps to make a migration.<br />
<br />
* Download the new OpenKM version and uncompress it.<br />
<br />
* Stop the actual JBoss instance and make a backup.<br />
<br />
* Modify the ''$NEW_JBOSS_HOME/server/default/conf/login-config.xml'' according to the old settings. If you didn't change it in the actual installation, this step is not required.<br />
<br />
* Modify the ''$NEW_JBOSS_HOME/server/default/deploy/openkm-ds.xml'' according to the old settings. If you didn't change it in the actual installation, this step is not required.<br />
<br />
* You need some changes in you database tables:<br />
** Change role ''UserRol'' to ''UserRole'' (tables '''roles''' and '''user_role''')<br />
** Change role ''AdminRol'' to ''AdminRole'' (tables '''roles''' and '''user_role''')<br />
** Table '''users''' has a new field ''usr_name VARCHAR(64)''<br />
<br />
<source lang="sql"><br />
ALTER TABLE users ADD COLUMN usr_name varchar(64) NULL;<br />
</source><br />
<br />
** Remember that in this OpenKM release, the defaul setting are for MD5 password encoded, so you have to make this changes.<br />
** Add this new table: <br />
<br />
<source lang="sql"><br />
CREATE TABLE mail_accounts(ma_id IDENTITY, ma_user VARCHAR(32), ma_mhost VARCHAR(32), ma_muser VARCHAR(32), ma_mpass VARCHAR(32), ma_mfolder VARCHAR(32), ma_active BOOLEAN, PRIMARY KEY(ma_id));<br />
CREATE TABLE twitter_accounts(ta_id IDENTITY, ta_user VARCHAR(32), ta_tuser VARCHAR(32), ta_active BOOLEAN, PRIMARY KEY(ta_id));<br />
</source><br />
<br />
* Modify the ''$NEW_JBOSS_HOME/server/default/deploy/mail-service.xml'' according to the old settings.<br />
<br />
* Modify the ''$NEW_JBOSS_HOME/OpenKM.cfg'' according to the old settings. Remember to check the changelog because some properties can be deprecated.<br />
<br />
* Perhaps you need to copy the JDBC library from ''$OLD_JBOSS_HOME/server/default/lib'' to ''$NEW_JBOSS_HOME/server/default/lib''. You can skip this step for a default OpenKM installation.<br />
<br />
* Run the migration utility.<br />
<br />
* Start the new JBoss.<br />
<br />
[[Category: Migration Guide]]</div>Pavila