#234: Resolve MariaDB Service Check Failures in Nagios - Jenrite/OE2-project-group-B GitHub Wiki

create nagios user on db-b machine

CREATE USER 'nagios'@'10.2.0.7' IDENTIFIED BY 'mypasswd';
GRANT SELECT ON nagiosdb.* TO 'nagios'@'10.2.0.7';
FLUSH PRIVILEGES;

CHANGE BIND-ADDRESS TO 0.0.0.0 IN PUPPET TO ALLOW REMOTE CONNECTIONS

image

Check connection

With following command /usr/lib/nagios/plugins/check_mysql -H db-b -u nagios -p mypasswd

modify check command in nagios

image

confirm in nagios

image