realtebo

# Edit the following file on nagios controller
# 

# add an entry like

define contact {

    contact_name            user_nick_name
    use                     generic-contact
    alias                   Realtebo

realtebo

define host {
    host_name               HostNameWithoutSpecialChars
    hostgroups              NCPA
    address                 139.xx.yyy.zzzz
    check_command           check_ncpa!-t 'community_string' -P 5693 -M system/agent_version
    max_check_attempts      5
    check_interval          5
    retry_interval          1
    check_period            24x7
    contacts                nagiosadmin

realtebo

Configure mysql to log query on file

Change the file /etc/mysql/conf.d/mysql.cnf (require elevated privileges) adding

[mysqld]
general_log = on
general_log_file=/var/log/query

If you change the filename, keep it consistent in the following steps !

realtebo

# Nota - Se eseguendo dpk c'è un errore di comandi non trovati
# su
# nano /root/.bashrc
# appendero in fondo 
# export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
# salvare
# source /root/.bashrc


su

realtebo

#!/usr/bin/env bash
PACKAGES=`apt list --upgradable 2>/dev/null | wc -l`

echo "Trovati $PACKAGES package da aggiornare"

# soglie da default
WARNING=10
CRITICAL=20

# Leggo i valori delle opzioni