Database Queries

[bmcdarby]

Hi,

I am trying to figure out how to have Zabbix send a query to a specific database on a database server? Any pointers on where to look would be appreciated as I have not seen anything in the docs yet. Still reading through.

Thanks.

[untergeek]

Your best bet is to use something like Orabbix (search for this in other threads).

If you absolutely need Zabbix to initiate the query, so long as the response comes back within the Timeout you have specified you can have a UserParameter with a script to do the query. Otherwise, some clever workarounds will use the UserParameter to call the item, then use a second item to receive via a ZabbixTrapper type.

[sue]

Your best bet is to use something like Orabbix (search for this in other threads).

If you absolutely need Zabbix to initiate the query, so long as the response comes back within the Timeout you have specified you can have a UserParameter with a script to do the query. Otherwise, some clever workarounds will use the UserParameter to call the item, then use a second item to receive via a ZabbixTrapper type.

to receive we use zabbix trapper right? But, where we set the userparameter? and where we put it??

[untergeek]

You should probably go through the Zabbix documentation for the official explanation and data for that. I am willing to help where I can, but a complete walk-through of installing and configuring for you is not something I can do. I have my own Zabbix installs to manage.