安裝MySQL MPM外掛時，在zabbix web前端點選Monitoring->Latest data檢視監控，沒有生成監控資料
檢視MPM的日誌，發現下面報錯
[root@localhost etc]# tail -f /var/log/zabbix/FromDualMySQLagent.log
15989:2017-04-10 07:59:44.725 - INFO: FromDual Performance Monitor for MySQL (0.9.1) run started.
15989:2017-04-10 07:59:44.945 - WARN:       192.168.174.187, 10051, db_server
15989:2017-04-10 07:59:44.945 - WARN:       Connection to zabbix server failed (rc=1305)!
15989:2017-04-10 07:59:46.078 - WARN:       192.168.174.187, 10051, db_server
15989:2017-04-10 07:59:46.078 - WARN:       Connection to zabbix server failed (rc=1305)!

解決方法：
註釋掉Zabbix Agent端下面檔案中的check語句
[root@localhost etc]# vim /usr/local/mysql_performance_monitor-agent/lib/sendData.pm
#    $rc = &FromDualMySQLagent::checkConnectionToZabbixServer($main::gParameter{'ZabbixServer'}, $main::gParameter{'ZabbixServerPort'}, $main::gParameter{'Hostname'});

之後關閉Agentd服務，刪除cache資料夾裡面的檔案
[root@localhost cache]# cd /var/log/zabbix/cache
[root@localhost cache]# rm -rf *
之後重啟Agentd服務

再次執行FromDualMySQLagent.pl檔案後，MPM日誌報下面的錯，但是不影響監控資料的生成，在Zabbix web前端可以看到正確的資料
[root@localhost etc]# tail -f /var/log/zabbix/FromDualMySQLagent.log
19420:2017-04-11 07:58:56.164 - INFO: FromDual Performance Monitor for MySQL (0.9.1) run started.
19420:2017-04-11 07:58:56.190 - ERR :       Load of cache file failed. rc=1301
19420:2017-04-11 07:58:56.283 - ERR :       Load of cache file failed. rc=1301

Zabbix 2.2安裝MySQL MPM外掛報錯'Connection to zabbix server failed (rc=1305)'

相關文章