MSQL Management Pack not configuring or working properly

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

After "validating the connection" the error "Unable to connect to the server. Verify your host settings" as seen below:

Log analysis shows the below:
node_#################.zip_extracted/log/adapters/MySQLAdapter:
YYYY-MM-DDTHH:MM:SS ERROR [Collector worker thread #] (PID) <domain_name>.DataProvider.error - <domain_name>.DataProvider: Caught an exception while collecting: java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='<IP_ADDR>', port=<port_number>, type='master''}. Host '<node_name>' is not allowed to connect to this MySQL server
YYYY-MM-DDTHH:MM:SS ERROR [Collector worker thread #] (PID) <domain_name>.DataProvider.error - <domain_name>.DataProvider: Diagnosing connection problem
YYYY-MM-DDTHH:MM:SS ERROR [Collector worker thread #] (PID) <domain_name>.DataProvider.error - <domain_name>.DataProvider: Diagnostic Result:
    Can connect to MySQL Server Instance
      Type:       can_connect_to_mysql_server_instance
      Result:     Failed
      Message:    Could not connect to HostAddress{host='<IP_ADDR>', port=<port_number>, type='master'}. Host '<node_name>' is not allowed to connect to this MySQL server. Check connection settings. Failed to run query: SHOW databases

Port test on the cloud proxy will be successful.

Environment

VCF Aria Operations 8.18.x

Cause

Connectivity issues, which indicates a firewall presence in the network.

Resolution

Check the IPs of the database that are failing to connect. If possible, whitelist the cloud proxy IPs assigned to the adapter to allow connections to the servers

Additional Information

SSL-enabled connectivity, the certificate of the server must be manually copied into Aria Operations as per the reference doc - https://techdocs.broadcom.com/us/en/vmware-cis/aria/aria-operations-for-integrations/9-1/management-pack-for-mysql-9-1/system-requirements-mysql.html

Issue with Postgresql Management Pack on Aria Operations 8.18.4/5 - "SSL connection is not enabled. Server required an SSL connection" & after SSL has been enabled the error "The server doesn't support SSL. Disable SSL mode"