zabbix_sender trap value lost by zabbix_proxy

[jdoucerain]

Hi,
I encountered a problem when I tried to send a trap related to a host which is monitored via a proxy.
In the proxy log we can see the trap is well received, and matches an existent host and key. But we can also see that the resulting insert request to the database doesn't propagate the value received from the trap.
zabbix_sender and zabbix_proxy are 1.6.2, running on a SLES 10 SP2 box.
The database at the proxy level is MySQL 5.0.
Here is the log
2860:20090320:093214 Trapper got [{
"request":"sender data",
"data":[
{
"host":"test",
"key":"hardware_problem",
"value":"test test"}]}] len 114
2860:20090320:093214 In process_new_values()
2860:20090320:093214 In process_mass_data()
2860:20090320:093214 In DCinit_nextchecks()
2860:20090320:093214 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,
i.snmp_oid,h.useip,h.ip,i.history,i.lastvalue,i.pr evvalue,i.hostid,h.status,i.value_type,h.errors_fr om,i.snmp_port,i.delta,i.
prevorgvalue,i.lastclock,i.units,i.multiplier,i.sn mpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_ authpassphrase,i.snmpv3_p
rivpassphrase,i.formula,h.available,i.status,i.tra pper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex, h.dns,i.params,i.trends,h
.useipmi,h.ipmi_port,h.ipmi_authtype,h.ipmi_privil ege,h.ipmi_username,h.ipmi_password,i.ipmi_sensor, i.lastlogsize from hosts
h, items i where h.hostid=i.hostid and h.proxy_hostid=0 and h.status=0 and i.status in (0,3) and i.type in (2,7) and ((h.host
='test' and i.key_='hardware_problem'))]
2860:20090320:093214 Query [begin;]
2860:20090320:093214 In proxy_process_new_value(hardware_problem)
2860:20090320:093214 In proxy_add_history(itemid: 100100000033125,key:"hardware_problem",value_type: 4,TEXT:[test test])
2860:20090320:093214 In proxy_add_history_text()
2860:20090320:093214 Query [insert into proxy_history (itemid,clock,value) values (100100000033125,1237555934,'')]
2860:20090320:093214 End of proxy_add_history
2860:20090320:093214 In proxy_update_item()
2860:20090320:093214 In calculate_item_nextcheck (100100000033125,30,"",1237555934)
2860:20090320:093214 End calculate_item_nextcheck (result:1237555945)
2860:20090320:093214 Query [update items set nextcheck=1237555945 where itemid=100100000033125]
2860:20090320:093214 End proxy_update_item()
2860:20090320:093214 Query [commit;]

The item hardware_problem is defined as a zabbix_trapper text item.

Thanks for your help
Jerome

[jdoucerain]

error fixed

Hi,
I found where the error was
in functions.c the DBproxy_add_history_text call uses a wrong argument. It should be value->text instead of value->str

see diff below

/usr/local/src/zabbix-1.6.2/src/libs/zbxserver> diff functions.c functions.c.20090320
732c732
< DBproxy_add_history_text(item->itemid, value->text, now);
---
> DBproxy_add_history_text(item->itemid, value->str, now);

Thanks
Jerome

[Alexei]

Thanks for reporting this. It will be included into 1.6.3 if the fix is correct.