zabbix proxy empty data

[tachikoma]

Hello everyone

we have
1. local zabbix-server 2.2.3
2. remote host with zabbix-proxy 2.0.6 (passive mode) + zabbix-agent 2.0.6

trouble:
zabbix server getting empty data from proxy:

18319:20140916:121013.364 obtained data from proxy "D17 proxy": { 
        "data":[], 
        "clock":1410855013}

frontend tells that proxy available (no problems with access)


remote host has proxy on 0.0.0.0:10050 (non-default port)
and agent 127.0.0.1:10052 (also non-default)

agent has "server" option: 127.0.0.1,192.168.0.145

I've checked agent response:

[root@d17 ~]# zabbix_get -s 127.0.0.1 -p 10052 -k agent.version 
2.0.6

no problems here

zabbix-proxy has dedicated database (based on mysql 5.1.61) and user (zabbix)

with correct permissions:

GRANT SELECT,INSERT,UPDATE,DELETE ON zabbix_proxy.* TO 'zabbix'@'localhost' identified by 'ultra_password';

btw database tables are empty i don't know why.

i did manual selects, inserts with zabbix-mysql-user, there are no problems with permissions

also process list of active zabbix-proxy:

mysql> show processlist;
+-----+--------+-----------+--------------+---------+------+-------+------------------+
| Id  | User   | Host      | db           | Command | Time | State | Info             |
+-----+--------+-----------+--------------+---------+------+-------+------------------+
| 199 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 200 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 201 | zabbix | localhost | zabbix_proxy | Sleep   |    1 |       | NULL             |
| 202 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 203 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 204 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 206 | zabbix | localhost | zabbix_proxy | Sleep   |    5 |       | NULL             |
| 207 | zabbix | localhost | zabbix_proxy | Sleep   |   14 |       | NULL             |
| 208 | zabbix | localhost | zabbix_proxy | Sleep   |    1 |       | NULL             |
| 209 | zabbix | localhost | zabbix_proxy | Sleep   |    1 |       | NULL             |
| 210 | zabbix | localhost | zabbix_proxy | Sleep   |   22 |       | NULL             |
| 211 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 212 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 213 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 214 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 215 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 216 | zabbix | localhost | zabbix_proxy | Sleep   | 1736 |       | NULL             |
| 217 | zabbix | localhost | zabbix_proxy | Sleep   |   56 |       | NULL             |
| 228 | root   | localhost | NULL         | Query   |    0 | NULL  | show processlist |
+-----+--------+-----------+--------------+---------+------+-------+------------------+

what i did already:
1. zabbix-server restart
2. zabbix-proxy restart
3. zabbix-agent restart
4. play with IP bindings for zabbix-agent and zabbix-proxy
5. wait 30 min, 1h, etc.. nothing happens
5. check logs for all componens with DebugLevel=4. nothings suspicious

most sadly fact that we have a few the same 1-by-1 hosts with 2.0.6 (proxy and agents)


Can you help me?

[tachikoma]

problem solved

zabbix-server version schema was incorrect after upgrade from 2.0.X to 2.2.3, especially table dchecks (required for zabbix-proxy).

i repaired this manually