Preparing the RDE Service Database

Important: You must create the RDE service database before deploying the RDE service.

The RDE service database stores information about what. You can deploy the RDE service database in one of these ways:

  • Scenario 1. Deploy the database to the Operations database node.
  • Scenario 2. Deploy the database using the PostgreSQL database service in Azure.

Scenario 1. Deploying the RDE Service Database to the Operations Database Node

To deploy the RDE service database to the Operations database node:

  1. Connect to the Operations database node under the root user.
  2. Create the create_db.sql script file by running this command:

    cat << EOF > /tmp/create_db.sql
    DO
    \$\$
    BEGIN
    	IF NOT EXISTS (SELECT FROM pg_catalog.pg_roles WHERE rolname = 'mservice_login') THEN
    	   CREATE ROLE mservice_login LOGIN;
    	   RAISE NOTICE 'Group mservice_login created';
    	END IF;
    END
    \$\$;
    CREATE USER :name PASSWORD :'password';
    \echo User :name created
    GRANT mservice_login to :name;
    \echo User is a member of mservice_login group
    GRANT :name to CURRENT_USER;
    CREATE DATABASE a8n_:name OWNER :name;
    \echo Database a8n_:name created
    REVOKE :name from CURRENT_USER;
    SELECT pg_reload_conf();
    EOF
  3. Add the connect permissions for all the mservice_login group members by adding the following lines to the /var/lib/pgsql/<PostgreSQL_Version>/data/pg_hba.conf configuration file:

    host    all     mservice_login      <rde_app_host_ip>/32       reject
    host    all     +mservice_login      <rde_app_host_ip>/32       md5

    where:

  4. Create the database by running this command:

    su - postgres -c "psql -f /tmp/create_db.sql --set ON_ERROR_STOP=on -q -o /dev/null -v name='rde' -v password='<db_user_password>'"

    where:

    • <db_user_password> is the password of the RDE service database user.

RDE Service Database Connection Parameters

To connect to the RDE service database, provide the following parameters:

Parameter Value
BackNet IP address of the database host The BackNet IP of the Operations database host
Database a8n_rde
Database user (name) rde
Password of the database user (password) <db_user_password> is the password you specified in step 4

Scenario 2. Deploying the RDE Service Database Using the PostgreSQL Database Service in Azure

Prerequisites

Deployment Procedure

To deploy the RDE service database using the PostgreSQL database service in Azure:

  1. Connect to the Operations management node under the root user.

  2. Create the create_db.sql script file by running this command:

    cat << EOF > /tmp/create_db.sql
    DO
    \$\$
    BEGIN
    	IF NOT EXISTS (SELECT FROM pg_catalog.pg_roles WHERE rolname = 'mservice_login') THEN
    	   CREATE ROLE mservice_login LOGIN;
    	   RAISE NOTICE 'Group mservice_login created';
    	END IF;
    END
    \$\$;
    CREATE USER :name PASSWORD :'password';
    \echo User :name created
    GRANT mservice_login to :name;
    \echo User is a member of mservice_login group
    GRANT :name to CURRENT_USER;
    CREATE DATABASE a8n_:name OWNER :name;
    \echo Database a8n_:name created
    REVOKE :name from CURRENT_USER;
    SELECT pg_reload_conf();
    EOF
  3. Create the database by running this command:

    psql \
    -h <db_postgresql_service_name_in_azure> \
    -U <db_admin_login> \
    -d postgres \
    -f /tmp/create_db.sql \
    --set ON_ERROR_STOP=on \
    -v name='rde' \
    -v password='<db_user_password>'

    where:

    • <db_postgresql_service_name_in_azure> is the PostgreSQL database service name in Azure (provided by Azure as a result of the PostgreSQL database service configuration).
    • <db_admin_login> is the admin log-in name to the PostgreSQL database service in Azure (provided by Azure as a result of the PostgreSQL database service configuration).

RDE Service Database Connection Parameters

To connect to the RDE service database in Azure, provide the following parameters:

Parameter Value
The PostgreSQL database service name in Azure <db_postgresql_service_name_in_azure>, provided by Azure as a result of the PostgreSQL database service configuration
Database a8n_rde
Database user (name) rde
Password of the database user (password) <db_user_password> is the password you specified in step 3