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:
- Navigate to
%AGILIANCE_HOME%\MySQL\bin
and open command prompt from that window. - Enter the following command:
mysql -u root -p
Enter the root password (by default the root password is agiliance).
- Check the connection for the reportuser by running the following query on the MySQL database:
SELECT * FROM USER WHERE USER = 'reportuser';
- 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;
- 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.
- 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:
- Open command prompt and navigate to the
%AGILIANCE_HOME%\install\toolbox\bin
directory. - Run the command:
encrypt.cmd <password>
to encrypt the reportuser password.
- Copy the encrypted password.
- Open the
%AGILIANCE_HOME%\config\agiliance.properties
file and set the following property:jasper.reportuser.password.encrypted=EncryptedString
- Restart the Application server.
For the Report Server:
- Open the
%JASPER_HOME%\apache-tomcat\webapps\jasperserver-pro\WEB-INF\agiliance.properties
file. - Set a password for the property:
For a MySQL database:
database.mysql.password.encrypted=EncryptedString
For an Oracle database:database.oracle.password.encrypted =SchemaUserPasswordinEncryptedString
Restart the ReportServer.
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.Log in with sysadmin credentials (username sysadmin and password agiliance)
Click the View menu > Repository.
Expand the Public folder, then click Data Sources.
Edit the RiskVision JDBC data source.
Enter the new reportuser password.
Test the connection.
Click Save.
Restart the jasperreportsTomcat service.