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.
R10.3.1 installer is missing the BOCI/CABI cleanup - so manual cleanup is required by native mysql command to update reporting.registry entry.
Check for existing configuration per native mysql-command. All native mysql-command are executed per Spectrum install owner logon from directory $SPECROOT/mysql/bin at CA Spectrum OC/SRM server:
- show the current configuration data:
./mysql[.exe] --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> -e"select * from registry\G;" reporting
- update single entries out of this record
./mysql[.exe] --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> -e"update registry set ='value';" reporting
Sample: ./mysql[.exe] --defaults-file=../my-spectrum.cnf -uroot -proot -e"update registry set BOPort='0';" reporting
Here it is required to overwrite the entries: BOPort and BOHost
Please set BOXI port-number to "0" - while BOXI hostname / URL set to "nothing". So set BOHost=''; ( which are 2 single_quotes without any space/blank character ).
When the reporting.registry parameters are modified, you are required to restart the OC/SRM tomcat service once.
Using alias like "alias strmy='/app/spectrum/mysql/bin/mysql --defaults-file=/app/spectrum/mysql/my-spectrum.cnf -uroot -p<PASSWD>'
Then checking for configuration shows / here sample for not configured BOXI parameter:
[[email protected] bin]$ strmy reporting -e"select * from registry\G;" | grep BO
BOPassword:
BOCommonFiles:
BOHome:
BOInstallRoot:
ConvertedReportsToBOXI: false
BOUser:
BOHost:
BOPort: 0
BOAuthType:
BOTomcatPort: 0
BOInfoView:
BOCmc:
BOInfoViewCredentials:
BOInfoViewAuthType:
DefaultBOXIUserPassword:
BOSharedSecret: