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=jdbc
racle: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?
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=jdbc
racle:thin:@xxxxxxx.pharmacy.arizona.edu:xxxx:PHMW EB2016-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?