Clearing zabbix history via SQL

DELETE FROM history_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM history WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM trends_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM trends WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM events WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM alerts WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));

Перевірка закінчення дати делегування домена в Zabbix

в zabbix_agentd.conf

EnableRemoteCommands=1

файл: checkdomain.sh

 #!/bin/bash

DOMAIN="$1"

data=$(whois $1 | grep -E 'paid|Expir|expir' | grep -o -E '[0-9]{4}.[0-9]{2}.[0-9]{2}|[0-9]{2}/[0-9{2}/[0-9]{4}' | tr . / | awk 'NR == 1')
expire=$((`date -d "$data" '+%s'`))
today=$((`date '+%s'`))
lefts=$(($expire - $today))
leftd=$(($lefts/86400))
echo $leftd

Items:

Перевірка терміну придатності SSL-сертифікату в Zabbix

в zabbix_agentd.conf

EnableRemoteCommands=1

файл: checkssl.sh

#!/bin/bash

ssl-cert-check -s $1 -p $2 -n | sed 's/  */ /g' | cut -f6 -d" " | sed -e 's#|days=##'

Items:

 Trigger:

mysql заміна кодування в таблицях і полях на прикладі апгрейда zabbix

Таблиці: 

SELECT CONCAT('ALTER TABLE ',
              table_schema,
              '.',
              table_name,
              ' COLLATE=utf8_bin;') AS cmd 
FROM   (SELECT table_schema, 
               table_name, 
               table_collation 
        FROM   information_schema.tables t 
        WHERE  table_schema = 'zabbix' 
               AND table_collation != 'utf8_bin') AS tables 
ORDER  BY cmd;

Поля:

SELECT CONCAT('ALTER TABLE ',
              table_schema,
              '.',
              table_name,
              ' MODIFY COLUMN ',
              column_name,
              ' ',
              column_type,
              ' CHARACTER SET utf8 COLLATE utf8_bin',
              defaultval,
              nullable,
              ';') AS cmd
FROM   (SELECT table_schema, 
               table_name, 
               column_name, 
               collation_name, 
               character_set_name, 
               column_type, 
               column_default, 
               CASE 
                 WHEN column_default IS NULL THEN '' 
                 ELSE CONCAT(' DEFAULT ''', column_default, ''' ') 
               END AS defaultval, 
               CASE 
                 WHEN is_nullable = 'NO' THEN ' NOT NULL ' 
                 ELSE '' 
               END AS nullable 
        FROM   information_schema.columns 
        WHERE  table_schema = 'zabbix' 
               AND ( collation_name != 'utf8_bin' 
                      OR character_set_name != 'utf8' )) AS cols 
ORDER  BY cmd; 

Zabbix: помилка при icmp ping - Name or service not known

Щоб перевірити чи Zabbix може використовувати команду fping

# su - zabbix -s /bin/bash
su: warning: cannot change directory to /var/lib/zabbix: No such file or directory
-bash-4.2$ fping 111.222.111.222
(null): can't create socket (must run as root?) : Permission denied

Тут очевидна проблема з доступом до fping
Фікс:

# chown root:zabbix /usr/sbin/fping
# chmod 4710 /usr/sbin/fping
# chmod ug+s /usr/sbin/fping

перевіряємо

# su - zabbix -s /bin/bash
Last login: Tue Feb  7 06:35:20 EET 2017 on pts/0
su: warning: cannot change directory to /var/lib/zabbix: No such file or directory
-bash-4.2$ fping 111.222.111.222
111.222.111.222 is alive

Все ок!