Article ID: 114333, created on Jul 11, 2012, last review on Nov 22, 2014

  • Applies to:
  • Operations Automation 5.4

Automatic import from KB #114333

In POA-managed Standard Linux Shared Hosting configuration of websites hosted on a server is stored in separate Apache configuration files located on file system in webspace folder, like /usr/local/pem/vhosts/WEBSPACE_ID/webspace/conf/vhost.conf, where WEBSPACE_ID is the ID of customer's webspace, e.g. 100001.

In Linux Shared Hosting NG (for POA versions 5.4 and below) configuration of all NG clusters, websites and users is stored in the database on the special Configuration Database (CDB) server(s). In this implementation PostgreSQL is used as database engine. The Configuration Database server(s) is (are) the part of NG cluster. POA supports multiple CDB servers per NG cluster.

Two users are being created by POA in PostgreSQL on CDB server:

  • web_cluster_user<cluster-id> - used to replicate data from POA Management Node
  • web_cluster_rouser<cluster-id> - read only user used by NG Caching Service to read information from database Credentials for web_cluster_rouser are stored at each webserver in the /etc/h2e_shstg.conf file in the <db-endpoint> section:


    In the example above the following information about CDB server is provided:

  • IP address of CDB server -
  • Database name - web_cluster_db74
  • User name - web_cluster_rouser74
  • Password - hDFlzj7qSerzf7AS
  • Credentials for both users are stored in POA database in the apache_h2e_db table:

    plesk=> select * from apache_h2e_db;
     -[ RECORD 1 ]-+---------------------
     db_host_id    | 43
     cluster_id    | 74
     state         | e
     db_name       | web_cluster_db74
     db_user       | web_cluster_user74
     db_password   | 5d0FL441PFqi7abb
     db_rouser     | web_cluster_rouser74
     db_ropassword | hDFlzj7qSerzf7AS

    Database structure on CDB server is being created by executing PostgreSQL script /usr/local/pem/etc/web_cluster/create_ws_database.sql (located at POA management node) during CDB server registration in POA.

    The v_apache_h2e_websites table on CDB server contains list of current websites with all their properties (which are stored in Apache configuration files in Legacy Linux Shared Hosting).

    Web servers access CDB servers via NG Caching Service in order to get information about users/sites configuration.

    See the main Knowledgebase article #114326 Linux Shared Hosting NG: General Information, Best Practices and Troubleshooting for more information about NG Hosting in Parallels Automation.

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae ac82ce33439a9c1feec4ff4f2f638899 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF