check_xi_mysql_health does not support SSL

[Tonysnorek]

Hello All,

I am sure I won't be the last person to be caught by this issue for AWS Servers, and until Nagios implements support for SSL in the Check_xi_mysql_health, here is what we were able to work out.

These lines were added to the plugin file at line 1863

$self->{dsn} .= ";mysql_ssl=1";
$self->{dsn} .= ";mysql_ssl_verify_server_cert=1";
$self->{dsn} .= ";mysql_ssl_ca_file=/etc/ssl/mysql/ca.crt";

The cert used was the RDS CA Root Certificate which can be downloaded from the AWS Documentation or obtained from AWS.

[scottwilkerson]

Thanks for sharing