same => n,Dial(local/101@office&local/102@office,15)exten => _10x,1,NoOp()
same => n,Dial(${PJSIP_DIAL_CONTACTS(${EXTEN})},60,T)
same => n,Hangup()1. Уровень сигнала - http://192.168.1.1/default.html#more/diagnostic.html
2. Настройки сети - http://192.168.1.1/default.html?version=2018-11-12-14-39#settings/routerSetting.html
3. Настройки безопасности - http://192.168.1.1/default.html#settings/adminSetup.html
4. Включение фаервола - http://192.168.1.1/default.html#settings/firewallSetting.html
5. Включение DMZ - http://192.168.1.1/default.html#settings/dmzSetting.html
6. Включение UpnP - http://192.168.1.1/default.html#settings/upnpSetting.html
7. Фильтрация IP - http://192.168.1.1/default.html#settings/ipFilter.html
8. Фильтрация URL - http://192.168.1.1/default.html#settings/urlFilterSetting.htmlSELECT create_hypertable('history', 'clock', chunk_time_interval => 86400, migrate_data => true);
SELECT create_hypertable('history_uint', 'clock', chunk_time_interval => 86400, migrate_data => true);
SELECT create_hypertable('history_log', 'clock', chunk_time_interval => 86400, migrate_data => true);
SELECT create_hypertable('history_text', 'clock', chunk_time_interval => 86400, migrate_data => true);
SELECT create_hypertable('history_str', 'clock', chunk_time_interval => 86400, migrate_data => true);
SELECT create_hypertable('trends', 'clock', chunk_time_interval => 86400, migrate_data => true);
SELECT create_hypertable('trends_uint', 'clock', chunk_time_interval => 86400, migrate_data => true);
UPDATE config SET db_extension='timescaledb', hk_history_global=1, hk_trends_global=1;
UPDATE config SET compression_status=1, compress_older='7d';systemctl restart zabbix-server.service && \
service rh-php72-php-fpm.service restart && \
service rh-nginx116-nginx.service restartSELECT chunk_table,total_bytes FROM chunk_relation_size('history_uint');INSERT INTO history_log select * from history_log_p2020_11_21; DROP table history_log_p2020_11_21;
INSERT INTO history_log select * from history_log_p2020_11_22; DROP table history_log_p2020_11_22;
INSERT INTO history_log select * from history_log_p2020_11_23; DROP table history_log_p2020_11_23;
INSERT INTO history_log select * from history_log_p2020_11_24; DROP table history_log_p2020_11_24;
INSERT INTO history_log select * from history_log_p2020_11_25; DROP table history_log_p2020_11_25;
INSERT INTO history_log select * from history_log_p2020_11_26; DROP table history_log_p2020_11_26;
INSERT INTO history_log select * from history_log_p2020_11_27; DROP table history_log_p2020_11_27;
INSERT INTO history select * from history_p2020_11_21; DROP table history_p2020_11_21;
INSERT INTO history select * from history_p2020_11_22; DROP table history_p2020_11_22;
INSERT INTO history select * from history_p2020_11_23; DROP table history_p2020_11_23;
INSERT INTO history select * from history_p2020_11_24; DROP table history_p2020_11_24;
INSERT INTO history select * from history_p2020_11_25; DROP table history_p2020_11_25;
INSERT INTO history select * from history_p2020_11_26; DROP table history_p2020_11_26;
INSERT INTO history select * from history_p2020_11_27; DROP table history_p2020_11_27;
INSERT INTO history_uint select * from history_uint_p2020_11_21; DROP table history_uint_p2020_11_21;
INSERT INTO history_uint select * from history_uint_p2020_11_22; DROP table history_uint_p2020_11_22;
INSERT INTO history_uint select * from history_uint_p2020_11_23; DROP table history_uint_p2020_11_23;
INSERT INTO history_uint select * from history_uint_p2020_11_24; DROP table history_uint_p2020_11_24;
INSERT INTO history_uint select * from history_uint_p2020_11_25; DROP table history_uint_p2020_11_25;
INSERT INTO history_uint select * from history_uint_p2020_11_26; DROP table history_uint_p2020_11_26;
INSERT INTO history_uint select * from history_uint_p2020_11_27; DROP table history_uint_p2020_11_27;
-- ЗДЕСЬ могут быть ПРОБЛЕМЫ!
INSERT INTO trends select * from trends_p2019_12; DROP table trends_p2019_12;
INSERT INTO trends select * from trends_p2020_01; DROP table trends_p2020_01;
INSERT INTO trends select * from trends_p2020_02; DROP table trends_p2020_02;
INSERT INTO trends select * from trends_p2020_03; DROP table trends_p2020_03;
INSERT INTO trends select * from trends_p2020_04; DROP table trends_p2020_04;
INSERT INTO trends select * from trends_p2020_05; DROP table trends_p2020_05;
INSERT INTO trends select * from trends_p2020_06; DROP table trends_p2020_06;
INSERT INTO trends select * from trends_p2020_07; DROP table trends_p2020_07;
INSERT INTO trends select * from trends_p2020_08; DROP table trends_p2020_08;
INSERT INTO trends select * from trends_p2020_09; DROP table trends_p2020_09;
INSERT INTO trends select * from trends_p2020_10; DROP table trends_p2020_10;
INSERT INTO trends select * from trends_p2020_11; DROP table trends_p2020_11;
INSERT INTO trends_uint select * from trends_uint_p2019_12; DROP table trends_uint_p2019_12;
INSERT INTO trends_uint select * from trends_uint_p2020_01; DROP table trends_uint_p2020_01;
INSERT INTO trends_uint select * from trends_uint_p2020_02; DROP table trends_uint_p2020_02;
INSERT INTO trends_uint select * from trends_uint_p2020_03; DROP table trends_uint_p2020_03;
INSERT INTO trends_uint select * from trends_uint_p2020_04; DROP table trends_uint_p2020_04;
INSERT INTO trends_uint select * from trends_uint_p2020_05; DROP table trends_uint_p2020_05;
INSERT INTO trends_uint select * from trends_uint_p2020_06; DROP table trends_uint_p2020_06;
INSERT INTO trends_uint select * from trends_uint_p2020_07; DROP table trends_uint_p2020_07;
INSERT INTO trends_uint select * from trends_uint_p2020_08; DROP table trends_uint_p2020_08;
INSERT INTO trends_uint select * from trends_uint_p2020_09; DROP table trends_uint_p2020_09;
INSERT INTO trends_uint select * from trends_uint_p2020_10; DROP table trends_uint_p2020_10;
INSERT INTO trends_uint select * from trends_uint_p2020_11; DROP table trends_uint_p2020_11;zabbix=# INSERT INTO trends select * from trends_p2020_06;
ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "trends_pkey"
ПОДРОБНОСТИ: Ключ "(itemid, clock)=(215864, 1592535600)" уже существует.DELETE FROM trends WHERE itemid='215864' AND clock='1592535600';DELETE FROM trends WHERE clock='1592535600';
DELETE FROM trends WHERE clock='1603522800';
DELETE FROM trends WHERE clock='1603476000';
DELETE FROM trends WHERE clock='1603515600';
DELETE FROM trends WHERE clock='1603512000';
DELETE FROM trends_uint WHERE clock='1592535600';
DELETE FROM trends_uint WHERE clock='1603522800';
DELETE FROM trends_uint WHERE clock='1603476000';
DELETE FROM trends_uint WHERE clock='1603515600';
DELETE FROM trends_uint WHERE clock='1603512000';SELECT *
from [oktell].[dbo].[vm_potok]
WHERE data <= DATEADD(mi, -255, GETDATE())
AND (
DATENAME(hour, DATEADD(hh, -7 + [gmt_client], GETDATE())) >= 9
AND
DATENAME( hour, DATEADD(hh, -7 + [gmt_client], GETDATE()) ) < 23
)
UNION
SELECT *
FROM [oktell].[dbo].[vm_potok]
WHERE data <= DATEADD(mi, -255, GETDATE())
AND (
DATENAME(hh, GETDATE()) between 15 and 17 and gmt_client = 13
)[gmt_client] = 13 and DATENAME(hh, GETDATE()) between 15 and 17
externip = ваш_текущий_внешний_IP_адресесли используете chan pjsip, тогда можно использовать так:
1 - так же заменять текущий IP адрес и делать pjsip reload (не помню, поможет ли)
2 - использовать своё внешнее DNS имя
ваш_текущий_внешний_DNS_адрес - должен резолвить на текущий активный IP адрес