Zabbix 1.6 Proxy

[ataylo13]

I am having an issue with the proxy server not adding newly monitored hosts to its database. I can see in the logs on the server where it is sending the data to the proxy.

13721:20081017:183445 Sending configuration data to proxy. Datalen 400342
13722:20081017:183514 Sending configuration data to proxy. Datalen 374320
13723:20081017:183544 Sending configuration data to proxy. Datalen 374320
13723:20081017:183614 Sending configuration data to proxy. Datalen 378656
13723:20081017:183644 Sending configuration data to proxy. Datalen 378656
13724:20081017:183714 Sending configuration data to proxy. Datalen 374320
13721:20081017:183744 Sending configuration data to proxy. Datalen 378660
13724:20081017:183814 Sending configuration data to proxy. Datalen 378660

I have 86 hosts being monitored by the proxy server and everything seems to be working fine. When I try to add any more hosts the number in the server logs goes up but nothing changes on the proxy database. I have tried adding 1 at a time, mass update, hosts->proxies page, and nothing seems to effect anything. The load on the server is minimal.

Both servers are using mysql backend and running on Linux RHEL 4u6.

Any ideas?

[Alexei]

Proxies synchronize configuration with Zabbix Server every one hour by default. You may use zabbix_proxy.conf's parameter ConfigFrequency to override the default value.

[ataylo13]

I initially thought that was the issue so I set it to 120s so that I could test that. Is there some manual way to tell the proxy server what hosts are talking to it?

[ataylo13]

I am noticing in the proxy logs the inserts and deletes coming from the zabbix server to the proxy and is not entering the data into the database. If I copy and paste the insert statements into the mysql server the hosts start reporting data... The proxy agent does not have issues writing to the history tables and from time to time it will insert the hosts...

[Hober]

I am noticing in the proxy logs the inserts and deletes coming from the zabbix server to the proxy and is not entering the data into the database. If I copy and paste the insert statements into the mysql server the hosts start reporting data... The proxy agent does not have issues writing to the history tables and from time to time it will insert the hosts...

debug 4 on the proxy:

insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,key_,delay,status,value_type,trapper_hosts,un
its,multiplier,delta,snmpv3_securityname,snmpv3_se curitylevel,snmpv3_authpassphrase,snmpv3_privpassp hrase,formula,log
timefmt,templateid,valuemapid,delay_flex,params,ip mi_sensor) values (37682,7,'public','interfaces.ifTable.ifEntry.ifI
nOctets.1',161,10108,'system.run[sudo /usr/share/zabbix/scripts/run.sh ups_charge]',60,0,0,'','',0,0,'',0,'','','1','
',32317,0,'','DSN=<database source name>\\nuser=<user name>\\npassword=<password>\\nsql=<query>','');
insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,key_,delay,status,value_type,trapper_hosts,un
its,multiplier,delta,snmpv3_securityname,snmpv3_se curitylevel,snmpv3_authpassphrase,snmpv3_privpassp hrase,formula,log
timefmt,templateid,valuemapid,delay_flex,params,ip mi_sensor) values (37683,7,'public','interfaces.ifTable.ifEntry.ifI
nOctets.1',161,10108,'system.run[sudo /usr/share/zabbix/scripts/run.sh ups_load]',60,0,0,'','',0,0,'',0,'','','1','',
32316,0,'','DSN=<database source name>\\nuser=<user name>\\npassword=<password>\\nsql=<query>','');
insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,key_,delay,status,value_type,trapper_hosts,un
its,multiplier,delta,snmpv3_securityname,snmpv3_se curitylevel,snmpv3_authpassphrase,snmpv3_privpassp hrase,formula,log
timefmt,templateid,valuemapid,delay_flex,params,ip mi_sensor) values (37684,7,'public','interfaces.ifTable.ifEntry.ifI
nOctets.1',161,10108,'system.run[sudo /usr/share/zabbix/scripts/run.sh ups_voltage]',60,0,0,'','',0,0,'',0,'','','1',
'',32315,0,'','DSN=<database source name>\\nuser=<user name>\\npassword=<password>\\nsql=<query>','');

15358:20090213:161701 Query [rollback;]

DELETE from items; ( on the proxy )

and work