Connection error in CABI/Jasper when trying to create reports

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

When trying to create reports using CABI/Jasper, users are seeing the following error;

"Host "HOSTNAME" is not allowed to connect to this MySQL server"

Environment

DX NetOps Spectrum integrated with CABI/Jasper

Cause

The CABI/Jasper system does not have privilege to access MySQL on the Spectrum Report Manager (SRM) server.

Resolution

NOTE: Starting in DX NetOps Spectrum 21.2.4, the default root password for MySQL is "MySqlR00t". For DX NetOps Spectrum versions prior to 21.2.4, the default root password is "root".

1 - Log into the SRM system as the user that owns the Spectrum installation

2 - If on Windows, start a bash shell by running "bash -login"

3 - cd to the $SPECROOT/mysql/bin directory and run the following command to log into MySQL where <PASSWD> is the root password for your version of DX NetOps Spectrum:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD>

4. At the MySQL command prompt, run the following MySQL commands where <HOSTNAME> is the hostname of the CABI/Jasper system::

mysql> GRANT ALL PRIVILEGES ON srmdbapi.* TO 'WEBI_user'@'<HOSTNAME>' IDENTIFIED BY '0n3cl1Ck';

mysql> GRANT ALL PRIVILEGES ON srmdbapi.* TO 'CR_user'@'<HOSTNAME>' IDENTIFIED BY '0n3cl1Ck';

mysql> GRANT ALL PRIVILEGES ON reporting.* TO 'WEBI_user'@'<HOSTNAME>' IDENTIFIED BY '0n3cl1Ck';

mysql> GRANT ALL PRIVILEGES ON reporting.* TO 'CR_user'@'<HOSTNAME>' IDENTIFIED BY '0n3cl1Ck';

mysql> FLUSH PRIVILEGES;