Documentation
Table of Contents
§¯§Ñ§ã§ä§â§à§Û§Ü§Ñ §ê§Ñ§Ò§Ý§à§ß§à§Ó ODBC
§º§Ñ§Ô§Ú §Õ§Ý§ñ §à§Ò§Ö§ã§á§Ö§é§Ö§ß§Ú§ñ §á§â§Ñ§Ó§Ú§Ý§î§ß§à§Û §â§Ñ§Ò§à§ä§í §ê§Ñ§Ò§Ý§à§ß§à§Ó, §Ü§à§ä§à§â§í§Ö §ã§à§Ò§Ú§â§Ñ§ð§ä §Þ§Ö§ä§â§Ú§Ü§Ú §é§Ö§â§Ö§Ù §Þ§à§ß§Ú§ä§à§â§Ú§ß§Ô ODBC:
1. §µ§Ò§Ö§Õ§Ú§ä§Ö§ã§î, §é§ä§à §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§í§Û §Õ§â§Ñ§Û§Ó§Ö§â ODBC §å§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß §ß§Ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ö §Ú§Ý§Ú §á§â§à§Ü§ã§Ú.
2. §±§â§Ú§Ó§ñ§Ø§Ú§ä§Ö §ê§Ñ§Ò§Ý§à§ß §ß§Ñ §è§Ö§Ý§Ö§Ó§à§Û §å§Ù§Ö§Ý §ã§Ö§ä§Ú (§Ö§ã§Ý§Ú §ê§Ñ§Ò§Ý§à§ß §ß§Ö§Õ§à§ã§ä§å§á§Ö§ß §Ó §Ó§Ñ§ê§Ö§Û §å§ã§ä§Ñ§ß§à§Ó§Ü§Ö Áú»¢¶Ä²©, §Ó§Ñ§Þ §Þ§à§Ø§Ö§ä §á§à§ä§â§Ö§Ò§à§Ó§Ñ§ä§î§ã§ñ §ã§ß§Ñ§é§Ñ§Ý§Ñ §Ú§Þ§á§à§â§ä§Ú§â§à§Ó§Ñ§ä§î §æ§Ñ§Û§Ý .xml §ê§Ñ§Ò§Ý§à§ß§Ñ - §ã§Þ. §Ú§ß§ã§ä§â§å§Ü§è§Ú§Ú §Ó §â§Ñ§Ù§Õ§Ö§Ý§Ö §¤§à§ä§à§Ó§í§Ö §ê§Ñ§Ò§Ý§à§ß§í).
3. §±§â§Ú §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à§ã§ä§Ú §Ú§Ù§Þ§Ö§ß§Ú§ä§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§ñ §à§Ò§ñ§Ù§Ñ§ä§Ö§Ý§î§ß§í§ç §Þ§Ñ§Ü§â§à§ã§à§Ó.
4. §¯§Ñ§ã§ä§â§à§Û§ä§Ö §à§Ò§ì§Ö§Ü§ä §Õ§Ý§ñ §Þ§à§ß§Ú§ä§à§â§Ú§ß§Ô§Ñ §ä§Ñ§Ü, §é§ä§à§Ò§í §â§Ñ§Ù§â§Ö§ê§Ú§ä§î §à§Ò§Þ§Ö§ß §Õ§Ñ§ß§ß§í§Þ§Ú §ã Áú»¢¶Ä²© - §ã§Þ. §Ú§ß§ã§ä§â§å§Ü§è§Ú§Ú §Ó §ã§ä§à§Ý§Ò§è§Ö §¥§à§á§à§Ý§ß§Ú§ä§Ö§Ý§î§ß§í§Ö §ê§Ñ§Ô§Ú/§Ü§à§Þ§Þ§Ö§ß§ä§Ñ§â§Ú§Ú.
§¿§ä§Ñ §ã§ä§â§Ñ§ß§Ú§è§Ñ §ã§à§Õ§Ö§â§Ø§Ú§ä §ä§à§Ý§î§Ü§à §Þ§Ú§ß§Ú§Þ§Ñ§Ý§î§ß§í§Û §ß§Ñ§Ò§à§â §Þ§Ñ§Ü§â§à§ã§à§Ó §Ú §ê§Ñ§Ô§à§Ó §ß§Ñ§ã§ä§â§à§Û§Ü§Ú, §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§í§ç §Õ§Ý§ñ §á§â§Ñ§Ó§Ú§Ý§î§ß§à§Û §â§Ñ§Ò§à§ä§í §ê§Ñ§Ò§Ý§à§ß§Ñ. §±§à§Õ§â§à§Ò§ß§à§Ö §à§á§Ú§ã§Ñ§ß§Ú§Ö §ê§Ñ§Ò§Ý§à§ß§Ñ, §Ó§Ü§Ý§ð§é§Ñ§ñ §á§à§Ý§ß§í§Û §ã§á§Ú§ã§à§Ü §Þ§Ñ§Ü§â§à§ã§à§Ó, §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Ú §ä§â§Ú§Ô§Ô§Ö§â§à§Ó, §Õ§à§ã§ä§å§á§ß§à §Ó §æ§Ñ§Û§Ý§Ö Readme.md §ê§Ñ§Ò§Ý§à§ß§Ñ (§Õ§à§ã§ä§å§á§ß§à§Þ §á§â§Ú §ß§Ñ§Ø§Ñ§ä§Ú§Ú §ß§Ñ §Ú§Þ§ñ §ê§Ñ§Ò§Ý§à§ß§Ñ).
| §º§Ñ§Ò§Ý§à§ß | §°§Ò§ñ§Ù§Ñ§ä§Ö§Ý§î§ß§í§Ö §Þ§Ñ§Ü§â§à§ã§í | §¥§à§á§à§Ý§ß§Ú§ä§Ö§Ý§î§ß§í§Ö §ê§Ñ§Ô§Ú/§Ü§à§Þ§Þ§Ö§ß§ä§Ñ§â§Ú§Ú |
|---|---|---|
| {$MSSQL.DSN} - §Ú§Þ§ñ §ã§Ú§ã§ä§Ö§Þ§ß§à§Ô§à §Ú§ã§ä§à§é§ß§Ú§Ü§Ñ §Õ§Ñ§ß§ß§í§ç (§á§à §å§Þ§à§Ý§é§Ñ§ß§Ú§ð: <§µ§Ü§Ñ§Ø§Ú§ä§Ö §ã§Ó§à§Û DSN>) {$MSSQL.PORT} - TCP-§á§à§â§ä Microsoft SQL Server (§á§à §å§Þ§à§Ý§é§Ñ§ß§Ú§ð:1433) {$MSSQL.USER}, {$MSSQL.PASSWORD} - §å§é§Ö§ä§ß§í§Ö §Õ§Ñ§ß§ß§í§Ö Microsoft SQL (§á§à §å§Þ§à§Ý§é§Ñ§ß§Ú§ð: §ß§Ö §Ù§Ñ§Õ§Ñ§ß§í) |
§³§à§Ù§Õ§Ñ§Û§ä§Ö §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§ñ Microsoft SQL §Õ§Ý§ñ §Þ§à§ß§Ú§ä§à§â§Ú§ß§Ô§Ñ §Ú §á§â§Ö§Õ§à§ã§ä§Ñ§Ó§î§ä§Ö §Ö§Þ§å §ã§Ý§Ö§Õ§å§ð§ë§Ú§Ö §â§Ñ§Ù§â§Ö§ê§Ö§ß§Ú§ñ: View Server State (§±§â§à§ã§Þ§à§ä§â §ã§à§ã§ä§à§ñ§ß§Ú§ñ §ã§Ö§â§Ó§Ö§â§Ñ); View Any Definition (§±§â§à§ã§Þ§à§ä§â §Ý§ð§Ò§à§Ô§à §à§á§â§Ö§Õ§Ö§Ý§Ö§ß§Ú§ñ); §ã§Þ. §á§à§Õ§â§à§Ò§ß§Ö§Ö §Ó §Õ§à§Ü§å§Þ§Ö§ß§ä§Ñ§è§Ú§Ú ). §¿§Ý§Ö§Þ§Ö§ß§ä §Õ§Ñ§ß§ß§í§ç "Service's TCP port state" §Ú§ã§á§à§Ý§î§Ù§å§Ö§ä §Þ§Ñ§Ü§â§à§ã§í {HOST.CONN} §Ú {$MSSQL.PORT}, §é§ä§à§Ò§í §á§â§à§Ó§Ö§â§Ú§ä§î §Õ§à§ã§ä§å§á§ß§à§ã§ä§î Microsoft SQL. |
|
| {$MYSQL.DSN} - §Ú§Þ§ñ §ã§Ú§ã§ä§Ö§Þ§ß§à§Ô§à §Ú§ã§ä§à§é§ß§Ú§Ü§Ñ §Õ§Ñ§ß§ß§í§ç (§á§à §å§Þ§à§Ý§é§Ñ§ß§Ú§ð: <§µ§Ü§Ñ§Ø§Ú§ä§Ö §ã§Ó§à§Û DSN>) {$MYSQL.USER}, {$MYSQL.PASSWORD} - §å§é§Ö§ä§ß§í§Ö §Õ§Ñ§ß§ß§í§Ö MySQL; §á§Ñ§â§à§Ý§î §Þ§à§Ø§Ö§ä §Ò§í§ä§î §á§å§ã§ä§í§Þ (§á§à §å§Þ§à§Ý§é§Ñ§ß§Ú§ð: §ß§Ö §Ù§Ñ§Õ§Ñ§ß§í) |
§¹§ä§à§Ò§í §á§â§Ö§Õ§à§ã§ä§Ñ§Ó§Ú§ä§î §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§ð MySQL, §Ü§à§ä§à§â§í§Û §Ò§å§Õ§Ö§ä §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î§ã§ñ §Õ§Ý§ñ §Þ§à§ß§Ú§ä§à§â§Ú§ß§Ô§Ñ, §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§í§Ö §á§â§Ú§Ó§Ú§Ý§Ö§Ô§Ú§Ú, §Ó§í§á§à§Ý§ß§Ú§ä§Ö:GRANT USAGE,REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON %% *.* TO '<username>'@'%';%%§ã§Þ. §á§à§Õ§â§à§Ò§ß§Ö§Ö §Ó §Õ§à§Ü§å§Þ§Ö§ß§ä§Ñ§è§Ú§Ú . |
|
| {$ORACLE.DSN} - §Ú§Þ§ñ §ã§Ú§ã§ä§Ö§Þ§ß§à§Ô§à §Ú§ã§ä§à§é§ß§Ú§Ü§Ñ §Õ§Ñ§ß§ß§í§ç (§á§à §å§Þ§à§Ý§é§Ñ§ß§Ú§ð: <§µ§Ü§Ñ§Ø§Ú§ä§Ö §ã§Ó§à§Û DSN>) {$ORACLE.PORT} - TCP-§á§à§â§ä Oracle DB (§á§à §å§Þ§à§Ý§é§Ñ§ß§Ú§ð: 1521) {$ORACLE.USER}, {$ORACLE.PASSWORD} - §å§é§Ö§ä§ß§í§Ö §Õ§Ñ§ß§ß§í§Ö Oracle (§á§à §å§Þ§à§Ý§é§Ñ§ß§Ú§ð: §ß§Ö §Ù§Ñ§Õ§Ñ§ß§í) |
1. §¹§ä§à§Ò§í §ã§à§Ù§Õ§Ñ§ä§î §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§ñ Oracle §Õ§Ý§ñ §Þ§à§ß§Ú§ä§à§â§Ú§ß§Ô§Ñ, §Ó§í§á§à§Ý§ß§Ú§ä§Ö:CREATE USER zabbix_mon IDENTIFIED BY <PASSWORD>;-- Grant access to the zabbix_mon user.GRANT CONNECT, CREATE SESSION TO zabbix_mon;GRANT SELECT ON V_$instance TO zabbix_mon;GRANT SELECT ON V_$database TO zabbix_mon;GRANT SELECT ON v_$sysmetric TO zabbix_mon;GRANT SELECT ON v$recovery_file_dest TO zabbix_mon;GRANT SELECT ON v$active_session_history TO zabbix_mon;GRANT SELECT ON v$osstat TO zabbix_mon;GRANT SELECT ON v$restore_point TO zabbix_mon;GRANT SELECT ON v$process TO zabbix_mon;GRANT SELECT ON v$datafile TO zabbix_mon;GRANT SELECT ON v$pgastat TO zabbix_mon;GRANT SELECT ON v$sgastat TO zabbix_mon;GRANT SELECT ON v$log TO zabbix_mon;GRANT SELECT ON v$archive_dest TO zabbix_mon;GRANT SELECT ON v$asm_diskgroup TO zabbix_mon;GRANT SELECT ON sys.dba_data_files TO zabbix_mon;GRANT SELECT ON DBA_TABLESPACES TO zabbix_mon;GRANT SELECT ON DBA_TABLESPACE_USAGE_METRICS TO zabbix_mon;GRANT SELECT ON DBA_USERS TO zabbix_mon;2. §µ§Ò§Ö§Õ§Ú§ä§Ö§ã§î, §é§ä§à ODBC §á§à§Õ§Ü§Ý§ð§é§Ñ§Ö§ä§ã§ñ §Ü Oracle §ã §á§Ñ§â§Ñ§Þ§Ö§ä§â§à§Þ §ã§Ö§ã§ã§Ú§Ú NLS_NUMERIC_CHARACTERS= '.,'3. §¥§à§Ò§Ñ§Ó§î§ä§Ö §ß§à§Ó§å§ð §Ù§Ñ§á§Ú§ã§î §Ó odbc.ini: [$ORACLE.DSN]Driver = Oracle 19 ODBC driverServername = $ORACLE.DSNDSN = $ORACLE.DSN4. §±§â§à§Ó§Ö§â§î§ä§Ö §ã§à§Ö§Õ§Ú§ß§Ö§ß§Ú§Ö §é§Ö§â§Ö§Ù isql: isql $TNS_NAME $DB_USER $DB_PASSWORD5.§¯§Ñ§ã§ä§â§à§Û§ä§Ö Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â §Ú§Ý§Ú Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú §Õ§Ý§ñ §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§ñ Oracle ENV. §°§ä§â§Ö§Õ§Ñ§Ü§ä§Ú§â§å§Û§ä§Ö §Ú§Ý§Ú §Õ§à§Ò§Ñ§Ó§î§ä§Ö §ß§à§Ó§í§Û §æ§Ñ§Û§Ý: /etc/sysconfig/zabbix-server, §Ú§Ý§Ú §Õ§Ý§ñ §á§â§à§Ü§ã§Ú: /etc/sysconfig/zabbix-proxy. §©§Ñ§ä§Ö§Þ §Õ§à§Ò§Ñ§Ó§î§ä§Ö §Ó §æ§Ñ§Û§Ý §ã§Ý§Ö§Õ§å§ð§ë§Ú§Ö §ã§ä§â§à§Ü§Ú: export ORACLE_HOME=/usr/lib/oracle/19.6/client64export PATH=$PATH:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib64:/usr/lib:$ORACLE_HOME/binexport TNS_ADMIN=$ORACLE_HOME/network/admin6. §±§Ö§â§Ö§Ù§Ñ§á§å§ã§ä§Ú§ä§Ö Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â §Ú§Ý§Ú §á§â§à§Ü§ã§Ú. |