DBforBIX

[dalle]

Hi David,
did you downloaded oracle's jdbc driver?
It's no more included on mine distribution.
Please verify that you have ojdbc6.jar inside /lib/ directory

[Yello]

Hi David,
did you downloaded oracle's jdbc driver?
It's no more included on mine distribution.
Please verify that you have ojdbc6.jar inside /lib/ directory

Hi Dalle,
I didn't have the driver and have now downloaded it and installed in the lib directory. However, I still have errors:

2011-09-26 11:32:46,526 [main] INFO DBforBIX - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@49bdc9d8
2011-09-26 11:32:46,526 [main] INFO DBforBIX - URL=jdbcracle:thin:@<IP Addr>:<Port>:nmsd
2011-09-26 11:32:46,526 [main] INFO DBforBIX - maxPoolSize=5
2011-09-26 11:32:46,526 [main] INFO DBforBIX - maxIdleSize=1
2011-09-26 11:32:46,526 [main] INFO DBforBIX - maxIdleTime=1800000ms
2011-09-26 11:32:46,526 [main] INFO DBforBIX - poolTimeout=100
2011-09-26 11:32:46,526 [main] INFO DBforBIX - timeBetweenEvictionRunsMillis=-1
2011-09-26 11:32:46,526 [main] INFO DBforBIX - numTestsPerEvictionRun=3
2011-09-26 11:32:46,687 [main] ERROR DBforBIX - Error on Configurator for database pulley -->ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

Regards,
David

[molokolab]

If I understand correctly in the log of all good:

 2011-10-11 19:11:26,864 [main] DEBUG Orabbix - Note: uptime.Period null or not present null
 2011-10-11 19:11:26,865 [main] DEBUG Orabbix - Note: uptime.Period null or not present using default values 5 min.
 2011-10-11 19:11:26,865 [main] DEBUG Orabbix - Note: uptime.ExcludeColumnsList error null
 2011-10-11 19:11:26,865 [main] DEBUG Orabbix - Note: uptime.RaceConditionQueryExcludeColumnsList error null
 2011-10-11 19:11:26,865 [main] DEBUG Orabbix - Ready to run DBJob for dbname ->DB1
 2011-10-11 19:11:26,865 [pool-1-thread-5] DEBUG Orabbix - Starting dbJob on database DB1 QueryList
 2011-10-11 19:11:26,876 [pool-1-thread-5] DEBUG Orabbix - sending <req><host>REIx</host><key>YWxpdmU=</key><data>MQ==</data></req>
 2011-10-11 19:11:26,878 [pool-1-thread-5] DEBUG Orabbix - received OK
 2011-10-11 19:11:26,878 [pool-1-thread-5] DEBUG Orabbix - sending <req><host>REIx</host><key>T3JhYmJpeFZlcnNpb24=</key><data>T3JhYmJpeCBWZXJzaW9uIDEuMi4w</data></req>
 2011-10-11 19:11:26,878 [pool-1-thread-5] DEBUG Orabbix - received OK
 2011-10-11 19:11:26,878 [pool-1-thread-5] INFO  Orabbix - Done with dbJob on database DB1 QueryList elapsed time 13 ms

I Load the orabix Template, but i can't see any data in zabbix portal..
What's wrong?

[dalle]

If I understand correctly in the log of all good:

 2011-10-11 19:11:26,864 [main] DEBUG Orabbix - Note: uptime.Period null or not present null
 2011-10-11 19:11:26,865 [main] DEBUG Orabbix - Note: uptime.Period null or not present using default values 5 min.
 2011-10-11 19:11:26,865 [main] DEBUG Orabbix - Note: uptime.ExcludeColumnsList error null
 2011-10-11 19:11:26,865 [main] DEBUG Orabbix - Note: uptime.RaceConditionQueryExcludeColumnsList error null
 2011-10-11 19:11:26,865 [main] DEBUG Orabbix - Ready to run DBJob for dbname ->DB1
 2011-10-11 19:11:26,865 [pool-1-thread-5] DEBUG Orabbix - Starting dbJob on database DB1 QueryList
 2011-10-11 19:11:26,876 [pool-1-thread-5] DEBUG Orabbix - sending <req><host>REIx</host><key>YWxpdmU=</key><data>MQ==</data></req>
 2011-10-11 19:11:26,878 [pool-1-thread-5] DEBUG Orabbix - received OK
 2011-10-11 19:11:26,878 [pool-1-thread-5] DEBUG Orabbix - sending <req><host>REIx</host><key>T3JhYmJpeFZlcnNpb24=</key><data>T3JhYmJpeCBWZXJzaW9uIDEuMi4w</data></req>
 2011-10-11 19:11:26,878 [pool-1-thread-5] DEBUG Orabbix - received OK
 2011-10-11 19:11:26,878 [pool-1-thread-5] INFO  Orabbix - Done with dbJob on database DB1 QueryList elapsed time 13 ms

I Load the orabix Template, but i can't see any data in zabbix portal..
What's wrong?

from your log seem that you have a database called "DB1" inside config file
DEBUG Orabbix - Ready to run DBJob for dbname ->DB1
and you should have the same host
DB1 inside zabbix server.
if you don't have an host with the name DB1 zabbix simply discard the item received.

[molokolab]

from your log seem that you have a database called "DB1" inside config file
DEBUG Orabbix - Ready to run DBJob for dbname ->DB1
and you should have the same host
DB1 inside zabbix server.
if you don't have an host with the name DB1 zabbix simply discard the item received.

i have in orabix config:
DB1.Url=jdbcracle:thin:@oracle.domail.ru:1521BSID
DB1.User=ZABBIX
DB1.Password=zabbix

in zabbix portal i have a host oracle.domail.ru and this host have "Template Oracle"

[dalle]

You need to have an host exactly called DB1 so... or you create an host called DB1 (inside zabbix)
ot you change
from
DB1.Url=jdbcracle:thin:@oracle.domail.ru:1521BSID
DB1.User=ZABBIX
DB1.Password=zabbix
to
oracle.domail.ru.Url=jdbcracle:thin:@oracle.domail.ru:1521BSID
oracle.domail.ru.User=ZABBIX
oracle.domail.ru.Password=zabbix

let me know

[molokolab]

You need to have an host exactly called DB1 so... or you create an host called DB1 (inside zabbix)
ot you change
from
DB1.Url=jdbcracle:thin:@oracle.domail.ru:1521BSID
DB1.User=ZABBIX
DB1.Password=zabbix
to
oracle.domail.ru.Url=jdbcracle:thin:@oracle.domail.ru:1521BSID
oracle.domail.ru.User=ZABBIX
oracle.domail.ru.Password=zabbix

let me know

Thank you very much it helped!!!!!!!!!!

write about it in the documentation

[dalle]

Thank you very much it helped!!!!!!!!!!

write about it in the documentation

your're welcome!

[Yello]

your're welcome!

Hi,
I've seen no reply to my post about oracle errors. Could you comment on that please?


Regards,
David

[dalle]

Hi,
I've seen no reply to my post about oracle errors. Could you comment on that please?


Regards,
David

Sure I don't think that it's about my software. I've found an Oracle Note about your issue on metalink, I don't know if you can log in btw here in attach there is the note.
try to see if this can help
Regards
Andrea

[Yello]

Hi,
I've fixed it by adding the following to run.sh:

"-Duser.timezone=GMT"

So, I think you need to factor that into your default release.


Regards,
David

[dalle]

Hi,
I've fixed it by adding the following to run.sh:

"-Duser.timezone=GMT"

So, I think you need to factor that into your default release.


Regards,
David

Thank you!
I wasn't able to reproduce your issue
Thank you for this suggestion
Regards
Andrea

[dalle]

Hi,
I've fixed it by adding the following to run.sh:

"-Duser.timezone=GMT"

So, I think you need to factor that into your default release.


Regards,
David

I've published your suggestion on my website

[ninguno]

Hi dalle! This sort of plugin for zabbix seems really great!!! Thanks for your work.
I'm having same problem configuring dbforbix 0.4 for monitoring a mysql database. Zabbix is 1.8.8 in an Ubuntu 10.04.

When I start dbforbix I'm getting this error

2011-11-15 13:12:39,620 [main] INFO DBforBIX - Starting DBforBIX Version 0.4
2011-11-15 13:12:39,634 [main] INFO DBforBIX - DBforBIX started with pid:14113
2011-11-15 13:12:39,634 [main] INFO DBforBIX - PidFile -> ./logs/dbforbix.pid
2011-11-15 13:12:39,675 [main] INFO DBforBIX - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@2c64f6cd
2011-11-15 13:12:39,675 [main] INFO DBforBIX - URL=jdbc:mysql://localhost:3306/zabbix
2011-11-15 13:12:39,675 [main] INFO DBforBIX - maxPoolSize=10
2011-11-15 13:12:39,675 [main] INFO DBforBIX - maxIdleSize=1
2011-11-15 13:12:39,675 [main] INFO DBforBIX - maxIdleTime=1800000ms
2011-11-15 13:12:39,675 [main] INFO DBforBIX - poolTimeout=100
2011-11-15 13:12:39,675 [main] INFO DBforBIX - timeBetweenEvictionRunsMillis=-1
2011-11-15 13:12:39,675 [main] INFO DBforBIX - numTestsPerEvictionRun=3
2011-11-15 13:12:39,990 [main] INFO DBforBIX - Connected as zabbix@localhost
2011-11-15 13:12:39,991 [main] INFO DBforBIX - --------- on Database -> zabbix
2011-11-15 13:12:40,389 [pool-1-thread-1] WARN DBforBIX - received unexpected response '@
5.1.41-3ubuntu12.9q.I9#CeTS%���^+WX5=rIUPrk¿½ï¿½Got packets out of order' for key 'DBforBIX.MySQL.alive'
2011-11-15 13:12:40,390 [pool-1-thread-1] WARN DBforBIX - received unexpected response '@
5.1.41-3ubuntu12.9r.";C|ix@t���HK!]50.8oFQE¿½ï¿½Got packets out of order' for key 'DBforBIX.Version'
2011-11-15 13:12:40,391 [pool-1-thread-1] WARN DBforBIX - received unexpected response '@
5.1.41-3ubuntu12.9s.Zk/CDifC���],^vX6B*Jv5C¿½ï¿½Got packets out of order' for key 'DBforBIX.MySQL.dbversion'
2011-11-15 13:12:40,395 [pool-1-thread-1] WARN DBforBIX - received unexpected response '@
5.1.41-3ubuntu12.9t.j;'O9nB>���LG]}!(BT`dVa¿½ï¿½Got packets out of order' for key 'DBforBIX.MySQL.Aborted_clients'
2011-11-15 13:12:40,396 [pool-1-thread-1] WARN DBforBIX - received unexpected response '@
5.1.41-3ubuntu12.9u.s2={uX9S���tr\V|,d6}63<¿½ï¿½Got packets out of order' for key 'DBforBIX.MySQL.Aborted_connects'
2011-11-15 13:12:40,397 [pool-1-thread-1] WARN DBforBIX - received unexpected response '@
5.1.41-3ubuntu12.9v.o8ewF5uq���V9[An*$q3GI{¿½ï¿½Got packets out of order' for key 'DBforBIX.MySQL.Binlog_cache_disk_use'
2011-11-15 13:12:40,397 [pool-1-thread-1] WARN DBforBIX - received unexpected response '@
5.1.41-3ubuntu12.9w.?n/<}'Fh���\tT%XoEI|X#C¿½ï¿½Got packets out of order' for key 'DBforBIX.MySQL.Binlog_cache_use'
2011-11-15 13:12:40,398 [pool-1-thread-1] WARN DBforBIX - received unexpected response '@

This is my config.props (mysqlquery.props remain untouch).

Do you know what the problem could be?
Thanks in advance!

[dalle]

did you changed the query file?
The response received from DB is invalid this is sure.. but i don't know why.. may be language setting or locale?