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:

    <db-endpoint>
      <dbserver>10.39.94.114</dbserver>
      <database>web_cluster_db74</database>
      <username>web_cluster_rouser74</username>
      <password>hDFlzj7qSerzf7AS</password>
     </db-endpoint>
    

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

  • IP address of CDB server - 10.39.94.114
  • 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.

Internal content