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

book

Article ID: 19548

calendar_today

Updated On:

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.