What steps need to be followed to change the Infoview URL to use IPAddress instead of hostname

Products

• CA Spectrum

Issue/Introduction

CABI is integrated with Hostname and what steps need to be followed to change the URL to use IP address instead of Hostname

Example : http://SpectrumServer:port/spectrum/repmgr/boInfoView.jsp

Client would like it as http://x.x.x.x:port/spectrum/repmgr/boInfoView.jsp (where x.x.x.x is the ip address)

Environment

Spectrum 10.2.x or below integrated with CABI BOXI 4.1 SP3 or below.

Resolution

Follow the below steps on OneClick + SRM (Spectrum Report Manager) server

Windows:
Click on Start Button
Click on Run
Type in "cmd"
Command prompt will be opened
Type "bash -l"

Unix:

In the Unix Terminal
cd %SPECROOT%/mysql/bin

$ ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting

First take the backup of the current registry contents into a file called reg.txt under the current directory
tee reg.txt
select * from registry\G
notee

Now follow below steps
Update registry set BOHost="<IP>";
Update registry set CrystalReportsHost="<IP>";
Update registry set DBHost="<IP>";
Update registry set BOInfoView="http://<IP>:<port>/InfoViewApp";
Update registry set BOCmc="http://<IP>:<port>/CmcApp";

Example:
Update registry set BOHost="10.10.1.52";
Update registry set CrystalReportsHost="10.10.1.52";
Update registry set DBHost="10.10.1.52";
Update registry set BOInfoView="http://10.10.1.52:8080/InfoViewApp";
Update registry set BOCmc="http://10.10.1.52:8080/CmcApp";

Now recycle the tomcat service and check.