Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-14638

Orabbix is not connecting to Zabbix server

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 3.4.11
    • Server (S)
    • 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"

       

        1. screenshot1.png
          screenshot1.png
          17 kB
        2. screenshot1.png
          screenshot1.png
          7 kB
        3. Untitled2.png
          Untitled2.png
          10 kB

            Unassigned Unassigned
            abdallah AbdAllah Talaat
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: