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
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> <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 -
- Database name -
- User name -
- Password -
Credentials for both users are stored in POA database in the
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.
v_apache_h2e_websitestable 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.