Mysql is down in the PAM Appliance

Products

• CA Privileged Access Manager (PAM)

Issue/Introduction

The SNMP console is receiving alerts stating that the MySQL service running on the PAM server is down.
However, the cluster status pane in the PAM user interface shows that the cluster status is healthy and this cannot occur with MySQL stopped, as MySQL is used for the data replication among the cluster nodes.

Environment

Product: Privileged Access Manager.

Cause

The most suitable cause for this problem to occur is having an external SNMP polling tool trying to access the PAM resources from outside.
If the polling system is not able to reach the MySQL running information for any reason (not present in the PAM MIB, not reachable from outside as the PAM appliance has almost all the ports blocked, etc) this may lead to raise a false alert.

Resolution

Normally, the false alert is generated by an external SNMP polling system which is monitoring the PAM servers.
If this is the case, please remove the parameter inside the MySQL process monitoring on the SNMP polling tool.

It should look like this, although it may vary depending on the SNMP polling tool being used.

/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

After removing the proper parameter from the SNMP polling tool the false alert should not be shown anymore.

Additional Information

In order to make sure it all was in place in the appliance you can open a support case and the support technician will ssh the PAM servers and verify that mysqld was actually running: