Galera, bom dia, eu segui a documentação do zabbix pra instalar a versão 2.2 como sempre fiz desde a versão 1.8 e nunca tive problemas, porém essa vez aconteceu que o server não conecta com o agent que encontra-se na mesma máquina, abaixo segue o zabbix_server.log:
root@GLPI:/var/log/zabbix-server# tail /tmp/zabbix_server.log
9765:20140313:074636.286 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707596 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9765:20140313:074641.287 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707601 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9765:20140313:074646.288 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707606 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9765:20140313:074651.289 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707611 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9765:20140313:074656.290 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707616 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9764:20140313:074700.169 [Z3005] query failed: [1054] Unknown column 'h.port' in 'field list' [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prev value,i.hostid,i.value_type,i.delta,i.prevorgvalue ,i.lastclock,i.units,i.multiplier,i.formula,i.stat us,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.dat a_type,i.mtime,h.status from hosts h,items i where i.hostid=h.hostid and i.itemid in (23287)]
9748:20140313:074701.169 [Z3005] query failed: [1054] Unknown column 'i.snmp_port' in 'field list' [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_typ e,i.value_type,i.key_,i.snmp_community,i.snmp_oid, i.snmp_port,i.snmpv3_securityname,i.snmpv3_securit ylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassph rase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_ hosts,i.logtimefmt,i.params,i.status,i.authtype,i. username,i.password,i.publickey,i.privatekey from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3) and i.itemid between 000000000000000 and 099999999999999]
9748:20140313:074701.170 [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]
9769:20140313:074701.170 [Z3005] query failed: [1054] Unknown column 'unique_dcheckid' in 'field list' [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1394707621 or nextcheck>1394707621+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
9765:20140313:074701.291 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707621 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
root@GLPI:/var/log/zabbix-server# tail /tmp/zabbix_server.log
9765:20140313:074636.286 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707596 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9765:20140313:074641.287 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707601 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9765:20140313:074646.288 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707606 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9765:20140313:074651.289 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707611 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9765:20140313:074656.290 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707616 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
9764:20140313:074700.169 [Z3005] query failed: [1054] Unknown column 'h.port' in 'field list' [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prev value,i.hostid,i.value_type,i.delta,i.prevorgvalue ,i.lastclock,i.units,i.multiplier,i.formula,i.stat us,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.dat a_type,i.mtime,h.status from hosts h,items i where i.hostid=h.hostid and i.itemid in (23287)]
9748:20140313:074701.169 [Z3005] query failed: [1054] Unknown column 'i.snmp_port' in 'field list' [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_typ e,i.value_type,i.key_,i.snmp_community,i.snmp_oid, i.snmp_port,i.snmpv3_securityname,i.snmpv3_securit ylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassph rase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_ hosts,i.logtimefmt,i.params,i.status,i.authtype,i. username,i.password,i.publickey,i.privatekey from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3) and i.itemid between 000000000000000 and 099999999999999]
9748:20140313:074701.170 [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]
9769:20140313:074701.170 [Z3005] query failed: [1054] Unknown column 'unique_dcheckid' in 'field list' [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1394707621 or nextcheck>1394707621+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
9765:20140313:074701.291 [Z3005] query failed: [1054] Unknown column 't.macros' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1394707621 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
Comment