Changing passwords in Yellowfin

You can change the TrueSight Server Automation database password and the Yellowfin database password from Yellowfin. 

• • To change TrueSight Server Automation database password
  • To change Yellowfin database password

To change TrueSight Server Automation database password

Do the following:

1. Log on to Yellowfin URL as REPORT_ADMIN.
2. Select Administration > Admin Console.
3. Expand Data Sources.
4. Click Connections (for example, BSA).
5. Expand Connection Settings.
6. Navigate to Password section and click Click here to change password.
7. Enter the new TrueSight Server Automation database password.
8. Click Test Connection. Verify if the connection is successful.
9. Click Save.

To change Yellowfin database password

Do the following:

1. Stop the Yellowfin Tomcat service by executing the following command:

   <livereporting_installation_directory>/Yellowfin/appserver/bin/shutdown.sh
2. Download EncryptPassword.jar. 
3. Copy the EncryptPassword.jar on the Yellowfin machine.

4. Run the following command:

   java -jar EncryptPassword.jar
5. Enter the new password and generate the encrypted password.
6. Copy the Generated Password.
7. Open <livereporting_installation_directory>/appserver/webapps/root/web-inf/web.xml file by using any text editor (for example, Notepad).
8. Search for the JDBCPassword text. 

9. Replace the param value with the new password.

   <init-param>
   <param-name>JDBCPassword</param-name>
   <param-value>EnterNewPassword</param-value>
   </init-param>
10. Save the file.

11. Start the Yellowfin Tomcat service.

    <livereporting_installation_directory>/Yellowfin/appserver/bin/startup.sh