Upgrade from 1.8 to 2.0 - can no longer find hosts

[ben.bressler]

Hello!

I recently upgraded from 1.8 to 2.0 and once I got the server back up and running it can't seem to find any of my hosts.

From within the zabbix front end I see this error:
Get value from agent failed: *** Cannot connect to [[10.4.58.216]:10050]: [4] Interrupted system call

If I try to telnet to that box from the server I get this:
Trying 10.4.58.216...
Connected to 10.4.58.216.
Escape character is '^]'.
Connection closed by foreign host.

Looking in the server log file I see:
12685:20130124:181235.183 Sending list of active checks to [10.4.58.216] failed: host [api] not found

I'm also seeing this in the server logs:
12684:20130124:182236.770 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`autoreg_host`, CONSTRAINT `c_autoreg_host_1` FOREIGN KEY (`proxy_hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into autoreg_host (autoreg_hostid,proxy_hostid,host) values (221,0,'api3')]

Any assistance I can get would be awesome since I'm running out of my own ideas to try.

Thanks!

[tchjts1]

Describe the steps you did for your upgrade.

Did you run the DB upgrade scripts?

# cat schema.sql | mysql -uxxxxxx -pxxxxxx
# cat images_mysql.sql | mysql -uxxxxxx -pxxxxxx
# cat data.sql | mysql -uxxxxxx -pxxxxxxx

Additionally, there are some new fields in the zabbix_agentd.conf file for on the host. In particular ServerActive=

[ben.bressler]

I followed the steps outlined here:

https://www.zabbix.com/documentation/2.0/manual/installation/upgrade

I followed that procedure to the letter.

I didn't run the specific upgrade scrips you mentioned but I did run zabbix-2.0.4/upgrades/dbpatches/2.0/mysql/upgrade (making sure to pass it the mysql username, pass and db) that is outlined in the upgrade procedures.

I'll double check the server config file but I think it looks alright. I am able to successfully monitor the zabbix agent running on the zabbix server (using the ip 127.0.0.1) but anything else isn't being found.

Also, thanks for the reply!