CAPA
search cancel

CAPA

book

Article ID: 262018

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

I need to update the database password for the application.  Plesae help me locate the config file so I can update the password for the database.  

We have EnableStudio 141/142 installed.  

Environment

Release : 16.0.1

Resolution

PSB process for changing database password for the CAPA / ES 14.1

Before proceeding keep the below credentials handy

  • Apache Tomcat GUI Admin User and password
    default admin (no password for admin use)
  • SQL admin user to reset CAPA / ES DB user password if not done already
  • CAPA / ES WAR admin username and password (for troubleshooting if needed)

o   Default CAPA / ES WAR admin username and password

o   1. Username: admin

o   2. Password: dfkhvlkp$75

  • CAPA superadmin password (testing/troubleshooting if needed)

 

Process

  1. full back up of Application DB i.e. SQL DB (CAPA /ES Database)
  2. open the apache tomcat homepage
  3. Click on the manager app

https://mail.google.com/mail/u/0?ui=2&ik=8309932636&attid=0.0.1&permmsgid=msg-f:1759787951392295095&th=186c05d16ac008b7&view=fimg&fur=ip&sz=s0-l75-ft&attbid=ANGjdJ9fSRn4W7tASqQsXABd0hr59cglpT68_LJBEYr9izaOmwoX_ohkNf7xtSZQjm6-OtOyeTw8iTirSeXEZ1gySTl7nGpGrDV8LOnlUhBSabvyoj_ZuzD0KhUqW_Q&disp=emb&realattid=ii_lezf2egu0

 6.       Stop your CAPA / ES app

 

https://mail.google.com/mail/u/0?ui=2&ik=8309932636&attid=0.0.2&permmsgid=msg-f:1759787951392295095&th=186c05d16ac008b7&view=fimg&fur=ip&sz=s0-l75-ft&attbid=ANGjdJ_GHek8uLrziMDFWXntMFaVwETt-fJel1B87s7lspZpmHhjDm3AFcNEPE1sGGn9CJvgqyCBEQ4PLc1vqswJxgtdP0-NSD42PlC7vNS5VNh4DFuO4b5Ok5aYo24&disp=emb&realattid=ii_lezf3vk21

7.       Find the apache installation path example:
C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\es141\WEB-INF\classes

8.       Find and open “config.properties” from the above folder

9.       Find “dbs.password” parameter and update your updated password

10.   Save the file

11.   Start the app from the apache tomcat application list

12.   Verify ES / CAPA login page.