DA data source test fails after upgrade to 21.2.2

book

Article ID: 224225

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

We upgraded to 21.2.2 and the DA data source shows unavailable.

When we hit test, the test fails.

Tried IP, short name and fqdn

Cause

The SsoEncryptionDecryptionKey in the mysql netqosportal database does not match the SsoEncryptionDecryptionKey in the DA rest endpoint

Environment

Release : 21.2

Component : IM Data Aggregator

Resolution

Login to the netqosportal db on the CAPC:

mysql netqosportal -unetqos -p (this will prompt for your mysql db password)

select PropValue from netqosportal.performance_center_properties where PropName = 'SsoEncryptionDecryptionKey';

 

Now compare that to the DA rest endpoint:

http://YOUR-DA:8581/rest/dataaggregator

<SsoEncryptionDecryptionKey>#$utP9%z</SsoEncryptionDecryptionKey>

 

If they do not match, set the DA rest value to match the netqosportal value:

curl -X PUT -u admin -H 'Content-Type: application/xml' -d'<DataAggregatorInfo version="1.0.0"><SsoEncryptionDecryptionKey>VALUE-FROM-NETQOSPORTAL</SsoEncryptionDecryptionKey></DataAggregatorInfo>' http://localhost:8581/rest/dataaggregator/<ID>

((replace <ID> with the DA id from the same rest endpoint used above))

(when prompted for password, it is looking for the CAPC admin user password)

You should get a 200 OK response

Then try the test on the DA datasource again and it should work.

Additional Information

If you want to check the DA rest endpoint from the command line:

curl -vk -u admin http://YOUR-DA:8581/rest/dataaggregator

And it will prompt for the password (this is the CAPC admin user password)