User Parameter Item does not show any data in Zabbix GUI

[akumar]

Hi All,

I am facing an issue with an Item, which i have configured to use the key of a user parameter defined by me. Below are the details of the issue. Any help would be much appreciated.

Problem statement -
We need to capture the result of a SQL query (on a MS SQL database) in Zabbix GUI (in the form of a graph). We already have this SQL server host configured and monitored in Zabbix.

Action Steps -
I created a user parameter in the zabbix agent configuration file on the SQL server host machine by adding the following line -
UserParameter=pages.gen,sqlcmd -U <user> -P <pwd> -Q "<my sql query>"
I then restarted the zabbix agent service on SQL server host machine
Now I added an item for SQL server host in Zabbix with Item key as pages.gen

Issue -
I cannot see the Item value in Zabbix and last check field for this item shows up as Never.
I was able to successfully verify my user parameter from the Zabbix server command line using - zabbix_get -s <host ip> -p 10050 -k pages.gen, and it returns the correct query result.

Kindly advise me where am I going wrong here.

Ps : All values stated above within <> contain actual values, which I have not shared for security reasons.

[raoul]

Hi,
How did you setup your item in Zabbix interface ?
Cheers,
r/

[akumar]

Hi raoul,

Thanks for replying. Just found out that there were issues with Zabbix server daemon process, because of which Zabbix server was unable to startup. Got to know this from the Zabbix server log.

Have restarted the server daemon now, and all works fine.

Thanks,
Avinash

[scottwricketts]

Can I get a bump on this thread? I've created the User Parameter, restarted the Zabbix agent, tested the parameter from the command line, and I don't see this anywhere in the GUI for the host. Is there a step I'm missing?

[Atsushi]

You can not monitor just by adding it as a UserParameter. You need to register the item in the host settings.