Áú»¢¶Ä²©

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

§°§Ò§Ù§à§â

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

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

MySQL

shell> mysql -uroot -p<§á§Ñ§â§à§Ý§î>
       mysql> create database zabbix character set utf8 collate utf8_bin;
       mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '&±ô³Ù;§á§Ñ§â§à§Ý§î&²µ³Ù;';
       mysql> quit;

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

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

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

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

Oracle

§®§í §á§à§Ý§Ñ§Ô§Ñ§Ö§Þ, §é§ä§à §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§î zabbix §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §ã §á§Ñ§â§à§Ý§Ö§Þ §á§Ñ§â§à§Ý§î §å§Ø§Ö §ã§å§ë§Ö§ã§ä§Ó§å§Ö§ä §Ú §Ú§Þ§Ö§Ö§ä §á§â§Ñ§Ó§Ñ §ß§Ñ §ã§à§Ù§Õ§Ñ§ß§Ú§Ö §à§Ò§ì§Ö§Ü§ä§à§Ó §Ó ORCL §ã§Ý§å§Ø§Ò§Ö, §â§Ñ§ã§á§à§Ý§à§Ø§Ö§ß§ß§à§Û §ß§Ñ §ç§à§ã§ä §ã§Ö§â§Ó§Ö§â§Ö §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Oracle c shell §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§Ö§Þ §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§î, §Ü§à§ä§à§â§í§Û §Ú§Þ§Ö§Ö§ä §Õ§à§ã§ä§å§á §Ó §á§Ñ§á§Ü§å /tmp. Áú»¢¶Ä²© §ä§â§Ö§Ò§å§Ö§ä §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Ó §À§ß§Ú§Ü§à§Õ §Ü§à§Õ§Ú§â§à§Ó§Ü§Ö §Ú §ß§Ñ§è§Ú§à§ß§Ñ§Ý§î§ß§å§ð §Ü§à§Õ§Ú§â§à§Ó§Ü§å UTF8. §±§â§à§Ó§Ö§â§î§ä§Ö §ä§Ö§Ü§å§ë§Ú§Ö §ß§Ñ§ã§ä§â§à§Û§Ü§Ú:

sqlplus> select parameter,value from v$nls_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_NCHAR_CHARACTERSET';

§¦§ã§Ý§Ú §Ó§í §ã§à§Ù§Õ§Ñ§Ö§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ §Ó§Ñ§Þ §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à §á§à§Þ§Ö§ã§ä§Ú§ä§î §Ü§å§Õ§Ñ-§ä§à §Ú§Ù§à§Ò§â§Ñ§Ø§Ö§ß§Ú§ñ §ß§Ñ §ç§à§ã§ä §ã Oracle §Ú§Ù §Ú§ã§ç§à§Õ§ß§í§ç §Ü§à§Õ§à§Ó Áú»¢¶Ä²©. §³§Ü§à§á§Ú§â§å§Û§ä§Ö §Ú§ç §Ó /tmp/zabbix_images §á§Ñ§á§Ü§å §ß§Ñ §ç§à§ã§ä§Ö §ã Oracle:

shell> cd /§á§å§ä§î/§Ü/§Ú§ã§ç§à§Õ§ß§í§Þ/§Ü§à§Õ§Ñ§Þ/zabbix
       shell> ssh user@oracle_host "mkdir /tmp/zabbix_images"
       shell> scp -r misc/images/png_modern user@oracle_host:/tmp/zabbix_images/

§´§Ö§á§Ö§â§î §á§à§Õ§Ô§à§ä§à§Ó§î§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç:

shell> cd /§á§å§ä§î/§Ü/§Ú§ã§ç§à§Õ§ß§í§Þ/§Ü§à§Õ§Ñ§Þ/zabbix/database/oracle
       shell> sqlplus zabbix/§á§Ñ§â§à§Ý§î@oracle_host/ORCL
       sqlplus> schema.sql
       # §à§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö§ã§î §Ù§Õ§Ö§ã§î, §Ö§ã§Ý§Ú §Ó§í §ã§à§Ù§Õ§Ñ§Ö§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú
       sqlplus> images.sql
       sqlplus> data.sql

§´§Ö§á§Ö§â§î §Ó§â§Ö§Þ§Ö§ß§ß§å§ð §á§Ñ§á§Ü§å §Þ§à§Ø§ß§à §å§Õ§Ñ§Ý§Ú§ä§î:

shell> ssh user@oracle_host "rm -rf /tmp/zabbix_images"

SQLite

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

shell> cd database/sqlite3
       shell> sqlite3 /var/lib/sqlite/zabbix.db < schema.sql

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