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

Monitoraggio del risultato di query

• Installare prerequisiti:

sudo apt-get install php5-sybase

• Installare lo script:

sudo mkdir -p /usr/local/lib/nagios/plugins/
sudo wget "https://exchange.nagios.org/components/com_mtree/attachment.php?link_id=497&cf_id=24" -O /usr/local/lib/nagios/plugins/check_mssql_query
sudo chmod -+x /usr/local/lib/nagios/plugins/check_mssql_query

• Definire il check command (attenzione, utilizzare l'FQDN o l'IP, non basta il nome host al check):

# Check MS SQL SERVER QUERY RESULT
# check_mssql_server!username!password!database!query!result
define  command {
    command_name    check-mssql-query
    command_line    /usr/local/lib/nagios/plugins/check_mssql-query -H $HOSTADDRESS$ --username $ARG1$ --password $ARG2$ --database $ARG3$ --query  "$ARG4$" --result "$ARG5$"
}

• Definire il service da testare:

define service{
    use                     generic-service
    host_name               galarchive
    service_description     CUSTOM-SQL-CHECK
    check_command           check-mssql-query!nagios!secretpasword!backup_results!SELECT ReturnCode from backup_results!0
}

Riferimenti

• check_mssql - Nagios Exchange