Áú»¢¶Ä²©

8 §±§à§Ù§ß§Ñ§ä§Ú §á§â§à§Ò§Ý§Ö§Þ§Ú

§´§Ñ§Ü§à?§Ö §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö: §±§â§à§Ò§Ý§Ö§Þ§Ú §ã§Ñ §Ü§à§Þ§á§Ú§Ý§Ñ§è§Ú?§à§Þ.

§±§à§Ü§â§Ö§ä§Ñ?§Ö §á§â§à§Ü§ã§Ú?§Ñ §ã§Ñ MySQL 8.0.0-8.0.17

zabbix_proxy §ß§Ñ MySQL §Ó§Ö§â§Ù§Ú?§Ñ§Þ§Ñ 8.0.0-8.0.17 §ß§Ö §å§ã§á§Ö§Ó§Ñ §ã§Ñ §ã§Ý§Ö§Õ§Ö?§Ú§Þ §Ô§â§Ö§ê§Ü§Ñ "§á§â§Ú§ã§ä§å§á §à§Õ§Ò§Ú?§Ö§ß":

[Z3001] §Ó§Ö§Ù§Ñ §ã§Ñ §Ò§Ñ§Ù§à§Þ §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ 'zabbix' §ß§Ú?§Ö §å§ã§á§Ö§Ý§Ñ: [1227] §±§â§Ú§ã§ä§å§á §à§Õ§Ò§Ú?§Ö§ß; §á§à§ä§â§Ö§Ò§ß§Ñ §Ó§Ñ§Þ ?§Ö (§Ò§Ñ§â ?§Ö§Õ§ß§Ñ §à§Õ) §á§â§Ú§Ó§Ú§Ý§Ö§Ô§Ú?§Ñ SUPER, SYSTEM_VARIABLES_ADMIN §Ú§Ý§Ú SESSION_VARIABLES_ADMIN §Ù§Ñ §à§Ó§å §à§á§Ö§â§Ñ§è§Ú?§å

§´§à ?§Ö §Ù§Ò§à§Ô §ä§à§Ô§Ñ §ê§ä§à ?§Ö MySQL 8.0.0 §á§à§é§Ö§à §Õ§Ñ §á§â§Ú§Þ§Ö?§å?§Ö §á§à§ã§Ö§Ò§ß§Ö §Õ§à§Ù§Ó§à§Ý§Ö §Ù§Ñ §á§à§ã§ä§Ñ§Ó?§Ñ?§Ö §Ó§Ñ§â§Ú?§Ñ§Ò§Ý§Ú §ã§Ö§ã§Ú?§Ö. §®§Ö?§å§ä§Ú§Þ, §å 8.0.18 §à§Ó§à §á§à§ß§Ñ§ê§Ñ?§Ö ?§Ö §å§Ü§Ý§à?§Ö§ß§à:

§©§Ñ§à§Ò§Ú§Ý§Ñ§Ù§ß§à §â§Ö§ê§Ö?§Ö §ã§Ö §Ù§Ñ§ã§ß§Ú§Ó§Ñ §ß§Ñ §Õ§Ñ§Ó§Ñ?§å §Õ§à§Õ§Ñ§ä§ß§Ú§ç §á§â§Ú§Ó§Ú§Ý§Ö§Ô§Ú?§Ñ zabbix §Ü§à§â§Ú§ã§ß§Ú§Ü:

§©§Ñ MySQL §Ó§Ö§â§Ù§Ú?§Ö 8.0.14 - 8.0.17:

grant SESSION_VARIABLES_ADMIN on *.* to 'zabbix'@'localhost';

§©§Ñ MySQL §Ó§Ö§â§Ù§Ú?§Ö 8.0.0 - 8.0.13:

grant SYSTEM_VARIABLES_ADMIN on *.* to 'zabbix'@'localhost';

§¯§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ñ

§±§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ö §³§¬§­ §â§Ö§Ø§Ú§Þ§Ñ §Ù§Ñ §å§ã§á§Ö§ê§ß§å §ß§Ñ§Õ§à§Ô§â§Ñ§Õ?§å

§±§à§ã§ä§Ñ§Ó§Ü§Ñ sql_mode §å MySQL/MariaDB §Þ§à§â§Ñ §Ú§Þ§Ñ§ä§Ú §á§à§Õ§Ö§ê§Ö§ß §â§Ö§Ø§Ú§Þ "STRICT_TRANS_TABLES". §¡§Ü§à ?§Ö §à§Õ§ã§å§ä§Ñ§ß, §ß§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ñ Áú»¢¶Ä²© §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ß§Ö?§Ö §å§ã§á§Ö§ä§Ú (§á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §ä§Ñ§Ü§à?§Ö ).

§¯§Ñ§Õ§à§Ô§â§Ñ§Õ§Ú§ä§Ö §ã§Ñ MariaDB 10.2.1 §Ú §â§Ñ§ß§Ú?§Ö

§¯§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ñ Áú»¢¶Ä²©-§Ñ §Þ§à§Ø§Õ§Ñ §ß§Ö?§Ö §å§ã§á§Ö§ä§Ú §Ñ§Ü§à §ã§å §ä§Ñ§Ò§Ö§Ý§Ö §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §Ü§â§Ö§Ú§â§Ñ§ß§Ö §á§à§Þ§à?§å MariaDB-§Ñ 10.2.1 §Ú §â§Ñ§ß§Ú?§Ö, ?§Ö§â ?§Ö §å §ä§Ú§Þ §Ó§Ö§â§Ù§Ú?§Ñ§Þ§Ñ §á§à§Õ§â§Ñ§Ù§å§Þ§Ö§Ó§Ñ§ß§Ú §æ§à§â§Þ§Ñ§ä §â§Ö§Õ§Ñ §Ü§à§Þ§á§Ñ§Ü§ä§Ñ§ß. §°§Ó§à §ã§Ö §Þ§à§Ø§Ö §á§à§á§â§Ñ§Ó§Ú§ä§Ú §á§â§à§Þ§Ö§ß§à§Þ §æ§à§â§Þ§Ñ§ä§Ñ §â§Ö§Õ§Ñ §å §Õ§Ú§ß§Ñ§Þ§Ú§é§Ü§Ú (§á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §ä§Ñ§Ü§à?§Ö ).

§º§Ñ§Ò§Ý§à§ß§Ú

§¬§à§Þ§á§Ñ§ä§Ú§Ò§Ú§Ý§ß§à§ã§ä §ê§Ñ§Ò§Ý§à§ß§Ñ §å §à§Ü§â§å§Ø§Ö?§Ú§Þ§Ñ §ã§Ñ §Õ§Ó§Ñ §ã§ä§Ö§Ü§Ñ (IPv4/IPv6).

§µ §à§Ü§â§å§Ø§Ö?§Ú§Þ§Ñ §ã§Ñ §Õ§Ó§à§ã§ä§â§å§Ü§Ú§Þ §ã§ä§Ö§Ü§à§Þ (§ã§Ú§ã§ä§Ö§Þ§Ú §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ã§Ñ§ß§Ú §Õ§Ñ §á§à§Õ§â§Ø§Ñ§Ó§Ñ?§å §Ú §ª§±§Ó4 §Ú §ª§±§Ó6), §Ú§Þ§Ö §Õ§à§Þ§Ñ?§Ú§ß§Ñ localhost §ã§Ö §à§Ò§Ú§é§ß§à §â§Ö§ê§Ñ§Ó§Ñ §å IPv4 §Ú IPv6 §Ñ§Õ§â§Ö§ã§Ö. §©§Ò§à§Ô §å§à§Ò§Ú§é§Ñ?§Ö§ß§à§Ô §á§â§Ú§à§â§Ú§ä§Ö§ä§Ñ IPv6 §ß§Ñ§Õ IPv4 §à§Õ §ã§ä§â§Ñ§ß§Ö §Þ§ß§à§Ô§Ú§ç §à§á§Ö§â§Ñ§ä§Ú§Ó§ß§Ú§ç §ã§Ú§ã§ä§Ö§Þ§Ñ §Ú DNS §â§Ñ§Ù§â§Ö§ê§Ú§Ó§Ñ§é§Ñ, Áú»¢¶Ä²© §ê§Ñ§Ò§Ý§à§ß§Ú §Þ§à§Ø§Õ§Ñ §ß§Ö?§Ö §â§Ñ§Õ§Ú§ä§Ú §Ú§ã§á§â§Ñ§Ó§ß§à §Ñ§Ü§à ?§Ö §å§ã§Ý§å§Ô§Ñ §Ü§à?§Ñ §ã§Ö §ß§Ñ§Õ§Ô§Ý§Ö§Õ§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ã§Ñ§ß§Ñ §Õ§Ñ §ã§Ý§å§ê§Ñ §ã§Ñ§Þ§à §ß§Ñ IPv4.

§µ§ã§Ý§å§Ô§Ö §Ü§à?§Ö §ß§Ú§ã§å §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ã§Ñ§ß§Ö §Õ§Ñ §ã§Ý§å§ê§Ñ?§å IPv6 §Ñ§Õ§â§Ö§ã§Ö §Þ§à§Ô§å §á§à§ã§ä§Ñ§ä§Ú §ß§Ö§Õ§à§ã§ä§å§á§ß§Ö, §ê§ä§à §Õ§à§Ó§à§Õ§Ú §Õ§à §ß§Ö§å§ã§á§Ö§ç§Ñ §å §á§â§Ñ?§Ö?§å. §¬§à§â§Ú§ã§ß§Ú§è§Ú §Þ§à§Ô§å §Ú§ã§á§â§Ñ§Ó§ß§à §Õ§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ê§å §á§â§Ú§ã§ä§å§á §Ù§Ñ IPv4, §Ñ§Ý§Ú §ã§Ö §Ú §Õ§Ñ?§Ö §ã§å§à§é§Ñ§Ó§Ñ?§å §ã§Ñ §á§â§à§Ò§Ý§Ö§Þ§Ú§Þ§Ñ §ã§Ñ §Ó§Ö§Ù§à§Þ §Ù§Ò§à§Ô §á§à§Õ§â§Ñ§Ù§å§Þ§Ö§Ó§Ñ§ß§à§Ô §á§à§ß§Ñ§ê§Ñ?§Ñ §Õ§Ñ§Ó§Ñ?§Ñ §á§â§Ú§à§â§Ú§ä§Ö§ä§Ñ IPv6.

§©§Ñ§à§Ò§Ú§Ý§Ñ§Ù§ß§à §â§Ö§ê§Ö?§Ö §Ù§Ñ §à§Ó§à ?§Ö §Õ§Ñ §ã§Ö §à§ã§Ú§Ô§å§â§Ñ §Õ§Ñ §ã§å §å§ã§Ý§å§Ô§Ö (Nginx, Apache, PostgreSQL, §Ú§ä§Õ.) §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ã§Ñ§ß§Ö §Õ§Ñ §ã§Ý§å§ê§Ñ?§å §Ú §ß§Ñ IPv4 §Ú IPv6 §Ñ§Õ§â§Ö§ã§Ñ§Þ§Ñ, §Ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§å/§Ñ§Ô§Ö§ß§ä§å ?§Ö §Õ§à§Ù§Ó§à?§Ö§ß §á§â§Ú§ã§ä§å§á §á§â§Ö§Ü§à IPv6. §±§à§â§Ö§Õ §ä§à§Ô§Ñ, §å Áú»¢¶Ä²© §ê§Ñ§Ò§Ý§à§ß§Ú§Þ§Ñ §Ú §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú?§Ñ§Þ§Ñ, §Ö§Ü§ã§á§Ý§Ú§è§Ú§ä§ß§à §Ü§à§â§Ú§ã§ä§Ú§ä§Ö localhost §å§Þ§Ö§ã§ä§à 127.0.0.1 §Õ§Ñ §Ò§Ú§ã§ä§Ö §à§ã§Ú§Ô§å§â§Ñ§Ý§Ú §Ü§à§Þ§á§Ñ§ä§Ú§Ò§Ú§Ý§ß§à§ã§ä §Ú §ã§Ñ IPv4 §Ú IPv6.

§¯§Ñ §á§â§Ú§Þ§Ö§â, §Ü§Ñ§Õ§Ñ §ß§Ñ§Õ§Ô§Ý§Ö§Õ§Ñ§ä§Ö PostgreSQL §á§à§Þ§à?§å §ê§Ñ§Ò§Ý§à§ß, §Þ§à§Ø§Õ§Ñ ?§Ö§ä§Ö §Þ§à§â§Ñ§ä§Ú §Õ§Ñ §Ú§Ù§Þ§Ö§ß§Ú§ä§Ö pg_hba.conf §Õ§Ñ §Ò§Ú§ã§ä§Ö §à§Þ§à§Ô§å?§Ú§Ý§Ú §Ó§Ö§Ù§Ö §Ù§Ñ §Ü§à§â§Ú§ã§ß§Ú§Ü§Ñ zbx_monitor. §¡§Ü§à §à§Ü§â§å§Ø§Ö?§Ö §ã§Ñ §Õ§Ó§à§ã§ä§â§å§Ü§Ú§Þ §ã§ä§Ö§Ü§à§Þ §Õ§Ñ?§Ö §á§â§Ú§à§â§Ú§ä§Ö§ä IPv6 (§ã§Ú§ã§ä§Ö§Þ §â§Ö§ê§Ñ§Ó§Ñ localhost §å ::1) §Ú §Ó§Ú §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ê§Ö§ä§Ö localhost §Ñ§Ý§Ú §ã§Ñ§Þ§à §Õ§à§Õ§Ñ§ä§Ö IPv4 §å§ß§à§ã (127.0.0.1/32), §Ó§Ö§Ù§Ñ §ß§Ö?§Ö §å§ã§á§Ö§ä§Ú ?§Ö§â §ß§Ö§Þ§Ñ §á§à§Õ§å§Õ§Ñ§â§Ñ?§Ñ IPv6 §å§ß§à§ã.

§³§Ý§Ö§Õ§Ö?§Ú §á§â§Ú§Þ§Ö§â §Õ§Ñ§ä§à§ä§Ö§Ü§Ö pg_hba.conf §à§Ò§Ö§Ù§Ò§Ö?§å?§Ö §Õ§Ñ §Ü§à§â§Ú§ã§ß§Ú§Ü zbx_monitor §Þ§à§Ø§Ö §Õ§Ñ §ã§Ö §á§à§Ó§Ö§Ø§Ö §ã§Ñ §Ò§Ú§Ý§à §Ü§à?§à§Þ §Ò§Ñ§Ù§à§Þ §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ã§Ñ §Ý§à§Ü§Ñ§Ý§ß§Ö §Þ§Ñ§ê§Ú§ß§Ö §Ü§à§â§Ú§ã§ä§Ö?§Ú IPv4 §Ú IPv6 §Ñ§Õ§â§Ö§ã§Ö §ã§Ñ §â§Ñ§Ù§Ý§Ú§é§Ú§ä§Ú§Þ §Þ§Ö§ä§à§Õ§Ñ§Þ§Ñ §á§â§à§Ó§Ö§â§Ö §Ñ§å§ä§Ö§ß§ä§Ú§é§ß§à§ã§ä§Ú:

# TYPE  DATABASE  USER  ADDRES  SMETHOD
         host  all  zbx_monitor  localhost  trust
         host  all  zbx_monitor127.0.0.1/32  md5
         host  all  zbx_monitor::1/128  scram-sha-256

§¡§Ü§à ?§Ö §á§à§ä§â§Ö§Ò§ß§à, §ä§Ñ§Ü§à?§Ö §Þ§à§Ø§Ö§ä§Ö §Ü§à§â§Ú§ã§ä§Ú§ä§Ú IPv4 §Ñ§Õ§â§Ö§ã§å (127.0.0.1) §Õ§Ú§â§Ö§Ü§ä§ß§à §Ü§Ñ§Õ§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ê§Ö§ä§Ö §ê§Ñ§Ò§Ý§à§ß§ã§Ü§Ú §Þ§Ñ§Ü§â§à §Ù§Ñ §ß§Ú§Ù §Ó§Ö§Ù§Ö.

§³§Ý§å§é§Ñ?§ß§Ñ §Ú§ß§ã§ä§Ñ§Ý§Ñ§è§Ú?§Ñ EPEL Áú»¢¶Ä²© §á§Ñ§Ü§Ö§ä§Ñ

§³§Ñ §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ§ß§Ú§Þ §Ú §à§Þ§à§Ô§å?§Ö§ß§Ú§Þ EPEL §â§Ö§á§à§Ù§Ú§ä§à§â§Ú?§å§Þ§à§Þ, §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ?§Ö Áú»¢¶Ä²©-§Ñ §Ú§Ù §á§Ñ§Ü§Ö§ä§Ñ ?§Ö §Õ§à§Ó§Ö§ã§ä§Ú §Õ§à §ä§à§Ô§Ñ §Õ§Ñ §ã§Ö §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ?§å EPEL Áú»¢¶Ä²© §á§Ñ§Ü§Ö§ä§Ú §å§Þ§Ö§ã§ä§à §Ù§Ó§Ñ§ß§Ú§é§ß§Ú§ç Áú»¢¶Ä²© §á§Ñ§Ü§Ö§ä§Ñ.

§µ §à§Ó§à§Þ §ã§Ý§å§é§Ñ?§å §Õ§Ö§Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ?§ä§Ö Áú»¢¶Ä²© §á§Ñ§Ü§Ö§ä§Ö §Ú§Ù EPEL-§Ñ, §ä?.:

dnf remove zabbix-server-mysql

§¢§Ý§à§Ü§Ú§â§Ñ?§ä§Ö Áú»¢¶Ä²© §á§Ñ§Ü§Ö§ä§Ö §Ú§Ù EPEL-§Ñ. §¥§à§Õ§Ñ?§ä§Ö §ã§Ý§Ö§Õ§Ö?§Ú §â§Ö§Õ §å §Õ§Ñ§ä§à§ä§Ö§Ü§å /etc/yum.conf:

exclude=zabbix7.0*

§±§à§ß§à§Ó§à §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ?§ä§Ö Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â:

dnf install zabbix-server-mysql

§°§Ò§â§Ñ§ä§Ú§ä§Ö §á§Ñ§Ø?§å §Õ§Ñ §Ù§Ó§Ñ§ß§Ú§é§ß§Ú Áú»¢¶Ä²© §á§Ñ§Ü§Ö§ä§Ú §Ú§Þ§Ñ?§å §â§Ö§é release §å §ß§Ú§Ù§å §Ó§Ö§â§Ù§Ú?§Ö:

7.0.0-release1.el8

Áú»¢¶Ä²© §á§Ñ§Ü§Ö§ä§Ú §Ù§Ñ RHEL §ß§Ñ Red Hat UBI §à§Ü§â§å§Ø§Ö?§Ú§Þ§Ñ

§¬§Ñ§Õ§Ñ §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ§ä§Ö Áú»¢¶Ä²© §Ú§Ù Red Hat Enterprise Linux §á§Ñ§Ü§Ö§ä§Ñ §ß§Ñ §à§Ü§â§å§Ø§Ö?§Ñ, §à§Ò§Ö§Ù§Ò§Ö§Õ§Ú§ä§Ö §á§â§Ú§ã§ä§å§á §á§à§ä§â§Ö§Ò§ß§Ú§Þ §â§Ö§á§à§Ù§Ú§ä§à§â§Ú?§å§Þ§Ú§Þ§Ñ §Ú §Ù§Ñ§Ó§Ú§ã§ß§à§ã§ä§Ú§Þ§Ñ. Áú»¢¶Ä²© §á§Ñ§Ü§Ö§ä§Ú §Ù§Ñ§Ó§Ú§ã§Ö §à§Õ §Ò§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§Ñ libOpenIPMI.so §Ú libOpenIPMIposix.so, §Ü§à?§Ö §ß§Ö §à§Ò§Ö§Ù§Ò§Ö?§å?§Ö §ß§Ú?§Ö§Õ§Ñ§ß §á§Ñ§Ü§Ö§ä §å §á§à§Õ§â§Ñ§Ù§å§Þ§Ö§Ó§Ñ§ß§Ú§Þ §â§Ö§á§à§Ù§Ú§ä§à§â§Ú?§å§Þ§Ú§Þ§Ñ §Þ§Ö§ß§Ñ?§Ö§â§Ñ §á§Ñ§Ü§Ö§ä§Ñ §à§Þ§à§Ô§å?§Ö§ß§Ú§Þ §ß§Ñ UBI §ã§Ú§ã§ä§Ö§Þ§Ú§Þ§Ñ §Ú §Õ§à§Ó§Ö§ê?§Ö §Õ§à §ß§Ö§å§ã§á§Ö§ç§Ñ §Ú§ß§ã§ä§Ñ§Ý§Ñ§è§Ú?§Ö.

§¢§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§Ö libOpenIPMI.so §Ú libOpenIPMIposix.so §ã§å §Õ§à§ã§ä§å§á§ß§Ö §å §á§Ñ§Ü§Ö§ä§å OpenIPMI-libs, §Ü§à?§Ú §à§Ò§Ö§Ù§Ò§Ö?§å?§Ö redhat-#-for-<arch>-appstream-rpms §ã§á§â§Ö§Þ§Ú§ê§ä§Ö. §±§â§Ú§ã§ä§å§á §à§Ó§à§Þ §ã§á§â§Ö§Þ§Ú§ê§ä§å ?§Ö §Ü§å§â§Ú§â§Ñ§ß §á§â§Ö§ä§á§Ý§Ñ§ä§Ñ§Þ§Ñ, §Ü§à?§Ö §ã§Ö, §å §ã§Ý§å§é§Ñ?§å UBI §à§Ü§â§å§Ø§Ö?§Ñ, §á§â§à§á§Ñ§Ô§Ú§â§Ñ?§å §Þ§à§ß§ä§Ú§â§Ñ?§Ö§Þ §Õ§Ú§â§Ö§Ü§ä§à§â§Ú?§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú?§Ö §ã§á§â§Ö§Þ§Ú§ê§ä§Ñ §Ú §ä§Ñ?§ß§Ú§ç §Õ§Ú§â§Ö§Ü§ä§à§â§Ú?§Ñ RHEL §Õ§à§Þ§Ñ?§Ú§ß§Ñ §å §Ú§Þ§Ö§ß§ã§Ü§Ú §á§â§à§ã§ä§à§â §ã§Ú§ã§ä§Ö§Þ§Ñ §Õ§Ñ§ä§à§ä§Ö§Ü§Ñ §Ü§à§ß§ä§Ö?§ß§Ö§â§Ñ.

§©§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

§ª§ã§ä§Ö§Ü§Ý§Ú §á§à§ä§á§Ú§ã§Ñ§ß§Ú §Ü?§å§é §Ù§Ñ RHEL §á§Ñ§Ü§Ö§ä§Ö

§¬§Ñ§Õ§Ñ §ß§Ñ§Õ§à§Ô§â§Ñ?§å?§Ö§ä§Ö Áú»¢¶Ä²© §ß§Ñ Red Hat Enterprise Linux §Ú§Ý§Ú ?§Ö§Ô§à§Ó§Ö §Õ§Ö§â§Ú§Ó§Ñ§ä§Ö, §Þ§à§Ø§Õ§Ñ ?§Ö§ä§Ö §ß§Ñ§Ú?§Ú §ß§Ñ §á§â§à§Ò§Ý§Ö§Þ §ã§Ñ §Ú§ã§ä§Ö§Ü§Ý§Ú§Þ §á§à§ä§á§Ú§ã§Ñ§ß§Ú§Þ §Ü?§å§é§Ö§Þ §Ù§Ñ §á§Ñ§Ü§Ö§ä§Ö §å . §¬§Ñ§Õ§Ñ §Ü?§å§é §Ù§Ñ §á§à§ä§á§Ú§ã§Ú§Ó§Ñ?§Ö §Ú§ã§ä§Ö§Ü§ß§Ö, §á§à§Ü§å§ê§Ñ?§Ú §Ó§Ö§â§Ú§æ§Ú§Ü§Ñ§è§Ú?§Ö §á§à§ä§á§Ú§ã§Ñ §á§Ñ§Ü§Ö§ä§Ñ ?§Ö §â§Ö§Ù§å§Ý§ä§Ú§â§Ñ§ä§Ú §Ô§â§Ö§ê§Ü§à§Þ §Ü§à?§Ñ §å§Ü§Ñ§Ù§å?§Ö §Õ§Ñ §ã§Ö§â§ä§Ú§æ§Ú§Ü§Ñ§ä §Ú§Ý§Ú §Ü?§å§é §Ó§Ú§ê§Ö §ß§Ú§ã§å §Ó§Ñ§Ø§Ö?§Ú. §¯§Ñ §á§â§Ú§Þ§Ö§â:

error: Verifying a signature using certificate D9AA84C2B617479C6E4FCF4D19F2475308EFA7DD (Áú»¢¶Ä²© LLC (Jul 2022) <[email protected]>):
         1. Certificiate 19F2475308EFA7DD invalid: certificate is not alive
            because: The primary key is not live
            because: Expired on 2024-07-04T11:41:23Z
         2. Key 19F2475308EFA7DD invalid: key is not alive
            because: The primary key is not live
            because: Expired on 2024-07-04T11:41:23Z

§¥§Ñ §Ò§Ú§ã§ä§Ö §â§Ö§ê§Ú§Ý§Ú §ä§Ñ§Ü§Ó§Ö §á§â§à§Ò§Ý§Ö§Þ§Ö, §â§å§é§ß§à §á§à§ß§à§Ó§à §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ?§ä§Ö §ß§Ñ?§ß§à§Ó§Ú?§Ú zabbix-release §á§Ñ§Ü§Ö§ä §Ù§Ñ §Ó§Ñ§ê§å §ã§á§Ö§è§Ú§æ§Ú§é§ß§å §Ó§Ñ§â§Ú?§Ñ§ß§ä§å RHEL-§Ñ (§Ù§Ñ§Þ§Ö§ß§Ú§ä§Ö §Ó§Ö§Ù§å §Ú§ã§á§à§Õ §Ú§ã§á§â§Ñ§Ó§ß§à§Þ §Ú§Ù ).

§¯§Ñ §á§â§Ú§Þ§Ö§â, §ß§Ñ RHEL 9, §á§à§Ü§â§Ö§ß§Ú§ä§Ö:

rpm -Uvh https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-release-latest.el9.noarch.rpm

§©§Ñ§ä§Ú§Þ §Ñ§Ø§å§â§Ú§â§Ñ?§ä§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ö §à §â§Ö§á§à§Ù§Ú§ä§à§â§Ú?§å§Þ§å:

dnf update

§©§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

TLS §Ó§Ö§Ù§Ñ §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ã§Ñ MariaDB

TLS §Ó§Ö§Ù§Ñ §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ß§Ú?§Ö §á§à§Õ§â§Ø§Ñ§ß§Ñ §ã§Ñ §à§á§è§Ú?§à§Þ 'verify_ca' §Ù§Ñ DBTLSConnect §á§Ñ§â§Ñ§Þ§Ö§ä§Ñ§â §Ñ§Ü§à §ã§Ö §Ü§à§â§Ú§ã§ä§Ú MariaDB.

§®§à§Ô§å?§Ñ §Ò§Ý§à§Ü§Ñ§Õ§Ñ §ã§Ñ MySQL/MariaDB

§¬§Ñ§Õ§Ñ §ã§Ö §â§Ñ§Õ§Ú §á§à§Õ §Ó§Ö§Ý§Ú§Ü§Ú§Þ §à§á§ä§Ö§â§Ö?§Ö?§Ö§Þ §Ú §ã§Ñ §Ó§Ú§ê§Ö §à§Õ ?§Ö§Õ§ß§à§Ô LLD §â§Ñ§Õ§ß§Ú§Ü§Ñ §å§Ü?§å§é§Ö§ß§Ú§ç, §Þ§à§Ô§å?§Ö ?§Ö §ß§Ñ§Ú?§Ú §ß§Ñ §Ù§Ñ§ã§ä§à? §å§Ù§â§à§Ü§à§Ó§Ñ§ß§å §Ô§â§Ö§ê§Ü§à§Þ InnoDB §Ü§à?§Ñ §ã§Ö §à§Õ§ß§à§ã§Ú §ß§Ñ §ã§ä§â§Ñ§ä§Ö§Ô§Ú?§å §Ù§Ñ§Ü?§å§é§Ñ§Ó§Ñ?§Ñ §â§Ö§Õ§à§Ó§Ñ (§á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö ). §¤§â§Ö§ê§Ü§Ñ ?§Ö §Ú§ã§á§â§Ñ§Ó?§Ö§ß§Ñ §å MySQL §à§Õ 8.0.29, §Ñ§Ý§Ú §ß§Ö §Ú §å MariaDB. §©§Ñ §Ó§Ú§ê§Ö §Õ§Ö§ä§Ñ?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

§¤§Ý§à§Ò§Ñ§Ý§ß§Ñ §Ü§à§â§Ö§Ý§Ñ§è§Ú?§Ñ §Õ§à§Ô§Ñ?§Ñ?§Ñ

§¥§à§Ô§Ñ?§Ñ?§Ú §Þ§à§Ø§Õ§Ñ §ß§Ö?§Ö §Ò§Ú§ä§Ú §á§â§Ñ§Ó§Ú§Ý§ß§à §á§à§Ó§Ö§Ù§Ñ§ß§Ú §Ñ§Ü§à §Ó§â§Ö§Þ§Ö§ß§ã§Ü§Ú §Ú§ß§ä§Ö§â§Ó§Ñ§Ý §Ú§Ù§Þ§Ö?§å §á§â§Ó§Ú §Ú §Õ§â§å§Ô§Ú §Õ§à§Ô§Ñ?§Ñ? ?§Ö §Ó§Ö§à§Þ§Ñ §Þ§Ñ§Ý§Ú, §à§Õ§ß§à§ã§ß§à §á§à§Ý§Ñ §ã§Ö§Ü§å§ß§Õ§Ö §Ú §Þ§Ñ?§Ö.

§¯§å§Þ§Ö§â§Ú§é§Ü§Ú (§æ§Ý§à§Ñ§ä) §à§á§ã§Ö§Ô §ä§Ú§á§à§Ó§Ñ §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ã§Ñ PostgreSQL 11 §Ú §ã§ä§Ñ§â§Ú?§Ú§Þ §Ó§Ö§â§Ù§Ú?§Ñ§Þ§Ñ

PostgreSQL 11 §Ú §ã§ä§Ñ§â§Ú?§Ö §Ó§Ö§â§Ù§Ú?§Ö §á§à§Õ§â§Ø§Ñ§Ó§Ñ?§å §ã§Ñ§Þ§à §Ó§â§Ö§Õ§ß§à§ã§ä §å §á§à§Ü§â§Ö§ä§ß§à§Þ §Ù§Ñ§â§Ö§Ù§å §à§á§ã§Ö§Ô §à§Õ §á§â§Ú§Ò§Ý§Ú§Ø§ß§à -1.34E-154 §Õ§à 1.34E+154.

NetBSD 8.0 §Ú §ß§à§Ó§Ú?§Ö

§²§Ñ§Ù§Ý§Ú§é§Ú§ä§Ú Áú»¢¶Ä²© §á§â§à§è§Ö§ã§Ú §ã§Ö §Þ§à§Ô§å §ß§Ñ§ã§å§Þ§Ú§é§ß§à §ã§â§å§ê§Ú§ä§Ú §á§â§Ú §á§à§Ü§â§Ö§ä§Ñ?§å §ß§Ñ NetBSD-§å §Ó§Ö§â§Ù§Ú?§Ö 8.X §Ú 9.X. §´§à ?§Ö §Ù§Ò§à§Ô §á§â§Ö§Þ§Ñ§Ý§Ö §á§à§Õ§â§Ñ§Ù§å§Þ§Ö§Ó§Ñ§ß§Ö §Ó§Ö§Ý§Ú§é§Ú§ß§Ö §ã§ä§Ö§Ü§Ñ (4MB), §Ü§à?§Ú §ã§Ö §Þ§à§â§Ñ §á§à§Ó§Ö?§Ñ§ä§Ú §á§à§Ü§â§Ö§ä§Ñ?§Ö§Þ:

ulimit -s 10240

§©§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §á§à§Ó§Ö§Ù§Ñ§ß§Ú §Ú§Ù§Ó§Ö§ê§ä§Ñ? §à §á§â§à§Ò§Ý§Ö§Þ§å: .

§°§Ô§â§Ñ§ß§Ú§é§Ö?§Ñ §â§Ö§Ô§å§Ý§Ñ§â§ß§à§Ô §Ú§Ù§â§Ñ§Ù§Ñ §å Áú»¢¶Ä²© §Ñ§Ô§Ö§ß§ä§å 2

Áú»¢¶Ä²© §Ñ§Ô§Ö§ß§ä 2 §ß§Ö §á§à§Õ§â§Ø§Ñ§Ó§Ñ lookaheads §Ú lookbehinds §å §â§Ö§Ô§å§Ý§Ñ§â§ß§Ú§Þ §Ú§Ù§â§Ñ§Ù§Ú§Þ§Ñ §Ù§Ò§à§Ô §à§Ô§â§Ñ§ß§Ú§é§Ö?§Ñ §ã§ä§Ñ§ß§Õ§Ñ§â§Õ§ß§Ö §Ò§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§Ö Go regexp.

IPMI §á§â§à§Ó§Ö§â§Ö

IPMI §á§â§à§Ó§Ö§â§Ö §ß§Ö?§Ö §â§Ñ§Õ§Ú§ä§Ú §ã§Ñ §å§Ü?§å§é§Ö§ß§Ú§Þ §ã§ä§Ñ§ß§Õ§Ñ§â§Õ§ß§Ú§Þ §á§Ñ§Ü§Ö§ä§à§Þ §Ò§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§Ö OpenIPMI Debian §á§â§Ö 9 (stretch) §Ú Ubuntu §á§â§Ö 16.04 (xenial). §¥§Ñ §á§à§á§â§Ñ§Ó§Ú§Þ §Õ§Ñ §á§à§ß§à§Ó§à §Ü§à§Þ§á§Ñ?§Ý§Ú§â§Ñ?§ä§Ö OpenIPMI §Ò§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§å §ã§Ñ §à§Þ§à§Ô§å?§Ö§ß§Ú§Þ OpenSSL-§à§Þ §Ü§Ñ§à §ê§ä§à ?§Ö §à§Ò?§Ñ§ê?§Ö§ß§à §å .

SSH §á§â§à§Ó§Ö§â§Ö

• §¯§Ö§Ü§Ö Linux §Õ§Ú§ã§ä§â§Ú§Ò§å§è§Ú?§Ö §Ü§Ñ§à §ê§ä§à §ã§å Debian, Ubuntu §ß§Ö §á§à§Õ§â§Ø§Ñ§Ó§Ñ?§å §ê§Ú§æ§â§à§Ó§Ñ§ß§Ö §á§â§Ú§Ó§Ñ§ä§ß§Ú §Ü?§å§é§Ö§Ó§Ú (§ã§Ñ §á§â§Ú§ã§ä§å§á§ß§à§Þ §æ§â§Ñ§Ù§à§Þ) §Ñ§Ü§à ?§Ö §Ò§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§Ñ libssh2 §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ§ß§Ñ §Ú§Ù §á§Ñ§Ü§Ö§ä§Ú. §±§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Ó§Ú§ê§Ö §Õ§Ö§ä§Ñ?§Ñ.

¨C §¬§Ñ§Õ§Ñ §Ü§à§â§Ú§ã§ä§Ú§ä§Ö libssh 0.9.§Ü §ß§Ñ §ß§Ö§Ü§Ú§Þ Linux §Õ§Ú§ã§ä§â§Ú§Ò§å§è§Ú?§Ñ§Þ§Ñ §ã§Ñ OpenSSH 8, SSH §á§â§à§Ó§Ö§â§Ö §Þ§à§Ô§å §á§à§Ó§â§Ö§Þ§Ö§ß§à §Ú§Ù§Ó§Ö§ã§ä§Ú "§¯§Ö §Þ§à§Ô§å §Õ§Ñ §á§â§à§é§Ú§ä§Ñ§Þ §á§à§Õ§Ñ§ä§Ü§Ö §ã§Ñ SSH §ã§Ö§â§Ó§Ö§â§Ñ". §°§Ó§à ?§Ö §å§Ù§â§à§Ü§à§Ó§Ñ§ß§à §à§Õ libssh (). §¤§â§Ö§ê§Ü§Ñ ?§Ö §à§é§Ö§Ü§Ú§Ó§Ñ§ß§Ñ §Õ§Ñ ?§Ö §á§à§á§â§Ñ§Ó?§Ö§ß§à §ã§ä§Ñ§Ò§Ú§Ý§ß§Ú§Þ §Ú§Ù§Õ§Ñ?§Ö§Þ libssh 0.9.5. §£§Ú§Õ§Ú §ä§Ñ§Ü§à?§Ö §Ù§Ñ §Õ§Ö§ä§Ñ?§Ö.

• §¬§à§â§Ú§ê?§Ö?§Ö §è§Ö§Ó§Ú "|" §å SSH §ã§Ü§â§Ú§á§ä§Ú §Þ§à§Ø§Ö §Õ§à§Ó§Ö§ã§ä§Ú §Õ§à §Ñ §¤§â§Ö§ê§Ü§Ñ "§¯§Ö §Þ§à§Ô§å §Õ§Ñ §á§â§à§é§Ú§ä§Ñ§Þ §á§à§Õ§Ñ§ä§Ü§Ö §ã§Ñ SSH §ã§Ö§â§Ó§Ö§â§Ñ". §µ §à§Ó§à§Þ §ã§Ý§å§é§Ñ?§å §ã§Ö §á§â§Ö§á§à§â§å§é§å?§Ö §Õ§Ñ §ß§Ñ§Õ§à§Ô§â§Ñ§Õ§Ú§ä§Ö §Ó§Ö§â§Ù§Ú?§å §Ò§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§Ö libssh. §´§Ñ§Ü§à?§Ö §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Õ§Ö§ä§Ñ?§Ö.

ODBC §á§â§à§Ó§Ö§â§Ö

• MySQL unixODBC §Õ§â§Ñ?§Ó§Ö§â §ß§Ö §Ò§Ú §ä§â§Ö§Ò§Ñ§Ý§à §Õ§Ñ §ã§Ö §Ü§à§â§Ú§ã§ä§Ú §ã§Ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§à§Þ §Ú§Ý§Ú Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú?§Ö§Þ §Ü§à§Þ§á§Ñ?§Ý§Ú§â§Ñ§ß§Ú§Þ §ß§Ñ MariaDB §Ü§à§ß§Ö§Ü§ä§à§â§å §Ò§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§Ñ §Ú §à§Ò§â§ß§å§ä§à, §Ñ§Ü§à ?§Ö §Þ§à§Ô§å?§Ö, §ä§Ñ§Ü§à?§Ö ?§Ö §Ò§à?§Ö §Ú§Ù§Ò§Ö§Ô§Ñ§Ó§Ñ§ä§Ú §Ü§à§â§Ú§ê?§Ö?§Ö §Ú§ã§ä§à§Ô §Ü§à§ß§Ö§Ü§ä§à§â§Ñ §Ü§Ñ§à §Ú §Õ§â§Ñ?§Ó§Ö§â §Ù§Ò§à§Ô . §±§â§Ö§Õ§Ý§à§Ø§Ö§ß§à §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ö:

  PostgreSQL, SQLite §Ú§Ý§Ú Oracle §Ü§à§ß§Ö§Ü§ä§à§â ¡ú MariaDB §Ú§Ý§Ú MySQL unixODBC §Õ§â§Ñ?§Ó§Ö§â MariaDB §Ü§à§ß§Ö§Ü§ä§à§â ¡ú MariaDB unixODBC §Õ§â§Ñ?§Ó§Ö§â MySQL §Ü§à§ß§Ö§Ü§ä§à§â ¡ú MySQL unixODBC §Õ§â§Ñ?§Ó§Ö§â

§±§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ §Ú §Õ§à§ã§ä§å§á§ß§Ñ §â§Ö§ê§Ö?§Ñ.

• XML §á§à§Õ§Ñ§è§Ú §ä§â§Ñ§Ø§Ö§ß§Ú §à§Õ Microsoft SQL Server §Þ§à§Ô§å §Ò§Ú§ä§Ú §ã§Ü§â§Ñ?§Ö§ß§Ú §ß§Ñ §â§Ñ§Ù§Ý§Ú§é§Ú§ä§Ö §ß§Ñ§é§Ú§ß§Ö §ß§Ñ Linux §Ú UNIX §ã§Ú§ã§ä§Ö§Þ§Ú§Þ§Ñ.

• §±§â§Ú§Þ§Ö?§Ö§ß§à ?§Ö §Õ§Ñ §Ü§à§â§Ú§ê?§Ö?§Ö ODBC §á§â§à§Ó§Ö§â§Ñ§Ó§Ñ §Ù§Ñ §á§â§Ñ?§Ö?§Ö Oracle §Ò§Ñ§Ù§Ñ §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §Ü§à§â§Ú§ã§ä§Ö?§Ú §â§Ñ§Ù§Ý§Ú§é§Ú§ä§Ö §Ó§Ö§â§Ù§Ú?§Ö Oracle Instant Client §Ù§Ñ Linux §å§Ù§â§à§Ü§å?§Ö §á§Ñ§Õ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ.? §´§Ñ§Ü§à?§Ö §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö: , .

• §¡§Ü§à §Ü§à§â§Ú§ã§ä§Ú§ä§Ö FreeTDS UnixODBC §Õ§â§Ñ?§Ó§Ö§â, §á§à§ä§â§Ö§Ò§ß§à ?§Ö §Õ§Ñ §Õ§à§Õ§Ñ§ä§Ö §ß§Ñ§â§Ö§Õ§Ò§å 'SET NOCOUNT ON' §ß§Ñ SQL §å§á§Ú§ä (§ß§Ñ §á§â§Ú§Þ§Ö§â, SET NOCOUNT ON DECLARE @strsql NVARCHAR(max) SET @strsql = ....). §µ §ã§å§á§â§à§ä§ß§à§Þ, §ã§ä§Ñ§Ó§Ü§Ñ §Þ§à§ß§Ú§ä§à§â§Ñ §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §å Áú»¢¶Ä²©-§å §ß§Ö?§Ö §å§ã§á§Ö§ä§Ú §Õ§Ñ §á§â§Ö§å§Ù§Þ§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ö §ã§Ñ §Ô§â§Ö§ê§Ü§à§Þ "SQL §å§á§Ú§ä ?§Ö §Ó§â§Ñ§ä§Ú§à §á§â§Ñ§Ù§Ñ§ß §â§Ö§Ù§å§Ý§ä§Ñ§ä".
  §±§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ.

§¯§Ö§ä§Ñ§é§Ñ§ß §á§Ñ§â§Ñ§Þ§Ö§ä§Ñ§â §Þ§Ö§ä§à§Õ§Ñ §Ù§Ñ§ç§ä§Ö§Ó§Ñ §å §ã§ä§Ñ§Ó§Ü§Ñ§Þ§Ñ

§±§Ñ§â§Ñ§Þ§Ö§ä§Ñ§â §Þ§Ö§ä§à§Õ§Ö §Ù§Ñ§ç§ä§Ö§Ó§Ñ, §Ü§à?§Ú §ã§Ö §Ü§à§â§Ú§ã§ä§Ú §ã§Ñ§Þ§à §å HTTP §á§â§à§Ó§Ö§â§Ñ§Þ§Ñ, §Þ§à§Ø§Ö §Ò§Ú§ä§Ú §á§à§Ô§â§Ö§ê§ß§à §á§à§ã§ä§Ñ§Ó?§Ö§ß§à §ß§Ñ '1', §Ó§â§Ö§Õ§ß§à§ã§ä §Ü§à?§Ñ §ß§Ú?§Ö §á§à§Õ§â§Ñ§Ù§å§Þ§Ö§Ó§Ñ§ß§Ñ §Ù§Ñ §ã§Ó§Ö §ã§ä§Ñ§Ó§Ü§Ö §Ü§Ñ§à §â§Ö§Ù§å§Ý§ä§Ñ§ä §ß§Ñ§Õ§à§Ô§â§Ñ§Õ§Ú§ä§Ö §ã§Ñ Áú»¢¶Ä²© §Ó§Ö§â§Ù§Ú?§Ö §á§â§Ö 4.0. §©§Ñ §Õ§Ö§ä§Ñ?§Ö §à §ä§à§Þ§Ö §Ü§Ñ§Ü§à §Õ§Ñ §à§Ó§à §á§à§á§â§Ñ§Ó§Ú§ä§Ö §ã§Ú§ä§å§Ñ§è§Ú?§å, §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

§£§Ö§Ò §ß§Ñ§Õ§Ô§Ý§Ö§Õ§Ñ?§Ö §Ú HTTP §Ñ§Ô§Ö§ß§ä

Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â §á§â§à§á§å§ê§ä§Ñ §Þ§Ö§Þ§à§â§Ú?§å §ß§Ñ §ß§Ö§Ü§Ú§Þ Linux §Õ§Ú§ã§ä§â§Ú§Ò§å§è§Ú?§Ñ§Þ§Ñ §Ù§Ò§à§Ô §Ü§Ñ§Õ§Ñ "SSL verify peer" ?§Ö §à§Þ§à§Ô§å?§Ö§ß §å §Ó§Ö§Ò §ã§è§Ö§ß§Ñ§â§Ú?§Ú§Þ§Ñ §Ú§Ý§Ú HTTP §Ñ§Ô§Ö§ß§ä§å. §±§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ö §Ú §Õ§à§ã§ä§å§á§ß§Ñ §â§Ö§ê§Ö?§Ñ.

?§Ö§Õ§ß§à§ã§ä§Ñ§Ó§ß§Ö §á§â§à§Ó§Ö§â§Ö

§±§à§ã§ä§à?§Ú §Ô§â§Ö§ê§Ü§Ñ §å fping §Ó§Ö§â§Ù§Ú?§Ñ§Þ§Ñ §ã§ä§Ñ§â§Ú?§Ú§Þ §à§Õ v3.10 §Ü§à?§Ñ §á§à§Ô§â§Ö§ê§ß§à §â§å§Ü§å?§Ö §Õ§å§á§Ý§Ú§Ü§Ñ§ä§Ú echo replay §á§Ñ§Ü§Ö§ä§Ñ. §°§Ó§à §Þ§à§Ø§Ö §Õ§à§Ó§Ö§ã§ä§Ú §Õ§à §ß§Ö§à§é§Ö§Ü§Ú§Ó§Ñ§ß§Ú§ç §â§Ö§Ù§å§Ý§ä§Ñ§ä§Ñ §Ù§Ñ icmpping, icmppingloss, icmppingsec §ã§ä§Ñ§Ó§Ü§Ö. §±§â§Ö§á§à§â§å§é§å?§Ö §ã§Ö §Õ§Ñ §ã§Ö §Ü§à§â§Ú§ã§ä§Ú§ä§Ö §ß§Ñ?§ß§à§Ó§Ú?§å §Ó§Ö§â§Ù§Ú?§å fping. §®§à§Ý§Ú§Þ §Ó§Ñ§ã §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Ó§Ú§ê§Ö §Õ§Ö§ä§Ñ?§Ú§Þ§Ñ.

§¤§â§Ö§ê§Ü§Ö §ã§Ñ §Ú§Ù§Ó§â§ê§Ñ§Ó§Ñ?§Ö§Þ fping-§Ñ §å §Ü§à§ß§ä§Ö?§ß§Ö§â§Ú§Þ§Ñ §Ò§Ö§Ù §Ü§à§â§Ö§ß§Ñ

§¬§Ñ§Õ§Ñ §ã§Ö §Ü§à§ß§ä§Ö?§ß§Ö§â§Ú §á§à§Ü§â§Ö?§å §å §â§Ö§Ø§Ú§Þ§å §Ò§Ö§Ù §Ü§à§â§Ö§ß§Ñ §Ú§Ý§Ú §å §à§Ü§â§å§Ø§Ö?§å §ã§Ñ §à§Õ§â§Ö?§Ö§ß§Ú§Þ §à§Ô§â§Ñ§ß§Ú§é§Ö?§Ú§Þ§Ñ, §Þ§à§Ø§Ö§ä§Ö §ã§Ö §ã§å§à§é§Ú§ä§Ú §ã§Ñ §Ô§â§Ö§ê§Ü§Ñ§Þ§Ñ §å §Ó§Ö§Ù§Ú §ã§Ñ §Ú§Ù§Ó§â§ê§Ñ§Ó§Ñ?§Ö§Þ fping-§Ñ §á§â§Ú§Ý§Ú§Ü§à§Þ §Ú§Ù§Ó§à?§Ö?§Ñ ICMP §á§â§à§Ó§Ö§â§Ñ, §Ü§Ñ§à §ê§ä§à ?§Ö fping: §°§á§Ö§â§Ñ§è§Ú?§Ñ §ß§Ú?§Ö §Õ§à§Ù§Ó§à?§Ö§ß§Ñ §Ú§Ý§Ú §ã§å §Ú§Ù§Ô§å§Ò?§Ö§ß§Ú §ã§Ó§Ú §á§Ñ§Ü§Ö§ä§Ú §Ù§Ñ §ã§Ó§Ö §â§Ö§ã§å§â§ã§Ö.

§¥§Ñ §Ò§Ú§ã§ä§Ö §â§Ö§ê§Ú§Ý§Ú §à§Ó§Ñ? §á§â§à§Ò§Ý§Ö§Þ, §Õ§à§Õ§Ñ?§ä§Ö --cap-add=net_raw §å §Ü§à§Þ§Ñ§ß§Õ§Ö "docker run" §Ú§Ý§Ú "podman run".

§±§à§â§Ö§Õ §ä§à§Ô§Ñ, §Ú§Ù§Ó§â§ê§Ñ§Ó§Ñ?§Ö fping-§Ñ §å §à§Ü§â§å§Ø§Ö?§Ú§Þ§Ñ §Ü§à?§Ñ §ß§Ú§ã§å §â§à§à§ä §Þ§à§Ø§Ö §Ù§Ñ§ç§ä§Ö§Ó§Ñ§ä§Ú §Þ§à§Õ§Ú§æ§Ú§Ü§Ñ§è§Ú?§å sysctl-§Ñ, §ä?.:

sudo sysctl -w "net.ipv4.ping_group_range=0 1995"

§Ô§Õ§Ö ?§Ö "1995" zabbix GID. §©§Ñ §Ó§Ú§ê§Ö §Õ§Ö§ä§Ñ?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

SNMP §á§â§à§Ó§Ö§â§Ö

§¡§Ü§à §ã§Ö §Ü§à§â§Ú§ã§ä§Ú OpenBSD §à§á§Ö§â§Ñ§ä§Ú§Ó§ß§Ú §ã§Ú§ã§ä§Ö§Þ, §Ô§â§Ö§ê§Ü§Ñ §Ò§Ö§Ù §å§á§à§ä§â§Ö§Ò§Ö §å Net-SNMP §Ò§Ú§Ò§Ý§Ú§à§ä§Ö§Ü§Ñ §Õ§à §Ó§Ö§â§Ù§Ú?§Ö 5.7.3 §Þ§à§Ø§Ö §Ú§Ù§Ñ§Ù§Ó§Ñ§ä§Ú §á§Ñ§Õ Áú»¢¶Ä²©-§Ñ §ã§Ö§â§Ó§Ö§â §Ñ§Ü§à ?§Ö §á§Ñ§â§Ñ§Þ§Ö§ä§Ñ§â SourceIP §á§à§ã§ä§Ñ§Ó?§Ö§ß §ß§Ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§å §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú§à§ß§Ú §æ§Ñ?§Ý. §¬§Ñ§à §â§Ö§ê§Ö?§Ö, §ß§Ö§Þ§à?§ä§Ö §á§à§ã§ä§Ñ§Ó?§Ñ§ä§Ú SourceIP §á§Ñ§â§Ñ§Þ§Ö§ä§Ñ§â. §ª§ã§ä§Ú §á§â§à§Ò§Ý§Ö§Þ §Ó§Ñ§Ø§Ú §Ú §Ù§Ñ Linux, §Ñ§Ý§Ú §ß§Ö §å§Ù§â§à§Ü§à§Ó§Ñ§ä§Ú §Õ§Ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â §á§â§Ö§ã§ä§Ñ§ß§Ö §Õ§Ñ §â§Ñ§Õ§Ú. §­§à§Ü§Ñ§Ý§ß§Ñ §Ù§Ñ§Ü§â§á§Ñ §Ù§Ñ §ß§Ö§ä-§ã§ß§Þ§á §á§Ñ§Ü§Ö§ä §ß§Ñ OpenBSD ?§Ö §á§â§Ú§Þ§Ö?§Ö§ß §Ú §Ò§Ú?§Ö §à§Ò?§Ñ§Ó?§Ö§ß §ã§Ñ OpenBSD 6.3.

SNMP §á§à§Õ§Ñ§è§Ú

§±§â§Ú§Þ§Ö?§Ö§ß§Ú §ã§å §ã§Ü§à§Ü§à§Ó§Ú §å SNMP §á§à§Õ§Ñ§è§Ú§Þ§Ñ §Ü§à?§Ú §Þ§à§Ô§å §Ò§Ú§ä§Ú §á§à§Ó§Ö§Ù§Ñ§ß§Ú §ã§Ñ §à§Õ§â§Ö?§Ö§ß§Ú§Þ §æ§Ú§Ù§Ú§é§Ü§Ú §æ§Ñ§Ü§ä§à§â§Ú §Ü§Ñ§à §ê§ä§à §ã§å §ã§Ü§à§Ü§à§Ó§Ú §ß§Ñ§á§à§ß§Ñ §å §Þ§â§Ö§Ø§Ú. §£§Ú§Õ§Ú§ä§Ö §Ó§Ú§ê§Ö §Õ§Ö§ä§Ñ?§Ñ.

SNMP §Ù§Ñ§Þ§Ü§Ö

§±§Ñ§Ü§Ö§ä "net-snmp-perl", §á§à§ä§â§Ö§Ò§Ñ§ß §Ù§Ñ SNMP §Ù§Ñ§Þ§Ü§Ö, ?§Ö §å§Ü§Ý§à?§Ö§ß RHEL 8.0-8.2; §á§à§ß§à§Ó§à §Õ§à§Õ§Ñ§ä§à §å RHEL 8.3.

§¥§Ñ§Ü§Ý§Ö, §Ñ§Ü§à §Ü§à§â§Ú§ã§ä§Ú§ä§Ö RHEL 8.0-8.2, §ß§Ñ?§Ò§à?§Ö §â§Ö§ê§Ö?§Ö ?§Ö §ß§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ñ §ß§Ñ RHEL 8.3.

§´§Ñ§Ü§à?§Ö §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ.

§±§Ñ§Õ §á§â§à§è§Ö§ã§Ñ §å§á§à§Ù§à§â§Ö?§Ñ §å RHEL 7

§¯§Ñ§Ú§ê§Ý§Ú §ã§å §ß§Ñ §ã§Ý§å§é§Ñ?§Ö§Ó§Ö §á§Ñ§Õ§Ñ §á§â§à§è§Ö§ã§Ñ §å§á§à§Ù§à§â§Ö?§Ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ §å RHEL 7. §±§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Õ§Ö§ä§Ñ?§Ö.

§¯§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ñ Áú»¢¶Ä²© §Ñ§Ô§Ö§ß§ä§Ñ 2 (6.0.5 §Ú§Ý§Ú §ã§ä§Ñ§â§Ú?§Ú)

§±§â§Ú§Ý§Ú§Ü§à§Þ §ß§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ö Áú»¢¶Ä²© §Ñ§Ô§Ö§ß§ä§Ñ 2 (§Ó§Ö§â§Ù§Ú?§Ñ 6.0.5 §Ú§Ý§Ú §ã§ä§Ñ§â§Ú?§Ñ) §Ú§Ù §á§Ñ§Ü§Ö§ä§Ñ, §Þ§à§Ø§Ö §Õ§à?§Ú §Õ§à §Ô§â§Ö§ê§Ü§Ö §å §Ü§à§ß§æ§Ý§Ú§Ü§ä§å §Õ§Ñ§ä§à§ä§Ö§Ü§Ñ §å §Ó§Ö§Ù§Ú §ã§Ñ §Õ§à§Õ§Ñ§è§Ú§Þ§Ñ. §¥§Ñ §Ò§Ú§ã§ä§Ö §Ú§ã§á§â§Ñ§Ó§Ú§Ý§Ú §Ô§â§Ö§ê§Ü§å, §ß§Ñ§á§â§Ñ§Ó§Ú§ä§Ö §â§Ö§Ù§Ö§â§Ó§ß§å §Ü§à§á§Ú?§å §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú?§Ö §Ñ§Ô§Ö§ß§ä§Ñ 2 (§Ñ§Ü§à ?§Ö §á§à§ä§â§Ö§Ò§ß§à), §Õ§Ö§Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ?§ä§Ö §Ñ§Ô§Ö§ß§ä§Ñ 2 §Ú §á§à§ß§à§Ó§à §Ô§Ñ §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ?§ä§Ö.

§¯§Ñ §ã§Ú§ã§ä§Ö§Þ§Ú§Þ§Ñ §Ù§Ñ§ã§ß§à§Ó§Ñ§ß§Ú§Þ §ß§Ñ RHEL, §á§à§Ü§â§Ö§ß§Ú§ä§Ö:

dnf remove zabbix-agent2
       dnf install zabbix-agent2

§¯§Ñ §ã§Ú§ã§ä§Ö§Þ§Ú§Þ§Ñ §Ù§Ñ§ã§ß§à§Ó§Ñ§ß§Ú§Þ §ß§Ñ Debian-§å §á§à§Ü§â§Ö§ß§Ú§ä§Ö:

apt remove zabbix-agent2
       apt install zabbix-agent2

§©§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

§±§â§Ö§Ò§Ñ§è§Ú§Ó§Ñ?§Ö §Ý§à§Ü§Ñ§Ý§Ñ §Ü§à§â§Ú§ã§ß§Ú§é§Ü§à§Ô §Ú§ß§ä§Ö§â§æ§Ö?§ã§Ñ

§±§â§Ú§Þ§Ö?§Ö§ß§à ?§Ö §Õ§Ñ §ã§Ö §Ý§à§Ü§Ñ§Ý§Ú§Ù§Ñ§è§Ú?§Ñ §Ü§à§â§Ú§ã§ß§Ú§é§Ü§à§Ô §Ú§ß§ä§Ö§â§æ§Ö?§ã§Ñ §Þ§à§Ø§Ö §á§â§à§Þ§Ö§ß§Ú§ä§Ú §Ò§Ö§Ù §à§é§Ú§Ô§Ý§Ö§Õ§ß§Ö §Ý§à§Ô§Ú§Ü§Ö, §ä?. §ß§Ö§Ü§Ö §ã§ä§â§Ñ§ß§Ú§è§Ö (§Ú§Ý§Ú §Õ§Ö§Ý§à§Ó§Ú §ã§ä§â§Ñ§ß§Ú§è§Ñ) §ã§Ö §á§â§Ú§Ü§Ñ§Ù§å?§å §ß§Ñ ?§Ö§Õ§ß§à§Þ ?§Ö§Ù§Ú§Ü§å §Õ§à§Ü §Õ§â§å§Ô§Ö §ã§ä§â§Ñ§ß§Ú§è§Ö (§Ú§Ý§Ú §Õ§Ö§Ý§à§Ó§Ú §ã§ä§â§Ñ§ß§Ú§è§Ñ) §ß§Ñ §Õ§â§å§Ô§à§Þ ?§Ö§Ù§Ú§Ü§å. §°§Ò§Ú§é§ß§à §ã§Ö §á§â§à§Ò§Ý§Ö§Þ §Þ§à§Ø§Ö §á§à?§Ñ§Ó§Ú§ä§Ú §Ü§Ñ§Õ§Ñ §á§à§ã§ä§à?§Ú §ß§Ö§Ü§à§Ý§Ú§Ü§à §Ü§à§â§Ú§ã§ß§Ú§Ü§Ñ, §ß§Ö§Ü§Ú §à§Õ ?§Ú§ç §Ü§à?§Ú §Ü§à§â§Ú§ã§ä§Ö ?§Ö§Õ§Ñ§ß §Ý§à§Ü§Ñ§Ý, §Õ§à§Ü §Õ§â§å§Ô§Ú §Ü§à§â§Ú§ã§ä§Ö §Õ§â§å§Ô§Ú.

§±§à§Ù§ß§Ñ§ä§à §â§Ö§ê§Ö?§Ö §Ù§Ñ §à§Ó§à ?§Ö §à§ß§Ö§Þ§à§Ô§å?§Ñ§Ó§Ñ?§Ö §Ó§Ú§ê§Ö§ß§Ú§ä§ß§à§Ô §â§Ñ§Õ§Ñ §å PHP-§å §Ú Apache-§å.

§±§â§à§Ò§Ý§Ö§Þ ?§Ö §á§à§Ó§Ö§Ù§Ñ§ß §ã§Ñ §ß§Ñ§é§Ú§ß§à§Þ §ß§Ñ §Ü§à?§Ú §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ö §Ý§à§Ü§Ñ§Ý§Ú§Ù§Ñ§è§Ú?§Ö §æ§å§ß§Ü§è§Ú§à§ß§Ú§ê§Ö : §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ö §à §Ý§à§Ü§Ñ§Ý§Ú§Ù§Ñ§è§Ú?§Ú §ã§Ö §à§Õ§â§Ø§Ñ§Ó§Ñ?§å §á§à §á§â§à§è§Ö§ã§å, §Ñ §ß§Ö §á§à §ß§Ú§ä§Ú. §¥§Ñ§Ü§Ý§Ö §å §Ó§Ú§ê§Ö§ß§Ú§ä§ß§à§Þ §à§Ü§â§å§Ø§Ö?§å, §Ü§Ñ§Õ§Ñ §á§à§ã§ä§à?§Ú §ß§Ö§Ü§à§Ý§Ú§Ü§à §á§â§à?§Ö§Ü§Ñ§ä§Ñ §Ü§à?§Ú §á§à§Ü§â§Ö?§Ö §Ú§ã§ä§Ú Apache §á§â§à§è§Ö§ã, §Þ§à§Ô§å?§Ö ?§Ö §Õ§Ñ §ã§Ö §Ý§à§Ü§Ñ§Ý§Ú§Ù§Ñ§è§Ú?§Ñ §á§â§à§Þ§Ö§ß§Ú §å §Õ§â§å§Ô§à? §ß§Ú§ä§Ú §Ú §ä§à §Þ§Ö?§Ñ §ß§Ñ§é§Ú§ß §ß§Ñ §Ü§à?§Ú §ã§Ö §á§à§Õ§Ñ§è§Ú §Þ§à§Ô§å §à§Ò§â§Ñ§Õ§Ú§ä§Ú §å Áú»¢¶Ä²© §ß§Ú§ä§Ú.

§©§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §á§à§Ó§Ö§Ù§Ñ§ß§Ö §Ú§Ù§Ó§Ö§ê§ä§Ñ?§Ö §à §á§â§à§Ò§Ý§Ö§Þ§Ú§Þ§Ñ:

• (§±§â§à§Ò§Ý§Ö§Þ §ã§Ñ §á§â§Ö§Ò§Ñ§è§Ú§Ó§Ñ?§Ö§Þ §Ý§à§Ü§Ñ§Ý§Ñ §ß§Ñ §Ü§à§â§Ú§ã§ß§Ú§é§Ü§à§Þ §Ú§ß§ä§Ö§â§æ§Ö?§ã§å)
• (§±§â§à§Ò§Ý§Ö§Þ §ã§Ñ §à§Ò§â§Ñ§Õ§à§Þ §Ò§â§à?§Ö§Ó§Ñ §å §Ô§â§Ñ§æ§à§Ó§Ú§Þ§Ñ §Ü§à§â§Ú§ã§ä§Ö?§Ú §æ§å§ß§Ü§è§Ú?§å bcdiv BC Math §æ§å§ß§Ü§è§Ú?§Ö)

§¤§â§Ñ§æ§à§Ó§Ú

§Ý§Ö§ä?§Ö §â§Ñ§é§å§ß§Ñ?§Ö §Ó§â§Ö§Þ§Ö§ß§Ñ

§±§â§à§Þ§Ö§ß§Ö §Ý§Ö§ä?§Ö§Ô §â§Ñ§é§å§ß§Ñ?§Ñ §Ó§â§Ö§Þ§Ö§ß§Ñ (DST) §Õ§à§Ó§à§Õ§Ö §Õ§à §ß§Ö§á§â§Ñ§Ó§Ú§Ý§ß§à§ã§ä§Ú §Ü§Ñ§Õ§Ñ §á§â§Ú§Ü§Ñ§Ù§Ú§Ó§Ñ?§Ö §à§Ù§ß§Ñ§Ü§Ñ X §à§ã§Ö (§Õ§å§á§Ý§Ú§è§Ú§â§Ñ?§Ö §Õ§Ñ§ä§å§Þ§Ñ, §Õ§Ñ§ä§å§Þ §Ü§à?§Ú §ß§Ö§Õ§à§ã§ä§Ñ?§Ö, §Ú§ä§Õ.).

§¡§Ô§â§Ö§Ô§Ñ§è§Ú?§Ñ §Ù§Ò§Ú§â§Ñ

§¬§Ñ§Õ§Ñ §Ü§à§â§Ú§ã§ä§Ú§ä§Ö sum aggregation §ß§Ñ §Ô§â§Ñ§æ§Ú§Ü§à§ß§å §Ù§Ñ §á§Ö§â§Ú§à§Õ §Ü§â§Ñ?§Ú §à§Õ ?§Ö§Õ§ß§à§Ô §ã§Ñ§ä§Ñ, §Ô§â§Ñ§æ§Ú§Ü§à§ß§Ú §ã§Ö §á§â§Ú§Ü§Ñ§Ù§å?§å §ß§Ö§ä§Ñ§é§ß§Ö (§å§Þ§ß§à§Ø§Ö§ß§Ö) §Ó§â§Ö§Õ§ß§à§ã§ä§Ú §Ü§Ñ§Õ§Ñ §á§à§Õ§Ñ§è§Ú §á§à§ä§Ú§é§å §Ú§Ù §ä§â§Ö§ß§Õ§à§Ó§Ñ.

§´§Ö§Ü§ã§ä §ã§Ö §á§â§Ö§Ü§Ý§Ñ§á§Ñ

§©§Ñ §ß§Ö§Ü§Ö ?§Ö§Ù§Ú§Ü§Ö §Ü§à§â§Ú§ã§ß§Ú§é§Ü§à§Ô §Ú§ß§ä§Ö§â§æ§Ö?§ã§Ñ (§ß§á§â. ?§Ñ§á§Ñ§ß§ã§Ü§Ú), §Ý§à§Ü§Ñ§Ý§ß§Ú §æ§à§ß§ä§à§Ó§Ú §Þ§à§Ô§å §Õ§Ñ §Ú§Ù§Ñ§Ù§à§Ó§å §á§â§Ö§Ü§Ý§Ñ§á§Ñ?§Ö §ä§Ö§Ü§ã§ä§Ñ §å §Ý§Ö§Ô§Ö§ß§Õ§Ú §Ô§â§Ñ§æ§Ú§Ü§à§ß§Ñ. §¥§Ñ §Ò§Ú§ã§ä§Ö §ä§à §Ú§Ù§Ò§Ö§Ô§Ý§Ú, §Ü§à§â§Ú§ã§ä§Ú§ä§Ö §Ó§Ö§â§Ù§Ú?§å 2.3.0 (§Ú§Ý§Ú §ß§à§Ó§Ú?§å) PHP GD §Ö§Ü§ã§ä§Ö§ß§Ù§Ú?§Ö.

§¯§Ñ§Õ§Ô§Ý§Ö§Õ§Ñ?§Ö §Õ§Ñ§ä§à§ä§Ö§Ü§Ö §Õ§ß§Ö§Ó§ß§Ú§Ü§Ñ

§³§ä§Ñ§Ó§Ü§Ö log[] §Ú logrt[] §Ó§Ú§ê§Ö §á§å§ä§Ñ §á§à§ß§à§Ó§à §é§Ú§ä§Ñ?§å §Õ§Ñ§ä§à§ä§Ö§Ü§å §Ö§Ó§Ú§Õ§Ö§ß§è§Ú?§Ö §Ú§Ù §á§à§é§Ú?§Ö §Ñ§Ü§à ?§Ö §ã§Ú§ã§ä§Ö§Þ §Õ§Ñ§ä§à§ä§Ö§Ü§Ñ 100% §á§å§ß §Ú §Õ§Ñ§ä§à§ä§Ö§Ü§Ñ §Ö§Ó§Ú§Õ§Ö§ß§è§Ú?§Ö §ã§Ö §Õ§à§Õ§Ñ?§Ö (§á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ù§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ö).

§³§á§à§â§Ú MySQL §å§á§Ú§ä§Ú

Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â §Ô§Ö§ß§Ö§â§Ú§ê§Ö §ã§á§à§â§Ö SELECT §å§á§Ú§ä§Ö §å §ã§Ý§å§é§Ñ?§å §ß§Ö§á§à§ã§ä§à?§Ö?§Ú§ç §Ó§â§Ö§Õ§ß§à§ã§ä§Ú §Ù§Ñ §ã§ä§Ñ§Ó§Ü§Ö. §±§à§Ù§ß§Ñ§ä§à ?§Ö §Õ§Ñ §ã§Ö §à§Ó§Ñ? ?§Ñ§Ó?§Ñ §å §Ó§Ö§â§Ù§Ú?§Ñ§Þ§Ñ MySQL 5.6/5.7 (§Ù§Ñ §á§â§à§ê§Ú§â§Ö§ß§å §Õ§Ú§ã§Ü§å§ã§Ú?§å §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö ), §Ñ, §å §à§Õ§â§Ö?§Ö§ß§Ú§Þ §ã§Ý§å§é§Ñ?§Ö§Ó§Ú§Þ§Ñ, §Þ§à§Ø§Ö §ã§Ö §á§à?§Ñ§Ó§Ú§ä§Ú §Ú§å §Ü§Ñ§ã§ß§Ú?§Ú§Þ §Ó§Ö§â§Ù§Ú?§Ñ§Þ§Ñ MySQL-§Ñ. §©§Ñ§à§Ò§Ú§Ý§Ñ§Ù§ß§à §â§Ö§ê§Ö?§Ö §Ù§Ñ §à§Ó§à ?§Ö §à§ß§Ö§Þ§à§Ô§å?§Ñ§Ó§Ñ?§Ö §Ú§Ý§Ú §à§á§ä§Ú§Þ§Ú§Ù§Ñ§ä§à§â §å MySQL-§å. §ª§Þ§Ñ?§ä§Ö §ß§Ñ §å§Þ§å, §Þ§Ö?§å§ä§Ú§Þ, §Õ§Ñ §à§Ó§à §â§Ö§ê§Ö?§Ö §Þ§à§Ø§Õ§Ñ §ß§Ö?§Ö §â§Ö§ê§Ú§ä§Ú §ã§Ó§Ö §á§â§à§Ò§Ý§Ö§Þ§Ö §å §Ó§Ö§Ù§Ú §ã§Ñ §ã§á§à§â§Ú§Þ §å§á§Ú§ä§Ú§Þ§Ñ.

§³§á§à§â§Ñ §ã§Ú§ß§ç§â§à§ß§Ú§Ù§Ñ§è§Ú?§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú?§Ö §ã§Ñ Oracle-§à§Þ

§³§Ú§ß§ç§â§à§ß§Ú§Ù§Ñ§è§Ú?§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú?§Ö §Þ§à§Ø§Ö §Ò§Ú§ä§Ú §ã§á§à§â§Ñ §å Áú»¢¶Ä²© §Ú§ß§ã§ä§Ñ§Ý§Ñ§è§Ú?§Ñ§Þ§Ñ §ã§Ñ Oracle DB-§à§Þ §Ü§à?§Ö §Ú§Þ§Ñ?§å §Ó§Ö§Ý§Ú§Ü§Ú §Ò§â§à? §ã§ä§Ñ§Ó§Ü§Ú §Ú §Ü§à§â§Ñ§Ü§Ñ §Ù§Ñ §á§â§Ö§ä§ç§à§Õ§ß§å §à§Ò§â§Ñ§Õ§å §ã§ä§Ñ§Ó§Ü§Ú. §°§Ó§à ?§Ö §å§Ù§â§à§Ü§à§Ó§Ñ§ß§à §Ò§â§Ù§Ú§ß§à§Þ §à§Ò§â§Ñ§Õ§Ö §á§à?§Ñ §ä§Ú§á§Ñ nclob Oracle §Þ§Ñ§ê§Ú§ß§Ö §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ.

§¥§Ñ §Ò§Ú§ã§ä§Ö §á§à§Ò§à?§ê§Ñ§Ý§Ú §á§Ö§â§æ§à§â§Þ§Ñ§ß§ã§Ö, §Þ§à§Ø§Ö§ä§Ö §Õ§Ñ §Ü§à§ß§Ó§Ö§â§ä§å?§Ö§ä§Ö §ä§Ú§á§à§Ó§Ö §á§à?§Ñ §Ú§Ù nclob §å nvarchar2 §ä§Ñ§Ü§à §ê§ä§à ?§Ö§ä§Ö §â§å§é§ß§à §á§â§Ú§Þ§Ö§ß§Ú§ä§Ú §Ù§Ñ§Ü§â§á§å §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ [items_nvarchar_prepare.sql]((/../assets/en/manual/installation/items_nvarchar_prepare.sql). §ª§Þ§Ñ?§ä§Ö §ß§Ñ §å§Þ§å §Õ§Ñ ?§Ö §à§Ó§Ñ §Ü§à§ß§Ó§Ö§â§Ù§Ú?§Ñ §ã§Þ§Ñ?§Ú§ä§Ú §Þ§Ñ§Ü§ã§Ú§Þ§Ñ§Ý§ß§å §Ó§Ö§Ý§Ú§é§Ú§ß§å §á§à?§Ñ §ã§Ñ 65535 §Ò§Ñ?§ä§à§Ó§Ñ §ß§Ñ 4000 §Ò§Ñ?§ä§à§Ó§Ñ §Ù§Ñ §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ö §Ù§Ñ §á§â§Ö§ä§ç§à§Õ§ß§å §à§Ò§â§Ñ§Õ§å §ã§ä§Ñ§Ó§Ü§Ö §Ú §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ö §ã§ä§Ñ§Ó§Ü§Ö §Ü§Ñ§à §ê§ä§à §ã§å Description, §á§à?§Ö §ã§ä§Ñ§Ó§Ü§Ö §ã§Ü§â§Ú§á§ä§Ö Script, §±§à?§Ñ §ã§ä§Ñ§Ó§Ü§Ö HTTP §Ñ§Ô§Ö§ß§ä§Ñ Request body §Ú Headers, §á§à?§Ö §ã§ä§Ñ§Ó§Ü§Ö §Ù§Ñ §á§â§Ñ?§Ö?§Ö §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ SQL query. §µ§á§Ú§ä§Ú §Ù§Ñ §à§Õ§â§Ö?§Ú§Ó§Ñ?§Ö §Ú§Þ§Ö§ß§Ñ §ê§Ñ§Ò§Ý§à§ß§Ñ §Ü§à?§Ö §ä§â§Ö§Ò§Ñ §Ú§Ù§Ò§â§Ú§ã§Ñ§ä§Ú §á§â§Ö §á§â§Ú§Þ§Ö§ß§Ö §Ù§Ñ§Ü§â§á§Ö §ã§å §Õ§Ñ§ä§Ú §å §Ù§Ñ§Ü§â§á§Ú §Ü§Ñ§à §Ü§à§Þ§Ö§ß§ä§Ñ§â. §¡§Ý§ä§Ö§â§ß§Ñ§ä§Ú§Ó§ß§à, §Ñ§Ü§à ?§Ö MAX_STRING_SIZE §á§à§Õ§Ö§ê§Ö§ß, §Þ§à§Ø§Ö§ä§Ö §á§â§à§Þ§Ö§ß§Ú§ä§Ú nvarchar2(4000) §å nvarchar2(32767) §å §å§á§Ú§ä§Ú§Þ§Ñ §Ù§Ñ§Ü§â§á§Ö §Õ§Ñ §Ò§Ú§ã§ä§Ö §á§à§ã§ä§Ñ§Ó§Ú§Ý§Ú §à§Ô§â§Ñ§ß§Ú§é§Ö?§Ö §Ó§Ö§Ý§Ú§é§Ú§ß§Ö §á§à?§Ñ §à§Õ 32767 §Ò§Ñ?§ä§à§Ó§Ñ.

§©§Ñ §á§â§à§ê§Ú§â§Ö§ß§å §Õ§Ú§ã§Ü§å§ã§Ú?§å, §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

§´§â§Ñ?§ß§Ñ §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ñ §æ§Ú§Ý§ä§Ö§â§Ñ §Ú§Ù §Ó§Ö§Ù§Ñ

§¬§Ñ§Õ§Ñ §à§ä§Ó§à§â§Ú§ä§Ö §Ó§Ö§Ù§å §Ü§Ñ §ã§ä§â§Ñ§ß§Ú§è§Ú Áú»¢¶Ä²© §Ü§à§â§Ú§ã§ß§Ú§é§Ü§à§Ô §Ú§ß§ä§Ö§â§æ§Ö?§ã§Ñ §Ü§à?§Ñ §ã§Ñ§Õ§â§Ø§Ú §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ñ §æ§Ú§Ý§ä§Ö§â§Ñ, §å§Ü?§å§é§å?§å?§Ú §Ò§Ú§â§Ñ§é §Ó§â§Ö§Þ§Ö§ß§Ñ, §æ§Ú§Ý§ä§Ö§â §ã§Ö §Ñ§å§ä§à§Þ§Ñ§ä§ã§Ü§Ú §é§å§Ó§Ñ §å §Ò§Ñ§Ù§Ú §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §Ù§Ñ §Ü§à§â§Ú§ã§ß§Ú§Ü§Ñ, §Ù§Ñ§Þ§Ö?§å?§å?§Ú §á§â§Ö§ä§ç§à§Õ§ß§à §ã§Ñ§é§å§Ó§Ñ§ß§Ú §æ§Ú§Ý§ä§Ö§â §Ú/§Ú§Ý§Ú §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ñ §ã§Ö§Ý§Ö§Ü§ä§à§â§Ñ §Ó§â§Ö§Þ§Ö§ß§Ñ §Ù§Ñ §ä§å §ã§ä§â§Ñ§ß§Ú§è§å. §°§Ó§Ñ §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ñ §à§ã§ä§Ñ?§å §Ñ§Ü§ä§Ú§Ó§ß§Ñ §ã§Ó§Ö §Õ§à§Ü §Ú§ç §Ü§à§â§Ú§ã§ß§Ú§Ü §â§å§é§ß§à §ß§Ö §Ñ§Ø§å§â§Ú§â§Ñ §Ú§Ý§Ú §â§Ö§ã§Ö§ä§å?§Ö.

§±§â§à§Ò§Ý§Ö§Þ §ã§Ñ IPv6 §Ñ§Õ§â§Ö§ã§à§Þ §å SNMPv3 §Ù§Ñ§Þ§Ü§Ñ§Þ§Ñ

§©§Ò§à§Ô §ß§Ö§ä-§ã§ß§Þ§á §Ô§â§Ö§ê§Ü§Ö, IPv6 §Ñ§Õ§â§Ö§ã§Ñ §Þ§à§Ø§Õ§Ñ §ß§Ö?§Ö §Ò§Ú§ä§Ú §Ú§ã§á§â§Ñ§Ó§ß§à §á§â§Ú§Ü§Ñ§Ù§Ñ§ß§Ñ §Ü§Ñ§Õ§Ñ §Ü§à§â§Ú§ã§ä§Ö?§Ú SNMPv3 §å SNMP §Ù§Ñ§Þ§Ü§Ñ§Þ§Ñ. §©§Ñ §Ó§Ú§ê§Ö §Õ§Ö§ä§Ñ?§Ñ §Ú §Þ§à§Ô§å?§Ö §â§Ö§ê§Ö?§Ö, §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

§ª§ã§Ö§é§Ö§ß§Ñ §Õ§å§Ô§Ñ IPv6 IP §Ñ§Õ§â§Ö§ã§Ñ §å §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ§Þ§Ñ §à §ß§Ö§å§ã§á§Ö§ê§ß§à? §á§â§Ú?§Ñ§Ó§Ú

§±§à§â§å§Ü§Ñ §à §ß§Ö§å§ã§á§Ö§Ý§à§Þ §á§à§Ü§å§ê§Ñ?§å §á§â§Ú?§Ñ§Ó§Ö ?§Ö §á§â§Ú§Ü§Ñ§Ù§Ñ§ä§Ú §ã§Ñ§Þ§à §á§â§Ó§Ú§ç 39 §Ù§ß§Ñ§Ü§à§Ó§Ñ §ã§Ñ§é§å§Ó§Ñ§ß§Ö IP §Ñ§Õ§â§Ö§ã§Ö ?§Ö§â ?§Ö §ä§à §à§Ô§â§Ñ§ß§Ú§é§Ö?§Ö §Ò§â§à?§Ñ §Ù§ß§Ñ§Ü§à§Ó§Ñ §å §Ò§Ñ§Ù§Ú §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §á§à?§Ö. §´§à §Ù§ß§Ñ§é§Ú §Õ§Ñ ?§Ö IPv6 IP §Ñ§Õ§â§Ö§ã§Ö §Õ§å§Ø§Ö §à§Õ 39 §Ù§ß§Ñ§Ü§à§Ó§Ñ §Ò§Ú§ä§Ú §á§â§Ú§Ü§Ñ§Ù§Ñ§ß §ß§Ö§á§à§ä§á§å§ß§à.

Áú»¢¶Ä²© §Ñ§Ô§Ö§ß§ä §á§â§à§Ó§Ö§â§Ñ§Ó§Ñ Windows

§¯§Ö§á§à§ã§ä§à?§Ö?§Ú DNS §å§ß§à§ã§Ú §å §á§Ñ§â§Ñ§Þ§Ö§ä§â§å §³§Ö§â§Ó§Ö§â Áú»¢¶Ä²© §Ñ§Ô§Ö§ß§ä§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú§à§ß§Ú §æ§Ñ?§Ý (zabbix_agentd.conf) §Þ§à§Ø§Ö §á§à§Ó§Ö?§Ñ§ä§Ú Áú»¢¶Ä²© §Ñ§Ô§Ö§ß§ä §Ó§â§Ö§Þ§Ö §à§Õ§Ô§à§Ó§à§â§Ñ §ß§Ñ Windows-§å. §°§Ó§à §ã§Ö §Õ§Ö§ê§Ñ§Ó§Ñ §Ù§Ò§à§Ô Windows DNS §Ü§Ö§ê§Ú§â§Ñ?§Ñ §Õ§Ñ§Ö§Þ§à§ß §ß§Ö §Ü§Ö§ê§å?§Ö §ß§Ö§Ô§Ñ§ä§Ú§Ó§ß§Ö §à§Õ§Ô§à§Ó§à§â§Ö §Ù§Ñ IPv4 §Ñ§Õ§â§Ö§ã§Ö. §®§Ö?§å§ä§Ú§Þ, §Ù§Ñ §¯§Ö§Ô§Ñ§ä§Ú§Ó§ß§Ú §à§Õ§Ô§à§Ó§à§â§Ú IPv6 §Ñ§Õ§â§Ö§ã§Ñ §ã§å §Ü§Ö§ê§Ú§â§Ñ§ß§Ú, §ä§Ñ§Ü§à §Õ§Ñ ?§Ö §Þ§à§Ô§å?§Ö §â§Ö§ê§Ö?§Ö §à§Ó§à ?§Ö §à§ß§Ö§Þ§à§Ô§å?§Ñ§Ó§Ñ?§Ö IPv4 §ß§Ñ §Õ§à§Þ§Ñ?§Ú§ß§å.

YAML §Ú§Ù§Ó§à§Ù/§å§Ó§à§Ù

§±§à§ã§ä§à?§Ö §ß§Ö§Ü§Ú §á§à§Ù§ß§Ñ§ä§Ú §á§â§à§Ò§Ý§Ö§Þ§Ú §ã§Ñ YAML-§à§Þ §Ú§Ù§Ó§à§Ù/§å§Ó§à§Ù:

• §±§à§â§å§Ü§Ö §à §Ô§â§Ö§ê§Ü§Ñ§Þ§Ñ §ã§Ö §ß§Ö §Þ§à§Ô§å §á§â§Ö§Ó§Ö§ã§ä§Ú;
• §£§Ñ§Ø§Ö?§Ú JSON §ã§Ñ §Ö§Ü§ã§ä§Ö§ß§Ù§Ú?§à§Þ §Õ§Ñ§ä§à§ä§Ö§Ü§Ö .yaml §á§à§ß§Ö§Ü§Ñ§Õ §ã§Ö §ß§Ö §Þ§à§Ø§Ö §å§Ó§Ö§ã§ä§Ú;
• §¯§Ö§ß§Ñ§Ó§Ö§Õ§Ö§ß§Ú §Õ§Ñ§ä§å§Þ§Ú §é§Ú§ä?§Ú§Ó§Ú §Ù§Ñ §é§à§Ó§Ö§Ü§Ñ §ã§Ö §Ñ§å§ä§à§Þ§Ñ§ä§ã§Ü§Ú §Ü§à§ß§Ó§Ö§â§ä§å?§å §å Unix §Ó§â§Ö§Þ§Ö§ß§ã§Ü§Ö §à§Ù§ß§Ñ§Ü§Ö.

§¹§Ñ§â§à§Ò?§Ñ§Ü §Ù§Ñ §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ö §ß§Ñ SUSE-§å §ã§Ñ NGNIX-§à§Þ §Ú php-fpm-§à§Þ

§¹§Ñ§â§à§Ò?§Ñ§Ü §Ù§Ñ §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ö §Ü§à§â§Ú§ã§ß§Ú§é§Ü§à§Ô §Ú§ß§ä§Ö§â§æ§Ö?§ã§Ñ §ß§Ö §Þ§à§Ø§Ö §Õ§Ñ §ã§Ñ§é§å§Ó§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú§à§ß§å §Õ§Ñ§ä§à§ä§Ö§Ü§å §ß§Ñ SUSE §ã§Ñ NGINX-§à§Þ + php-fpm. §°§Ó§à ?§Ö §å§Ù§â§à§Ü§à§Ó§Ñ§ß§à §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ö§Þ §å /usr/lib/systemd/system/php-fpm.service ?§Ö§Õ§Ú§ß§Ú§è§Ñ, §Ü§à?§Ñ §ã§á§â§Ö§é§Ñ§Ó§Ñ Áú»¢¶Ä²© §Õ§Ñ §á§Ú§ã§Ñ?§Ö §å /etc. (§å§Ó§Ö§Õ§Ö§ß§à §å ).

§¥§à§ã§ä§å§á§ß§Ö §ã§å §Õ§Ó§Ö §à§á§è§Ú?§Ö §Ù§Ñ §Ù§Ñ§à§Ò§Ú§Ý§Ñ§Ù§ß§à §â§Ö§ê§Ö?§Ö:

• §±§à§ã§ä§Ñ§Ó§Ú§ä§Ö §à§á§è§Ú?§å §ß§Ñ 'true' §å§Þ§Ö§ã§ä§à §ß§Ñ 'full' §å ?§Ö§Õ§Ú§ß§Ú§è§Ú php-fpm systemd.
• §²§å§é§ß§à §ã§Ñ§é§å§Ó§Ñ?§ä§Ö /etc/zabbix/web/zabbix.conf.php §Õ§Ñ§ä§à§ä§Ö§Ü§å.

§±§â§à§ã§Ý§Ö?§Ú§Ó§Ñ?§Ö §Ù§Ñ§Ô§Ý§Ñ§Ó?§Ñ §Ñ§å§ä§à§â§Ú§Ù§Ñ§è§Ú?§Ö

§µ §ß§Ö§Ü§Ú§Þ §ã§Ý§å§é§Ñ?§Ö§Ó§Ú§Þ§Ñ, Apache §Ú§Ý§Ú NGINX §Þ§à§Ô§å §ã§á§â§Ö§é§Ú§ä§Ú §Õ§Ñ §Ù§Ñ§Ô§Ý§Ñ§Ó?§Ö §Ñ§å§ä§à§â§Ú§Ù§Ñ§è§Ú?§Ö §å API §Ù§Ñ§ç§ä§Ö§Ó§Ú§Þ§Ñ §ã§ä§Ú§Ô§ß§å §Õ§à Áú»¢¶Ä²©-§Ñ. §°§Ó§à §Þ§à§Ø§Ö §Õ§Ñ §Ú§Ù§Ñ§Ù§à§Ó§Ö §á§â§à§Ò§Ý§Ö§Þ§Ö §ã§Ñ §Ñ§å§ä§Ö§ß§ä§Ú§æ§Ú§Ü§Ñ§è§Ú?§à§Þ §Ü§Ñ§Õ§Ñ §Ü§à§â§Ú§ã§ä§Ú§ä§Ö Áú»¢¶Ä²© API §Ú§Ý§Ú §å§ã§Ý§å§Ô§Ö ?§Ö§Õ§Ú§ß§ã§ä§Ó§Ö§ß§Ö §á§â§Ú?§Ñ§Ó§Ö (SSO), §Ü§Ñ§à §ê§ä§à ?§Ö SAML §ã§Ñ Okta.

§¥§Ñ §Ò§Ú§ã§ä§Ö §ä§à §â§Ö§ê§Ú§Ý§Ú, §Ñ§Ø§å§â§Ú§â§Ñ?§ä§Ö §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú?§å §ã§Ó§à§Ô §Ó§Ö§Ò §ã§Ö§â§Ó§Ö§â§Ñ.

§©§Ñ Apache, §Ñ§Ü§à §Ô§Ñ §Ü§à§â§Ú§ã§ä§Ú§ä§Ö §Ü§Ñ§à §à§Ò§â§ß§å§ä§Ú §á§â§à§Ü§ã§Ú (§ß§Ö-CGI §á§à§Õ§Ö§ê§Ñ§Ó§Ñ?§Ö), §Õ§à§Õ§Ñ?§ä§Ö §ã§Ý§Ö§Õ§Ö?§å §Õ§Ú§â§Ö§Ü§ä§Ú§Ó§å §å /etc/httpd/conf/httpd.conf (§ß§Ñ §ã§Ú§ã§ä§Ö§Þ§Ú§Þ§Ñ §Ù§Ñ§ã§ß§à§Ó§Ñ§ß§Ú§Þ §ß§Ñ RHEL-§å) §Ú§Ý§Ú /etc/apache2/apache2.conf (§ß§Ñ Debian/Ubuntu §ã§Ú§ã§ä§Ö§Þ§Ú§Þ§Ñ):

SetEnvIfNoCase ^Authorization$ "(.+)" HTTP_AUTHORIZATION=$1

§¡§Ü§à Apache §Õ§Ú§â§Ö§Ü§ä§ß§à §Ú§Ù§Ó§â§ê§Ñ§Ó§Ñ §ã§Ü§â§Ú§á§ä§Ö §Ù§Ñ §à§Ò§â§Ñ§Õ§å §Ù§Ñ§ç§ä§Ö§Ó§Ñ (§ß§á§â., §Ü§à§â§Ú§ê?§Ö?§Ö§Þ mod_cgi), §å§Þ§Ö§ã§ä§à §ä§à§Ô§Ñ §Õ§à§Õ§Ñ?§ä§Ö §ã§Ý§Ö§Õ§Ö?§å §Õ§Ú§â§Ö§Ü§ä§Ú§Ó§å:

CGIPassAuth On

§¯§Ñ§ã§å§á§â§à§ä §ä§à§Þ§Ö, NGINX §Ñ§å§ä§à§Þ§Ñ§ä§ã§Ü§Ú §â§å§Ü§å?§Ö §Ù§Ñ§Ô§Ý§Ñ§Ó?§Ö§Þ §Ñ§å§ä§à§â§Ú§Ù§Ñ§è§Ú?§Ö. §®§Ö?§å§ä§Ú§Þ, §Ñ§Ü§à NGINX §Õ§Ö§Ý§å?§Ö §Ü§Ñ§à §à§Ò§â§ß§å§ä§Ú §á§â§à§Ü§ã§Ú, §Þ§à§Ø§Ö§ä§Ö §Ö§Ü§ã§á§Ý§Ú§è§Ú§ä§ß§à §Õ§Ñ §á§â§à§ã§Ý§Ö§Õ§Ú§ä§Ö §Ù§Ñ§Ô§Ý§Ñ§Ó?§Ö §Ñ§å§ä§à§â§Ú§Ù§Ñ§è§Ú?§Ö §Õ§à§Õ§Ñ§Ó§Ñ?§Ö§Þ §ã§Ý§Ö§Õ§Ö?§Ú§ç §Õ§Ú§â§Ö§Ü§ä§Ú§Ó§Ñ §å /etc/nginx/nginx.conf (§Ù§Ñ §Ó§Ñ§ê§å Áú»¢¶Ä²© §Ý§à§Ü§Ñ§è§Ú?§å §Ü§à§â§Ú§ã§ß§Ú§é§Ü§à§Ô §Ú§ß§ä§Ö§â§æ§Ö?§ã§Ñ):

...
       location / {
       ...
           proxy_set_header Authorization $http_authorization;
           proxy_pass http://backend_server;
       ...
       }

§¯§Ñ§Ü§à§ß §Ñ§Ø§å§â§Ú§â§Ñ?§Ñ §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú?§Ö, §á§à§ß§à§Ó§à §á§à§Ü§â§Ö§ß§Ú§ä§Ö §Ó§Ö§Ò §ã§Ö§â§Ó§Ö§â.

§©§Ñ §Ó§Ú§ê§Ö §Õ§Ö§ä§Ñ?§Ñ, §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö:

• §Ú §Õ§Ú§â§Ö§Ü§ä§Ú§Ó§Ö

Chromium §Ù§Ñ Áú»¢¶Ä²© §Ó§Ö§Ò §ã§Ö§â§Ó§Ú§ã §ß§Ñ Ubuntu 20

§ª§Ñ§Ü§à §å §Ó§Ö?§Ú§ß§Ú §ã§Ý§å§é§Ñ?§Ö§Ó§Ñ, Áú»¢¶Ä²© §Ó§Ö§Ò §ã§Ö§â§Ó§Ú§ã §Þ§à§Ø§Ö §Õ§Ñ §â§Ñ§Õ§Ú §ã§Ñ §å§Ü?§å§é§Ö§ß§Ú§Þ Chromium-§à§Þ Ubuntu 20.04 §Ü§à?§Ú §Ü§à§â§Ú§ã§ä§Ú Chromium §Ú§Ù§Ñ§Ù§Ú§Ó§Ñ §ã§Ý§Ö§Õ§Ö?§å §Ô§â§Ö§ê§Ü§å:

§¯§Ú?§Ö §Þ§à§Ô§å?§Ö §á§â§Ö§å§Ù§Ö§ä§Ú §á§à§Õ§Ñ§ä§Ü§Ö: chrome §ß§Ú?§Ö §å§ã§á§Ö§à §Õ§Ñ §ã§Ö start:cmd_run.go:994:
       §µ§±§°§©§°§²§¦?§¦: §ß§Ö §Þ§à§Ô§å §Ü§â§Ö§Ú§â§Ñ§ä§Ú §Ú§Þ§Ö§ß§Ú§Ü §Ü§à§â§Ú§ã§ß§Ú§é§Ü§Ú§ç §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ: §ß§Ö §Þ§à§Ô§å §Ü§â§Ö§Ú§â§Ñ§ä§Ú 
       "/var/lib/zabbix/snap/chromium/1564": mkdir /var/lib/zabbix: §Õ§à§Ù§Ó§à§Ý§Ñ §à§Õ§Ò§Ú?§Ö§ß§Ñ
       §¨§Ñ§à §ß§Ñ§Þ ?§Ö, §Ü§å?§ß§Ú §Õ§Ú§â§Ö§Ü§ä§à§â§Ú?§Ú §Ú§Ù§Ó§Ñ§ß /home §ä§â§Ö§ß§å§ä§ß§à §ß§Ú§ã§å §á§à§Õ§â§Ø§Ñ§ß§Ú. §±§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö https://forum.snapcraft.io/t/11209 §Ù§Ñ §Õ§Ö§ä§Ñ?§Ö.

§°§Ó§Ñ §Ô§â§Ö§ê§Ü§Ñ §ã§Ö ?§Ñ§Ó?§Ñ §Ù§Ñ§ä§à §ê§ä§à §ã§Ö /var/lib/zabbix §Ü§à§â§Ú§ã§ä§Ú §Ü§Ñ§à §á§à§é§Ö§ä§ß§Ú §Õ§Ú§â§Ö§Ü§ä§à§â§Ú?§å§Þ §Ü§à§â§Ú§ã§ß§Ú§Ü§Ñ 'zabbix'.

MySQL §á§â§Ú§Ý§Ñ§Ô§à?§Ö§ß§Ú §Ü§à§Õ§à§Ó§Ú §Ô§â§Ö§ê§Ñ§Ü§Ñ

§¬§Ñ§Õ§Ñ Áú»¢¶Ä²© §à§ä§Ü§â§Ú?§Ö §Õ§Ñ ?§Ö §á§à§Ù§Ñ§Õ§Ú§ß§ã§Ü§Ñ §Ò§Ñ§Ù§Ñ §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ß§Ö§Õ§à§ã§ä§å§á§ß§Ñ, §ê§Ñ?§Ö §à§Ò§Ñ§Ó§Ö§ê§ä§Ö?§Ö §Ú §ß§Ñ§ã§ä§Ñ§Ó?§Ñ §Õ§Ñ §á§à§Ü§å§ê§Ñ§Ó§Ñ §Õ§Ñ §ã§Ö §á§à§Ó§Ö§Ø§Ö. §©§Ñ §à§Õ§â§Ö?§Ö§ß§Ö §Þ§Ö§ç§Ñ§ß§Ú§Ù§Þ§Ö §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §á§â§Ö§á§à§Ù§ß§Ñ?§å §ã§Ö §ã§á§Ö§è§Ú§æ§Ú§é§ß§Ú §Ü§à§Õ§à§Ó§Ú §Ô§â§Ö§ê§Ñ§Ü§Ñ. §µ MySQL-§å, §à§Ó§Ú §á§â§Ö§á§à§Ù§ß§Ñ§ä§Ú §Ü§à§Õ§à§Ó§Ú §Ô§â§Ö§ê§Ñ§Ü§Ñ §å§Ü?§å§é§å?§å:

• CR_CONN_HOST_ERROR
• CR_SERVER_GONE_ERROR
• CR_CONNECTION_ERROR
• CR_SERVER_LOST
• CR_UNKNOWN_HOST
• ER_SERVER_SHUTDOWN
• ER_ACCESS_DENIED_ERROR
• ER_ILLEGAL_GRANT_FOR_TABLE
• ER_TABLEACCESS_DENIED_ERROR
• ER_UNKNOWN_ERROR

§±§à§â§Ö§Õ §ä§à§Ô§Ñ, §Ü§Ñ§Õ§Ñ §Ü§à§â§Ú§ã§ä§Ú§ä§Ö Áú»¢¶Ä²© §ã§Ñ MySQL §Ú§ß§ã§ä§Ñ§Ý§Ñ§è§Ú?§à§Þ §ß§Ñ Azure-§å, §Ô§Ö§ß§Ö§â§Ú§é§Ü§Ñ §á§à§â§å§Ü§Ñ §à §Ô§â§Ö§ê§è§Ú [9002] §¥§à§ê§Ý§à ?§Ö §Õ§à §ß§Ö§Ü§Ú§ç §Ô§â§Ö§ê§Ñ§Ü§Ñ §Þ§à§Ø§Ö §ã§Ö §á§à?§Ñ§Ó§Ú§ä§Ú §å Áú»¢¶Ä²© §Ý§à§Ô§à§Ó§Ú§Þ§Ñ. §°§Ó§å §á§à§â§å§Ü§å §Ò§Ñ§Ù§Ñ §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ê§Ñ?§Ö Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§å §Ú§Ý§Ú §á§â§à§Ü§ã§Ú?§å. §¥§Ñ §Ò§Ú§ã§ä§Ö §å§ä§Ó§â§Õ§Ú§Ý§Ú §å§Ù§â§à§Ü §Ô§â§Ö§ê§Ü§Ö, §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö Azure §Ý§à§Ô§à§Ó§Ö.

§¯§Ö§Ó§Ñ§Ø§Ö?§Ú §â§Ö§Ô§å§Ý§Ñ§â§ß§Ú §Ú§Ù§â§Ñ§Ù§Ú §ß§Ñ§Ü§à§ß §á§â§Ö§Ý§Ñ§ã§Ü§Ñ §ß§Ñ PCRE2

§µ Áú»¢¶Ä²© 6.0 ?§Ö §Õ§à§Õ§Ñ§ä§Ñ §á§à§Õ§â§ê§Ü§Ñ §Ù§Ñ PCRE2. §ª§Ñ§Ü§à ?§Ö PCRE §Ú §Õ§Ñ?§Ö §á§à§Õ§â§Ø§Ñ§ß, Áú»¢¶Ä²© §Ú§ß§ã§ä§Ñ§Ý§Ñ§è§Ú§à§ß§Ú §á§Ñ§Ü§Ö§ä§Ú §Ù§Ñ RHEL 7 §Ú §ß§à§Ó§Ú?§Ö, SLES (§ã§Ó§Ö §Ó§Ö§â§Ù§Ú?§Ö), Debian 9 §Ú §ß§à§Ó§Ú?§Ö, Ubuntu 16.04 §Ú §ß§à§Ó§Ú?§Ö §ã§å §Ñ§Ø§å§â§Ú§â§Ñ§ß§Ú §Õ§Ñ §Ü§à§â§Ú§ã§ä§Ö PCRE2. §ª§Ñ§Ü§à §á§â§å§Ø§Ñ §Þ§ß§à§Ô§Ö §á§â§Ö§Õ§ß§à§ã§ä§Ú, §á§â§Ö§Ý§Ñ§Ù§Ñ§Ü §ß§Ñ PCRE2 §Þ§à§Ø§Ö §Õ§à§Ó§Ö§ã§ä§Ú §Õ§à §ä§à§Ô§Ñ §Õ§Ñ §à§Õ§â§Ö?§Ö§ß§Ú §á§à§ã§ä§à?§Ö?§Ú PCRE §à§Ò§â§Ñ§ã§è§Ú §â§Ö§Ô§å§Ý§Ñ§â§ß§Ú§ç §Ú§Ù§â§Ñ§Ù§Ñ §á§à§ã§ä§Ñ§ß§å §ß§Ö§Ó§Ñ§Ø§Ö?§Ú §Ú§Ý§Ú §Õ§Ñ §ã§Ö §á§à§ß§Ñ§ê§Ñ?§å §Õ§â§å§Ô§Ñ§é§Ú?§Ö. §°§Ó§à §á§à§ã§Ö§Ò§ß§à §å§ä§Ú§é§Ö §ß§Ñ §à§Ò§â§Ñ§Ù§Ñ§è ^[\w-\.]. §¥§Ñ §Ò§Ú §à§Ó§Ñ? §â§Ö§Ô§Ö§Ü§á §á§à§ß§à§Ó§à §Ò§Ú§à §Ó§Ñ§Ý§Ú§Õ§Ñ§ß §Ò§Ö§Ù §å§ä§Ú§è§Ñ?§Ñ §ß§Ñ §ã§Ö§Þ§Ñ§ß§ä§Ú§Ü§å, §á§â§à§Þ§Ö§ß§Ú§ä§Ö §Ú§Ù§â§Ñ§Ù §å ^[-\w\.] . §°§Ó§à §ã§Ö §Õ§Ö§ê§Ñ§Ó§Ñ §Ù§Ò§à§Ô §é§Ú?§Ö§ß§Ú§è§Ö §Õ§Ñ PCRE2 §ä§â§Ö§ä§Ú§â§Ñ §Ù§ß§Ñ§Ü §è§â§ä§Ú§è§Ö §Ü§Ñ§à §Ô§â§Ñ§ß§Ú§é§ß§Ú§Ü, §ã§ä§Ó§Ñ§â§Ñ?§å?§Ú §à§á§ã§Ö§Ô §å§ß§å§ä§Ñ§â §Ü§Ý§Ñ§ã§Ö §Ü§Ñ§â§Ñ§Ü§ä§Ö§â§Ñ.

§¤§â§Ö§ê§Ü§Ñ §Ó§Ú?§Ö§ä§Ñ §¤§Ö§à§Þ§Ñ§áa

§®§Ñ§á§Ö §å §¤§Ö§à§Þ§Ñ§á §Ó§Ú?§Ö§ä§å §ã§Ö §Þ§à§Ø§Õ§Ñ §ß§Ö?§Ö §á§â§Ñ§Ó§Ú§Ý§ß§à §å§é§Ú§ä§Ñ§ä§Ú §Ñ§Ü§à §ã§ä§Ö §Ú§Ù§Ó§â§ê§Ú§Ý§Ú §ß§Ñ§Õ§à§Ô§â§Ñ§Õ?§å §ã§Ñ §ã§ä§Ñ§â§Ú?§Ö Áú»¢¶Ä²© §Ó§Ö§â§Ù§Ú?§Ö §ã§Ñ NGINX-§à§Þ §Ú §ß§Ú§ã§ä§Ö §á§â§Ö§ê§Ý§Ú §ß§Ñ §ß§à§Ó§å NGINX §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú§à§ß§å §Õ§Ñ§ä§à§ä§Ö§Ü§å §ä§à§Ü§à§Þ §ß§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ö.

§¥§Ñ §Ò§Ú§ã§ä§Ö §â§Ö§ê§Ú§Ý§Ú §á§â§à§Ò§Ý§Ö§Þ, §Þ§à§Ø§Ö§ä§Ö §à§Õ§Ò§Ñ§è§Ú§ä§Ú §ã§ä§Ñ§â§å §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú§à§ß§å §Õ§Ñ§ä§à§ä§Ö§Ü§å, §Ü§à§â§Ú§ã§ä§Ú§ä§Ú §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú§à§ß§å §Õ§Ñ§ä§à§ä§Ö§Ü§å §Ú§Ù §á§Ñ§Ü§Ö§ä§Ñ §ä§â§Ö§ß§å§ä§ß§Ö §Ó§Ö§â§Ù§Ú?§Ö §Ú §á§à§ß§à§Ó§à ?§Ö §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ã§Ñ§ä§Ú §Ü§Ñ§à §ê§ä§à ?§Ö §à§á§Ú§ã§Ñ§ß§à §å §å§á§å§ä§ã§ä§Ó§Ú§Þ§Ñ §Ù§Ñ §á§â§Ö§å§Ù§Ú§Þ§Ñ?§Ö §å §à§Õ§Ö?§Ü§å §Ö. §¬§à§ß§æ§Ú§Ô§å§â§Ú§ê§Ú§ä§Ö PHP §Ù§Ñ Áú»¢¶Ä²© §Ü§à§â§Ú§ã§ß§Ú§é§Ü§Ú §Ú§ß§ä§Ö§â§æ§Ö?§ã.

§¡§Ý§ä§Ö§â§ß§Ñ§ä§Ú§Ó§ß§à, §Þ§à§Ø§Ö§ä§Ö §â§å§é§ß§à §Õ§Ñ §å§â§Ö§Õ§Ú§ä§Ö §á§à§ã§ä§à?§Ö?§å NGINX §Ü§à§ß§æ§Ú§Ô§å§â§Ñ§è§Ú§à§ß§å §Õ§Ñ§ä§à§ä§Ö§Ü§å (§à§Ò§Ú§é§ß§à, /etc/zabbix/nginx.conf). §¥§Ñ §Ò§Ú§ã§ä§Ö §ä§à §å§â§Ñ§Õ§Ú§Ý§Ú, §à§ä§Ó§à§â§Ú§ä§Ö §Õ§Ñ§ä§à§ä§Ö§Ü§å §Ú §á§â§à§ß§Ñ?§Ú§ä§Ö §ã§Ý§Ö§Õ§Ö?§Ú §Ò§Ý§à§Ü:

location ~ /(api\/|conf[^\.]|include|locale|vendor) {
               deny  all;
               return  404;
       }

§©§Ñ§ä§Ú§Þ §Ù§Ñ§Þ§Ö§ß§Ú§ä§Ö §à§Ó§Ñ? §Ò§Ý§à§Ü §ã§Ñ:

location ~ /(api\/|conf[^\.]|include|locale) {
               deny all;
               return  404;
       }
       
       location /vendor {
               deny all;
               return 404;
       }

§³§Ý§å§é§Ñ? §å§á§à§ä§â§Ö§Ò§Ö §ã§Ñ §Ô§Ý§à§Ò§Ñ§Ý§ß§Ú§Þ §Ó§Ñ§â§Ú?§Ñ§Ò§Ý§Ñ§Þ§Ñ §Ü§à?§Ö §ã§Ö §Õ§Ö§Ý§Ö §å §á§à§Ù§Ú§Ó§Ú§Þ§Ñ §Ó§Ö§Ò§ç§å§Ü§Ñ

§±§à§ê§ä§à §ã§Ö §Ô§Ý§à§Ò§Ñ§Ý§ß§Ö §á§â§à§Þ§Ö§ß?§Ú§Ó§Ö §Õ§Ö§Ý§Ö §å §â§Ñ§Ù§Ý§Ú§é§Ú§ä§Ú§Þ §á§à§Ù§Ú§Ó§Ú§Þ§Ñ §Ó§Ö§Ò§ç§å§Ü§Ñ, §ã§Ý§Ö§Õ§Ö?§Ú §Ü§à§Õ ?§Ö §Õ§à§Ó§Ö§ã§ä§Ú §Õ§à §á§à§ã§ä§Ö§á§Ö§ß§à§Ô §á§à§Ó§Ö?§Ñ?§Ñ §Ò§â§à?§Ñ§é§Ñ §Ó§â§Ö§Õ§ß§à§ã§ä§Ú §à§Ù§ß§Ñ§Ü§Ö:

try 
       {
          §Ñ§Ñ = §Ñ§Ñ + 1;
       }
       catch(e)
       {
          §Ñ§Ñ = 0;
       }

       result = {
               'tags': {
                   'endpoint': §Ñ§Ñ
               }
           };
       return JSON.stringify(result);

§±§â§Ö§á§à§â§å§é§å?§Ö §ã§Ö §Ü§à§â§Ú§ê?§Ö?§Ö §Ý§à§Ü§Ñ§Ý§ß§Ú§ç §á§â§à§Þ§Ö§ß?§Ú§Ó§Ú§ç §å§Þ§Ö§ã§ä§à §Ô§Ý§à§Ò§Ñ§Ý§ß§Ú§ç §Õ§Ñ §Ò§Ú§ã§ä§Ö §Ò§Ú§Ý§Ú §ã§Ú§Ô§å§â§ß§Ú §Õ§Ñ §ã§Ó§Ñ§Ü§Ñ §ã§Ü§â§Ú§á§ä§Ñ §â§Ñ§Õ§Ú §ß§Ñ §ã§à§á§ã§ä§Ó§Ö§ß§Ú§Þ §á§à§Õ§Ñ§è§Ú§Þ§Ñ §Ú §Õ§Ñ §ß§Ö§Þ§Ñ §Ü§à§Ý§Ú§Ù§Ú?§Ñ §Ú§Ù§Þ§Ö?§å §Ú§ã§ä§à§Ó§â§Ö§Þ§Ö§ß§Ú§ç §á§à§Ù§Ú§Ó§Ñ.

§±§Ñ§Õ §ã§Ö§â§Ó§Ö§â§Ñ §ã§Ñ PostgreSQL/TimescaleDB §ß§Ñ§Ü§à§ß §ß§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ö §ã§Ñ 7.0

§¯§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ñ §ß§Ñ Áú»¢¶Ä²© 7.0.1 (§Ú§Ý§Ú §ß§à§Ó§Ú?§å) §ã§Ñ Áú»¢¶Ä²© 7.0.0 §ã§Ñ PostgreSQL/TimescaleDB §Õ§à§Ó§à§Õ§Ú §Õ§à §á§Ñ§Õ§Ñ §ã§Ö§â§Ó§Ö§â§Ñ. §°§Ó§Ñ? §á§â§à§Ò§Ý§Ö§Þ ?§Ö §å§Ù§â§à§Ü§à§Ó§Ñ§ß §â§Ö§ê§Ö?§Ö§Þ §á§â§à§Ò§Ý§Ö§Þ§Ñ §ã§Ñ §Ü§à§Þ§á§â§Ö§ã§Ú?§à§Þ §å §ä§Ñ§Ò§Ö§Ý§Ú auditlog §å Áú»¢¶Ä²© 7.0 §Ü§à?§Ö ?§Ö §ß§Ö§á§à§Ó§â§Ñ§ä§ß§à §á§â§à§Þ§Ö§ß§Ú§Ý§à §á§à§Ý§Ú§ä§Ú§Ü§å §Ü§à§Þ§á§â§Ö§ã§Ú?§Ö §ä§Ñ§Ò§Ö§Ý§Ö auditlog.

§¥§Ñ §Ò§Ú§ã§ä§Ö §â§Ö§ê§Ú§Ý§Ú §á§â§à§Ò§Ý§Ö§Þ, §Ú§Ù§Ó§â§ê§Ú§ä§Ö §â§å§é§ß§å §â§Ö§Ü§à§ß§ã§ä§â§å§Ü§è§Ú?§å auditlog §ä§Ñ§Ò§Ö§Ý§Ö. §°§ê§ä§Ö?§Ö§ß§å §ä§Ñ§Ò§Ý§Ú §Þ§à§Ø§Ö§ä§Ö §à§ä§Ü§â§Ú§ä§Ú §á§à§Þ§à?§å §à§Ó§à§Ô §å§á§Ú§ä§Ñ:

SELECT config FROM timescaledb_information.jobs WHERE application_name LIKE 'Compression%' AND hypertable_schema='public' AND hypertable_name='auditlog';.

§¡§Ü§à §å§á§Ú§ä §Ó§â§Ñ§ä§Ú JSON §à§Ò?§Ö§Ü§Ñ§ä §Ü§à?§Ú §ã§Ñ§Õ§â§Ø§Ú §ã§Ó§à?§ã§ä§Ó§à compress_after (§Ü§Ñ§à {"hypertable_id": 14, "compress_after": 612000}), §à§ß§Õ§Ñ §Ò§Ú §ä§â§Ö§Ò§Ñ§Ý§à §Õ§Ñ §á§à§ß§à§Ó§à §ß§Ñ§á§â§Ñ§Ó§Ú§ä§Ö §ä§Ñ§Ò§Ö§Ý§å.

§¯§Ñ??§Ö§Õ§ß§à§ã§ä§Ñ§Ó§ß§Ú?§Ú §ß§Ñ§é§Ú§ß §Ù§Ñ §á§à§ß§à§Ó§ß§à §á§â§Ñ§Ó?§Ö?§Ö §ä§Ñ§Ò§Ö§Ý§Ö auditlog ?§Ö:

CREATE TABLE auditlog_tmp (
           LIKE auditlog INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES
       );
       
       SELECT create_hypertable('auditlog_tmp', 'auditid', chunk_time_interval => 604800,
               time_partitioning_func => 'cuid_timestamp', migrate_data => true, if_not_exists => true);
       
       WITH moved_rows AS (
           DELETE FROM auditlog
           RETURNING *
       )
       INSERT INTO auditlog_tmp
       SELECT * FROM moved_rows;
       
       DROP TABLE auditlog;
       ALTER TABLE auditlog_tmp RENAME TO auditlog;

§±§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ú §Ù§Ñ §à§á§ä§Ú§Þ§Ú§Ù§à§Ó§Ñ§ß§Ú?§Ö §ß§Ñ§é§Ú§ß§Ö §Ù§Ñ §Þ§Ú§Ô§â§Ñ§è§Ú?§å §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ.

§¤§â§Ö§ê§Ü§Ñ §á§â§Ú§Ý§Ú§Ü§à§Þ §à§Ò§ß§Ñ§Ó?§Ñ?§Ñ §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ã§Ñ PostgreSQL/TimescaleDB §ß§Ñ§Ü§à§ß §ß§Ñ§Õ§à§Ô§â§Ñ§Õ?§Ö §ã§Ñ 7.0.0-7.0.4

§¬§à§â§Ú§ê?§Ö?§Ö §Ù§Ñ §Ó§â§Ñ?§Ñ?§Ö §â§Ö§Ù§Ö§â§Ó§ß§Ö §Ü§à§á§Ú?§Ö PostgreSQL/TimescaleDB §Ü§â§Ö§Ú§â§Ñ§ß§Ö §å Áú»¢¶Ä²©-§å 7.0.0-7.0.4 ?§Ö §â§Ö§Ù§å§Ý§ä§Ú§â§Ñ§ä§Ú §ß§Ö§Õ§à§ã§ä§Ñ?§å?§à§Þ error §æ§å§ß§Ü§è§Ú?§à§Þ base36_decode, §ê§ä§à §Õ§à§Ó§à§Õ§Ú §Õ§à §ß§Ö§å§ã§á§Ö§ê§ß§à§Ô §Ó§â§Ñ?§Ñ?§Ñ:

ERROR:function base36_decode(text) does not exist
       LINE 1: CAST(base36_decode(substring(cuid FROM 2 FOR 8))/1000 AS int...
        ^
       HINT:No function matches the given name and argument types. You might need to add explicit type casts.

§°§Ó§Ñ §Ô§â§Ö§ê§Ü§Ñ §ã§Ö ?§Ñ§Ó?§Ñ §á§â§Ú§Ý§Ú§Ü§à§Þ §Ó§â§Ñ?§Ñ?§Ñ §â§Ö§Ù§Ö§â§Ó§ß§Ö §Ü§à§á§Ú?§Ö §ß§Ñ§á§â§Ñ§Ó?§Ö§ß§Ö §á§à§Þ§à?§å .

§¥§Ñ §Ò§Ú§ã§ä§Ö §â§Ö§ê§Ú§Ý§Ú §à§Ó§Ñ? §á§â§à§Ò§Ý§Ö§Þ, §Ù§Ñ§Þ§Ö§ß§Ú§ä§Ö §æ§å§ß§Ü§è§Ú?§å cuid_timestamp §å §Ó§Ñ§ê§à? Áú»¢¶Ä²© §Ò§Ñ§Ù§Ú §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §á§â§Ö §á§â§Ñ§Ó?§Ö?§Ñ §â§Ö§Ù§Ö§â§Ó§ß§Ö §Ü§à§á§Ú?§Ö (§á§â§Ö§á§à§â§å§é§å?§Ö §ã§Ö §Ù§Ñ§å§ã§ä§Ñ§Ó?§Ñ?§Ö PostgreSQL/TimescaleDB §á§â§Ö §á§à§Ü§â§Ö§ä§Ñ?§Ñ §ã§Ü§â§Ú§á§ä§Ö):

CREATE OR REPLACE FUNCTION cuid_timestamp(cuid varchar(25)) RETURNS integer AS $$
       DECLARE
           base36 varchar;
           a char[];
           ret bigint;
           i int;
           val int;
           chars varchar;
       BEGIN
           base36 := substring(cuid FROM 2 FOR 8);
       
           chars := '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';
       
           FOR i IN REVERSE char_length(base36)..1 LOOP
              a := a || substring(upper(base36) FROM i FOR 1)::char;
           END LOOP;
           i := 0;
           ret := 0;
           WHILE i < (array_length(a, 1)) LOOP
               val := position(a[i + 1] IN chars) - 1;
               ret := ret + (val * (36 ^ i));
               i := i + 1;
           END LOOP;
       
           RETURN CAST(ret/1000 AS integer);
       END;
       $$ LANGUAGE 'plpgsql' IMMUTABLE;
       DROP FUNCTION IF EXISTS base36_decode(character varying);

§´§Ñ§Ü§à?§Ö §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö (§Ù§Ñ §Õ§à§Õ§Ñ§ä§ß§Ö §Õ§Ö§ä§Ñ?§Ö §à §Ô§â§Ö§ê§è§Ú) §Ú (§Ù§Ñ §Õ§à§Õ§Ñ§ä§ß§Ö §à§á§è§Ú?§Ö §á§â§Ñ§Ó?§Ö?§Ñ §â§Ö§Ù§Ö§â§Ó§ß§Ú§ç §Ü§à§á§Ú?§Ñ §Ú §Ó§â§Ñ?§Ñ?§Ñ).

§¤§â§å§á§Ö §á§â§à§è§Ö§ã§à§â§Ñ §ß§Ñ Windows-§å

Microsoft §Õ§à§Ü§å§Þ§Ö§ß§ä§Ñ§è§Ú?§Ñ §ß§Ñ§Ó§à§Õ§Ú §Õ§Ñ §ã§Ú§ã§ä§Ö§Þ§Ú §ã§Ñ §Þ§Ñ?§Ö §à§Õ 64 §Ý§à§Ô§Ú§é§Ü§Ñ §á§â§à§è§Ö§ã§à§â§Ñ §å§Ó§Ö§Ü §Ú§Þ§Ñ?§å ?§Ö§Õ§ß§å §Ô§â§å§á§å §á§â§à§è§Ö§ã§à§â§Ñ, §¤§â§å§á§å 0. §®§Ö?§å§ä§Ú§Þ, Áú»¢¶Ä²© §Ü§à§â§Ú§ã§ß§Ú§è§Ú §ã§å §á§â§Ú?§Ñ§Ó§Ú§Ý§Ú §â§Ö§ä§Ü§å §Ô§â§Ö§ê§Ü§å , §Ü§Ñ§Õ§Ñ §á§à§ã§ä§à?§Ö §Õ§Ó§Ö §Ô§â§å§á§Ö §á§â§à§è§Ö§ã§à§â§Ñ §ß§Ñ §ã§Ú§ã§ä§Ö§Þ§Ú§Þ§Ñ §ã§Ñ 64 §Ú§Ý§Ú §Þ§Ñ?§Ö §Ý§à§Ô§Ú§é§Ü§Ú§ç §á§â§à§è§Ö§ã§à§â§Ñ. §°§Ó§à ?§Ö §Õ§à§Ó§Ö§Ý§à §Õ§à §ä§à§Ô§Ñ §Õ§Ñ §Ú§Þ§Ñ§Þ§à "(n)" §Ò§â§à?§Ñ§é§Ö §á§Ö§â§æ§à§â§Þ§Ñ§ß§ã§Ú §ã§Ñ§Þ§à §Ù§Ñ ?§Ö§Õ§ß§å §à§Õ §Õ§Ó§Ö §Ô§â§å§á§Ö §á§â§à§è§Ö§ã§à§â§Ñ. §³§ä§Ó§Ñ§â§ß§Ú §à§ã§ß§à§Ó§ß§Ú §å§Ù§â§à§Ü §à§Ó§Ö §Ô§â§Ö§ê§Ü§Ö §ß§Ú?§Ö §á§à§Ù§ß§Ñ§ä. §®§Ö?§å§ä§Ú§Þ, §ã§Ý§Ú§é§Ñ§ß §ã§Ý§å§é§Ñ? ?§Ö §à§á§Ú§ã§Ñ§ß §ß§Ñ , §Ñ §à§ã§ß§à§Ó§ß§Ú §å§Ù§â§à§Ü ?§Ö §Ò§Ú§à §å §Ú§ß§ä§Ö§â§Ñ§Ü§è§Ú?§Ú §Ú§Ù§Þ§Ö?§å BIOS-§Ñ §Ú Windows-§Ñ.

§°§Ô§â§Ñ§ß§Ú§é§Ö?§Ñ §æ§Ú§Ý§ä§â§Ú§â§Ñ?§Ñ §ã§Ñ utf8mb4 §Ü§à§Ý§Ñ§è§Ú?§Ñ§Þ§Ñ

§¶§Ú§Ý§ä§Ö§â§Ú (§ß§á§â, §å §±§â§Ú§Ü§å§á?§Ñ?§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ ¡ú §°§Õ§â§Ø§Ñ§Ó§Ñ?§Ö) §Þ§à§Ø§Õ§Ñ §ß§Ö?§Ö §Ú§ã§á§â§Ñ§Ó§ß§à §æ§å§ß§Ü§è§Ú§à§ß§Ú§ã§Ñ§ä§Ú §Ü§Ñ§Õ§Ñ §ã§Ö §á§â§Ú§Þ§Ö?§å?§å §ß§Ñ §Ö§ß§ä§Ú§ä§Ö§ä§Ö §Ü§à?§Ú §ã§Ñ§Õ§â§Ø§Ö §à§Õ§â§Ö?§Ö§ß§Ö Unicode §Ü§Ñ§â§Ñ§Ü§ä§Ö§â§Ö (§ß§á§â, ?, ?). §°§Ó§Ñ? §á§â§à§Ò§Ý§Ö§Þ §ß§Ñ§ã§ä§Ñ?§Ö §Ù§Ò§à§Ô §ä§à§Ô§Ñ §Ü§Ñ§Ü§à §á§à§Õ§â§Ñ§Ù§å§Þ§Ö§Ó§Ñ§ß§Ñ utf8mb4_bin §Ü§à§Ý§Ñ§è§Ú?§Ñ §Ù§Ñ MySQL §Ú§Ý§Ú MariaDB §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §å§á§â§Ñ§Ó?§Ñ §ã§à§â§ä§Ú§â§Ñ?§Ö§Þ §Ú §á§à§â§Ö?§Ö?§Ö§Þ Unicode §Ü§Ñ§â§Ñ§Ü§ä§Ö§â§Ñ.

§¥§Ñ §Ò§Ú §â§Ö§ê§Ú§Ý§Ú §à§Ó§à §à§Ô§â§Ñ§ß§Ú§é§Ö?§Ö, §Ü§à§â§Ú§ã§ß§Ú§è§Ú §Þ§à§Ô§å §Õ§Ñ §á§â§à§Þ§Ö§ß§Ö §å§á§à§â§Ö?§Ú§Ó§Ñ?§Ö §Ü§à§Ý§à§ß§Ñ §Ò§Ñ§Ù§Ö §á§à§Õ§Ñ§ä§Ñ§Ü§Ñ §ß§Ñ §Ñ§Ý§ä§Ö§â§ß§Ñ§ä§Ú§Ó§Ö §Ü§Ñ§à §ê§ä§à §ã§å utf8mb4_0900_bin, utf8mb4_0900_ai_ci, §Ú§Ý§Ú utf8mb4_unicode_520_ci. §ª§Þ§Ñ?§ä§Ö §ß§Ñ §å§Þ§å, §Þ§Ö?§å§ä§Ú§Þ, §Õ§Ñ §á§â§à§Þ§Ö§ß§Ñ §å§á§à§â§Ö?§Ú§Ó§Ñ?§Ñ §Þ§à§Ø§Ö §Õ§Ñ §Ú§Ù§Ñ§Ù§à§Ó§Ö §ß§Ö§à§é§Ö§Ü§Ú§Ó§Ñ§ß§à §á§à§ß§Ñ§ê§Ñ?§Ö §å §â§å§Ü§à§Ó§Ñ?§å §á§â§Ñ§Ù§ß§Ú§Þ §á§â§à§ã§ä§à§â§Ú§Þ§Ñ, §Ü§Ñ§à §Ú §ã§à§â§ä§Ú§â§Ñ?§å §Ú §æ§Ú§Ý§ä§â§Ú§â§Ñ?§å §Ù§Ñ §Õ§â§å§Ô§Ö §Ü§Ñ§â§Ñ§Ü§ä§Ö§â§Ö.

§©§Ñ §Ó§Ú§ê§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ñ §à §á§â§à§Þ§Ö§ß§Ú §å§á§à§â§Ö?§Ú§Ó§Ñ?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §Ú§Ý§Ú . §©§Ñ §Õ§Ö§ä§Ñ?§Ö §à §â§Ñ§Ù§Ý§Ú§Ü§Ñ§Þ§Ñ §å §á§à§â§Ö?§Ö?§å, §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §å MySQL §Õ§à§Ü§å§Þ§Ö§ß§ä§Ñ§è§Ú?§Ú.

§¯§Ö§ä§Ñ§é§ß§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ö §Ú§Ù §å§Ô?§Ö§Ø§Õ§Ö§ß§Ö §Ô§â§å§á§Ö §Õ§à§Þ§Ñ?§Ú§ß§Ñ §å §Þ§Ñ§á§Ñ§Þ§Ñ

§ª§ß§æ§à§â§Þ§Ñ§è§Ú?§Ö §Ú§Ù §å§Ô?§Ö§Ø§Õ§Ö§ß§Ú§ç §Ô§â§å§á§Ñ §Õ§à§Þ§Ñ?§Ú§ß§Ñ §ã§Ö §á§à§Ô§â§Ö§ê§ß§à §á§â§Ú§Ü§Ñ§Ù§å?§å §ß§Ñ §Þ§Ñ§á§Ñ§Þ§Ñ, §ß§Ñ §á§â§Ú§Þ§Ö§â:

• §°§Ù§ß§Ñ§Ü§Ñ §Ô§â§å§á§Ö §Õ§à§Þ§Ñ?§Ú§ß§Ñ §á§â§Ú§Ü§Ñ§Ù§å?§Ö §â§Ö§Ù§Ú§Þ§Ö §á§â§à§Ò§Ý§Ö§Þ§Ñ §ß§Ö §å§Ü?§å§é§å?§å?§Ú §ã§Ó§Ö §Õ§à§Þ§Ñ?§Ú§ß§Ö §å §å§Ô?§Ö§Ø§Õ§Ö§ß§Ú§Þ §Ô§â§å§á§Ñ§Þ§Ñ §Õ§à§Þ§Ñ?§Ú§ß§Ñ;
• §±§â§Ú§Ü§Ñ§Ù "§¦§Ý§Ö§Þ§Ö§ß§ä§Ú §Ô§â§å§á§Ö §Õ§à§Þ§Ñ?§Ú§ß§Ñ" §ß§Ö §á§â§Ú§Ü§Ñ§Ù§å?§Ö §á§à§ã§Ö§Ò§Ñ§ß §Ö§Ý§Ö§Þ§Ö§ß§ä §Þ§Ñ§á§Ö §Ù§Ñ §ã§Ó§Ñ§Ü§à§Ô §Õ§à§Þ§Ñ?§Ú§ß§Ñ §å §å§Ô?§Ö§Ø§Õ§Ö§ß§Ú§Þ §Ô§â§å§á§Ñ§Þ§Ñ §Õ§à§Þ§Ñ?§Ú§ß§Ñ;
• §°§Ù§ß§Ñ§Ü§Ñ §Þ§Ñ§á§Ö §á§â§Ú§Ü§Ñ§Ù§å?§Ö §â§Ö§Ù§Ú§Þ§Ö §ã§Ó§Ú§ç §á§â§à§Ò§Ý§Ö§Þ§Ñ, §ß§Ö §å§Ü?§å§é§å?§å?§Ú §à§ß§Ö §å §å§Ô§ß§Ö§Ø?§Ö§ß§Ú§Þ §Ô§â§å§á§Ñ§Þ§Ñ §Õ§à§Þ§Ñ?§Ú§ß§Ñ.

§¯§Ö§Ú§ã§á§â§Ñ§Ó§ß§à LLD §á§â§Ñ§Ó§Ú§Ý§à §ß§Ñ§Õ?§Ñ§é§Ñ§Ó§Ñ?§Ñ §å §Ó§Ö§â§Ù§Ú?§Ú 7.0.7

§µ §Ó§Ö§â§Ù§Ú?§Ú 7.0.7, Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â §ã§Ö §â§å§ê§Ú §ß§Ñ§Ü§à§ß §à§Ò§â§Ñ§Õ§Ö §á§â§Ñ§Ó§Ú§Ý§Ñ §à§ä§Ü§â§Ú§Ó§Ñ?§Ñ §ß§Ú§ã§Ü§à§Ô §ß§Ú§Ó§à§Ñ overrides. §¬§Ñ§à §á§â§Ñ§Ó§Ú§Ý§ß§à §â§Ö§ê§Ö?§Ö, §à§ß§Ö§Þ§à§Ô§å?§Ú§ä§Ö LLD §á§â§Ñ§Ó§Ú§Ý§Ñ §Ü§à?§Ñ §ã§Ñ§Õ§â§Ø§Ö §ß§Ñ§Õ?§Ñ§é§Ñ§Ó§Ñ?§Ñ. §±§â§à§Ò§Ý§Ö§Þ ?§Ö §Ú§ã§á§â§Ñ§Ó?§Ö§ß §å Áú»¢¶Ä²© 7.0.8rc2.

§®§Ñ§Ü§â§à §æ§å§ß§Ü§è§Ú?§Ö

§®§Ñ§Ü§â§à §æ§å§ß§Ü§è§Ú?§Ö §ß§Ö §â§Ñ§Õ§Ö §å §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ú§Þ§Ñ §ã§ä§Ñ§Ó§Ü§Ö §ã§Ü§â§Ú§á§ä§Ö §Ú §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ú§Þ§Ñ §ã§Ü§â§Ú§á§ä§Ö §ã§ä§Ñ§Ó§Ü§Ö §á§â§Ö§Ô§Ý§Ö§Õ§Ñ§é§Ñ. §±§à§á§â§Ñ§Ó?§Ö§ß§à §å Áú»¢¶Ä²© 7.0.7 §Ó§Ö§â§Ù§Ú?§Ú.

§±§â§Ú§ã§ä§å§á UI §Ö§Ý§Ö§Þ§Ö§ß§ä§Ú§Þ§Ñ §ã§Ñ MariaDB 10.5.1¨C10.5.9

§±§â§Ú§ã§ä§å§á Áú»¢¶Ä²© §Ü§à§â§Ú§ã§ß§Ú§é§Ü§à§Þ §Ú§ß§ä§Ö§â§æ§Ö?§ã§å §ã§Ñ §å§Ý§à§Ô§à§Þ §Ü§à?§Ñ §ß§Ú?§Ö §³§å§á§Ö§â §Ñ§Õ§Þ§Ú§ß§Ú§ã§ä§â§Ñ§ä§à§â §Þ§à§Ø§Ö §Õ§à§Ó§Ö§ã§ä§Ú §Õ§à §á§à§â§å§Ü§Ö: "System error occurred. Please contact Áú»¢¶Ä²© administrator.". §°§Ó§Ñ? §á§â§à§Ò§Ý§Ö§Þ §å§ä§Ú§é§Ö §ß§Ñ §Ú§ß§ã§ä§Ñ§Ý§Ñ§è§Ú?§Ö §Ü§à?§Ö §Ü§à§â§Ú§ã§ä§Ö MariaDB §Ó§Ö§â§Ù§Ú?§Ö 10.5.1 §Õ§à 10.5.9.

§¥§Ñ §Ò§Ú§ã§ä§Ö §Ú§Ù§Ò§Ö§Ô§Ý§Ú §à§Ó§Ñ? §á§â§à§Ò§Ý§Ö§Þ, §Ñ§Ø§å§â§Ú§â§Ñ?§ä§Ö MariaDB §ß§Ñ §Ó§Ö§â§Ù§Ú?§å §Ü§Ñ§ã§ß§Ú?§å §à§Õ 10.5.9. §©§Ñ §Ó§Ú§ê§Ö §Õ§Ö§ä§Ñ?§Ñ §á§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö .

§±§â§à§æ§Ú§Ý§Ú§ã§Ñ?§Ö §á§â§Ö§Ü§à§Þ§Ö§â§ß§Ö §å§á§à§ä§â§Ö§Ò§Ö §Þ§Ö§Þ§à§â§Ú?§Ö §á§à§Þ§à?§å tcmallocIf-§Ñ

§¡§Ü§à §ã§å§Þ?§Ñ§ä§Ö §Õ§Ñ §Ó§Ñ§ê§Ñ Áú»¢¶Ä²© §Ú§ß§ã§ä§Ñ§Ý§Ñ§è§Ú?§Ñ §Ü§à§â§Ú§ã§ä§Ú §á§â§Ö§Ó§Ú§ê§Ö §Þ§Ö§Þ§à§â§Ú?§Ö, §Þ§à§Ø§Ö§ä§Ö §Ü§à§â§Ú§ã§ä§Ú§ä§Ú §æ§å§ß§Ü§è§Ú?§å §á§â§à§æ§Ú§Ý§Ú§ã§Ñ?§Ñ §Þ§Ö§Þ§à§â§Ú?§Ö §Õ§Ñ §Ò§Ú§ã§ä§Ö §Ú§ã§ä§â§Ñ§Ø§Ú§Ý§Ú §á§à§ä§â§à§ê?§å §Þ§Ö§Þ§à§â§Ú?§Ö Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ/§á§â§à§Ü§ã§Ú §ã§Ö§â§Ó§Ö§â§Ñ.

1. §¬§Ñ§Õ§Ñ §Ú§ß§ã§ä§Ñ§Ý§Ú§â§Ñ§ä§Ö Áú»¢¶Ä²© §Ú§Ù §Ú§Ù§Ó§à§â§Ñ, §Ü§à§ß§æ§Ú§Ô§å§â§Ú§ê§Ú§ä§Ö §Õ§à§Õ§Ñ§ä§ß§Ö §Ù§Ñ§ã§ä§Ñ§Ó§Ú§è§Ö:

export CFLAGS="-std=gnu99 -g -O0"

§°§Ù§ß§Ñ§Ü§Ñ -std=gnu99 ?§Ö §á§à§ä§â§Ö§Ò§ß§Ñ §Ù§Ñ §á§â§Ñ§Ó?§Ö?§Ö Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ, Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú?§Ñ §Ú§Ý§Ú Áú»¢¶Ä²© §Ñ§Ô§Ö§ß§ä§Ñ. §°§Ù§ß§Ñ§Ü§Ñ -g §Õ§à§Õ§Ñ?§Ö §Õ§à§Õ§Ñ§ä§ß§Ö §Ú§ß§æ§à§â§Þ§Ñ§è§Ú?§Ö §Ù§Ñ §à§ä§Ü§Ý§Ñ?§Ñ?§Ö §Ô§â§Ö§ê§Ñ§Ü§Ñ, §Õ§à§Ü -§°0 §à§ß§Ö§Þ§à§Ô§å?§Ñ§Ó§Ñ §à§á§ä§Ú§Þ§Ú§Ù§Ñ§è§Ú?§Ö, §ê§ä§à §Þ§à§Ø§Ö §à§Þ§Ö§ä§Ñ§ä§Ú §á§â§à§æ§Ú§Ý§Ú§ã§Ñ?§Ö §ä§è§Þ§Ñ§Ý§Ý§à§è-§Ñ.

2. §±§à§ã§ä§Ñ§Ó§Ú§ä§Ö §ã§Ý§Ö§Õ§Ö?§Ö §á§â§à§Þ§Ö§ß?§Ú§Ó§Ö §à§Ü§â§å§Ø§Ö?§Ñ §á§â§Ö §á§à§Ü§â§Ö§ä§Ñ?§Ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ. §°§Ó§Ö §Ó§Ñ§â§Ú?§Ñ§Ò§Ý§Ö §Ô§à§Ó§à§â§Ö tcmalloc-§å §Ü§Ñ§Ü§à §Õ§Ñ §á§â§Ñ§ä§Ú §Ú §Ú§Ù§Ó§Ö§ê§ä§Ñ§Ó§Ñ §à §å§á§à§ä§â§Ö§Ò§Ú §Þ§Ö§Þ§à§â§Ú?§Ö:

LD_PRELOAD="/usr/lib/aarch64-linux-gnu/libtcmalloc.so" \
       HEAPPROFILE=./heap_profile \
       HEAP_PROFILE_ALLOCATION_INTERVAL=0 \
       HEAP_PROFILE_INUSE_INTERVAL=4294967296 \
       HEAPPROFILESIGNAL=5 \
       MALLOCSTATS=1 \
       ./sbin/zabbix_server -f -c /etc/zabbix/zabbix_server.conf

3. §±§à§Ü§â§Ö§ß§Ú§ä§Ö §Ú§ã§á§Ú§ã §á§â§à§æ§Ú§Ý§Ñ §ã§Ý§Ñ?§Ö§Þ §ã§Ú§Ô§ß§Ñ§Ý§Ñ 5 §è§Ú?§ß§à§Þ §á§â§à§è§Ö§ã§å. §©§Ñ§Þ§Ö§ß§Ú§ä§Ö 1234 §ã§ä§Ó§Ñ§â§ß§Ú§Þ ID-§Ú?§Ö§Þ §á§â§à§è§Ö§ã§Ñ (PID):

kill -5 1234

4. §°§Õ§ê§ä§Ñ§Þ§á§Ñ?§ä§Ö §Ô§Ö§ß§Ö§â§Ú§ã§Ñ§ß§Ú §á§â§à§æ§Ú§Ý:

pprof-symbolize -text ./sbin/zabbix_server ./heap_profile.0001.heap
       
       §¬§à§â§Ú§ê?§Ö?§Ö §Ý§à§Ü§Ñ§Ý§ß§Ö §Õ§Ñ§ä§à§ä§Ö§Ü§Ö ./sbin/zabbix_server.
       §¬§à§â§Ú§ê?§Ö?§Ö §Ý§à§Ü§Ñ§Ý§ß§Ö §Õ§Ñ§ä§à§ä§Ö§Ü§Ö ./heap_profile.0001.heap.
       §µ§Ü§å§á§ß§à: 1078.1 MB
         1076.8  99.9%  99.9%  1076.8  99.9% zbx_malloc2
         1.0  0.1%. 100.0%  1.0  0.1% __GI___strdup
         0.2  0.0%  100.0%. 0.2. 0.0% CRYPTO_zalloc@@OPENSSL_3.0.0
         0.1  0.0%  100.0%  0.1  0.0% OPENSSL_LH_insert@@OPENSSL_3.0.0
         0.0  0.0%  100.0%  0.0  0.0% zbx_realloc2
         0.0  0.0%. 100.0%. 0.1  0.0% PKCS7_decrypt@@OPENSSL_3.0.0
         0.0. 0.0%  100.0%  0.0. 0.0% find_best_tree_node
         0.0. 0.0% 100.0%. 0.0  0.0% CRYPTO_strndup@@OPENSSL_3.0.0
         ...
         0.0. 0.0%. 100.0%  0.0. 0.0% preprocessing_flush_value
         0.0. 0.0%  100.0%  1074.099.6% preprocessor_add_request

§µ §à§Ó§à§Þ §á§â§Ú§Þ§Ö§â§å, zbx_malloc2 ?§Ö §à§Õ§Ô§à§Ó§à§â§Ñ§ß §Ù§Ñ §ã§Ü§à§â§à §ã§Ó§Ö §Ñ§Ý§à§Ü§Ñ§è§Ú?§Ö §Þ§Ö§Þ§à§â§Ú?§Ö.

§±§à§Ô§Ý§Ö§Õ§Ñ?§ä§Ö §ä§Ñ§Ü§à?§Ö:

• §Ú [ZBX-25584] (https://support.zabbix.com/browse/ZBX-25584) §Ù§Ñ §á§à§Ó§Ö§Ù§Ñ§ß§Ö §Ú§Ù§Ó§Ö§ê§ä§Ñ?§Ö §à §á§â§à§Ò§Ý§Ö§Þ§Ú§Þ§Ñ.
• §à §à§á§è§Ú?§Ñ§Þ§Ñ §ã§Ñ§ã§ä§Ñ§Ó?§Ñ?§Ñ (-std=gnu99, -g, -O0, etc.).
• §Õ§à§Ü§å§Þ§Ö§ß§ä§Ñ§è§Ú?§Ñ §à §Ó§Ñ§â§Ú?§Ñ§Ò§Ý§Ñ§Þ§Ñ §à§Ü§â§å§Ø§Ö?§Ñ §Ù§Ñ tcmalloc §á§â§à§æ§Ú§Ý§Ú§ã§Ñ?§Ö.