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.
- 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.
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.
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.
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.
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.
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.
Back to Menu