Choosing Remote Web Logical Servers for phpMyAdmin/phpPgAdmin Frontends

Parallels H-Sphere logical web server is by default installed on a physical box together with PostgreSQL/MySQL logical servers, thus phpMyAdmin and phpPgAdmin frontends use Apache on the same server.

It is possible to choose an alternative remote Web logical server for phpMyAdmin and phpPgAdmin. Now you can configure one phpMyAdmin/phpPgAdmin frontend to manage multiple database servers.

To choose remote Web servers for phpMyAdmin:

1. Login as cpanel user and set the following property in ~cpanel/shiva/psoft_config/hsphere.properties:

   EXTERNAL_SERVICE_USAGE = TRUE

   Then, restart Parallels H-Sphere to apply changes.

   Important: If EXTERNAL_SERVICE_USAGE is not set or is not TRUE, you will not be able to choose an external Web server for phpMyAdmin!

2. In admin CP, go to E.Manager -> Servers -> L.Servers, proceed to settings for this MySQL logical server, and Choose Unix Hosting server for phpMyAdmin under Additional Options.
3. Login to CP server as root, download and run the Parallels H-Sphere 3.0 RC 4+ updater with the hspackages reconfig option:

   hspackages reconfig=frontend

   Note: Regular Parallels H-Sphere update to 3.0 RC 4 and up automatically includes the reconfig option. However, for best performance we recommend running Parallels H-Sphere updater with this option separately.

4. To move phpMyAdmin content to respective remote Web logical server location, run the following script on the source box:

   /hsphere/pkg/scripts/uprocedures/dbs_content -h

   Usage: dbs_content [ -h ] -d dbtype [ -i ip ] [ -p password ]

   dbtype: horde or spamassassin or phpmyadmin

   ip: this option is required only in the case, if redefinition took place from current external MySQL server to another one or MySQL service, located on the corresponding mail logical server.

   password: this option is required only in the case, if redefinition took place from current external MySQL server to MySQL service, located on the corresponding mail logical server.

To choose remote Web servers for phpPgAdmin:

1. Login as cpanel user and set the following property in ~cpanel/shiva/psoft_config/hsphere.properties:

   EXTERNAL_SERVICE_USAGE = TRUE

   Then, restart Parallels H-Sphere to apply changes.

   Important: If EXTERNAL_SERVICE_USAGE is not set or is not TRUE, you won't be able to choose an external Web server for phpPgAdmin!

2. In admin CP, go to E.Manager -> Servers -> L.Servers, proceed to settings for this PostgreSQL logical server, and Choose Unix Hosting server for phpPgAdmin under Additional Options.

   Note: For security reasons, it is not possible to choose Web logical server on the CP box for phpPgAdmin.

3. Login to CP server as root, download and run the Parallels H-Sphere 3.0 RC 4+ updater with the hspackages reconfig option:

   hspackages reconfig=frontend

   Note: Regular Parallels H-Sphere update to 3.0 RC 4 and up automatically includes the reconfig option. However, for best performance we recommend running Parallels H-Sphere updater with this option separately.