Issue with grpsum and macro

[Denden54]

I have an issue with the grpsum function for cluster monitoring.

The grpsum is based on this item :
psql.primary_server[{$PGSCRIPTDIR},{$PGSCRIPT_CONFDIR}]

But in the grpsum item, zabbix change the macros with the macros values (so zabbix is looking for the item psql.primary_server["/usr/local/bin","/usr/local/etc"], but the "real item" in the item list of zabbix is show as psql.primary_server[{$PGSCRIPTDIR},{$PGSCRIPT_CONFDIR}].

Zabbix is sending us the error : No items for key psql.primary_server["/usr/local/bin","/usr/local/etc"] in group(s) MYGROUP"

[pengbo0328]

You need to create a "PostgreSQL Cluster" host group and add all PostgreSQL host to that group.

[Denden54]

Hello,

This is not a group issue. All my clusters hosts are in the zabbix group. The zabbix group is set in the macro as the documentation recquire.

The issue is that the grpsum command is looking for "psql.primary_server["/usr/local/bin","/usr/local/etc"]" item in hosts in the groups definied. But the item in the host item lists is "psql.primary_server[{$PGSCRIPTDIR},{$PGSCRIPT_CONFDIR}]". So for zabbix, it's not the same item.

To resolve this issue, i had to remove macro in the item and use directly the path of script and conf in the items.

[pengbo0328]

Which template did you apply to each PostgreSQL host?
If you linked the template "Template App PostgreSQL" to each PostgreSQL host, then the macro $PGSCRIPTDIR and {$PGSCRIPT_CONFDIR} will be expanded in the host item, because the the macros are defined in the template "Template App PostgreSQL".