Distributed monitoring problem

[Palmertree]

Look at the following to change timeouts:

http://www.zabbix.com/forum/showthread.php?t=9890

You have to change it in the C code and the zabbix_server.conf file for trapper.

[r3dn3ck]

Seems that zabbix server tries to insert data in PostgreSQL like it was MySQL.



I created a quick patch to check this:
In file src/zabbix_server/trapper/nodehistory.c
Find line 348. It should look like:
zbx_snprintf_alloc(sql, sql_allocated, &sql_offset, len + 8, "0x%s,",
Change that to
zbx_snprintf_alloc(sql, sql_allocated, &sql_offset, len + 38, "encode(decode('%s','hex'),'escape'),

Recompile Zabbix and that should work.

Yet, it still crashes occasionally. Perhaps after receiving data from Zabbix remote nodes. For now, I stopped the remote nodes and will see if it still crashes. If not, I will take a look at this problem again...

Would this change apply to a mysql back-ended setup?

[vinny]

I face this bug too...
I tried on the master & slaves nodes to modify the nodehistory.c but without success.

Was this bug corrected ?

vinny

[kombat]

Hi,
We have 4 nodes with mysql but when we decided mysql replace by postrge.
We have the same problem with nodes and postgres because on mysql it's system are working well.

maybe it's bug ?

Sorry, my english