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.

 

 

 

Environment

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

Resolution

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