Друзья, помогите чайнику. Устанавливал v2.0.3 около 10 раз по разным инструкциям, базу MySQL разворачивал из скачанного с оф.сайт дистрибутива, ZABBIX запускается, но в нижней части Web-панели вылезают ошибки см. скриншот (для макс. увеличения кликать 2 раза )
в zabbix_server.log слудеющее:
Настройки php.ini правильные
Как с этим бороться ?
в zabbix_server.log слудеющее:
2990:20121103:091527.050 [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<=1351926927 or nextcheck>1351926927+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
2937:20121103:091626.529 [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]
2937:20121103:091626.531 [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]
2971:20121103:091627.007 [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 (18,0,'localhost')]
2937:20121103:091626.529 [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]
2937:20121103:091626.531 [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]
2971:20121103:091627.007 [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 (18,0,'localhost')]
Как с этим бороться ?
Comment