-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
3.4.11
-
None
-
Oracle Linux
I have an Issue .. orabbix 1.2.3 is not connecting to zabbix server 3.4 ...
gives error message "Not supported item key" ... please help me
detect the problem and solve it... thanx
--------------------------------------------------------------------------------------------------
Orabbix 1.2.3 Log :
2018-07-24 13:42:05,486 [main] INFO Orabbix - Starting Orabbix Version 1.2.3
2018-07-24 13:42:05,500 [main] INFO Orabbix - Orabbix started with pid:12619
2018-07-24 13:42:05,500 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2018-07-24 13:42:05,660 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolDataSource@20b1c468
2018-07-24 13:42:05,660 [main] INFO Orabbix - URL=jdbc:oracle:thin:@<DB_HOST_IP>:PORT_NO:<dbname>
2018-07-24 13:42:05,661 [main] INFO Orabbix - maxPoolSize=10
2018-07-24 13:42:05,661 [main] INFO Orabbix - maxIdleSize=1
2018-07-24 13:42:05,661 [main] INFO Orabbix - maxIdleTime=1800000ms
2018-07-24 13:42:05,661 [main] INFO Orabbix - poolTimeout=10
2018-07-24 13:42:05,661 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2018-07-24 13:42:05,661 [main] INFO Orabbix - numTestsPerEvictionRun=3
2018-07-24 13:42:06,628 [main] INFO Orabbix - Connected as <DBUSER>
2018-07-24 13:42:06,630 [main] INFO Orabbix - --------- on Database -> <dbname>
2018-07-24 13:42:06,680 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 29 ms
2018-07-24 13:43:06,694 [pool-1-thread-2] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 18 ms
2018-07-24 13:44:06,705 [pool-1-thread-3] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 21 ms
2018-07-24 13:45:06,711 [pool-1-thread-4] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 24 ms
2018-07-24 13:46:06,703 [pool-1-thread-5] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 14 ms
2018-07-24 13:47:06,722 [pool-1-thread-6] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 25 ms
2018-07-24 13:48:06,714 [pool-1-thread-7] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 14 ms
2018-07-24 13:49:06,723 [pool-1-thread-8] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 21 ms
2018-07-24 13:50:06,744 [pool-1-thread-9] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 36 ms
2018-07-24 13:51:06,736 [pool-1-thread-10] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 18 ms
2018-07-24 13:52:06,732 [pool-1-thread-11] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 12 ms
2018-07-24 13:53:06,746 [pool-1-thread-12] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 19 ms
2018-07-24 13:54:06,741 [pool-1-thread-13] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 12 ms
2018-07-24 13:55:06,745 [pool-1-thread-14] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 14 ms
2018-07-24 13:56:06,757 [pool-1-thread-15] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 14 ms
2018-07-24 13:57:06,758 [pool-1-thread-16] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 15 ms
2018-07-24 13:58:06,761 [pool-1-thread-17] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 16 ms
2018-07-24 13:59:06,758 [pool-1-thread-18] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 11 ms
2018-07-24 14:00:06,767 [pool-1-thread-19] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 18 ms
2018-07-24 14:01:06,795 [pool-1-thread-20] INFO Orabbix - Done with dbJob on database <DB_host_name> QueryList elapsed time 22 ms
--------------------------------------------------------------------------------
Configuration File :
ZabbixServerList=DataBase_Monitor
DataBase_Monitor.Address=<IP_ADDRESS_OF_ZABBIX_SERVER>
DataBase_Monitor.Port=10051
OrabbixDaemon.PidFile=./logs/orabbix.pid
OrabbixDaemon.Sleep=300
OrabbixDaemon.MaxThreadNumber=100
DatabaseList=<DB_host_name>
DatabaseList.MaxActive=10
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1
<DB_host_name>.Url=jdbc:oracle:thin:@<DB_IP_ADDRESS>:PORT_NO:dbname
<DB_host_name>.User=DBUSER
<DB_host_name>.Password=DBPASS
<DB_host_name>.MaxActive=10
<DB_host_name>MaxWait=10
<DB_host_name>.MaxIdle=1
<DB_host_name>.QueryListFile=/opt/orabbix/conf/query.comp.props
--------------------------------------------------------------------------------
Query File
DefaultQueryPeriod=1
QueryList=key_name
key_name.ACTIVE=true
key_name.ACTIVE=true
key_name.NoDataFound="SQL Returned No Data"
key_name.Query=SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" FROM DUAL
---------------------------------------------------------------------------------
The problem is That zabbix server is saying "unsupported item key"