Zabbix running but not collecting data

[markclark]

Hi everyone,

Migrated to a new zabbix ubuntu box. installed ok and interface seems to work fine and imported in my existing mysql database.

only issue i am now having is that the server is running and can connect on client ports but no data is coming in. the ports on the firewall are still open as needed. only thing i am noticing is that i cannot telnet to the zabbix server on port 10050 or 10051 and under the queues there are about 700 entries waiting to be written to the database.

i have check the server_conf and it looks fine.

help please?!

[markclark]

Sorry this is sorted, unable to work out how to delete threads....

[novakm]

What was wrong?

Hi there,
may I ask how did you solve it? I upgraded 1.8.10 to 2.0 and it seems I am experiencing something similar.
The database and zabbix-server run fine but no new data are visible. I noticed zabbix-server.log full of messages like:
2165:20120529:102716.893 [Z3005] query failed: [1054] Unknown column 'useip' in 'field list' [select hostid,proxy_hostid,host,useip,ip,dns,port,useipmi ,ipmi_ip,ipmi_port,ipmi_authtype,ipmi_privilege,ip mi_username,ipmi_password,maintenance_status,maint enance_type,maintenance_from,errors_from,available ,disable_until,snmp_errors_from,snmp_available,snm p_disable_until,ipmi_errors_from,ipmi_available,ip mi_disable_until,status from hosts where status in (0,5,6) and hostid between 000000000000000 and 099999999999999]

I used the database patch so I don't know what went wrong :/

[markclark]

hmm good question there and havent upgraded to 2.0 yet.

few things to check.

one can you telnet into the ports 10050 or 10051 depends on the server_conf or the agent_conf.

open terminal

telnet <SERVER IP> 10050
or
telnet <SERVER IP> 10051

see where you get responses from. If you cannot check the zabbix-server is started and try again. If you cannot then there is something blocking the ports / lt isnt listening correctly.

thats what id check for now and see how you go.

[novakm]

Hi, I solved it (and I will share it )

Zabbix 2.0 has different location of binaries and conf files. I started it using "service zabbix-server" and the script in init.d still pointed at 1.8 binaries which were above 2.0 database.

Hope this helps anyone who encounters such problem.

[ploochan]

can you little more specific on this? I think I have the same problem. I can see that zabbix is running, and collecting data since in latest data tab I can see the actual date. But when testing, nothing shows in my dashboard and not sending any triggers. Is it something similar?