TEC601074: How to avoid a "database inaccessible" error?

Document created by SamCreek Employee on May 25, 2016Last modified by SamCreek Employee on May 25, 2016
Version 2Show Document
  • View in full screen mode

Document ID:  TEC601074

     Last Modified Date:  10/23/2013

 

  • Products
    • CA Application Performance Management
  • Releases
    • CA Application Performance Management:Release:CA APM 9.5
  • Components
    • WILY INTROSCOPE
    • INTROSCOPE
    • CUSTOMER EXPERIENCE MANAGER

 

 

 

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.

 

 

Search the Entire CA APM Knowledge Base

 

search-kb.jpg

Attachments

    Outcomes