Change Jaspersoft DB password integrated with Clarity
search cancel

Change Jaspersoft DB password integrated with Clarity

book

Article ID: 33318

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Steps on how to change your Jaspersoft Database (DB) password which is required in the below scenarios:

  • You get an error similar to the below:
    • Unable to Log in to Jaspersoft Console after changing the database password.
    • Also, all the reports are failing from Clarity with ORA-28000: the account is locked
      OR
  • You want to change the Jaspersoft database password
             OR
  • You want to change the database hostname or any other connection detail

Environment

Clarity Integrated with Jaspersoft 

All supported Releases

Resolution

To recreate the password either in plain text or encrypted as per organizational security policy use the below steps

Table of Contents

Recreate the password in plain text

  1. Open the following file with a text editor: $JSTomcat \webappseportservice\META-INF\context.xml
  2. Replace the details on the connection
  3. Enter the password in a non-encrypted way for the database
  4. save and restart Jaspersoft

Recreate the password in encrypted way in Jaspersoft 5.6.1, 6.1, 6.4.2 and higher

  1. Go to your Jaspersoft Install files: $jasper_install\jasperreports-server-5.6.1-bin\buildomatic\default_master.properties
  2. Enter the correct value for Jasper DB Password in plain text
  3. Ensure all other values are still valid, such as Tomcat directory etc.
  4. Change the encrypt.done=true to encrypt=true
  5. Save the file.
  6. Now navigate to $jasper_install\jasperreports-server-5.6.1-bin\buildomatic
  7. Run the command: js-ant refresh-config
    This will remove and recreate all the configuration files without deploying them to the application server.
  8. Once done, get the context file from: $jasper_install\jasperreports-server-5.6.1-bin\buildomatic\build_conf\default\webapp\META-INF\context.xml and replace the one in $JSTomcat\webappseportservice\META-INF\context.xml
  9. Restart Jaspersoft Tomcat

Recreate the password in encrypted way in Jaspersoft 7.1, 7.8, 8.1

  1. Go to your Jaspersoft Install files: $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
  2. Add the below parameters to the $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
  3. dbPassword=<Enter your Database Password>
  4. propsToEncrypt=dbPassword
  5. appServerType=tomcat
  6. dbType=<Enter your Database Type> (Example oracle or sql
  7. appServerDir==<Enter your Jaspersoft Installed Path> (Example C:\\App\\Jasper)
  8. encrypt=true
  9. Enter the correct value for dbPassword, dbType, appServerDir in plain text
  10. Save the file.
  11. Navigate to $jasper_install\jasperreports-server-7.1-bin\buildomatic
  12. Run the command: js-ant refresh-config and you should see the Build Success once the execution is completed.
  13. Now again go to your Jaspersoft Install files: $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
  14. You will see the dbPassword encrypted (Example: dbPassword=ENC-5024da1014088fdf4dc15a8f797f98f6d976ffd98e692173674e090778296f-)
  15. Stop the Jaspersoft services
  16. Open the following file with a text editor: $JSTomcat \webappseportservice\META-INF\context.xml
  17. Copy the encrypted database password generated in Step 9 and update the password in $JSTomcat \webappseportservice\META-INF\context.xml
     
    <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"maxActive="100" maxIdle="30" maxWait="10000"username="JASPER" password="ENC-b16918c25f30f1cc643a40d7fefb0918c592a5ccccb6043cd6712ca64c088c28-" driverClassName="oracle.jdbc.OracleDriver" accessToUnderlyingConnectionAllowed = "true" validationQuery="SELECT 1 FROM DUAL"testOnBorrow="true"url="jdbc:oracle:thin:@Oracle:1521/jspdb"factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>
     
  18. Restart the Jaspersoft Services

Recreate the password in encrypted way in Jaspersoft 9.x

  1. Stop the Jaspersoft Services
  2. Make a backup of file context.xml from $JSTomcat\webappseportservice\META-INF
  3. Go to your Jaspersoft Install files: $jasper_installer\buildomatic\default_master.properties and add below parameters 
    • dbPassword=<Enter your Database Password in plain text>
    • propsToEncrypt=dbPassword
    • appServerType=tomcat
    • dbType=<Enter your Database Type> (Example oracle, MSSQL, PostgreSQL) 
    • appServerDir==<Enter your Jaspersoft Installed Path> (Example C:\\App\\Jasper)
    • encrypt=true
  4. Save the file.
  5. Open a command prompt and Navigate to directory $jasper_installer\buildomatic 
  6. Run the command: js-ant refresh-config 
  7. Now again go to your Jaspersoft Installer files: $jasper_installer\buildomatic\default_master.properties
  8. You will see the dbPassword encrypted (Example: dbPassword=ENC-5024da1014088fdf4dc15a8f797f98f6d976ffd98e692173674e090778296f-)
  9. Open the following file with a text editor: $JSTomcat \webappseportservice\META-INF\context.xml
  10. Copy the encrypted database password generated in Step 7 and update the password in $JSTomcat \webappseportservice\META-INF\context.xml
    <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"maxActive="100" maxIdle="30" maxWait="10000"username="JASPER" password="ENC-b16918c25f30f1cc643a40d7fefb0918c592a5ccccb6043cd6712ca64c088c28-" driverClassName="oracle.jdbc.OracleDriver" accessToUnderlyingConnectionAllowed = "true" validationQuery="SELECT 1 FROM DUAL"testOnBorrow="true"url="jdbc:oracle:thin:@Oracle:1521/jspdb"factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>
  11. Start the Jaspersoft Services and check the context.xml to ensure password is encrypted 

 Note: In order to encrypt the password you will need to have the Jaspersoft Installer extracted on the Jaspersoft server.

 

  • After the Jaspersoft Database password is corrected you should be able to login to the Jaspersoft console using superuser however the default password will not work, reach out to Broadcom Support to have the superuser password reset  
  • However, running reports from Clarity --> Advance Reporting will continue to fail. In order to correct the same, you will need to perform the below steps
    1. Log in to Jaspersoft as Superuser  
    2. Search for user jasperadmin under your organization you created for integrating with Clarity and edit the user
    3. Look for tab Attributes on the right-hand panel
    4. Delete all the attributes except domainWhitelist as that is read-only
    5. Now log in to the Clarity application server
    6. Navigate to CLARITY_HOME\bin and execute admin update jasperParameters

Additional Information

Powered by Wolken Software