Ad Widget

**dagun** · 13-03-2012, 11:12

Hi, I think your soft have bug.

Originally posted by dagun

I am using version 0.5.1 of dbforbix.

When I use orabbix to monitor orable database, I can get 57 items results.
But , when I am testing with dbforbix-0.5 to monitor oracle, I could get only two items:Alive and DBforBIX Version. I will get nothing.
The log file is:
2012-03-14 00:58:12,057 [main] INFO DBforBIX - Starting DBforBIX Version 0.5
2012-03-14 00:58:22,107 [main] INFO DBforBIX - DBforBIX started with pid:5052
2012-03-14 00:58:22,108 [main] INFO DBforBIX - PidFile -> ./logs/dbforbix.pid
2012-03-14 00:58:22,114 [main] DEBUG DBforBIX - getConnection for database DB10
2012-03-14 00:58:22,555 [main] DEBUG DBforBIX - Trying to connect to database...
2012-03-14 00:58:22,601 [main] DEBUG DBforBIX - Connection attempt to database succeeded.
2012-03-14 00:58:41,074 [main] INFO DBforBIX - Connected as TEST
2012-03-14 00:58:41,078 [main] INFO DBforBIX - --------- on Database -> hrsoft
2012-03-14 00:58:41,103 [main] DEBUG DBforBIX - Loaded the properties from ./conf/oraclequery.props
2012-03-14 00:58:41,110 [main] DEBUG DBforBIX - Note: archive.NoDataFound null or not present null
2012-03-14 00:58:41,111 [main] DEBUG DBforBIX - Note: archive.WhenNotAlive null or not present null
2012-03-14 00:58:41,111 [main] DEBUG DBforBIX - Note: archive.Period null or not present null
2012-03-14 00:58:41,112 [main] DEBUG DBforBIX - Note: DefaultQueryPeriod null or not present using default values 2 min.
2012-03-14 00:58:41,112 [main] DEBUG DBforBIX - Note: archive.ExcludeColumnsList error null
2012-03-14 00:58:41,113 [main] DEBUG DBforBIX - Note: archive.RaceConditionQueryExcludeColumnsList error null
2012-03-14 00:58:41,116 [main] DEBUG DBforBIX - Note: audit.WhenNotAlive null or not present null
2012-03-14 00:58:41,116 [main] DEBUG DBforBIX - Note: audit.RaceConditionQuery null or not present null
2012-03-14 00:58:41,117 [main] DEBUG DBforBIX - Note: audit.RaceConditionValue null or not present null
2012-03-14 00:58:41,117 [main] DEBUG DBforBIX - Note: audit.Period null or not present null
2012-03-14 00:58:41,118 [main] DEBUG DBforBIX - Note: DefaultQueryPeriod null or not present using default values 2 min.
2012-03-14 00:58:41,118 [main] DEBUG DBforBIX - Note: audit.ExcludeColumnsList error null
2012-03-14 00:58:41,118 [main] DEBUG DBforBIX - Note: audit.RaceConditionQueryExcludeColumnsList error null
2012-03-14 00:58:41,119 [main] DEBUG DBforBIX - Note: dbblockgets.NoDataFound null or not present null
2012-03-14 00:58:41,119 [main] DEBUG DBforBIX - Note: dbblockgets.WhenNotAlive null or not present null
2012-03-14 00:58:41,119 [main] DEBUG DBforBIX - Note: dbblockgets.RaceConditionQuery null or not present null
2012-03-14 00:58:41,120 [main] DEBUG DBforBIX - Note: dbblockgets.RaceConditionValue null or not present null
2012-03-14 00:58:41,120 [main] DEBUG DBforBIX - Note: dbblockgets.Period null or not present null
2012-03-14 00:58:41,120 [main] DEBUG DBforBIX - Note: DefaultQueryPeriod null or not present using default values 2 min.
2012-03-14 00:58:41,121 [main] DEBUG DBforBIX - Note: dbblockgets.ExcludeColumnsList error null
2012-03-14 00:58:41,121 [main] DEBUG DBforBIX - Note: dbblockgets.RaceConditionQueryExcludeColumnsList error null

Why are they not same? Give me a message.Thanks.

**dalle** · 14-03-2012, 12:41

Originally posted by dagun

When I use orabbix to monitor orable database, I can get 57 items results.
But , when I am testing with dbforbix-0.5 to monitor oracle, I could get only two items:Alive and DBforBIX Version. I will get nothing.
The log file is:
2012-03-14 00:58:12,057 [main] INFO DBforBIX - Starting DBforBIX Version 0.5
2012-03-14 00:58:22,107 [main] INFO DBforBIX - DBforBIX started with pid:5052
2012-03-14 00:58:22,108 [main] INFO DBforBIX - PidFile -> ./logs/dbforbix.pid
2012-03-14 00:58:22,114 [main] DEBUG DBforBIX - getConnection for database DB10
2012-03-14 00:58:22,555 [main] DEBUG DBforBIX - Trying to connect to database...
2012-03-14 00:58:22,601 [main] DEBUG DBforBIX - Connection attempt to database succeeded.
2012-03-14 00:58:41,074 [main] INFO DBforBIX - Connected as TEST
2012-03-14 00:58:41,078 [main] INFO DBforBIX - --------- on Database -> hrsoft
2012-03-14 00:58:41,103 [main] DEBUG DBforBIX - Loaded the properties from ./conf/oraclequery.props
2012-03-14 00:58:41,110 [main] DEBUG DBforBIX - Note: archive.NoDataFound null or not present null
2012-03-14 00:58:41,111 [main] DEBUG DBforBIX - Note: archive.WhenNotAlive null or not present null
2012-03-14 00:58:41,111 [main] DEBUG DBforBIX - Note: archive.Period null or not present null
2012-03-14 00:58:41,112 [main] DEBUG DBforBIX - Note: DefaultQueryPeriod null or not present using default values 2 min.
2012-03-14 00:58:41,112 [main] DEBUG DBforBIX - Note: archive.ExcludeColumnsList error null
2012-03-14 00:58:41,113 [main] DEBUG DBforBIX - Note: archive.RaceConditionQueryExcludeColumnsList error null
2012-03-14 00:58:41,116 [main] DEBUG DBforBIX - Note: audit.WhenNotAlive null or not present null
2012-03-14 00:58:41,116 [main] DEBUG DBforBIX - Note: audit.RaceConditionQuery null or not present null
2012-03-14 00:58:41,117 [main] DEBUG DBforBIX - Note: audit.RaceConditionValue null or not present null
2012-03-14 00:58:41,117 [main] DEBUG DBforBIX - Note: audit.Period null or not present null
2012-03-14 00:58:41,118 [main] DEBUG DBforBIX - Note: DefaultQueryPeriod null or not present using default values 2 min.
2012-03-14 00:58:41,118 [main] DEBUG DBforBIX - Note: audit.ExcludeColumnsList error null
2012-03-14 00:58:41,118 [main] DEBUG DBforBIX - Note: audit.RaceConditionQueryExcludeColumnsList error null
2012-03-14 00:58:41,119 [main] DEBUG DBforBIX - Note: dbblockgets.NoDataFound null or not present null
2012-03-14 00:58:41,119 [main] DEBUG DBforBIX - Note: dbblockgets.WhenNotAlive null or not present null
2012-03-14 00:58:41,119 [main] DEBUG DBforBIX - Note: dbblockgets.RaceConditionQuery null or not present null
2012-03-14 00:58:41,120 [main] DEBUG DBforBIX - Note: dbblockgets.RaceConditionValue null or not present null
2012-03-14 00:58:41,120 [main] DEBUG DBforBIX - Note: dbblockgets.Period null or not present null
2012-03-14 00:58:41,120 [main] DEBUG DBforBIX - Note: DefaultQueryPeriod null or not present using default values 2 min.
2012-03-14 00:58:41,121 [main] DEBUG DBforBIX - Note: dbblockgets.ExcludeColumnsList error null
2012-03-14 00:58:41,121 [main] DEBUG DBforBIX - Note: dbblockgets.RaceConditionQueryExcludeColumnsList error null

Why are they not same? Give me a message.Thanks.

Dear dagun,
try with the last version of dbforbix I released the 0.6 that has some improvement.

**dalle** · 14-03-2012, 12:46

DBforBIX 0.6 has been relased

I released DBforBIX 0.6 more info are available here

**viniciusbecker** · 19-06-2012, 19:10

Hi!
I’ve configured DBforBIX to monitor my PostgreSQL database (the same of zabbix server) but i’m facing a problem. In the Zabbix frontend there isn't any information about the monitored database. Below is my log file:

Code:

…
2012-06-15 13:48:36,388 [main] INFO  DBforBIX - Starting DBforBIX Version 0.5.1
2012-06-15 13:48:36,404 [main] INFO  DBforBIX - DBforBIX started with pid:7608
2012-06-15 13:48:36,404 [main] INFO  DBforBIX - PidFile -> ./logs/orabbix.pid
2012-06-15 13:48:36,612 [main] INFO  DBforBIX - Connected as zabbix
2012-06-15 13:48:36,614 [main] INFO  DBforBIX - --------- on Database -> postgres
2012-06-15 13:48:36,755 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database PGSQL elapsed time 83 ms
2012-06-15 13:49:36,690 [pool-1-thread-2] INFO  DBforBIX - Done with dbJob on database PGSQL elapsed time 8 ms
2012-06-15 13:50:36,754 [pool-1-thread-3] INFO  DBforBIX - Done with dbJob on database PGSQL elapsed time 53 ms
2012-06-15 13:51:36,730 [pool-1-thread-4] INFO  DBforBIX - Done with dbJob on database PGSQL elapsed time 9 ms
2012-06-15 13:52:36,779 [pool-1-thread-5] INFO  DBforBIX - Done with dbJob on database PGSQL elapsed time 51 ms
…

I've already tried to delete and import the template, but no data is shown in the admin frontend. Now i’m using the 0.5.1 version of DBforBIX, but the problem occurs with the version 0.6 too.

Can anyone help me?

**dalle** · 19-06-2012, 19:32

Sorry for this basic question but:
Did you created an host inside Zabbix with name PGSQL ?
And this host has the right template associated?

**viniciusbecker** · 19-06-2012, 19:55

Originally posted by dalle

Sorry for this basic question but:
Did you created an host inside Zabbix with name PGSQL ?
And this host has the right template associated?

Oh, i'm sorry, was my fault... The hostname inside Zabbix wasn't "PGSQL". After renaming it, it worked perfectly!

Thanks a lot!

**absolut777** · 03-08-2012, 17:57

Hello! I tried to install dbforbix 0.6 with oracle lib and I have a problem with startup dbforbix. I received message:

Code:

Stopping
java.lang.NullPointerException
	at java.lang.String.<init>(String.java:165)
	at com.smartmarmot.common.Configurator.getQueryFile(Configurator.java:634)
	at com.smartmarmot.common.Configurator.buildQueryBoxbyDBName(Configurator.java:959)
	at com.smartmarmot.dbforbix.DBforBIX.run(DBforBIX.java:132)
	at com.smartmarmot.dbforbix.bootstrap.main(bootstrap.java:45)

dbforbix.log:
2012-08-03 19:44:37,642 [main] INFO DBforBIX - Starting DBforBIX Version 0.6
2012-08-03 19:44:37,660 [main] INFO DBforBIX - DBforBIX started with pid:6878
2012-08-03 19:44:37,660 [main] INFO DBforBIX - PidFile -> ./logs/dbforbix.pid
2012-08-03 19:44:38,337 [main] INFO DBforBIX - Connected as ZABBIX
2012-08-03 19:44:38,339 [main] INFO DBforBIX - --------- on Database -> loadtest

config.props:

Code:

#comma separed list of Zabbix servers here are only 2 but you can add how many you want
ZabbixServerList=ZabbixServer1

ZabbixServer1.Address=127.0.0.1
ZabbixServer1.Port=10051

#pidFile
DBforBIX.PidFile=./logs/dbforbix.pid
#frequency of item's refresh
DBforBIX.Sleep=30
#MaxThreadNumber should be >= than the number of your databases
DBforBIX.MaxThreadNumber=100

#put here your databases in a comma separated list
DatabaseList=loadtest

#Configuration of Connection pool
#if not specified Orabbis is going to use default values (hardcoded)
#Maximum number of active connection inside pool
DatabaseList.MaxActive=10
#The maximum number of milliseconds that the pool will wait 
#(when there are no available connections) for a connection to be returned 
#before throwing an exception, or <= 0 to wait indefinitely. 
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1
###Oracle
#define here your connection string for each database
#on the following example we are treating Oracle
loadtest.Url=jdbc:oracle:thin:@172.20.0.3:1521:loadtest
loadtest.User=zabbix
loadtest.Password=qweasd123
loadtest.DatabaseType=oracle
loadtest=./conf/oraclequery.props
#Those values are optionals if not specified DBforBIX is going to use the general values
#ORACLEDB1.MaxActive=10
#ORACLEDB1.MaxWait=100
#ORACLEDB1.MaxIdle=1

My envirnment:
java version "1.7.0_05-icedtea"
CentOS release 6.3 (Final)
zabbix 2.0.1

Could you help me with resolve this issue?

**dalle** · 08-08-2012, 19:05

Originally posted by absolut777

Hello! I tried to install dbforbix 0.6 with oracle lib and I have a problem with startup dbforbix. I received message:

Code:

Stopping
java.lang.NullPointerException
	at java.lang.String.<init>(String.java:165)
	at com.smartmarmot.common.Configurator.getQueryFile(Configurator.java:634)
	at com.smartmarmot.common.Configurator.buildQueryBoxbyDBName(Configurator.java:959)
	at com.smartmarmot.dbforbix.DBforBIX.run(DBforBIX.java:132)
	at com.smartmarmot.dbforbix.bootstrap.main(bootstrap.java:45)

dbforbix.log:
2012-08-03 19:44:37,642 [main] INFO DBforBIX - Starting DBforBIX Version 0.6
2012-08-03 19:44:37,660 [main] INFO DBforBIX - DBforBIX started with pid:6878
2012-08-03 19:44:37,660 [main] INFO DBforBIX - PidFile -> ./logs/dbforbix.pid
2012-08-03 19:44:38,337 [main] INFO DBforBIX - Connected as ZABBIX
2012-08-03 19:44:38,339 [main] INFO DBforBIX - --------- on Database -> loadtest

config.props:

Code:

#comma separed list of Zabbix servers here are only 2 but you can add how many you want
ZabbixServerList=ZabbixServer1

ZabbixServer1.Address=127.0.0.1
ZabbixServer1.Port=10051

#pidFile
DBforBIX.PidFile=./logs/dbforbix.pid
#frequency of item's refresh
DBforBIX.Sleep=30
#MaxThreadNumber should be >= than the number of your databases
DBforBIX.MaxThreadNumber=100

#put here your databases in a comma separated list
DatabaseList=loadtest

#Configuration of Connection pool
#if not specified Orabbis is going to use default values (hardcoded)
#Maximum number of active connection inside pool
DatabaseList.MaxActive=10
#The maximum number of milliseconds that the pool will wait 
#(when there are no available connections) for a connection to be returned 
#before throwing an exception, or <= 0 to wait indefinitely. 
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1
###Oracle
#define here your connection string for each database
#on the following example we are treating Oracle
loadtest.Url=jdbc:oracle:thin:@172.20.0.3:1521:loadtest
loadtest.User=zabbix
loadtest.Password=qweasd123
loadtest.DatabaseType=oracle
loadtest=./conf/oraclequery.props
#Those values are optionals if not specified DBforBIX is going to use the general values
#ORACLEDB1.MaxActive=10
#ORACLEDB1.MaxWait=100
#ORACLEDB1.MaxIdle=1

My envirnment:
java version "1.7.0_05-icedtea"
CentOS release 6.3 (Final)
zabbix 2.0.1

Could you help me with resolve this issue?

Well to be honest I never try to use the java 1.7 so I don't know if there are exception or new issue using that release...
could you try with java 1.6?
thank you

**absolut777** · 09-08-2012, 10:08

I have tried java 6 today, but without success((

Code:

rpm -qa|grep java
java-1.6.0-openjdk-1.6.0.0-1.48.1.11.3.el6_2.i686
java-1.6.0-openjdk-devel-1.6.0.0-1.48.1.11.3.el6_2.i686

Code:

[root@zabbix logs]# /etc/init.d/dbforbix start
Starting DBforBIX service:
[root@zabbix logs]# Stopping
java.lang.NullPointerException
	at java.lang.String.<init>(String.java:164)
	at com.smartmarmot.common.Configurator.getQueryFile(Configurator.java:634)
	at com.smartmarmot.common.Configurator.buildQueryBoxbyDBName(Configurator.java:959)
	at com.smartmarmot.dbforbix.DBforBIX.run(DBforBIX.java:132)
	at com.smartmarmot.dbforbix.bootstrap.main(bootstrap.java:45)

**andreazza** · 14-09-2012, 20:30

reading but not showing

hi
maybe someone can help me...

i have
zabbix server 2.0.2
dbforbix 0.6
centos 6.3
java version "1.6.0_24"
OpenJDK Runtime Environment (IcedTea6 1.11.4) (rhel-1.49.1.11.4.el6_3-x86_64)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)

my log file:
2012-09-14 15:13:30,895 [main] INFO DBforBIX - Starting DBforBIX Version 0.6
2012-09-14 15:13:31,266 [main] INFO DBforBIX - DBforBIX started with pid:2062
2012-09-14 15:13:31,266 [main] INFO DBforBIX - PidFile -> ./logs/orabbix.pid
2012-09-14 15:13:34,007 [main] INFO DBforBIX - Connected as ZABBIX
2012-09-14 15:13:34,008 [main] INFO DBforBIX - --------- on Database -> XE
2012-09-14 15:13:34,679 [pool-1-thread-1] INFO DBforBIX - Done with dbJob on database ORACLEDB1 elapsed time 528 ms
2012-09-14 15:14:34,182 [pool-1-thread-2] INFO DBforBIX - Done with dbJob on database ORACLEDB1 elapsed time 16 ms
2012-09-14 15:15:34,395 [pool-1-thread-3] INFO DBforBIX - Done with dbJob on database ORACLEDB1 elapsed time 213 ms
2012-09-14 15:16:34,248 [pool-1-thread-4] INFO DBforBIX - Done with dbJob on database ORACLEDB1 elapsed time 47 ms

my screen on zabbix
Name
CPU (13 Items)
Filesystems (15 Items)
General (5 Items)
Memory (5 Items)
Network interfaces (2 Items)
OS (8 Items)
Performance (13 Items)
Processes (2 Items)
Security (2 Items)
Zabbix agent (3 Items)

i attached this server on Template Linux AND Template Oracle

my DBA say that the trapper is reading my db, he can see connections from my zabbix server
but in latest data, no data is showing..
i tried telnet from my dbserver to zabbixserver 10051, and its ok..

where else can i check??
i think i'm missing something...

**andreazza** · 26-10-2012, 20:05

hi everybody!

i tried to install dbforbix 0.6 on a 1.8.15 zabbix server, and still cant see anydata coming to my screen...
any suggestions?

thanks!

**dalle** · 26-10-2012, 21:30

Originally posted by andreazza

hi
maybe someone can help me...

i have
zabbix server 2.0.2
dbforbix 0.6
centos 6.3
java version "1.6.0_24"
OpenJDK Runtime Environment (IcedTea6 1.11.4) (rhel-1.49.1.11.4.el6_3-x86_64)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)

my log file:
2012-09-14 15:13:30,895 [main] INFO DBforBIX - Starting DBforBIX Version 0.6
2012-09-14 15:13:31,266 [main] INFO DBforBIX - DBforBIX started with pid:2062
2012-09-14 15:13:31,266 [main] INFO DBforBIX - PidFile -> ./logs/orabbix.pid
2012-09-14 15:13:34,007 [main] INFO DBforBIX - Connected as ZABBIX
2012-09-14 15:13:34,008 [main] INFO DBforBIX - --------- on Database -> XE
2012-09-14 15:13:34,679 [pool-1-thread-1] INFO DBforBIX - Done with dbJob on database ORACLEDB1 elapsed time 528 ms
2012-09-14 15:14:34,182 [pool-1-thread-2] INFO DBforBIX - Done with dbJob on database ORACLEDB1 elapsed time 16 ms
2012-09-14 15:15:34,395 [pool-1-thread-3] INFO DBforBIX - Done with dbJob on database ORACLEDB1 elapsed time 213 ms
2012-09-14 15:16:34,248 [pool-1-thread-4] INFO DBforBIX - Done with dbJob on database ORACLEDB1 elapsed time 47 ms

my screen on zabbix
Name
CPU (13 Items)
Filesystems (15 Items)
General (5 Items)
Memory (5 Items)
Network interfaces (2 Items)
OS (8 Items)
Performance (13 Items)
Processes (2 Items)
Security (2 Items)
Zabbix agent (3 Items)

i attached this server on Template Linux AND Template Oracle

my DBA say that the trapper is reading my db, he can see connections from my zabbix server
but in latest data, no data is showing..
i tried telnet from my dbserver to zabbixserver 10051, and its ok..

where else can i check??
i think i'm missing something...

Did you created an host called exactly ORACLEDB1 and .. on that you should have applied my template..
Let me know the most common error is this one

**andreazza** · 26-10-2012, 21:39

Originally posted by dalle

Did you created an host called exactly ORACLEDB1 and .. on that you should have applied my template..
Let me know the most common error is this one

OMG... i didnt see that on documentation! LOL
MY mistake!! but yes! it worked!
i changed in config.props ORACLEDB1 to machine hostname "bancos" and it worked instantly!
thanks!!!!
uuhuuulll!!

**dalle** · 26-10-2012, 21:42

Originally posted by andreazza

OMG... i didnt see that on documentation! LOL
MY mistake!! but yes! it worked!
i changed in config.props ORACLEDB1 to machine hostname "bancos" and it worked instantly!
thanks!!!!
uuhuuulll!!

Cool I'm happy to hear that

**esawyja** · 02-11-2012, 08:57

Problem with Oracle connect using DBforBIX

Hi,
I'm monitoring Oracle and Postgres servers using DBforBIX, before I used Orabbix and Postbix and they worked fine, then I decided to use DBforBix, The Postgres monitoring is not a problem, but the problem is with Oracle, yes I do have the jar file in the /lib directory, I copied it from the Orabbix installation,
zabbix:/opt/dbforbix/lib # ls -ltr
total 6136
-rw-r--r-- 1 root root 23546 Mar 12 2012 commons-daemon-1.0.5.jar
-rw-r--r-- 1 root root 539705 Mar 12 2012 postgresql-9.0-801.jdbc4.jar
-rw-r--r-- 1 root root 775688 Mar 12 2012 mysql-connector-java-5.1.14-bin.jar
-rw-r--r-- 1 root root 302284 Mar 12 2012 jtds-1.2.5.jar
-rw-r--r-- 1 root root 391834 Nov 1 14:19 log4j-1.2.15.jar
-rw-r--r-- 1 root root 1374645 Nov 1 14:19 hsqldb.jar
-rw-r--r-- 1 root root 96221 Nov 1 14:19 commons-pool-1.5.4.jar
-rw-r--r-- 1 root root 60841 Nov 1 14:19 commons-logging-1.1.1.jar
-rw-r--r-- 1 root root 279193 Nov 1 14:19 commons-lang-2.5.jar
-rw-r--r-- 1 root root 160519 Nov 1 14:19 commons-dbcp-1.4.jar
-rw-r--r-- 1 root root 58160 Nov 1 14:19 commons-codec-1.4.jar
-rw-r--r-- 1 root root 2152051 Nov 1 15:53 ojdbc6.jar
zabbix:/opt/dbforbix/lib #
The problem is that in the log file, the connection seems to be fine AND I'm getting values in Zabbix, but then I get this error in the logfile

2012-11-02 08:18:59,343 [pool-1-thread-78] INFO DBforBIX - Done with dbJob on database xxx elapsed time 9 ms
2012-11-02 08:18:59,606 [pool-1-thread-79] INFO DBforBIX - Done with dbJob on database xxx elapsed time 276 ms
2012-11-02 08:18:59,618 [pool-1-thread-80] INFO DBforBIX - Done with dbJob on database xxx elapsed time 285 ms
2012-11-02 08:18:59,628 [pool-1-thread-76] INFO DBforBIX - Done with dbJob on database xxx elapsed time 285 ms
2012-11-02 08:19:00,072 [pool-1-thread-77] INFO DBforBIX - Done with dbJob on database xxx elapsed time 750 ms
2012-11-02 08:19:09,694 [main] INFO DBforBIX - New database founded! xxx
2012-11-02 08:19:09,695 [main] ERROR DBforBIX - Error when attempting to obtain DB Driver: oracle.jdbc.OracleDriver on Fri Nov 02 08:19:09 SAST 2012java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
2012-11-02 08:19:09,695 [main] ERROR DBforBIX - Error on Configurator for database xxx -->No suitable driver found for jdbc

racle:thin:@172.28.200.82:1521:dte
2012-11-02 08:19:09,695 [main] INFO DBforBIX - New database founded! xxx
2012-11-02 08:19:09,695 [main] ERROR DBforBIX - Error when attempting to obtain DB Driver: oracle.jdbc.OracleDriver on Fri Nov 02 08:19:09 SAST 2012java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
2012-11-02 08:19:09,696 [main] ERROR DBforBIX - Error on Configurator for database xxx -->No suitable driver found for jdbc

racle:thin:@172.28.200.91:1521:dte
2012-11-02 08:19:09,696 [main] INFO DBforBIX - New database founded! xxx
2012-11-02 08:19:09,696 [main] ERROR DBforBIX - Error when attempting to obtain DB Driver: oracle.jdbc.OracleDriver on Fri Nov 02 08:19:09 SAST 2012java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
2012-11-02 08:19:09,696 [main] ERROR DBforBIX - Error on Configurator for database xxx -->No suitable driver found for jdbc

racle:thin:@10.114.11.253:1521:dte
2012-11-02 08:19:09,696 [main] INFO DBforBIX - New database founded! xxx
2012-11-02 08:19:09,696 [main] ERROR DBforBIX - Error when attempting to obtain DB Driver: oracle.jdbc.OracleDriver on Fri Nov 02 08:19:09 SAST 2012java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
2012-11-02 08:19:09,696 [main] ERROR DBforBIX - Error on Configurator for database xxx -->No suitable driver found for jdbc

racle:thin:@10.199.25.142:1521:dte
2012-11-02 08:19:09,727 [pool-1-thread-97] INFO DBforBIX - Done with dbJob on database xxx elapsed time 10 ms
2012-11-02 08:19:09,820 [pool-1-thread-99] INFO DBforBIX - Done with dbJob on database xxx elapsed time 122 ms
2012-11-02 08:19:09,978 [pool-1-thread-98] INFO DBforBIX - Done with dbJob on database xxx elapsed time 276 ms
2012-11-02 08:19:09,996 [pool-1-thread-96] INFO DBforBIX - Done with dbJob on database xxx elapsed time 285 ms
2012-11-02 08:19:10,013 [pool-1-thread-100] INFO DBforBIX - Done with dbJob on database xxx elapsed time 286 ms

The Postgres connections are fine and I'm getting values for the Oracle databases, see attachements

The config file
#define here your connection string for each database
xxx.Url=jdbc

racle:thin:@xxxxxxx:1521:dte
xxx.User=zabbix
xxx.Password=xxxxxxx
xxx.DatabaseType=oracle
xxx.QueryListFile=./conf/oraclequery.props
#Those values are optionals if not specified Orabbix is going to use the general values
xxx.MaxActive=10
xxx.MaxWait=100
xxx.MaxIdle=1

Any suggestions on how to fix this?

Ad Widget

DBforBIX

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment