Just installed Zabbix 2.0.1 on my freshly kicked CentOS 5 64bit VM. I cannot get the agent to respond to the server, after some research, I found the command zabbix_server -n 0. I ran it and I get this output:
The DB was implemented as well, and it's true, those tables don't exist. Any reason why? Did I miss something along the way?
[root@linux mysql]#zabbix_server -n 0
Converting tables ...zabbix_server [1652]: Error: [Z3005] Query failed: [1054] Unknown column 'unique_dcheckid' in 'where clause' [update drules set unique_dcheckid=unique_dcheckid+0 where unique_dcheckid>0]
...............................zabbix_server [1652]: Error: [Z3005] Query failed: [1054] Unknown column 'object' in 'where clause' [update operations set objectid=objectid+0 where object=0 and objectid>0]
zabbix_server [1652]: Error: [Z3005] Query failed: [1054] Unknown column 'object' in 'where clause' [update operations set objectid=objectid+0 where object=1 and objectid>0]
..zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.opmediatypes' doesn't exist [update opmediatypes set opmediatypeid=opmediatypeid+0 where opmediatypeid>0]
zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.opmediatypes' doesn't exist [update opmediatypes set operationid=operationid+0 where operationid>0]
zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.opmediatypes' doesn't exist [update opmediatypes set mediatypeid=mediatypeid+0 where mediatypeid>0]
...............zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.hosts_profiles' doesn't exist [update hosts_profiles set hostid=hostid+0 where hostid>0]
.zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.hosts_profiles_ext' doesn't exist [update hosts_profiles_ext set hostid=hostid+0 where hostid>0]
...................zabbix_server [1652]: Error: [Z3005] Query failed: [1054] Unknown column 'iconid_unknown' in 'where clause' [update sysmaps_elements set iconid_unknown=iconid_unknown+0 where iconid_unknown>0]
.................zabbix_server [1652]: Error: [Z3005] Query failed: [1062] Duplicate entry '0' for key 1 [insert into nodes (nodeid,name,ip,nodetype) values (0,'Local node','127.0.0.1',1)]
done.
Conversion completed.
Converting tables ...zabbix_server [1652]: Error: [Z3005] Query failed: [1054] Unknown column 'unique_dcheckid' in 'where clause' [update drules set unique_dcheckid=unique_dcheckid+0 where unique_dcheckid>0]
...............................zabbix_server [1652]: Error: [Z3005] Query failed: [1054] Unknown column 'object' in 'where clause' [update operations set objectid=objectid+0 where object=0 and objectid>0]
zabbix_server [1652]: Error: [Z3005] Query failed: [1054] Unknown column 'object' in 'where clause' [update operations set objectid=objectid+0 where object=1 and objectid>0]
..zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.opmediatypes' doesn't exist [update opmediatypes set opmediatypeid=opmediatypeid+0 where opmediatypeid>0]
zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.opmediatypes' doesn't exist [update opmediatypes set operationid=operationid+0 where operationid>0]
zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.opmediatypes' doesn't exist [update opmediatypes set mediatypeid=mediatypeid+0 where mediatypeid>0]
...............zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.hosts_profiles' doesn't exist [update hosts_profiles set hostid=hostid+0 where hostid>0]
.zabbix_server [1652]: Error: [Z3005] Query failed: [1146] Table 'zabbix.hosts_profiles_ext' doesn't exist [update hosts_profiles_ext set hostid=hostid+0 where hostid>0]
...................zabbix_server [1652]: Error: [Z3005] Query failed: [1054] Unknown column 'iconid_unknown' in 'where clause' [update sysmaps_elements set iconid_unknown=iconid_unknown+0 where iconid_unknown>0]
.................zabbix_server [1652]: Error: [Z3005] Query failed: [1062] Duplicate entry '0' for key 1 [insert into nodes (nodeid,name,ip,nodetype) values (0,'Local node','127.0.0.1',1)]
done.
Conversion completed.