Removal of APMSQL in 10.7
search cancel

Removal of APMSQL in 10.7

book

Article ID: 232353

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

What is the recommended method to remove the APMSqlServer from version 10.7.192 Enterprise Managers so we can discontinue using it?

From https://support.broadcom.com/external/content/security-advisories/Security-Advisory-CVE-2019-17571-log4j-1.2-vulnerability-and-Broadcom-CA-APM/19839 :

  • Broadcom Engineering has determined that the external APMSQL Server bundle available as an additional download for APM 10.5 and 10.7 uses an affected version of the Log4j 1.2 and it's use should be discontinued.  To replace this functionality, please use the built-in APM RestAPI instead.  Please refer to the APM documenation usage of the APM RestAPI to remotely query/download APM metrics over http/https connections."

Log4J was detected at:

/opt/CA/APM/EM/APMSqlServer/repo/com.ca.apm.server.teiid-10.7.0.252.war Installed version : 1.2.17"

 

Environment

Release : 10.7.0

Component :

Resolution

For the removal of the APMSqlServer, do the following:

  1. Stop the EM
  2. Stop Webview
  3. Delete the <em home>/APMSqlServer directory
  4. Delete the <em_home>/config/APMSqlServer.properties
  5. Delete the working caches
    1. Product/enterprisemanager/configuration/org* and .settings*
    2. Product/webview/configuration/org* and .settings*
    3. <em_home>/work
  6. Start the EM
  7. Start Webview

Additional Information

.Q. What is the recommended method to remove the APMSqlServer from version 10.7.192 Enterprise Managers so we can discontinue using it?

A. APMSQL does not have a specific installer or uninstaller which it really should have. Looking at the 10.7 documentation, seeing this.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/integrating/apmsql-cookbook.html

Installing Enterprise Manager installs the APMSQL by default at the \\<EM_HOME>\APMSQLServer folder. The configuration file APMSQLServer.Properties is located in the \\config folder

So remove the files in the above locations.

Then go to the specific connection section to undo the install steps

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/integrating/apmsql-cookbook/connect-to-ca-apmsql.html

If there is a startup service and registry settings in Windows/environment settings in Unix account profile would remove that.

Powered by Wolken Software