I am trying to set up some database monitoring for ParAccel (version 3.0) using ODBC connections and the Database items. I have a small handful of queries that I need to run through these items and all of them work perfectly directly on the database server as well as using iSQL on the zabbix proxy server we are running our drivers on. The problem comes when i connect the template with the host. The latest data being returned is incorrect. An example would be counting the total number of connections (active and inactive):
The SQL statement is: select count(*) from pg_stat_activity.
On the command line it returns a value, in my case the current number is 2.
In Zabbix however, the latest data indicates that there are 42 total connections.
ParAccel is a PostgresSQL based platform, and I am using the most current version of the driver from the vendor... Does anyone have any suggestions? I can't even seem to figure out what the raw data the agent is sending is. If I try running a zabbix_get with the key, it errors out, but its not erroring out in Zabbix. I'm at a loss.
The SQL statement is: select count(*) from pg_stat_activity.
On the command line it returns a value, in my case the current number is 2.
In Zabbix however, the latest data indicates that there are 42 total connections.
ParAccel is a PostgresSQL based platform, and I am using the most current version of the driver from the vendor... Does anyone have any suggestions? I can't even seem to figure out what the raw data the agent is sending is. If I try running a zabbix_get with the key, it errors out, but its not erroring out in Zabbix. I'm at a loss.