Change the PostgreSQL Account Password

To change the password for the PostgreSQL account: 

1. Open command prompt and navigate to the %JASPER_HOME%\postgresql\bin directory.
2. Run the following commands:
   psql -U postgres -d jasperserver
alter user postgres with password '<new password>';
   
   The default password for the postgres user is agiliance.
3. Open command prompt again, making sure you select Run as Administrator. 
4. Run the following commands:
   set PGPASSWORD=<new password>
set ks= %JASPERREPORTS_HOME%\config_ks
set ksp= %JASPERREPORTS_HOME%\config
5. If you have changed the Postgres database password, open the %JASPER_HOME%\buildomatic\default_master.properties file using a text editor and perform the following:
   • Enter the database password in the following property:

     dbPassword=<password>

     The <password> must be entered in clear text

   • Delete the following property:
     encrypt.done=true property

   • Add the following property:
     encrypt=true

6. Open command prompt, navigate to the %JASPER_HOME%\buildomatic directory, and run the command js-ant refresh-config.

7. Open the Report Server. Replace external.jdbc.password with the generated encrypted password from the %JASPER_HOME%\buildomatic\default.master.properties file to the %JASPER_HOME%\apache-tomcat\webapps\jasperserver-pro\WEB-INF\js.externalAuth.properties
8. Restart the jasperreportsTomcat and jasperreportsPostgreSQL services to apply the changes.
9. Perform the following steps on the Application server:

   1. Encrypt the postgresSQL password using %AGILAINCE_HOME%\install\toolbox\bin\encrypt.cmd

   2. Copy the encrypted postgresSQL password, and open the %AGILIANCE_HOME%\config\agiliance.properties file and set the below mentioned properties:

      1. jasper.database.password
      2. database.jasper.admin.password.encrypted

Note: These values are the encrypted password. 

10. To copy the passwords from the Report server to Application server, perform the following:

    1. Go to the %JASPER_HOME%\buildomatic\build_conf\default directory and copy the js.jdbc.properties password properties for postgresSQL metadata.

    2. Replace the copied properties onto js.jdbc.properties file in the %AGILIANCE_HOME%\buildomatic\build_conf\default directory.

    3. Restart the RiskVision Tomcat service to apply the changes successfully.