CABI server integration with CAPM and Spectrum

[Uchira Amarasinghe]

Hi,

can anyone tell me what is the way of integrating CABI server with CAPM and Spectrum? 


Thanks,
Uchira.

[Silvio Okamoto]

Hi Uchira,

They are covered in these sections of Spectrum and Performance Management guides:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4-2/installing-and-upgrading/install-report-manager/cabi-jasperreports-server/cabi-jasperreports-server-integration-with-ca-spectrum.html

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4-2/installing-and-upgrading/install-report-manager/ca-spectrum-with-unified-dashboards-and-reporting-for-infrastructure-management/ca-spectrum-and-cabi-jasperreports-server-integration-for-unified-dashboards-and-reporting.html#concept.dita_3b05a33ab8fc1b23f8b3e41fc9e6f8e2474d64dc_InstallingtheIntegrationComponents

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/3-7/integrating/integrate-ca-business-intelligence/install-ca-business-intelligence-reports-and-dashboards.html

------------------------------
Technical Support Engineer IV
Broadcom Inc
------------------------------

[Uchira Amarasinghe]

Hi Silvio,

I have done Integration CA PC and Spectrum as per the given documents. when creating reports it getting below error do you have any idea on this?

Thanks,
Uchira.

[Silvio Okamoto]

Hi Uchira,

It looks like you enabled SSL, where you commonly supply the FQDN. In the screenshot, I see the IP address 10.58.75.112 which does not match with the hostname in the SSL certificate. Somewhere you have supplied the IP address instead of the hostname that is registered in the certificate.

------------------------------
Technical Support Engineer IV
Broadcom Inc
------------------------------

[Uchira Amarasinghe]

Hi Silvio,

we have integrated PM with Jasper server with the IP address of 10.58.75.112 and it goes through a WAF IP and the WAF IP has NAT to the public URL. (test.lk)

10.58.75.112:882 [CA PC] -> 172.26.89.66 [WAF] - > Public_IP [customer.lk]

Thanks,
Uchira.

[Uchira Amarasinghe]

Hi all,

integration and sync are ok with spectrum. we are getting a bellow error while generating a report on BABI from Spectrum

Thanks,
Uchira.

[Jeffrey Pinard]

I assume you fixed the PC certificate to have both the IP and FQHN  as SubjectAlternateName entries in the cert?  You no longer have cert issue?

As for the latest error, it seems CABI is unable to connect to the mysql server from the IP specified.
Is mysql local or remote to CABI machine?  Check the mysql.user table to see who/where mysql users can connect from.

[Uchira Amarasinghe]

Hello Jeffrey,

Thanks for the response, 

Yes, certificate issue sorted. 
Can you guide to get this done mysql is on ca pm (10.58.75.112) and ca spectrum (10.58.75.103). How to check mysql.user table? Both spectrum and pm sql are on default settings.

Thanks,
Uchira.

[Jeffrey Pinard]

Can you open a support ticket at this point?

Seems maybe something went wrong during integration setup, and one of the support engineers should be able to step you through the steps to reintegrate or resolve the permission issue.

Thanks.

[Uchira Amarasinghe]

Hi,

I have integrated jasper using the root user and spectrum running on svradmin, can this be an issue? anyway, I will open a support ticket for this. thank you for the response.

Thanks,
Uchira.