About This Document 3. About the Migration Process 4. Requirements and Prerequisites 5. Requirements... 5 Prerequisites... 5

Contents

About This Document

3

About the Migration Process

4

Requirements and Prerequisites

5

Requirements ... 5 Prerequisites ... 5

Installing the Migration Tool and Enabling Migration

8

On Linux Servers ... 9 On Windows Servers ... 10

Configuring the Page to Be Shown Instead of the Administrative Panel

12

Completing the Migration

13

Frequently Asked Questions

14

This document is intended for hosting service providers who want to transfer websites from standalone SiteBuilder 4.5 installations to Parallels Presence Builder 11.5

Standalone or Parallels Presence Builder 11.5 for Parallels Automation.

C

1

Migration is the transfer of websites and other related data from one (source) hosting platform to another (destination) platform.

In migration from SiteBuilder 4.5 Standalone to Presence Builder 11.5, websites are gradually transferred, one at a time:

After website owners log in to the SiteBuilder 4.5 wizard on the source server, they are redirected to the new Presence Builder 11.5 editor, and their website content is moved to the destination server along with hosting publishing settings.

The migration tool, which enables the migration process, modifies an existing SiteBuilder 4.5 installation so that it acts as a proxy between website owners visiting the SiteBuilder 4.5 wizard and Presence Builder 11.5. For this reason, the existing SiteBuilder 4.5 installation should not be removed until all sites are migrated and your hosting management software has been reintegrated with Presence Builder 11.5. Migration to Presence Builder 11.5 does not require you to purchase a new license key provided that the total number of websites allowed by the license is not exceeded. During the migration process, a new license key is automatically issued and installed in Presence Builder 11.5.

Note: If a custom locale or a locale that is not supported in PPB 11.5 was installed in

SiteBuilder 4.5, then after migration, PPB 11.5 will use the default American English locale. The contents of the migrated sites will not be affected: their language will not be changed.

C

2

Requirements

Source servers supported for migration: Microsoft Windows- and Linux-based servers running Parallels SiteBuilder 4.5. About 4 gigabytes of free disk space should be available on the source server.

Destination servers supported for migration: Linux-based servers running Parallels Presence Builder 11.5 Standalone or Parallels Presence Builder 11.5 for Parallels Automation.

Note: Clustered SiteBuilder installations on Linux are not supported. For assistance

with migrating from clustered installations, please contact a Parallels technical support representative.

Prerequisites

Before starting migration, you need to do the following.

On Windows Systems

1. Make the following changes to the Windows servers where sites are hosted: a Install PHP as described at http://www.php.net/manual/en/install.windows.php.

b Configure IIS to support PHP as described at

http://www.php.net/manual/en/install.windows.iis6.php or

http://www.php.net/manual/en/install.windows.iis7.php.

2. (Optional step.) Back up website data on the source server. The main items that

you need to back up: MS SQL Server database called sitebuilder and the contents of the directory C:\Program Files\Sitebuilder\Sites.

3. If you plan to use Parallels Presence Builder Standalone:

a Install Presence Builder 11.5 Standalone on a separate server.

b Set the administrator’s password for Presence Builder 11.5 by issuing the

command sb_config --sb_passwd <password>.

4. If you plan to use Parallels Presence Builder for Parallels Automation:

a Install Parallels Automation and Presence Builder for Parallels Automation.

C

3

6 Requirements and Prerequisites

b Find out the administrator's password and the URL to the Presence Builder

installation:

 In PA, click Hosting CP to open the control panel.

 Go to Applications tab > Parallels Automation for Web Presence > General tab.  Copy the URL at the bottom of the screen.

 Go to the Settings tab.

 Copy the password shown in the field Password to Parallels Presence Builder for

PA.

5. Make sure that the SiteBuilder 4.5 server and websites published on it can be

properly resolved from the server on which Presence Builder 11.5 is installed.

On Linux Systems

1. If you plan to use Parallels Presence Builder Standalone:

a Install Presence Builder 11.5 Standalone on a separate server.

b Set the administrator’s password for Presence Builder 11.5 by issuing the

command sb_config --sb_passwd <password>.

2. If you plan to use Parallels Presence Builder for Parallels Automation:

a Install Parallels Automation and Presence Builder for Parallels Automation. b Find out the administrator's password and the URL to the Presence Builder

installation:

 In PA, click Hosting CP to open the control panel.

 Go to Applications tab > Parallels Automation for Web Presence > General tab.  Copy the URL at the bottom of the screen.

 Go to the Settings tab.

 Copy the password shown in the field Password to Parallels Presence Builder for

PA.

3. (Optional step.) Back up website data on the source server. The main items that

you need to back up: MySQL database called sitebuilder3 and the contents of the directory /usr/local/sitebuilder/htdocs/sites or

/opt/sitebuilder/htdocs/sites.

4. On the source server, make changes to the product's configuration file. On

Debian-based systems, open for editing /opt/sitebuilder/config. On RPM-Debian-based systems, open /usr/local/sitebuilder/config.

a Add the following lines: [migrator]

wpb_url = https://sitebuilder.<Presence Builder 11 host name>/

wpb_password = <password to Presence Builder 11>

b If the editor's user interface is accessed at a non-default URL (other than

Requirements and Prerequisites 7

wpb_ui_url = http://<Presence Builder 11 host name>/ 5. Make sure that the SiteBuilder 4.5 server and websites published on it can be

The installation steps vary depending on the operating system running on the source server.

In this chapter:

On Linux Servers ... 9 On Windows Servers ... 10

C

4

Installing the Migration Tool and Enabling Migration 9

On Linux Servers

 To install the migration tool on Linux servers:

1. Log in as root over SSH to the source SiteBuilder 4.5 server.

2. Obtain and install the migration tool suitable for your operating system

by issuing the following command:

 On Debian Linux systems:

cd /root && wget -O sb45_migrator_latest.sh

http://download1.parallels.com/WPB/Migrators/sitebuilder_4.5_ migrator_deb_latest.sh && sh ./sb45_migrator_latest.sh

 On RPM package-based Linux systems:

cd /root && wget -O sb45_migrator_latest.sh

http://download1.parallels.com/WPB/Migrators/sitebuilder_4.5_ migrator_rpms_latest.sh && sh ./sb45_migrator_latest.sh

 On FreeBSD systems:

cd /root && fetch -M -o sb45_migrator_latest.sh

http://download1.parallels.com/WPB/Migrators/sitebuilder_4.5_ migrator_packs_latest.sh && sh ./sb45_migrator_latest.sh

After the migration tool is installed, the migration of websites will be performed after their owners log in to the SiteBuilder 4.5 wizard on the source server. For this reason, if you want to speed up the migration, advise all your customers to visit the editor as soon as possible. You can learn about the migration progress by issuing SQL queries, as described in Frequently Asked Questions (on page 14).

Users who previously had access to the Administrative Panel will no longer be able to log in to it. Instead of the Administrative Panel, a page with the message

“Administrative Panel is disabled” will be shown.

10 Installing the Migration Tool and Enabling Migration

On Windows Servers

 To install the migration tool on Windows servers:

1. Log in to the source SiteBuilder 4.5 server under an administrator's

user account.

2. Download the installation file that suits your operating system and run

it:

 On 32-bit systems:

http://download1.parallels.com/WPB/Migrators/sitebuilder-4.5.0_build131107.292_winx86.exe

 On 64-bit systems:

http://download1.parallels.com/WPB/Migrators/sitebuilder-4.5.0_build131107.292_winx64.exe

3. This will start an installation wizard.

4. In the wizard, specify the URL where Presence Builder 11.5 is installed

and the administrator's password to Presence Builder 11.5.

After the migration tool is installed, the migration of websites will be performed after their owners log in to the SiteBuilder 4.5 wizard on the source server. For this reason, if you want to speed up the migration, advise all your customers to visit the editor as soon as possible. You can learn about the migration progress by issuing SQL queries, as described in Frequently Asked Questions (on page 14).

Users who previously had access to the Administrative Panel will no longer be able to log in to it. Instead of the Administrative Panel, a page with the message

“Administrative Panel is disabled” will be shown. You can prepare a custom web page and configure SiteBuilder 4.5 to show it instead of the default page. See the following chapter for instructions on how to do it.

Note: Administrators will no longer be able to access the Administrative Panel by the

link on the Desktop.

If you want to cancel a migration, specify another destination server or administrator's password after a migration has started, you can do it by means of the command-line utility SBConfigure.exe, which is located in C:\Program

Files\Sitebuilder\Utils\.

To cancel a migration, run C:\Program

Files\Sitebuilder\Utils\SBConfigure.exe setmigrationparams --enable-migration=false

Installing the Migration Tool and Enabling Migration 11 To specify another password of the Presence Builder 11.5 administrator, run

C:\Program Files\Sitebuilder\Utils\SBConfigure.exe

To use a custom webpage instead of the default page with the message “Administrative Panel is disabled”, do the following.

On Linux systems, make changes to the SiteBuilder 4.5 configuration file:

1. On Debian-based systems, open for editing

/opt/sitebuilder/config. On RPM package-based systems, open

/usr/local/sitebuilder/config.

2. In the [migrator] section of the file, add the following line:

admin_panel_stub_url = http://<your domain name here>/<your file name here>.html

On Windows systems, run the following command:

C:\Program Files\Sitebuilder\Utils\SBConfigure.exe setmigrationparams --admin-url=<URL of the webpage>

C

5

After all websites have been migrated, you can reintegrate your hosting management software with the new Presence Builder installation: set the new URLs for access to Presence Builder and make other changes in your integration scripts. To learn about the Presence Builder's REST API, refer to the Presence Builder Standalone Installation and Administration Guide:

 Online version -

http://download1.parallels.com/WPB/Doc/11.5/en-US/online/presence-builder-standalone-installation-administration-guide/index.htm

 PDF -

http://download1.parallels.com/WPB/Doc/11.5/en-US/pdf/presence-builder-11.5-standalone-installation-administration-guide.pdf

After completing the integration with the new Presence Builder installation, you can remove the old SiteBuilder 4.5 installation.

C

6

Q: How can I track the migration progress?

A: You can find out the total number of existing sites and the number of migrated sites

by issuing the following SQL queries respectively: On Linux installations:

SELECT COUNT(*) FROM site WHERE is_old=1;

SELECT COUNT(*) FROM migrator_data LEFT JOIN site ON migrator_data.site_id=site.id WHERE site.is_old=1; On Windows installations:

SELECT COUNT(*) FROM SiteEntity WHERE WasWpbMigrationOff=1 SELECT COUNT(*) FROM WpbMigratorEntity LEFT JOIN SiteEntity ON WpbMigratorEntity.SiteId=SiteEntity.Id WHERE

SiteEntity.WasWpbMigrationOff=1

Q: How do I know whether the migration tool is installed and is operating properly? A: On Linux systems, if you cannot log in to the Administrative Panel of SiteBuilder 4.5,

or if there is the file /usr/local/sitebuilder/.migrator.revision on the file system, then it means that the migration tool is installed and is running.

C

7