Monitoraggio di Microsoft SQL Server con Nagios

Monitoraggio Connessione

• Installare i requisiti

sudo apt-get install python-pymssql

• Installare il plugin

sudo mkdir -p /usr/local/lib/nagios/plugins
sudo wget -O /usr/local/lib/nagios/plugins/check_mssql_server https://raw.githubusercontent.com/NagiosEnterprises/check_mssql_collection/master/check_mssql_server.py
sudo chmod +x /usr/local/lib/nagios/plugins/check_mssql_server

• Creare un utente SQL con privilegi minimi, ad esempio

username: nagios
password: secretpassword

• Testare il plugin

/usr/local/lib/nagios/plugins/check_mssql_database -H marte -U nagios -P secretpassword

OK: Time to connect was 0.00274610519409s|time=0.00274610519409s;;;;

• Definire il check command:

# Check MS SQL SERVER Connection
# check_mssql_server!username!password
define  command {
    command_name    check-mssql-server
    command_line    /usr/local/lib/nagios/plugins/check_mssql_server -H $HOSTADDRESS$ -U $ARG1$ -P $ARG2$ --time2connect
}

• Definire il service check come:

define service{
    use                     generic-service
    host_name               myhost
    service_description     MSSQL
    check_command           check-mssql-server!nagios!secretpassword
}

Riferimenti

• Check MSSQL Database Stats - Nagios Exchange