Change the ReportUser Password

The ReportUser password must be changed on the following servers:

  • MySQL database or Oracle database server;
  • Application server; and
  • Report server. 

For a MySQL database:

  1. Navigate to %AGILIANCE_HOME%\MySQL\bin and open command prompt from that window.
  2. Enter the following command:

mysql -u root -p

Enter the root password (by default the root password is agiliance).

  1. Check the connection for the reportuser by running the following query on the MySQL database:

SELECT * FROM USER WHERE USER = 'reportuser';

  1. Change the reportuser password using the following command:

SET PASSWORD FOR 'reportuser'@'REPORT_SERVER_HOST'= PASSWORD ('newpassword');
 FLUSH PRIVILEGES;

Enter the exit command to exit from the MySQL DB:
exit;

  1. Run the following command:

> grant all on *.* to 'reportuser'@'<ip_address or hostname>' identified by 'reportuser' with grant option;
 > flush privileges;

By default, the reportuser, username, and password is reportuser.

  1. Try logging in from MySQL with the reportuser and new password.

For an Oracle database:

ALTER user <username> IDENTIFIED BY <new_password>

For the Application Server:

  1. Open command prompt and navigate to the %AGILIANCE_HOME%\install\toolbox\bin directory.
  2. Run the command: encrypt.cmd <password> to encrypt the reportuser password. 
  1. Copy the encrypted password.
  2. Open the %AGILIANCE_HOME%\config\agiliance.properties file and set the following property: jasper.reportuser.password.encrypted=EncryptedString
  3. Restart the Application server. 

For the Report Server:

  1. Open the %JASPER_HOME%\apache-tomcat\webapps\jasperserver-pro\WEB-INF\agiliance.properties file.
  2. Set a password for the property: 

    For a MySQL database: 
    database.mysql.password.encrypted=EncryptedString
    For an Oracle database: 
    database.oracle.password.encrypted =SchemaUserPasswordinEncryptedString

  3. Restart the ReportServer.

  4. Open a web browser on the RiskVision Report Server host and enter the URL: http://<localhost>:<port>/jasperserver-pro/-login.html to log in to the RiskVision Report Server in a standalone mode. 

  5. Log in with sysadmin credentials (username sysadmin and password agiliance)

  6. Click the View menu > Repository.

  7. Expand the Public folder, then click Data Sources.

  8. Edit the RiskVision JDBC data source.

  9. Enter the new reportuser password.

  10. Test the connection.

  11. Click Save.

  12. Restart the jasperreportsTomcat service.