To recreate the password either in plain text or encrypted as per organizational security policy use the below steps
Recreate the password in plain text
- Open the following file with a text editor: $JSTomcat \webapps\reportservice\META-INF\context.xml
- Replace the details on the connection
- Enter the password in a non-encrypted way for the database
- save and restart Jaspersoft
Recreate the password in encrypted way in Jaspersoft 5.6.1, 6.1, 6.4.2 and higher
- Go to your Jaspersoft Install files: $jasper_install\jasperreports-server-5.6.1-bin\buildomatic\default_master.properties
- Enter the correct value for Jasper DB Password in plain text
- Ensure all other values are still valid, such as Tomcat directory etc.
- Change the encrypt.done=true to encrypt=true
- Save the file.
- Now navigate to $jasper_install\jasperreports-server-5.6.1-bin\buildomatic
- Run the command: js-ant refresh-config
This will remove and recreate all the configuration files without deploying them to the application server.
- 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\webapps\reportservice\META-INF\context.xml
- Restart Jaspersoft Tomcat
Recreate the password in encrypted way in Jaspersoft 7.1, 7.8 & 8.1
- Go to your Jaspersoft Install files: $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
- Add the below parameters to the $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
- dbPassword=<Enter your Database Password>
- propsToEncrypt=dbPassword
- appServerType=tomcat
- dbType=<Enter your Database Type> (Example oracle or sql
- appServerDir==<Enter your Jaspersoft Installed Path> (Example C:\\App\\Jasper)
- encrypt=true
- Enter the correct value for dbPassword, dbType, appServerDir in plain text
- Save the file.
- Navigate to $jasper_install\jasperreports-server-7.1-bin\buildomatic
- Run the command: js-ant refresh-config and you should see the Build Success once the execution is completed.
- Now again go to your Jaspersoft Install files: $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
- You will see the dbPassword encrypted (Example: dbPassword=ENC-5024da1014088fdf4dc15a8f797f98f6d976ffd98e692173674e090778296f-)
- Stop the Jaspersoft services
- Open the following file with a text editor: $JSTomcat \webapps\reportservice\META-INF\context.xml
- Copy the encrypted database password generated in Step 9 and update the password in $JSTomcat \webapps\reportservice\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"/>
- Restart the Jaspersoft Services
Note: In order to encrypt the password you will need to have the Jaspersoft Installation 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
-
- Log in to Jaspersoft as Superuser
- Search for user jasperadmin under your organization you created for integrating with Clarity and edit the user
- Look for tab Attributes on the right-hand panel
- Delete all the attributes except domainWhitelist as that is read-only
- Now log in to the Clarity application server
- Navigate to CLARITY_HOME\bin and execute admin update jasperParameters