DBforBIX

[ninguno]

Dalle, no, I don't change the mysql query file. The schema is in utf8. Do you mean language setting/locale of the database??

If i do "SELECT @@lc_time_names;" i get en_US

[ninguno]

Sorry dalle. Do you think there is anything more I could try? I test with two databases and I'm having the same error from both of them (one is mysql 5.1 and the other one mysql 5.0). I also tried to change mysql java connector without positive results.

[ninguno]

Dalle, sorry to repost. Do you have any new version to see if I can't get dbforbix to work with mysql?
Thanks in advance,

[f980215]

dbfoxbix configure multiple instances of mysql problem

hi,
I install 1) MySQL-server-community-5.1.56 to run 2 instances on one host (centos5.6 32bit) 2) dbfoxbix-0.4 3) zabbix-1.8.5 .

config.props: ( host name: ups1 in zabbix )

ZabbixServer1.Address=192.168.1.2
ZabbixServer1.Port=10051
DatabaseList=ups1

ups1.Url=jdbc:mysql://127.0.0.1:3307/db1
ups1.User=zabbix_monitor
ups1.Password=zabbixpassword
ups1.DatabaseType=mysql
ups1.QueryListFile=./conf/mysqlquery.props

ups1.Url=jdbc:mysql://127.0.0.1:3308/db2
ups1.User=zabbix_monitor
ups1.Password=zabbixpassword
ups1.DatabaseType=mysql
ups1.QueryListFile=./conf/mysqlquery.props

dbfoxbix.log
2011-12-14 09:49:52,044 [main] INFO DBforBIX - Starting DBforBIX Version 0.4
2011-12-14 09:49:52,057 [main] INFO DBforBIX - DBforBIX started with pid:1967
2011-12-14 09:49:52,057 [main] INFO DBforBIX - PidFile -> ./logs/orabbix.pid
2011-12-14 09:49:52,083 [main] INFO DBforBIX - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@1617189
2011-12-14 09:49:52,083 [main] INFO DBforBIX - URL=jdbc:mysql://127.0.0.1:3307/db1
....
2011-12-14 09:49:52,342 [main] INFO DBforBIX - Connected as [email protected]
2011-12-14 09:49:52,342 [main] INFO DBforBIX - --------- on Database -> db1
2011-12-14 09:49:52,343 [main] INFO DBforBIX - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@1010058
2011-12-14 09:49:52,343 [main] INFO DBforBIX - URL=jdbc:mysql://127.0.0.1:3308/db2
....
2011-12-14 09:49:52,365 [main] INFO DBforBIX - Connected as [email protected]
2011-12-14 09:49:52,365 [main] INFO DBforBIX - --------- on Database -> db2
...
2011-12-14 09:49:52,836 [pool-1-thread-2] INFO DBforBIX - Done with dbJob on database db1 QueryList elapsed time 292 ms
2011-12-14 09:49:52,841 [pool-1-thread-1] INFO DBforBIX - Done with dbJob on database db2 QueryList elapsed time 325 ms

Where running dbfoxbix, db1 instances data was found on zabbix, but db2 instances data was not found.

In template_mysql.xml , item key is: DBforBIX.MySQL.sort_buffer_size, DBforBIX.MySQL is is the key prefix.

Can be DBforBIX.MySQL prefix add : the instance name is a variable ?

This means that：

template_mysql.xml:
DBforBIX.<db type>.itemkey
change to
DBforBIX.<db type>.<db instance name>.itemkey

config.props: (DB1 is zabbix host name)
#define here your connection string for each database
DB1.Url=jdbc:mysql://[host ort],[host ort].../[database]
change to
DB1.<db instance name>.Url=jdbc:mysql://[host ort],[host ort].../[database]

for example

template_mysql.xml:
item key DBforBIX.MySQL.sort_buffer_size
change to
db1 instance : DBforBIX.MySQL.db1.sort_buffer_size，
db2 instance : DBforBIX.MySQL.db2.sort_buffer_size

config.props:
ups1.db1.Url=jdbc:mysql://127.0.0.1:3307/db1
....
ups1.db2.Url=jdbc:mysql://127.0.0.1:3308/db2
....

Thanks for your any help.
f980215

[dalle]

DBforBIX 0.5

DBforBIX 0.5 has been release and should fix your issue.

Please let me know

NOTE:It's not considered yet a production release.

[Yello]

Hi,
Can you clarify for me how I modify the default polling interval for DBforbix or a DBforbix Pool aside from specifying customQueryItemName.Period in the querylist file?


Regards,
David

[dalle]

Hi,
Can you clarify for me how I modify the default polling interval for DBforbix or a DBforbix Pool aside from specifying customQueryItemName.Period in the querylist file?


Regards,
David

there is only one way
customQueryItemName.Period

[Yello]

there is only one way
customQueryItemName.Period

Ok. Might you consider implementing this feature?


Regards,
David

[dalle]

Ok. Might you consider implementing this feature?


Regards,
David

Sorry but it's not working? there are issue with .Period?

[Yello]

Sorry but it's not working? there are issue with .Period?

It works as described, which is why this is a feature request and not a bug report.

Setting the Period for every query in a query file is not a high productivity exercise. IMO, a more efficient approach would be, when wanting to change the polling interval for all items, to set a variable in config.props which would apply to all items in the query file. QueryItem.Period could then be used as an override.

Indeed, this is what happens now except that the default period isn't exposed as a user configurable parameter.


Regards,
David

[dalle]

It works as described, which is why this is a feature request and not a bug report.

Setting the Period for every query in a query file is not a high productivity exercise. IMO, a more efficient approach would be, when wanting to change the polling interval for all items, to set a variable in config.props which would apply to all items in the query file. QueryItem.Period could then be used as an override.

Indeed, this is what happens now except that the default period isn't exposed as a user configurable parameter.


Regards,
David

AAAAA ok I didn't understood sorry

ok I'll do on spare time thanks


Regards
Andrea

[Yello]

AAAAA ok I didn't understood sorry

ok I'll do on spare time thanks


Regards
Andrea

Much appreciated


Regards,
David

[lgc78]

will DBforBIX work with Zabbix 2.0?

[dalle]

will DBforBIX work with Zabbix 2.0?

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

[lgc78]

I'm testing on 1.9.8 and have successfully started the dbforbix daemon, added the template to my host (testdb.home) in zabbix yet data is not being populated. I'm attempting to monitor a mysql server.

I've turned 'debug' on and am seeing this in the logs

2012-01-22 00:17:29,660 [main] INFO DBforBIX - Starting DBforBIX Version 0.5
2012-01-22 00:17:29,688 [main] INFO DBforBIX - DBforBIX started with pid:1498
2012-01-22 00:17:29,688 [main] INFO DBforBIX - PidFile -> ./logs/orabbix.pid
2012-01-22 00:17:29,690 [main] DEBUG DBforBIX - getConnection for database testdb.home
2012-01-22 00:17:29,758 [main] DEBUG DBforBIX - Trying to connect to database...
2012-01-22 00:17:29,780 [main] DEBUG DBforBIX - Connection attempt to database succeeded.
2012-01-22 00:17:30,240 [main] INFO DBforBIX - Connected as [email protected]
2012-01-22 00:17:30,241 [main] INFO DBforBIX - --------- on Database -> sampledb

2012-01-22 02:31:46,447 [main] DEBUG DBforBIX - Note: dbversion.NoDataFound null or not present null
2012-01-22 02:31:46,447 [main] DEBUG DBforBIX - Note: dbversion.WhenNotAlive null or not present null

2012-01-22 00:17:31,463 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 73 for query Table_locks_immediate on database=testdb.home

2012-01-22 00:17:31,463 [pool-1-thread-1] DEBUG DBforBIX - Actual query is Table_locks_waitedNextrun 2012/01/22 00:20:30 on database=testdb.home Period=3

2012-01-22 02:00:57,662 [pool-1-thread-4] DEBUG DBforBIX - sending <req><host>dIJrZHRvbWNhdDEuaG9tZQ==</host><key>REJmb3JCSVguVmVyc2lvbg==</key><data>REJmb3JCSVggVmVyc2lvbiAwLjU=</data></req>


2012-01-22 02:00:57,663 [pool-1-thread-4] INFO DBforBIX - Done with dbJob on database testdb.home elapsed time 51 ms


Any ideas?