How to avoid a "database inaccessible" error?

Products

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

Issue/Introduction

Description:

How is it possible to avoid an error like

"10/11/13 09:41:03.742 AM EDT [WARN] [CheckDatabase.Thread1]
[Manager.com.timestock.tess.util.DbUtils] database inaccessible; will check later"

which also includes a

FATAL: password
authentication failed for user "admin" message?

Solution:

The admin password needs to be encrypted, if it is changed.

The EM connects to the APM database using the parameters defined in the file tess-db-cfg.xml which is contained in the EM_HOME\config folder.

The username and password are declared as follows:

<property name="hibernate.connection.username">admin</property> 	<property name="hibernate.connection.password">ENC(J6Js3l/VRwggDvrAbGlcQA==)</property>

As you can see the password is an encrypted string and so there is a utility that you can use to create that string in the EM_HOME\tools folder called MD5encoder.bat

to run, simply pass it the argument of the password you want to encrypt
e.g.
md5encoder mypassword

the output will then finish with the encrypted string e.g. as below

mypassword:34819d7beeabb926a5c854bc85b3e44

You can then paste the encrypted string into the file.

Environment

Release:
Component: APMCM