[Percona Monitoring Plugins for Zabbix]_config_bug

Version Information

Zabbix 2.2.11
percona-zabbix-templates-1.1.6-1.noarch.rpm
mysql 5.6.10
----------------------------

NO.1 import template

Setp:
3.Import the XML template using Zabbix UI (Configuration -> Templates -> Import) by additionally choosing “Screens”.

Error message：
Percona Screen "MySQL Graphs" already exists.

Solution：

file:"zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.6.xml" line 3092

"<name>MySQL Graphs</name>" >>>>>>> "<name>Percona MySQL Graphs</name>"
-------------------------------

NO.2 get_mysql_stats_wrapper.sh

Mysql connection information：
username:root
password:root
port:3307

Error message：
# sh /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg
ERROR: run the command manually to investigate the problem: /usr/bin/php -q /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php --host 192.168.101.202 --items gg
# /usr/bin/php -q ./ss_get_mysql_stats.php --host 192.168.101.202 --items gg
gg:45747861

Solution：
file: "get_mysql_stats_wrapper.sh"

CACHEFILE="/tmp/$HOST-mysql_cacti_stats.txt"

change

PORT=3307
[ $PORT = 3306 ] && CACHEFILE="/tmp/$HOST-mysql_cacti_stats.txt" || CACHEFILE="/tmp/$HOST-mysql_cacti_stats.txt:$PORT"

TIMEFLM=`stat -c %Y /tmp/$HOST-mysql_cacti_stats.txt`

change

TIMEFLM=`stat -c %Y $CACHEFILE`
--------------------------------------