Creating a Postgres user and enabling SSL connection between Usage Metering and System Manager Postgres database

Last Updated : Aug 01, 2023 |
Prolog information
Usage Metering uses SSL connection to retrieve usage data from the System Manager Postgres database. You can use the smgrmeterchanges.sh script to enable the SSL connection.
The smgrmeterchanges.sh script does the following:
  • Opens port 5432. Usage Metering uses this port to connect to the System Manager Postgres database.
  • Enables SSL connection between Usage Metering and the System Manager Postgres database.
Note:
You must create a new read-only user for the System Manager Postgres database. You must use the access credentials of this user when adding System Manager to the Avaya OneCloud™ Subscription system in the Usage Metering Collector. Usage Metering Collector uses these access credentials to connect to the System Manager Postgres database.
Do not use these access credentials to perform any other operations in System Manager.
  1. On the server where the Usage Metering Collector is installed, navigate to the /opt/Avaya/usage-metering/bin/ location and download the following file:
    ADDITIONAL INFORMATION:
    smgrmeterchanges.sh
  2. Copy the smgrmeterchanges.sh file to any directory on the System Manager server.
  3. Run the following command as a root user at the System Manager CLI command prompt:
    ADDITIONAL INFORMATION:
    sh smgrmeterchanges.sh <collector_IPAddress> <postgres_user> <postgres_password>
    Where:
    • <collector_IPAddress> is the IP address of the Usage Metering Collector server.
    • <postgres_user> is a user name for the new read-only user for the Postgres database.
    • <postgres_password> is a password for the new read-only user for the Postgres database.