Skip to content

Instantly share code, notes, and snippets.

View bakaut's full-sized avatar

Nikolai Lebedev bakaut

6 followers · 12 following
  • Tempo
  • Montenegro
  • 17:08 (UTC +01:00)
View GitHub Profile
@bakaut
bakaut / Dockerfile
Last active August 10, 2017 14:08
python-django-docker
FROM debian:jessie
#Setup environment for pyenv
ENV HOME=/root PYENV_ROOT=/opt/pyenv PATH=/opt/pyenv/shims:/opt/pyenv/bin:$PATH DEBIAN_FRONTEND=noninteractive
#Install pyenv requirements https://github.com/yyuu/pyenv/wiki/Common-build-problems#requirements
RUN apt-get update -q && \
apt-get upgrade -q -y && \
apt-get install -y \
build-essential \
@bakaut
bakaut / convert-json.sh
Created August 25, 2017 21:35
#/bin/bash
rm -rf json_keys
data=`cat json.txt`
count=`echo $data| jq keys[]| wc -l`
countin=0
cat <<EOF>> json_keys
{
@bakaut
bakaut / README
Last active January 24, 2019 08:44
Zabbix linux lld discovery example. Parse from json url
Zabbix lld discovery example. Data source url, that return json formated data.
We have a url than provide some data, we want monitor. We want do less, get more. Thus we diside use zabbix lld discovery script and write on python.
Functions:
1. Get from url json, that we have to monitor.
2. Parse it and make output json in zabbix json format.
3. According to script arguments, we can get:
-All data from json.
-All items, that have string type.
@bakaut
bakaut / README
Last active September 3, 2017 19:52
Zabbix lld discovery from json data
Посчитать size_in_bytes для каждого shard
shard0 это сумма сегментов в order 0-0
shard1 это order 0-1
shard2 это order 1-0
shard3 это order 1-1
Посчитатть сумму сегоментов без учёта первого сегмента
@bakaut
bakaut / README
Created September 3, 2017 19:55
Zabbix tip to sort screens
Zabbix tip to sort screens
@bakaut
bakaut / create_host.py
Last active November 7, 2018 07:59
zabbix scripts
import time
import requests
import json
from pyzabbix import ZabbixAPI
post_url = "http://ip/zabbix/api_jsonrpc.php"
'''
@bakaut
bakaut / perfomance turning.txt
Last active July 14, 2018 13:32
postgesql and zabbix
https://zabbix.org/wiki/Docs/howto/zabbix2_postgresql_autopartitioning
https://github.com/kostya/pg_reindex
https://github.com/cavaliercoder/zabbix-pgsql-partitioning
http://www.umgum.com/zabbix-housekeeper-postgresql-vacuum
https://habr.com/company/postgrespro/blog/301238/
http://it-admin.org/?p=1602
https://blog.2ndquadrant.com/autovacuum-tuning-basics/
https://confluence.atlassian.com/kb/optimize-and-improve-postgresql-performance-with-vacuum-analyze-and-reindex-885239781.html
https://lob.com/blog?p=10
https://www.postgresql.org/docs/9.2/static/routine-vacuuming.html
@bakaut
bakaut / 3-15-schema.sql
Last active August 1, 2024 06:53
zabbix scheme sql compare
CREATE TABLE `users` (
`userid` bigint unsigned NOT NULL,
`alias` varchar(100) DEFAULT '' NOT NULL,
`name` varchar(100) DEFAULT '' NOT NULL,
`surname` varchar(100) DEFAULT '' NOT NULL,
`passwd` char(32) DEFAULT '' NOT NULL,
`url` varchar(255) DEFAULT '' NOT NULL,
`autologin` integer DEFAULT '0' NOT NULL,
`autologout` varchar(32) DEFAULT '15m' NOT NULL,
`lang` varchar(5) DEFAULT 'en_GB' NOT NULL,
@bakaut
bakaut / 01-logstash-config-exim-in
Created October 13, 2019 12:55
Exim 4.92 monitoring and logs parse
input {
syslog {
type => syslog
port => 2514
}
}
@bakaut
bakaut / 00-exim-monitoring.md
Last active December 4, 2023 08:57
Exim 4.92 monitoring and logs parse

Настройка парсинга логов exim

rsyslog сервер, на котором установлена elk stak и настроен rsyslog

На хостах exim добавить в cron

root zabbix_sender -z zabbix-server -s "exim_hostname_in_zabbix" -k exim.queue -o `exim -bpc`

Добавить в rsyslog.conf