Ad Widget

Collapse

Orabbix running, but no data is coming in...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • johnsonua
    Junior Member
    • Jun 2016
    • 1

    #1

    Orabbix running, but no data is coming in...

    Environment: Oracle 11G running on RHEL6 Hyper-V VM.

    I believe I've properly configured the config.props file, the zabbix user is created and I've tested the queries by hand, using the same jdbc connection type and they run without an issue. No errors are coming up in Zabbix, but no data is coming in either.

    The log shows minor warnings: (some data's been redacted)

    2016-06-20 10:44:02,135 [main] INFO Orabbix - Starting Orabbix Version 1.2.3
    2016-06-20 10:44:02,359 [main] INFO Orabbix - Orabbix started with pid:27461
    2016-06-20 10:44:02,360 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
    2016-06-20 10:44:03,465 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@745c172b
    2016-06-20 10:44:03,465 [main] INFO Orabbix - URL=jdbcracle:thin:@xxxxxxx.pharmacy.arizona.edu:xxxx:PHMW EB
    2016-06-20 10:44:03,465 [main] INFO Orabbix - maxPoolSize=10
    2016-06-20 10:44:03,465 [main] INFO Orabbix - maxIdleSize=1
    2016-06-20 10:44:03,465 [main] INFO Orabbix - maxIdleTime=1800000ms
    2016-06-20 10:44:03,465 [main] INFO Orabbix - poolTimeout=100
    2016-06-20 10:44:03,466 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
    2016-06-20 10:44:03,466 [main] INFO Orabbix - numTestsPerEvictionRun=3
    2016-06-20 10:44:05,882 [main] INFO Orabbix - Connected as ZABBIX
    2016-06-20 10:44:05,896 [main] INFO Orabbix - --------- on Database -> phmweb_p
    2016-06-20 10:44:06,101 [main] ERROR Orabbix - Error on getZabbixServers while getting zabbix.pharmacy.arizona.edu.Address null
    2016-06-20 10:44:06,101 [main] WARN Orabbix - Warning on getZabbixServers while getting zabbix.pharmacy.arizona.edu.Port null
    2016-06-20 10:44:06,101 [main] WARN Orabbix - Warning I will use the default port10051
    2016-06-20 10:44:08,694 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database PHMWEB QueryList elapsed time 2590 ms

    The errors are odd because the zabbix config looks right:

    #comma separed list of Zabbix servers
    ZabbixServerList=zabbix.pharmacy.arizona.edu
    ZabbixServer1.Address=10.128.206.126
    ZabbixServer1.Port=10051

    I set the log level to DEBUG and now I get tons of notices like this:

    2016-06-20 13:44:05,433 [main] DEBUG Orabbix - Loaded the properties from ./conf/query.props
    2016-06-20 13:44:05,480 [main] DEBUG Orabbix - Note: archive.NoDataFound null or not present null
    2016-06-20 13:44:05,480 [main] DEBUG Orabbix - Note: archive.WhenNotAlive null or not present null
    2016-06-20 13:44:05,480 [main] DEBUG Orabbix - Note: archive.Period null or not present null
    2016-06-20 13:44:05,480 [main] DEBUG Orabbix - Note: archive.ExcludeColumnsList error null
    2016-06-20 13:44:05,481 [main] DEBUG Orabbix - Note: archive.RaceConditionQueryExcludeColumnsList error null
    2016-06-20 13:44:05,482 [main] DEBUG Orabbix - Note: audit.WhenNotAlive null or not present null
    2016-06-20 13:44:05,484 [main] DEBUG Orabbix - Note: audit.RaceConditionQuery null or not present null
    2016-06-20 13:44:05,484 [main] DEBUG Orabbix - Note: audit.RaceConditionValue null or not present null
    2016-06-20 13:44:05,484 [main] DEBUG Orabbix - Note: audit.Period null or not present null
    2016-06-20 13:44:05,484 [main] DEBUG Orabbix - Note: audit.ExcludeColumnsList error null

    The query.props file looks fine to me.

    What is going on?
Working...