Adding Nagios Plugins

pk8523 · 1 December 2017 17:36

Im new to Librenms but what Ive read says im able to use nagios plugins. I can’t seem to find instructions for adding them beyond the apt-get nagios-plugins. What I want to do is install SQL plugin from here

https://labs.consol.de/nagios/check_mssql_health/#installation

This plugin has many scripts in it so it seems like I would need to do more than just drop one of the files in the nagios/plugins folder. I’ve also never used nagios, I’m coming from a cacti background. Any help would be greatly appreciated.

Kevin_Krumm · 1 December 2017 17:38

I know you said Nagios plugins but look at the applications https://docs.librenms.org/#Extensions/Applications/
it has one for SQL.

Aso keeps in mind that not all Nagios plugins will work. afik only ones I have seen work are the core plugins.

If was me I just use the applications.

pk8523 · 1 December 2017 17:43

I’m trying to monitor MSSQL will the MYSQL work for that?
Thanks for the clarification with the core plugins.

Kevin_Krumm · 1 December 2017 17:47

not sure but you can look the code and see

github.com

librenms/librenms-agent/blob/master/snmp/mysql

#!/usr/bin/env php
<?php

// MYSQL Check - FIXME
// 1 UNKNOWN

### This script requires php-cli and php-mysql packages

# ============================================================================
# This program is part of Percona Monitoring Plugins
# License: GPL License (see COPYING)
# Copyright 2008-2016 Baron Schwartz, 2012-2016 Percona
# Authors:
#  Baron Schwartz, Roman Vynar
# ============================================================================

# ============================================================================
# To make this code testable, we need to prevent code from running when it is
# included from the test script.  The test script and this file have different
# filenames, so we can compare them.  In some cases $_SERVER['SCRIPT_FILENAME']

This file has been truncated. show original

Kevin_Krumm · 1 December 2017 17:48

Also looks like there is a service check for MySQL https://github.com/librenms/librenms/tree/master/includes/services

pk8523 · 1 December 2017 19:42

I did just find the service and it’s the same one I was trying to get setup.

laf · 2 December 2017 19:42

Once you’ve added that script you linked to into the dir you set as the nagios plugin dir then you should be able to select it as a service check.

When you can, I assume it will still fail as the script doesn’t accept -H hostname, if that’s the case you’ll need a custom service check file to set the arguments correctly. See includes/services/check_domain.inc.php as an example.

pk8523 · 5 December 2017 16:02

Sorry this took so long its been a hell of a week so far.

Im not sure what your suggesting I should be looking at includes/services/check_domain.inc.php. Is that the add on file? On my install they are all in /usr/lib/nagios/plugins.

Also I created the service and assigned it to the server I entered

-v --hostname ServerName --port PORT -f /usr/lib/nagios/mysql.cnf

into the parameters but it doesn’t show me anything. I found the -f switch in a forum that I cant seem to find again but even if I specify --User and --Password I get the same results.

pk8523 · 5 December 2017 16:03

This is what I see after I set the peramiters.

Check various parameters of MySQL databases

Usage:
check_mysql_health [-v] [-t ] [[–hostname ]
[–port