Log-in to the Performance Centre failing, SSO service failing to be started.

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration

Issue/Introduction

Log-in to the Performance Centre  (of Performance Management) failing, SSO service failing to be started

 

[root@<PortalHostName> ~]# service caperfcenter_sso start

Redirecting to /bin/systemctl start caperfcenter_sso.service

Job for caperfcenter_sso.service failed because the control process exited with error code. See "systemctl status caperfcenter_sso.service" and "journalctl -xe" for details.

[root@<PortalHostName> ~]# systemctl status caperfcenter_sso.service

● caperfcenter_sso.service - Performance Center SSO

   Loaded: loaded (/etc/systemd/system/caperfcenter_sso.service; enabled; vendor preset: disabled)

   Active: failed (Result: exit-code) since Mon 2019-10-14 09:57:01 BST; 14s ago

  Process: 30434 ExecStop=/opt/CA/PerformanceCenter/sso/bin/caperfcenter_sso stop sysd (code=exited, status=0/SUCCESS)

  Process: 20547 ExecStart=/opt/CA/PerformanceCenter/sso/bin/caperfcenter_sso start sysd (code=exited, status=0/SUCCESS)

  Process: 30590 ExecStartPre=/bin/sh -c /usr/bin/echo -n > /dev/tcp/localhost/3306 (code=exited, status=1/FAILURE)

 Main PID: 20613 (code=exited, status=0/SUCCESS)

 

Oct 14 09:57:01 <PortalHostName> systemd[1]: Starting Performance Center SSO...

Oct 14 09:57:01 <PortalHostName> sh[30590]: /bin/sh: connect: Connection refused

Oct 14 09:57:01 <PortalHostName> sh[30590]: /bin/sh: /dev/tcp/localhost/3306: Connection refused

Oct 14 09:57:01 <PortalHostName> systemd[1]: caperfcenter_sso.service: control process exited, code=exited status=1

Oct 14 09:57:01 <PortalHostName> systemd[1]: Failed to start Performance Center SSO.

Oct 14 09:57:01 <PortalHostName> systemd[1]: Unit caperfcenter_sso.service entered failed state.

Oct 14 09:57:01 <PortalHostName> systemd[1]: caperfcenter_sso.service failed.

[root@<PortalHostName> ~]#

 

Environment

Release : 3.5

Component : IM Reporting / Admin / Configuration

Cause

As per the log connection refused on port #3306 which is mysql port

 

Oct 14 09:57:01 <PortalHostName> sh[30590]: /bin/sh: connect: Connection refused

Oct 14 09:57:01 <PortalHostName> sh[30590]: /bin/sh: /dev/tcp/localhost/3306: Connection refused

Resolution

Restart mysql service by running below command 

service mysql stop

service mysql start

Additional Information

If still issue persists please open a support case for further assistance.