How to change the APM Postgres database connection settings after an install
book
Article ID: 19728
calendar_today
Updated On:
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.
Solution:
To configure the connection to an APM Postgres database after installation:
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/
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>
For the hibernate.connection.username property, specify the database user name. Note: This is not the PostgreSQL administrator user name.
For the hibernate.connection.password property, specify the database user password in plain text.
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.