How to change the APM Postgres database connection settings after an install

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

Change APM postgres database connection settings post install

Environment

Release: APM 10.x

Resolution

Description:

This document covers the steps to configure the APM database connection after a successful installation.

1. Solution:

   To configure the connection to an APM Postgres database after installation:

   1. Open the tess-db-cfg.xml file for editing. The file is located in the following directory, depending on your operating system:
      
      
      • Windows: <EM_home>\config\
        
        
      • UNIX: <EM_home>/rootFiles/config/
        
        
   2. For the hibernate.connection.url property, replace the current settings with the database hostname (or IP address), port, and database name.
      
      
   • For example: <property name="hibernate.connection.url">jdbc:postgresql://127.0.0.1:5432/cemdb</property>
     
     
   3. For the hibernate.connection.username property, specify the database user name.
      Note: This is not the PostgreSQL administrator user name.
      
      
   4. For the hibernate.connection.password property, specify the database user password in plain text.
      
      
   5. For the plainTextPasswords property, change the setting to true. This allows you to enter the password in plain text. Note that when the Enterprise Manager starts, Introscope sets the plainTextPasswords property back to false and encrypts the password.