Port 3306 needs to be opened between CABI and Spectrum

Document ID : KB000049270
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When trying to generate a report in InfoView after a new install of Spectrum Report Manager (SRM), the user gets the following error:

Parameter Name Error Message
WKP_ProxyUserSecurity No values set for this parameter WKP_CustomLogo No values set for this parameter

Solution:

Port 3306 is the default MySQL port that needs to be opened in the firewall between CABI and Spectrum or SRM cannot get to the Spectrum MySQL database properly which in turn causes Java timeouts and the HTML render to fail as it cannot get the information that it needs.

If you are installing BOXI on the same machine as CA Spectrum, you cannot use the default MySQL port of 3306, you must specify a different unused port which also needs to be opened in the firewall.

Windows Only

Verify that Windows Firewall settings on the source machine allows remote connections to MySQL:

  1. Select Start, Control Panel, Windows Firewall.
  2. Under the Exceptions tab, click Add Port and configure values as follows:

    1. Enter MySQL for the name.
    2. Enter 3306 for the Port Number.
    3. Select TCP.

  3. (Optional) Restrict the scope of access to MySQL to the destination machine by clicking Change Scope. Then enter the location of your 9.2 machine to allow remote connections to MySQL only from that machine and click OK. See Windows Help and Support for details.

Access to the report database on the Windows machine is enabled.