Configuring the POM database on the primary POM server

Last Updated : Jun 19, 2024 |

About this task

Use this procedure to configure the POM database only on the primary POM server. For the auxiliary POM server, you do not need to configure the POM database explicitly. When you add an auxiliary POM server from the POM Servers page, the auxiliary server can access the database.

Before you begin

Complete POM implementation.

Procedure

  1. Determine the type of database and the server where you want to install the database. For example, a local server for lab environment or an external server for production environment.
    Tip:

    When you install the POM database schema on a local or an external database, you are responsible for the administration of the database.

  2. Create a database instance for the POM database.
  3. For the external postgres server, in the pg_hba.conf file located at /var/lib/pgsql/data/, type the IP address of the POM server.
    Note:

    If you edit the pg_hba.conf file, restart the postgres service by running the postgresql restart command.

  4. For a secure database connection, add the third-party certificate in the POM Truststore by using $POM_HOME/bin/importCertInPomTruststore.sh

    For more information, see the section on Importing Certificate in POM truststore through Command Line Interface in Implementing Avaya Proactive Outreach Manager.

  5. Configure a desired server such as Postgres, Oracle, or Microsoft SQL Server.

    For installing Oracle drivers and Microsoft SQL drivers, see the instructions in the chapter Installing POM.

  6. Log in to the primary EPM as a root or sroot user.
  7. Type cd $POM_HOME/bin and press Enter.
  8. Type ./installDB.sh and press Enter.
    The system displays the following message: 
    Please select Contact Center Configuration mode from the following options:
    1. CCElite
    2. AACC-SBP [Skills-Based Pacing for Agentless POM]
    3. None
    4. AACC [Integrated & Blending]
    5. Oceana
    6. CCaaS-Outbound
  9. Type 1 ,2, 3, 4, 5 or 6 and press Enter:

    The system displays the following message:

    This script can modify $POM_HOME/config/PIMHibernate.cfg.xml or Test the DB connection.
    Do you like to continue? (y/n)
  10. Type y and press Enter.

    The system displays the following message:

    Please select from one of the following choices:
    1. Test DB Connection
    2. Create POM Schema on the given DB
    3. Save database configuration
    4. Configure database settings
    5. Configure database settings for reports (Optional)
    6. Exit from this utility

    Type 4 and press Enter.

  11. Type the database type. You can configure a Postgres, Oracle, or Microsoft SQL server. For installing Oracle drivers and Microsoft SQL drivers, see the instructions in the chapter Installing POM.
  12. If you select the MSSQL database, do the following:
    1. The system displays the following message Do you want to enable the POM Geo configuration? Please select(y/n), type y to enable Geo-redundancy.

      POM supports Geo-Redundancy on Standard/Enterprise edition of MS SQL database.

      If you enable Geo-redundancy, POM displays the Data Center Configuration page. For details, see Administering Avaya Proactive Outreach Manager.

    2. Type the Availability Group Listener FQDN.
    3. For all other databases, type the database server IP address or hostname.
  13. Type the port number.

    The default port is 5432 for Postgres database, 1521 for Oracle database, and 1433 for Microsoft SQL Server.

  14. If you select the database type as MSSQL, then the system displays the following message: 
    Please select an option connecting to MSSQL DB using SQL Server or Windows Authentication.
    1.SQLServer
    2.Windows
    Enter an option (1/2):

    If you select the database type as Oracle, then the system displays the following message:

    Please select an option connecting to Oracle DB using SID or Service Name.
    1.SID
    2.Service Name
    Enter an option (1/2):

    Type the appropriate option and press Enter.

  15. Type the name of the database.
  16. Type the username and password to connect to the database.
    The POM system displays the message: 
    Does Database require secured connection (Y/N):
    Note:

    To configure the Microsoft SQL Server database as a secured connection, type the hostname or FQDN of the database server.

  17. To enable Secure Connection, type y, or to disable type n.

    POM displays the following message after the database connection is created:

    Please select from one of the following choices:
    1. Test DB Connection
    2. Create POM Schema on the given DB
    3. Save database configuration
    4. Configure database settings
    5. Configure database settings for reports (Optional)
    6. Exit from this utility
  18. Optional Type 1 to verify the database connection.

    If the command returns SUCCESS, go to the next step.

    If the command returns FAILURE, the system displays the reason for failure on the console.

  19. To create a POM schema on the specified database, type 2
    The system displays the following message: 
    Do you want to save the values on the config file(y/n)?

    To save the values in the configuration file, type y.

    It creates the POM schema. You cannot use the database immediately, unless you save this configuration by using option 3 because EPM restarts after you save the configuration.

  20. To reconfigure the settings, such as changing the login credentials, the type of the database, the server IP address or the hostname, or the port number, type 4.
  21. POM displays the following message after the database connection is created: 
    Please select from one of the following choices:
    1. Test DB Connection
    2. Create POM Schema on the given DB
    3. Save database configuration
    4. Configure database settings
    5. Configure database settings for reports (Optional)
    6. Exit from this utility

    To exit, type 6.

    Caution:

    Ensure that the POM and VPMS services are not running before you restart your database.

  22. For any errors or exceptions, see the log file at $POM_HOME/logs/installDB.log.

    For information about configuring a separate database for POM reports, refer Configuring separate database for POM Reports in Implementing Avaya Proactive Outreach Manager guide