How to update / change Jasper Server Hostname

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Even though the change is successfully saved in the Jasper Integration page, if the page is refreshed, the original short hostname is displayed back.

This is the new FQDN of the Jasper Server Hostname:

But after refreshing the page, the original short hostname is back.

Environment

Release: Any
Component: Spectrum Report Manager (SRM) CABI/Jasper

Resolution

NOTE: Starting from 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". In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

Manually update the Jasper Server Hostname in the registry table of the reporting database on the OneClick+SRM (Spectrum Report Manager) machine.

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

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

3 - cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql:

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

4. Run the following MySQL syntax to show the jasperHost row of the registry table of the reporting database:

mysql> select jasperHost from registry;

+----------------+
| jasperHost     |
+----------------+
| cabiserver     |
+----------------+

5. Run the following MySQL syntax to update the jasperHost row of the registry table:

mysql> update registry set jasperHost="cabiserver.local.net";

6. Recycle the Tomcat service and check.

$ cd $SPECROOT/tomcat/bin

$ ./stopTomcat.sh

$ ./startTomcat.sh