Re: check_xi_mysql_health does not support SSL
Posted: Thu Jun 21, 2018 8:55 am
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.
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.