DBforBIX

[ahowell]

DBforBIX with zabbix 1.9

It should work, but I don't know yet (it work with 1.9.3 for sure)

I'm using dbforbix 0.4 with zabbix 1.9.8 monitoring mysql with limited issues. Just the problem I mentioned on page 5 of this post about one of the checks not working with mysql > 5.1.2 as it doesn't have table_cache.

But that's more a mysql issue, than any issue with zabbix 1.9

[dalle]

I'm using dbforbix 0.4 with zabbix 1.9.8 monitoring mysql with limited issues. Just the problem I mentioned on page 5 of this post about one of the checks not working with mysql > 5.1.2 as it doesn't have table_cache.

But that's more a mysql issue, than any issue with zabbix 1.9

Absolutely true you need to customize query for postgresql too because postgresql 9 is different from 8. (I mean tables that contain statistics are not the same) but this is not an issue.... depend on your version.

[lgc78]

I switched to dbforbix 0.4 and now everything works as expected. Not sure why the latest version (dbforbix 0.5) doesn't work on my system.

Curious to know if anyone else has encountered this behaviour.

[dalle]

I switched to dbforbix 0.4 and now everything works as expected. Not sure why the latest version (dbforbix 0.5) doesn't work on my system.

Curious to know if anyone else has encountered this behaviour.

sorry but did you updated the template with the new one?
Because there are some key changed to fix an issue about collision between keys.
Now all MySQL Item are in the form DBforBIX.MySQL.<ItemKey>
so if you have a postgres and a mysql db on same server and together calld "TESDTDB" you don't have more collision.
Now all the Items have a key in the form of
DBforBIX.[MySQL|Oracle|DB2|MSSQL|PostgreSQL].<itemkey>
and I've made a lot of changes to improve dbcp with db2 but I didn't tested it too much with db2.
Please le me know

[lgc78]

Yes, I'm using the templates packaged with version 0.5

The only file i'm using from version 0.4 is dbforbix-0.4.jar

I'm currently only monitoring 1 database server (mysql 5.5).

[lgc78]

general zabbix question. How do i monitor the dbforbix process?


* EDIT: I ended up creating an item with key proc.num[java] - which returns 1 (trigger if <1). Not sure if this is the best way.

[lgc78]

I have another question. Monitoring mysql replication is something i do now using the scripts submitted here:

http://www.zabbix.com/wiki/howto/mon...ng_replication

I like dbforbix because i don't have to install php on every database server and i will be able to update it easily.

The problem is I cannot read specific info using sql commands like 'show slave status\G' and 'show master status\G' - this is where php becomes useful.

Is mysql replication monitoring something that you could add to a future release? Or do you have any suggestions as to how i could accomplish this with current version of dbforbix?

thx again,
Lou

[Yello]

Hi,
Is "DefaultQueryPeriod" supported in DBforBIX? If not, can it be added?


Regards,
David

[dalle]

Hi,
Is "DefaultQueryPeriod" supported in DBforBIX? If not, can it be added?


Regards,
David

Hi David, yes It's supported
let me know if you have issue I see you are really a good tester

[Yello]

Hi David, yes It's supported
let me know if you have issue I see you are really a good tester

DefaultQueryPeriod didn't work for me. That's what prompted me to ask the question. Can you double check the functionality? BTW, I'm using 0.3.


Regards,
David

[Yello]

Is mysql replication monitoring something that you could add to a future release?
Lou

This is an issue for me too.

Regards,
David

[dalle]

DefaultQueryPeriod didn't work for me. That's what prompted me to ask the question. Can you double check the functionality? BTW, I'm using 0.3.


Regards,
David

sure!
Let me a bit time this week I'm not in office,I'm far away for work

[zaicnupagadi]

Hi everyone, especially Dalle

I have a little bit problem with dbforbix, I dunno what I am doing wrong, I have configured mine server with orabbix and dbforbix, as I monitor my database with orabbix - I have the data - it's fine, but as I monitor the database with dbforbix, the data are not refreshing on zabbix frontend, what I receive in my dbforbix log is:

2012-02-02 07:17:00,780 [main] INFO DBforBIX - Starting DBforBIX Version 0.5
2012-02-02 07:17:00,801 [main] INFO DBforBIX - DBforBIX started with pid:26416
2012-02-02 07:17:00,801 [main] INFO DBforBIX - PidFile -> ./logs/dbforbix.pid
2012-02-02 07:17:01,713 [main] INFO DBforBIX - Connected as ZABBIX
2012-02-02 07:17:01,715 [main] INFO DBforBIX - --------- on Database -> atmodb
2012-02-02 07:17:07,141 [pool-1-thread-1] INFO DBforBIX - Done with dbJob on database atmodb elapsed time 5363 ms
2012-02-02 07:18:01,800 [pool-1-thread-2] INFO DBforBIX - Done with dbJob on database atmodb elapsed time 9 ms
2012-02-02 07:19:02,892 [pool-1-thread-3] INFO DBforBIX - Done with dbJob on database atmodb elapsed time 1090 ms
2012-02-02 07:20:01,824 [pool-1-thread-4] INFO DBforBIX - Done with dbJob on database atmodb elapsed time 10 ms
2012-02-02 07:21:02,954 [pool-1-thread-5] INFO DBforBIX - Done with dbJob on database atmodb elapsed time 1115 ms
2012-02-02 07:22:01,858 [pool-1-thread-6] INFO DBforBIX - Done with dbJob on database atmodb elapsed time 8 ms


and so on, it presents the same as my orabbix log, so it seemes fine, where I can search for the problem?

I am very interested in dbforbix because in nearly days we gonna upgrade our TSM and I wanted to monitor it with dbforbix

My OS is RHEL 6.1

Thank you kindly for any help,
Pawel

[michelis]

Newbie Question concerning connection to the database Server

Hello,

I'm new to zabbix and want to monitor our database with zabbix and dbforbix. But apparently I'm doing something wrong. The conf.props look like this:

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

ZabbixServer1.Address=192.168.178.119
ZabbixServer1.Port=10051

DatabaseList=IMDB

###Oracle
#define here your connection string for each database
#on the following example we are treating Oracle
IMDB.Url=jdbc:oracle:thin:@life-vsrv-002:1521:IMDB
IMDB.User=zabbix
IMDB.Password=xxxxxxxx
IMDB.DatabaseType=oracle
IMDB.QueryListFile=./conf/oraclequery.props
#Those values are optionals if not specified DBforBIX is going to use the general values
IMDB.MaxActive=10
IMDB.MaxWait=100
IMDB.MaxIdle=1

The things I didn't change, I didn't post.
Now when I try to start dbforbix I receive the following error:

2012-02-02 16:53:33,330 [main] INFO  DBforBIX - maxPoolSize=10
 2012-02-02 16:53:33,330 [main] INFO  DBforBIX - maxIdleSize=1
 2012-02-02 16:53:33,330 [main] INFO  DBforBIX - maxIdleTime=1800000ms
 2012-02-02 16:53:33,330 [main] INFO  DBforBIX - poolTimeout=100
 2012-02-02 16:53:33,332 [main] INFO  DBforBIX - timeBetweenEvictionRunsMillis=-1
 2012-02-02 16:53:33,332 [main] INFO  DBforBIX - numTestsPerEvictionRun=3
 2012-02-02 16:53:33,680 [main] ERROR DBforBIX - Error on Configurator for database IMDB -->IO Error: Connection reset
 2012-02-02 16:53:33,680 [main] INFO  DBforBIX - This Database IMDB removed
 2012-02-02 16:53:33,680 [main] ERROR DBforBIX - ERROR on main - Connections is empty

On the commandline I receive the following:

Stopping
java.lang.Exception: ERROR on main - Connections is empty
        at com.smartmarmot.dbforbix.DBforBIX.run(DBforBIX.java:101)
        at com.smartmarmot.dbforbix.bootstrap.main(bootstrap.java:56)

But when I try to connect to the database via sqlplus or even with a small javaprogram the connection can be established. Even if it takes a long time. Does anybody have any suggestions?

edit I'm running RHEL 6.2 and zabbix 1.8.10, dbforbix 0.4 and 0.5 (I tried both)

edit: I'm using openjdk 1.6 could that be the reason.
Regards
Tobias

[zaicnupagadi]

Have you tried to give admin permission to that database for that user? Sometimes it works only on admin rights cannot precise why