Setup Additional Monitoring Plugins

Install MySQL / MariaDB health plugin - check_mysql_health

https://labs.consol.de/nagios/check_mysql_health/index.html

yum install -y perl-DBI perl-DBD-MySQL make gcc-c++
wget https://labs.consol.de/assets/downloads/nagios/check_mysql_health-2.2.2.tar.gz
tar -zxvf check_mysql_health-2.2.2.tar.gz
cd check_mysql_health-2.2.2
./configure --prefix=/usr/lib64/nagios/ --with-nagios-user=nagios --with-nagios-group=nagios --with-perl=/usr/bin/perl
make
make install
cp -p /usr/lib64/nagios/libexec/check_mysql_health /usr/lib64/nagios/plugins/.

Install Microsoft SQL server health plugin - check_mssql_health

https://labs.consol.de/nagios/check_mssql_health/index.html

yum install -y make gcc-c++ cpan freetds-devel freetds
export SYBASE="/usr"
cpan -fi DBD::Sybase
wget https://labs.consol.de/assets/downloads/nagios/check_mssql_health-2.7.2.1.tar.gz
tar -zxvf check_mssql_health-2.7.2.1.tar.gz
cd check_mssql_health-2.7.2.1
./configure --prefix=/usr/lib64/nagios/ --with-nagios-user=nagios --with-nagios-group=nagios --with-perl=/usr/bin/perl
make
make install
cp -p /usr/lib64/nagios/libexec/check_mssql_health /usr/lib64/nagios/plugins/.

Another method - Build RPM for DBD-Sybase (for EL7 when using check_mssql_health)

Requirements

• dev tools installed (including rpmbuild and environment for that)
• cpanspec installed
• freedts & freetds-devel installed

yum install -y freetds-devel freetds cpanspec gcc-c++

Build the rpm

Change to your builduser environment with su - builduser Download the latest dbd-sybase sources

wget 'http://search.cpan.org/CPAN/authors/id/M/ME/MEWP/DBD-Sybase-1.16.tar.gz' -nd -P /home/builduser/rpmbuild/SOURCES/

Create the SPEC file

cd ~/rpmbuild
cpanspec SOURCES/DBD-Sybase-1.16.tar.gz

Remove test from spec file if you dont have a runnning sybase database

sed -i '/^%check/d' perl-DBD-Sybase.spec
sed -i '/^make test/d' perl-DBD-Sybase.spec

Build the rpm, just answer all questions with yes

mv perl-DBD-Sybase.spec SPECS/
SYBASE=/usr rpmbuild -ba SPECS/perl-DBD-Sybase.spec

Install the newly created rpm from /home/builduser/rpmbuild/RPMS/x86_64/