Denbun POP version Manual
User's Manual | Administrator's Manual | Installation Guide | Initial Settings Guide
Back to Menu
 

Migration from V3.0 to V3.1 (Windows)

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 Windows, 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".
- PostgreSQL8.3 is installed in "C:\Program Files\PostgreSQL\8.3".
- Denbun is installed in "C:\Inetpub\Scripts\dnpwml".


1. Preparation
1-1. Confirm Logon User
If you are not logged on as an administrator, please log off and log on as administrator.

1-2. Backup Data
Backup all the modules and database of Denbun.
Please refer here about backup.

2. Upgrade Denbun
2-1. Upgrade to Denbun POP V3.1
Download Denbun POP V3.1 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. Migrate Mail Data
Run [conv3110.exe] on the command prompt with the following parameters.

Parameters:
-h [The full path name of Denbun installation directory]
-a
-m 1

> cd "C:\Inetpub\Scripts\dnpwml"
> conv3110.exe -h "C:\Inetpub\Scripts\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/scripts/dnpwml/dnpwmljs.exe? 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. Delete Source Data
Run [conv3110cleanup.exe] on the command prompt with the following parameters.

Parameters:
-h [The full path name of Denbun installation directory]
-dbusr [Administrator of PostgreSQL]
-dbpwd [Password for Administrator of PostgreSQL]

> cd "C:\Inetpub\Scripts\dnpwml"
> conv3110cleanup.exe -h "C:\Inetpub\Scripts\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 source 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
6-1. Reclaim Unnecessary Space in PostgreSQL
Reclaim unnecessary space that was created by "5. Delete Source Data" and rebuild indexes to increase available disk space.

Use PostgreSQL's maintenance commands.
Use the following command.
* Enter the password for the administrator when the prompt is displayed.
> cd "C:\Program Files\PostgreSQL\8.3\bin"
> vacuumdb.exe -f -v -z -d dnpwmldb -U postgres
Password:
> reindexdb.exe -d dnpwmldb -U postgres
Password:

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. Create Indexes for Full Text Search

Run [conv3110.exe] on the command prompt with the following parameters.

Parameters:
-h [The full path name of Denbun installation directory]
-a
-m 2

> cd "C:\Inetpub\Scripts\dnpwml"
> conv3110.exe -h "C:\Inetpub\Scripts\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. Delete Unnecessary Modules
Delete modules which are not necessary in V3.1.
- MeCab
- textsearch-ja

Delete the following directories and files.

  • C:\Program Files\PostgreSQL\8.3\bin\MeCab (folder)
  • C:\Program Files\PostgreSQL\8.3\bin\libmecab.dll
  • C:\Program Files\PostgreSQL\8.3\lib\textsearch_ja.dll

8-2. 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.

  • C:\Inetpub\Scripts\dnpwml\conv3110.exe
  • C:\Inetpub\Scripts\dnpwml\conv3110cleanup.exe
  • C:\Inetpub\Scripts\dnpwml\conv3110log (folder)

9. Complete
The migration from Denbun POP V3.0 to Denbun POP V3.1 completed.




 
Copyright (C) NEOJAPAN Inc. All Rights Reserved.