Choosing Remote Web Logical Servers for phpMyAdmin/phpPgAdmin Frontends

Last modified: 27 Dec 2007

WARNING: This documentation covers Parallels H-Sphere versions up to 3.1. For the latest up-to-date Parallels H-Sphere documentation, please proceed to the official Parallels site.

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.

In H-Sphere 3.0 RC 4 and up it is made 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 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 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 H-Sphere 3.0 RC 4+ updater with the hspackages reconfig option:

   hspackages reconfig=frontend

Note: Regular H-Sphere update to 3.0 RC 4 and up automatically includes the reconfig option. However, for best performance we recommend running 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 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 H-Sphere 3.0 RC 4+ updater with the hspackages reconfig option:

   hspackages reconfig=frontend

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