mysql 1305 报错_Zabbix 2.2安装MySQL MPM插件报错'Connection to zabbix server failed (rc=1305)'...

安装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