SsoConfig utility not connecting in NetOps Portal

Products

• CA Performance Management
• Network Observability

Issue/Introduction

After configuring SSL settings for NetOps Portal and then reversing the changes, the SsoConfig utility fails to connect 

[root@PerformanceCenter]# ./SsoConfig
Single Sign-On Configuration Tool
Enter q to quit the program or b to go back to previous menu

SSO Configuration:
1. CA Performance Center
Choose an option > 1

SSO Configuration/CA Performance Center:
1. LDAP Authentication
2. SAML2 Authentication
3. Performance Center
4. Single Sign-On
5. Test LDAP
6. Export SAML2 Service Provider Metadata
7. Enable FIPS
Choose an option > 4

SSO Configuration/CA Performance Center/Single Sign-On:
Cannot connect to the CA Performance Center SSO Web Service.
Check if CA Performance Center is running and retry.

Environment

DX NetOps CA Performance Management (CAPM) all supported releases

Cause

SSO Service fails to connect to the caperfcenter_console service. The PCService.log shows:

org.springframework.web.client.HttpServerErrorException: 503 Service Unavailable
        at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:92)
        at org.springframework.web.client.RestTemplate.handleResponseError(RestTemplate.java:494)

Console Service fails to connect to caperfcenter_devicemanager service with the following being seen in the DMService.log: 

Caused by: java.lang.IllegalArgumentException: Invalid enumeration value: 8382 for enumeration class com.ca.im.portal.api.net.Protocol
        at com.ca.im.portal.api.util.ValueEnumMapHelper.fromValue(ValueEnumMapHelper.java:57)
        at com.ca.im.portal.api.net.Protocol.fromString(Protocol.java:38)
        at com.ca.im.portal.dm.datasourcedb.DBDataSourceDAO.loadAddress(DBDataSourceDAO.java:868)
        at com.ca.im.portal.dm.datasourcedb.DBDataSourceDAO.loadDataSourceContact(DBDataSourceDAO.java:796)
        at com.ca.im.portal.dm.datasourcedb.DBDataSourceDAO.buildDataSourceFromRow(DBDataSourceDAO.java:757)
        at com.ca.im.portal.dm.datasourcedb.DBDataSourceDAO.loadDataSources(DBDataSourceDAO.java:70)
        at com.ca.im.portal.api.services.datasource.DataSourceService.updateCache(DataSourceService.java:447)
        at com.ca.im.portal.api.services.datasource.DataSourceService.refreshCache(DataSourceService.java:384)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:346)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:299)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:132)
        ... 137 more
 

The cause is that the ConsolePort and ConsoleProtocol field values in the data_sources2 table are incorrect within the netqosportal database .

Resolution

On the NetOps Portal Server, do the following:

1. Stop the NetOps Portal services as per:
   
   TechDocs : DX NetOps 23.3 : Stop NetOps Portal
   
   
2. Login to the netqosportal DB:
   
   cd /opt/CA/MySql/bin
./mysql -unetqos -p<PASSWORD> netqosportal
   
   
3. At the MySQL prompt, run;
   
   mysql> select SourceID,ConsoleName,ConsoleHost,ConsolePort,ConsoleProtocol from data_sources2;

+----------+-----------------------------------------+---------------+-------------+-----------------+
| SourceID | ConsoleName                             | ConsoleHost   | ConsolePort | ConsoleProtocol |
+----------+-----------------------------------------+---------------+-------------+-----------------+
|        0 | CA Performance Center                   | xx.xxx.xx.xx  |        8382 | 8382            |
   
   
4. Update the values within the data_sources2 table
   
   mysql> UPDATE `netqosportal`.`data_sources2` SET `ConsolePort`='8181', `ConsoleProtocol`='http' WHERE  `SourceID`=0;
   
   Note : set the above values according to the port/protocol you are using for NetOps Portal Web access.
   
   
5. Start the NetOps Portal Services
   
   TechDocs : DX NetOps 23.3 : Start NetOps Portal