|  | Back to Menu |
Migration from V3.0 to V3.1 (Linux)
This guide describes how to migrate from Denbun POP V3.0P R1.1 to Denbun POP V3.1P R1.0. If you use the lower than V3.0P R1.1, please upgrade it to V3.0P R1.1, and then follow the procedure of this guide.
Note This guide is written for users who have the knowledge about Apache HTTP Server, PostgreSQL, etc.Please refer the appropriate documentation for installation and operation of each product. We use general examples for the installation directory of each Software. It may differ from your environment. Prerequisites This migration procedure assumes that the following environments. - The migration source and destination must be on the same servers. - There is no access to Denbun (* Scheduler is stopped). - Anti-virus Software should be stopped. - The current version of Denbun is V3.0P R1.1 - The administrator for PostgreSQL is "postgres". - Denbun is installed in "/var/www/cgi-bin/dnpwml".
  1. Preparation 1-1. Take Backup Backup all the modules and database of Denbun. Please refer here about backup. 2. Upgrade Denbun 2-1. Upgrade to Denbun POP V3.1 R1.0 Download Denbun POP V3.1 R1.0 Update Module and install it. To upgrade Denbun, please refer this guide. Download Update Module 3. Migrate Mail Data After upgrading to Denbun POP V3.1, migrate the mail data. 3-1. Switch to root user If you are not logged in as root, use su command to switch to root user.
  $ su - Password:
  3-2. Set Permission setid and setgid to [conv3110] in the installation directory of Denbun. This setting is for migrating mail data with the rights of the owner of [conv3110].
  # cd /var/www/cgi-bin/dnpwml # chmod ug+s conv3110
  3-3. Migrate Mail Data Run [conv3110] with the following parameters. Parameters: -h [The full path name of Denbun installation directory] -a -m 1
  # ./conv3110 -h /var/www/cgi-bin/dnpwml -a -m 1
  When you run the program, the following confimation message is displayed. Enter "y" if you want to continue.
  * Please backup the database of Denbun. Start the conversion? (y/n) :
  When the migrating mail data is finished, a log file "conv3110.log" is created in "[Denbun installation directory]/conv3110log". Please make sure that there is no error. * If you find any error, please do not perform "Delete Source Data". * If you find the following message in the log file, the migration was successfully terminated.
  YY/MM/DD hh:mm:ss == Convert Start. == YY/MM/DD hh:mm:ss UserID:2 Start. YY/MM/DD hh:mm:ss UserID:2 Succeeded. YY/MM/DD hh:mm:ss UserID:3 Start. YY/MM/DD hh:mm:ss UserID:3 Succeeded. YY/MM/DD hh:mm:ss UserID:4 Start. YY/MM/DD hh:mm:ss UserID:4 Succeeded. . . (for number of users) . YY/MM/DD hh:mm:ss == Convert Completed. ==
  * If you find other messages, please see the log. <Example of Error Log>
  YY/MM/DD hh:mm:ss error:-110, [:567], Invalid UserID. No applicable data exist. YY/MM/DD hh:mm:ss UserID:9999 Failed.
  4. Confirm Migrated Data 4-1. Confirm Migrated Data Access to http://server name or IP address/cgi-bin/dnpwml/dnpwmljs.cgi? from a browser and login by each user, make sure all messages are displayed. 5. Delete Source Data Delete unnecessary information form PostgreSQL. * Please do not perform this operation if data for all the users has not been migrated. Migrating data cannot be done. 5-1. Switch to root user If you are not logged in as root, use su command to switch to root user.
  $ su - Password:
  5-2. Set Permission setid and setgid to [conv3110cleanup] in the installation directory of Denbun. This setting is for migrating mail data with the rights of the owner of [conv3110cleanup].
  # cd /var/www/cgi-bin/dnpwml # chmod ug+s conv3110cleanup
  5-3. Delete Source Data Run [conv3110cleanup] with the following parameters. Parameters: -h [The full path name of Denbun installation directory] -dbusr [Administrator of PostgreSQL] -dbpwd [Password for Administrator of PostgreSQL]
  # ./conv3110cleanup -h /var/www/cgi-bin/dnpwml -dbusr postgres -dbpwd postgres
  When you run the program, the following confimation message is displayed. Enter "y" if you want to continue.
  * Please do not perform this operation if data for all the users has not been migrated. Migrating data cannot be done. Start the cleanup? (y/n) :
  When the deleting mail data is finished, a log file "conv3110cleanup.log" is created in "[Denbun installation directory]/conv3110log". Please make sure that there is no error. * If you find the following message in the log file, deleting data was successfully terminated.
  YY/MM/DD hh:mm:ss == Cleanup Start. == YY/MM/DD hh:mm:ss Succeeded. drop configuration [denbun]. YY/MM/DD hh:mm:ss Succeeded. drop configuration [japanese]. YY/MM/DD hh:mm:ss Succeeded. drop parser [japanese]. YY/MM/DD hh:mm:ss Succeeded. drop dictionary [japanese_stem]. YY/MM/DD hh:mm:ss Succeeded. drop template [mecab]. YY/MM/DD hh:mm:ss Succeeded. drop function [ts_ja_start]. YY/MM/DD hh:mm:ss Succeeded. drop function [ts_ja_gettoken]. YY/MM/DD hh:mm:ss Succeeded. drop function [ts_ja_end]. YY/MM/DD hh:mm:ss Succeeded. drop function [ts_ja_lexize]. YY/MM/DD hh:mm:ss Succeeded. drop function [ja_analyze]. YY/MM/DD hh:mm:ss Succeeded. drop function [ja_normalize]. YY/MM/DD hh:mm:ss Succeeded. drop function [ja_wakachi]. YY/MM/DD hh:mm:ss Succeeded. drop function [web_query]. YY/MM/DD hh:mm:ss Succeeded. drop function [furigana]. YY/MM/DD hh:mm:ss Succeeded. drop function [hiragana]. YY/MM/DD hh:mm:ss Succeeded. drop function [katakana]. YY/MM/DD hh:mm:ss Succeeded. drop table [tmpr_wml_mailfile000]. YY/MM/DD hh:mm:ss Succeeded. drop table [tmpr_wml_mailtext000]. YY/MM/DD hh:mm:ss Succeeded. drop table [tmpr_wml_mailinfo000]. YY/MM/DD hh:mm:ss Succeeded. drop function [wml_lounlink]. YY/MM/DD hh:mm:ss Succeeded. delete [pg_largeobject]. YY/MM/DD hh:mm:ss == Cleanup Completed. ==
  6. Reclaim Unnecessary Space in PostgreSQL Reclaim unnecessary space that was created by "5. Delete Source Data" and rebuild indexes to increase available disk space. 6-1. Switch to Administrator of PostgreSQL Use su command to switch to the root user.
  # su - postgres
  6-2. Reclaim Unnecessary Space in PostgreSQL Execute the following PostgreSQL maintenance command
  $ vacuumdb -f -v -z -d dnpwmldb -U postgres $ reindexdb -d dnpwmldb -U postgres
  7. Create Indexes for Full Text Search Create Indexes for Full Text Search. * This operation is not mandatory. However if you do not perform it, the following limitations are applied. - Cannot find past messages by the search function. - Cannot filter past messages by the filter function. 7-1. Switch to root user If you are not logged in as root, use su command to switch to root user.
  $ su - Password:
  7-2. Set Permission setid and setgid to [conv3110] in the installation directory of Denbun. This setting is for migrating mail data with the rights of the owner of [conv3110].
  # cd /var/www/cgi-bin/dnpwml # chmod ug+s conv3110
  7-3. Create Indexes for Full Text Search Run [conv3110] with the following parameters. Parameters: -h [The full path name of Denbun installation directory] -a -m 2
  # ./conv3110 -h /var/www/cgi-bin/dnpwml -a -m 2
  When you run the program, the following confimation message is displayed. Enter "y" if you want to continue.
  Start creating the index? (y/n) :
  When the creating indexes is finished, a log file "conv3110.log" is created in "[Denbun installation directory]/conv3110log". Please make sure that there is no error. * If you find the following message in the log file, creating indexes was successfully terminated.
  YY/MM/DD hh:mm:ss == Convert Start. == YY/MM/DD hh:mm:ss UserID:2 Start. YY/MM/DD hh:mm:ss UserID:2 Succeeded. YY/MM/DD hh:mm:ss UserID:3 Start. YY/MM/DD hh:mm:ss UserID:3 Succeeded. YY/MM/DD hh:mm:ss UserID:4 Start. YY/MM/DD hh:mm:ss UserID:4 Succeeded. . . (for number of users) . YY/MM/DD hh:mm:ss == Convert Completed. ==
  * If you find other messages, please see the log. <Example of Error Log>
  YY/MM/DD hh:mm:ss error:-110, [:567], Invalid UserID. No applicable data exist. YY/MM/DD hh:mm:ss UserID:9999 Failed.
  8. Delete Unnecessary Modules 8-1. Switch to root user If you are not logged in as root, use su command to switch to root user.
  $ su - Password:
  8-2. Uninstall the Full Japanese Text Search Module (textsearch-ja) Uninstall textsearch-ja which is not necessary in V3.1.
  # cd /usr/local/src/postgresql-8.3.5/contrib/textsearch_ja/ # gmake uninstall . . (Omitted) . # cd ../ # \rm -r textsearch_ja/
  8-3. Uninstall MeCab Dictionary Uninstall MeCab dictionary which is not necessary in V3.1.
  # cd /usr/local/src/mecab-ipadic-2.7.0-20070801/ # gmake uninstall . . (Omitted) . # cd ../ # \rm -r mecab-ipadic-2.7.0-20070801/
  8-4. Uninstall MeCab Uninstall MeCab which is not necessary in V3.1.
  # \rm /usr/lib/libmecab.so # \rm /usr/lib/libmecab.so.1 # cd /usr/local/src/mecab-0.97/ # gmake uninstall . . (Omitted) . # cd ../ # \rm -r mecab-0.97/
  8-5. Delete Migration Tools When you finish the migration, the migration tools and logs are unnecessary. Please delete them. The log files should be back up if necessary. Delete the following directories and files. /var/www/cgi-bin/dnpwml/conv3110 /var/www/cgi-bin/dnpwml/conv3110cleanup /var/www/cgi-bin/dnpwml/conv3110log (directory)
  # rm -f /var/www/cgi-bin/dnpwml/conv3110 # rm -f /var/www/cgi-bin/dnpwml/conv3110cleanup # rm -rf /var/www/cgi-bin/dnpwml/conv3110log
9. Complete The migration from Denbun POP V3.0 to Denbun POP V3.1 completed.
| Copyright (C) NEOJAPAN Inc. All Rights Reserved.