Proxy + usermacro

[konstaner]

Hi!

i have the item with type Database monitoring. I put usermacro {$DSN} in Additional parameters: DSN={$DSN}

it work fine on hosts that are monitored directly, but not through proxy!
I have the error in zabbix_proxy.log:

Failed to connect to DSN '{$DSN}' : Error: failed connection [[unixODBC][Driver Manager]Data source name not found, and no default driver specified] (0)

I looked in table hostmacro on proxy, it is empty.

I think that zabbix can't sync usermacro with proxy. Is it truth?

[megamih]

Proxy + usermacro

Hi konstaner,

This is caused by "Database monitoring" item behavior: when added to host monitored through proxy, it looks into Zabbix Proxy database instead of Zabbix Server.

So if you have option ProxyLocalBuffer enabled (i.e. not "0") in your zabbix_proxy.conf you can get values from Zabbix Proxy DB (table "proxy_history" stores data, tables "hosts" and "items" - some info on config).

PS. be aware - there are no values for "description" in table "items" for example - you have to use "key_" instead an so on.