Áú»¢¶Ä²©

§¿§ä§à §á§Ö§â§Ö§Ó§à§Õ §ã§ä§â§Ñ§ß§Ú§è§í §Õ§à§Ü§å§Þ§Ö§ß§ä§Ñ§è§Ú§Ú §ã §Ñ§ß§Ô§Ý§Ú§Û§ã§Ü§à§Ô§à §ñ§Ù§í§Ü§Ñ. §±§à§Þ§à§Ô§Ú§ä§Ö §ß§Ñ§Þ §ã§Õ§Ö§Ý§Ñ§ä§î §Ö§Ô§à §Ý§å§é§ê§Ö.

1 §³§à§Ù§Õ§Ñ§ß§Ú§Ö §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç

§°§Ò§Ù§à§â

§¢§Ñ§Ù§Ñ §Õ§Ñ§ß§ß§í§ç Áú»¢¶Ä²© §Õ§à§Ý§Ø§ß§Ñ §Ò§í§ä§î §ã§à§Ù§Õ§Ñ§ß§Ñ §Ó §á§â§à§è§Ö§ã§ã§Ö §å§ã§ä§Ñ§ß§à§Ó§Ü§Ú Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ §Ú§Ý§Ú §á§â§à§Ü§ã§Ú.

§¿§ä§à§ä §â§Ñ§Ù§Õ§Ö§Ý §á§â§Ö§Õ§à§ã§ä§Ñ§Ó§Ý§ñ§Ö§ä §Ú§ß§ã§ä§â§å§Ü§è§Ú§Ú §Õ§Ý§ñ §ã§à§Ù§Õ§Ñ§ß§Ú§ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Áú»¢¶Ä²©. §°§ä§Õ§Ö§Ý§î§ß§í§Û §ß§Ñ§Ò§à§â §Ú§ß§ã§ä§â§å§Ü§è§Ú§Û §Õ§à§ã§ä§å§á§Ö§ß §Õ§Ý§ñ §Ü§Ñ§Ø§Õ§à§Û §Ú§Ù §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§Þ§í§ç §Ò§Ñ§Ù §Õ§Ñ§ß§ß§í§ç.

UTF-8 - §Ö§Õ§Ú§ß§ã§ä§Ó§Ö§ß§ß§Ñ§ñ §Ü§à§Õ§Ú§â§à§Ó§Ü§Ñ §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§Þ§Ñ§ñ Áú»¢¶Ä²©. §´§Ñ§Ü §Ø§Ö §Ú§Ù§Ó§Ö§ã§ä§ß§Ñ§ñ §ä§Ö§Þ, §é§ä§à §â§Ñ§Ò§à§ä§Ñ§Ö§ä §Ò§Ö§Ù §Ü§Ñ§Ü§Ú§ç-§Ý§Ú§Ò§à §å§ñ§Ù§Ó§Ú§Þ§à§ã§ä§Ö§Û §Ó §Ò§Ö§Ù§à§á§Ñ§ã§ß§à§ã§ä§Ú. §±§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§Ú §Õ§à§Ý§Ø§ß§í §à§ã§à§Ù§ß§Ñ§Ó§Ñ§ä§î §Ó§à§Ù§Þ§à§Ø§ß§à§Ö §ß§Ñ§Ý§Ú§é§Ú§Ú §å§ñ§Ù§Ó§Ú§Þ§à§ã§ä§Ö§Û §á§â§Ú §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§Ú §ß§Ö§Ü§à§ä§à§â§í§ç §Õ§â§å§Ô§Ú§ç §Ü§à§Õ§Ú§â§à§Ó§à§Ü.

§±§â§Ú §å§ã§ä§Ñ§ß§à§Ó§Ü§Ö §Ú§Ù , §£§Ñ§Þ §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à §Ó§í§á§à§Ý§ß§Ú§ä§î §Ü§à§Þ§Ñ§ß§Õ§å:

$ make dbschema

§á§â§Ö§Ø§Õ§Ö, §é§Ö§Þ §á§â§Ú§ã§ä§å§á§Ñ§ä§î §Ü §ã§Ý§Ö§Õ§å§ð§ë§Ú§Þ §ê§Ñ§Ô§Ñ§Þ.

MySQL

§¯§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó utf8 (§ä§Ñ§Ü §Ø§Ö utf8mb3) §Ú utf8mb4 §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§ð§ä§ã§ñ (§ã §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§ñ§Þ§Ú utf8_bin §Ú utf8mb4_bin §ã§à§à§ä§Ó§Ö§ä§ã§ä§Ó§Ö§ß§ß§à) §Õ§Ý§ñ §Ü§à§â§â§Ö§Ü§ä§ß§à§Û §â§Ñ§Ò§à§ä§í Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ/§á§â§à§Ü§ã§Ú §ã §Ò§Ñ§Ù§à§Û §Õ§Ñ§ß§ß§í§ç MySQL. §¥§Ý§ñ §ß§à§Ó§í§ç §å§ã§ä§Ñ§ß§à§Ó§à§Ü §â§Ö§Ü§à§Þ§Þ§Ö§ß§Õ§å§Ö§ä§ã§ñ §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î utf8mb4.

shell> mysql -uroot -p<password>
       mysql> create database zabbix character set utf8mb4 collate utf8mb4_bin;
       mysql> create user 'zabbix'@'localhost' identified by '<password>';
       mysql> grant all privileges on zabbix.* to 'zabbix'@'localhost';
       mysql> quit;

§¦§ã§Ý§Ú §£§í §å§ã§ä§Ñ§ß§Ñ§Ó§Ý§Ú§Ó§Ñ§Ö§ä§Ö Áú»¢¶Ä²© §Ú§Ù §á§Ñ§Ü§Ö§ä§à§Ó, §à§ã§ä§Ñ§ß§Ú§ä§Ö§ã§î §ß§Ñ §ï§ä§à§Þ §Þ§Ö§ã§ä§Ö §Ú §á§â§à§Õ§à§Ý§Ø§Ú§ä§Ö §Ú§ã§á§à§Ý§î§Ù§å§ñ §Ú§ß§ã§ä§â§å§Ü§è§Ú§Ú §Õ§Ý§ñ RHEL/CentOS §Ú§Ý§Ú Debian/Ubuntu §é§ä§à§Ò§í §Ú§Þ§á§à§â§ä§Ú§â§à§Ó§Ñ§ä§î §Õ§Ñ§ß§ß§í§Ö §Ó §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç.

§¦§ã§Ý§Ú §£§í §å§ã§ä§Ñ§ß§Ñ§Ó§Ý§Ú§Ó§Ñ§Ö§ä§Ö Áú»¢¶Ä²© §Ú§Ù §Ú§ã§ç§à§Õ§ß§í§ç §Ü§à§Õ§à§Ó, §á§Ö§â§Ö§Û§Õ§Ú§ä§Ö §Ü §Ú§Þ§á§à§â§ä§Ú§â§à§Ó§Ñ§ß§Ú§ð §Õ§Ñ§ß§ß§í§ç §Ó §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç. §¥§Ý§ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú, §ß§å§Ø§ß§à §Ú§Þ§á§à§â§ä§Ú§â§à§Ó§Ñ§ä§î §ä§à§Ý§î§Ü§à schema.sql (§Ò§Ö§Ù images.sql §Ú§Ý§Ú data.sql):

shell> cd database/mysql
       shell> mysql -uzabbix -p<password> zabbix < schema.sql
       # §à§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö§ã§î §Ù§Õ§Ö§ã§î, §Ö§ã§Ý§Ú §Ó§í §ã§à§Ù§Õ§Ñ§Ö§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú
       shell> mysql -uzabbix -p<password> zabbix < images.sql
       shell> mysql -uzabbix -p<password> zabbix < data.sql

PostgreSQL

§µ §£§Ñ§ã §Õ§à§Ý§Ø§Ö§ß §Ò§í§ä§î §ã§à§Ù§Õ§Ñ§ß §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§î §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §ã §á§â§Ñ§Ó§Ñ§Þ§Ú §ß§Ñ §ã§à§Ù§Õ§Ñ§ß§Ú§Ö §à§Ò§î§Ö§Ü§ä§à§Ó §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç. §³§Ý§Ö§Õ§å§ð§ë§Ñ§ñ §Ü§à§Þ§Ñ§ß§Õ§Ñ §ã§à§Ù§Õ§Ñ§ã§ä §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§ñ zabbix. §©§Ñ§Õ§Ñ§Û§ä§Ö §á§Ñ§â§à§Ý§î §á§â§Ú §á§à§ñ§Ó§Ý§Ö§ß§Ú§Ú §Ù§Ñ§á§â§à§ã§Ñ §Ú §Ù§Ñ§ä§Ö§Þ §Ó§Ó§Ö§Õ§Ú§ä§Ö §á§Ñ§â§à§Ý§î §á§à§Ó§ä§à§â§ß§à (§à§Ò§â§Ñ§ä§Ú§ä§Ö §Ó§ß§Ú§Þ§Ñ§ß§Ú§Ö, §é§ä§à §Ó §ß§Ñ§é§Ñ§Ý§Ö §Þ§à§Ø§Ö§ä §Ò§í§ä§î §Ù§Ñ§á§â§à§ê§Ö§ß sudo §á§Ñ§â§à§Ý§î):

shell> sudo -u postgres createuser --pwprompt zabbix

§´§Ö§á§Ö§â§î §Þ§í §ã§à§Ù§Õ§Ñ§Õ§Ú§Þ §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç zabbix (§á§à§ã§Ý§Ö§Õ§ß§Ú§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â) §ã §â§Ñ§ß§ß§Ö§Ö §ã§à§Ù§Õ§Ñ§ß§ß§í§Þ §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§Ö§Þ §Ó §Ü§Ñ§é§Ö§ã§ä§Ó§Ö §Ó§Ý§Ñ§Õ§Ö§Ý§î§è§Ñ (-O zabbix).

shell> sudo -u postgres createdb -O zabbix -E Unicode -T template0 zabbix

§¦§ã§Ý§Ú §£§í §å§ã§ä§Ñ§ß§Ñ§Ó§Ý§Ú§Ó§Ñ§Ö§ä§Ö Áú»¢¶Ä²© §Ú§Ù §á§Ñ§Ü§Ö§ä§à§Ó, §à§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö§ã§î §Ù§Õ§Ö§ã§î §Ú §Õ§Ñ§Ý§Ö§Ö §ã§Ý§Ö§Õ§å§Û§ä§Ö §Ú§ß§ã§ä§â§å§Ü§è§Ú§ñ§Þ §Õ§Ý§ñ RHEL/CentOS §Ú§Ý§Ú Debian/Ubuntu §Õ§Ý§ñ §Ú§Þ§á§à§â§ä§Ñ §ã§ç§Ö§Þ§í §Ú §Õ§Ñ§ß§ß§í§ç §Ó §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç.

§¦§ã§Ý§Ú §£§í §å§ã§ä§Ñ§ß§Ñ§Ó§Ý§Ú§Ó§Ñ§Ö§ä§Ö Áú»¢¶Ä²© §Ú§Ù §Ú§ã§ç§à§Õ§ß§í§ç §Ü§à§Õ§à§Ó, §á§Ö§â§Ö§ç§à§Õ§Ú§ä§Ö §Ü §Ú§Þ§á§à§â§ä§å §ã§ç§Ö§Þ§í §Ú §Õ§Ñ§ß§ß§í§ç (§á§â§Ö§Õ§á§à§Ý§à§Ô§Ñ§Ö§ä§ã§ñ, §é§ä§à §Ó§í §ß§Ñ§ç§à§Õ§Ú§ä§Ö§ã§î §Ó §Ü§à§â§ß§Ö§Ó§à§Û §Õ§Ú§â§Ö§Ü§ä§à§â§Ú§Ú §Ú§ã§ç§à§Õ§ß§í§ç §Ü§à§Õ§à§Ó Áú»¢¶Ä²©). §¥§Ý§ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú, §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à §Ú§Þ§á§à§â§ä§Ú§â§à§Ó§Ñ§ä§î §ä§à§Ý§î§Ü§à schema.sql (§Ò§Ö§Ù images.sql §Ú §Ò§Ö§Ù data.sql).

shell> cd database/postgresql
       shell> cat schema.sql | sudo -u zabbix psql zabbix
       # §à§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö§ã§î §Ù§Õ§Ö§ã§î, §Ö§ã§Ý§Ú §£§í §ã§à§Ù§Õ§Ñ§×§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú
       shell> cat images.sql | sudo -u zabbix psql zabbix
       shell> cat data.sql | sudo -u zabbix psql zabbix

§±§â§Ú§Ó§Ö§Õ§Ö§ß§ß§í§Ö §Ó§í§ê§Ö §Ü§à§Þ§Ñ§ß§Õ§í §á§â§Ö§Õ§à§ã§ä§Ñ§Ó§Ý§Ö§ß§í §Ü§Ñ§Ü §á§â§Ú§Þ§Ö§â, §Ü§à§ä§à§â§í§Û §Ò§å§Õ§Ö§ä §â§Ñ§Ò§à§ä§Ñ§ä§î §ß§Ñ §Ò§à§Ý§î§ê§Ú§ß§ã§ä§Ó§Ö GNU/Linux §Ú§ß§ã§ä§Ñ§Ý§Ý§ñ§è§Ú§Û. §£§í §Þ§à§Ø§Ö§ä§Ö §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î §Ú §Õ§â§å§Ô§Ú§Ö §Ü§à§Þ§Ñ§ß§Õ§í, §ß§Ñ§á§â§Ú§Þ§Ö§â, "psql -U <username>" §Ó §Ù§Ñ§Ó§Ú§ã§Ú§Þ§à§ã§ä§Ú §à§ä §ä§à§Ô§à, §Ü§Ñ§Ü§Ú§Þ §à§Ò§â§Ñ§Ù§à§Þ §ß§Ñ§ã§ä§â§à§Ö§ß§Ñ §£§Ñ§ê§Ñ §ã§Ú§ã§ä§Ö§Þ§Ñ/§Ò§Ñ§Ù§Ñ §Õ§Ñ§ß§ß§í§ç. §¦§ã§Ý§Ú §å §£§Ñ§ã §Ó§à§Ù§ß§Ú§Ü§Ý§Ú §ä§â§å§Õ§ß§à§ã§ä§Ú §ã §ß§Ñ§ã§ä§â§à§Û§Ü§à§Û §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç, §á§à§Ø§Ñ§Ý§å§Û§ã§ä§Ñ, §á§â§à§Ü§à§ß§ã§å§Ý§î§ä§Ú§â§å§Û§ä§Ö§ã§î §ã §£§Ñ§ê§Ú§Þ §Ñ§Õ§Þ§Ú§ß§Ú§ã§ä§â§Ñ§ä§à§â§à§Þ §Ò§Ñ§Ù §Õ§Ñ§ß§ß§í§ç.

TimescaleDB

§ª§ß§ã§ä§â§å§Ü§è§Ú§Ú §á§à §ã§à§Ù§Õ§Ñ§ß§Ú§ð §Ú §ß§Ñ§ã§ä§â§à§Û§Ü§Ö TimescaleDB §á§â§Ú§Ó§Ö§Õ§Ö§ß§í §Ó §à§ä§Õ§Ö§Ý§î§ß§à§Þ §â§Ñ§Ù§Õ§Ö§Ý§Ö.

Oracle

§ª§ß§ã§ä§â§å§Ü§è§Ú§Ú §á§à §ã§à§Ù§Õ§Ñ§ß§Ú§ð §Ú §ß§Ñ§ã§ä§â§à§Û§Ü§Ö §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Oracle §á§â§Ú§Ó§Ö§Õ§Ö§ß§í §Ó §à§ä§Õ§Ö§Ý§î§ß§à§Þ §â§Ñ§Ù§Õ§Ö§Ý§Ö.

SQLite

§ª§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§Ö SQLite §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§ä§ã§ñ §ä§à§Ý§î§Ü§à §Õ§Ý§ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú!

§¢§Ñ§Ù§Ñ §Õ§Ñ§ß§ß§í§ç §Ò§å§Õ§Ö§ä §ã§à§Ù§Õ§Ñ§ß§Ñ §Ñ§Ó§ä§à§Þ§Ñ§ä§Ú§é§Ö§ã§Ü§Ú, §Ö§ã§Ý§Ú §à§ß§Ñ §ß§Ö §ã§å§ë§Ö§ã§ä§Ó§å§Ö§ä.

§£§Ö§â§ß§å§ä§î§ã§ñ §Ó §â§Ñ§Ù§Õ§Ö§Ý §å§ã§ä§Ñ§ß§à§Ó§Ü§Ú.