'use strict';

try {
    var params = JSON.parse(value);

    // Проверка обязательных параметров
    if (!params.To || params.To.trim() === '') {
        throw 'Параметр "To" (user_id) обязателен!';
    }
    if (!params.Message || params.Message.trim() === '') {
        throw 'Параметр "Message" обязателен!';
    }

    // Формируем сообщение с URL-кодированием (как в shell-скрипте)
    var subject = params.Subject ? encodeURIComponent(params.Subject) : '';
    var message = encodeURIComponent(params.Message);
    var fullMessage = subject ? subject + '%0A' + message : message;

    // Токен доступа VK (замените на свой)
    var vkAccessToken = 'ТОКЕН'; // используйте правильный токен

    // Генерация random_id (аналог od -An -N2 -i /dev/random)
    var randomId = Math.floor(Math.random() * 0x7FFFFFFF); // 31-битное случайное число

    // Параметры запроса в виде строки (для прямой передачи в post)
    var queryString = 'access_token=' + encodeURIComponent(vkAccessToken) +
                      '&user_id=' + encodeURIComponent(params.To.toString()) +
                      '&message=' + fullMessage +
                      '&v=5.199' +
                      '&random_id=' + randomId;

    // Создаем HTTP-запрос
    var req = new HttpRequest();
    req.addHeader('Content-Type: application/x-www-form-urlencoded');

    // Настраиваем прокси (обязательно, если требуется)
    req.setProxy('ВАШ_ПРОКСИ');  // раскомментируйте и укажите свой прокси

    // Отправляем POST-запрос
    var response = req.post('https://api.vk.com/method/messages.send', queryString);

    // Логирование
    Zabbix.Log(4, '[VK Webhook] Request: ' + queryString);
    Zabbix.Log(4, '[VK Webhook] Response: ' + response);

    // Проверяем статус HTTP
    if (req.getStatus() < 200 || req.getStatus() >= 300) {
        throw 'HTTP Error: ' + req.getStatus() + ' - ' + response;
    }

    // Парсим ответ VK
    var respObj = JSON.parse(response);
    if (respObj.error) {
        throw 'VK API Error: ' + JSON.stringify(respObj.error);
    }

    return 'OK';
}
catch (error) {
    Zabbix.Log(3, '[VK Webhook] ERROR: ' + error);
    throw 'Ошибка отправки: ' + error;
}

#!/bin/sh

# Positional args
vk_user_id=$1
vk_subject=$2
vk_message=$3

# Group access token
vk_access_token="ТОКЕН"

# Get random id
vk_random_id=$(od -An -N2 -i /dev/random | tr -d '[:space:]')

# Message template
vk_full_message="$vk_subject%0A$vk_message"

# VK Api link to messages.send method
vk_api_method_url="https://api.vk.com/method/messages.send"

# Прокси (замените на свои данные)
PROXY="ВАШ_ПРОКСИ"

# Execute with proxy
curl -x "$PROXY" \
     -d "access_token=$vk_access_token&user_id=$vk_user_id&message=$vk_full_message&v=5.199&random_id=$vk_random_id" \
     $vk_api_method_url​

### Option: HousekeepingFrequency
# How often Zabbix will perform housekeeping procedure (in hours).
# Housekeeping is removing outdated information from the database.
# To prevent Housekeeper from being overloaded, no more than 4 times HousekeepingFrequency
# hours of outdated information are deleted in one housekeeping cycle, for each item.
# To lower load on server startup housekeeping is postponed for 30 minutes after server start.
# With HousekeepingFrequency=0 the housekeeper can be only executed using the runtime control option.
# In this case the period of outdated information deleted in one housekeeping cycle is 4 times the
# period since the last housekeeping cycle, but not less than 4 hours and not greater than 4 days.
#
# Mandatory: no
# Range: 0-24
# Default:
# HousekeepingFrequency=1

### Option: MaxHousekeeperDelete
# The table "housekeeper" contains "tasks" for housekeeping procedure in the format:
# [housekeeperid], [tablename], [field], [value].
# No more than 'MaxHousekeeperDelete' rows (corresponding to [tablename], [field], [value])
# will be deleted per one task in one housekeeping cycle.
# If set to 0 then no limit is used at all. In this case you must know what you are doing!
#
# Mandatory: no
# Range: 0-1000000
# Default:
# MaxHousekeeperDelete=5000

sudo -u postgres psql -c "SELECT default_version, installed_version FROM pg_available_extensions WHERE name = 'timescaledb';"
default_version | installed_version
-----------------+-------------------
2.24.0 |
(1 row)

sudo -u postgres psql zabbix

SELECT * FROM pg_extension WHERE extname = 'timescaledb';

oid | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-------+-------------+----------+--------------+----------------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------
22287 | timescaledb | 10 | 2200 | f | 2.23.0 | {22313,22314,22347,22364,22363,22388,22387,22407,2 2406,22440,22458,22460,22459,22485,22486,22572,225 91,22628,22645,22657,22669,22676,22687,22708,22720 ,22744,22755,22754} | {"","WHERE id >= 1","","","","","","","","","","","","","WHERE id >= 1000"," WHERE key <> 'uuid' ","","","","","","","","","","","",""}
(1 row)

dpkg -l | grep timescaledb
hi timescaledb-2-loader-postgresql-18 2.24.0~ubuntu24.04-1801 amd64 The loader for TimescaleDB to load individual versions.
hi timescaledb-2-postgresql-18 2.24.0~ubuntu24.04-1801 amd64 An open-source time-series database based on PostgreSQL, as an extension.
ii timescaledb-toolkit-postgresql-18 1:1.22.0~ubuntu24.04 amd64 Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities, compatible with TimescaleDB and PostgreSQL
ii timescaledb-tools 0.18.1~ubuntu24.04 amd64 A suite of tools that can be used with TimescaleDB.

sudo apt install -y timescaledb-2-postgresql-18

sudo timescaledb-tunetimescaledb-tune --version
timescaledb-tune 0.18.1 (linux amd64)

shared_preload_libraries = 'timescaledb'

sudo -u postgres psql -c "SHOW shared_preload_libraries;"
shared_preload_libraries
--------------------------
timescaledb
(1 row)

echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbixcat /usr/share/zabbix/sql-scripts/postgresql/timescaledb/schema.sql | sudo -u zabbix psql zabbix