Change the ReportUser Password

The ReportUser password need to be changed in the below servers:

• MySQL database or Oracle database
• Application server
• Report server

For the MySQL database:

1. Navigate to %AGILIANCE_HOME%\MySQL\bin and open the 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).

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

SELECT * FROM USER WHERE USER = 'reportuser';

4. 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;

5. Run the below command on the:

> 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.

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

For the Oracle database:

ALTER user <username> IDENTIFIED BY <new_password>

For the Application Server:

1. Encrypt the reportuser password with encrypt.cmd.
2. Open command prompt and navigate to the %AGILIANCE_HOME%\install\toolbox\bin directory.
3. Run the command: encrypt.cmd <password>

2. Copy the encrypted password.
3. Open the %AGILIANCE_HOME%\config\agiliance.properties file and set the following property: jasper.reportuser.password.encrypted=EncryptedString
4. Restart the Application server. 

For the Report Server:

1. In file %JASPER_HOME%\apache-tomcat\webapps\jasperserver-pro\WEB-INF\agiliance.properties,

• Set the password for property

For the MySQL database
database.mysql.password.encrypted=EncryptedString
For the Oracle database
database.oracle.password.encrypted =SchemaUserPasswordinEncryptedString

• Restart the ReportServer

2. On the RiskVision Report Server host, open a web browser, enter the URL http://<localhost>:<port>/jasperserver-pro/-login.html that will allow you to log in to the RiskVision Report Server in a standalone mode
3. Log in with sysadmin credentials (username as sysadmin and password as agiliance)
4. On the View menu, click Repository
5. Expand the Public folder, select Data Sources, and edit the RiskVision JDBC data source.
6. Enter the new reportuser password
7. Test connection
8. Click Save
9. Restart the jasperreportsTomcat service.