CAPC Upgrade Fails With MySQL Errors

book

Article ID: 193609

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

During the upgrade of CAPC r3.2 to CAPC r3.7.12 fails with MySQL invalid password.
From the MySQL install log we can see the following messages: 

------snip------
Custom Action:            com.ca.im.installanywhere.action.MigrateDb
                          Status: FATAL ERROR
                          Additional Notes: FATAL ERROR -     class com.ca.im.installanywhere.action.MigrateDb FatalInstallException: Unable to open database connection: (jdbc:mysql://localhost:3306/netqosporta
l?useUnicode=true&characterEncoding=UTF-8&useSSL=true&verifyServerCertificate=false with netqos) com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
------snip------

Cause

The issue was put down to missing pre-requisite Linux packages.

Resolution

Make sure the the pre-requisite packages are installed on the CAPC server.
In this scenario the following Linux packages were installed: 

fontconfig
libaio-devel
libaio
numactl

The packages must be 32bit and 64bit, an example looks like: 
libaio-0.3.109-13.el7.x86_64 

Additional Information

The pull list of required packages are available here (upgrade):
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/performance-management/3-7/upgrading/upgrade-requirements-and-considerations.html#concept.dita_b2aa9703ab037cf3947eb0bb6f2777d530bdd53f_PackageRequirements

Full Install:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/performance-management/3-7/installing/review-installation-requirements-and-considerations.html#concept.dita_669f11a1a7b734ff07869f266794dc77910ebbf3_PackageRequirements