歡迎您光臨本站 註冊首頁

配置zabbix proxy代理時出錯:failed to update local proxy configuration copy: dat

  3008:20130804:230634.344 query failed: Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`opgroup`, CONSTRAINT `c_opgroup_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`)) [delete from groups where groupid in (1,2,4);
delete from dchecks where dcheckid=2;
delete from drules where druleid=2;
delete from interface where interfaceid=1;
delete from hosts where (hostid between 10065 and 10079 or hostid in (10047,10056,10060,10081,10082,10083,10084));
]
  3008:20130804:230634.344 failed to update local proxy configuration copy: database error
《解決方案》

主伺服器與代理各自用本地資料庫,導入資料庫文件也成功了的,訪問用戶許可權測試正常。
shell> mysql -u<username> -p<password> zabbix < database/mysql/schema.sql
shell> mysql -u<username> -p<password> zabbix < database/mysql/images.sql
shell> mysql -u<username> -p<password> zabbix < database/mysql/data.sql
現在不知道哪裡出錯了。

[火星人 ] 配置zabbix proxy代理時出錯:failed to update local proxy configuration copy: dat已經有2188次圍觀

http://coctec.com/docs/service/show-post-11248.html