When I execute the script /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg return empty.
my PHP version is php-5.1.6-45.el5_11
[root@localhost scripts]# ./get_mysql_stats_wrapper.sh gg
[root@localhost scripts]#
================================================== =
[root@localhost scripts]# cat ~zabbix/.my.cnf
[client]
user = zabbix
password = zabbix
================================================== =
[root@localhost scripts]# ll
total 76
-rwxr-xr-x 1 root root 1277 Jan 15 14:27 get_mysql_stats_wrapper.sh
-rwxr-xr-x 1 root root 999 Jan 13 16:17 nginx_status.sh
-rwxr-xr-x 1 root root 59634 Jan 15 11:50 ss_get_mysql_stats.php
-rwxr-xr-x 1 root root 798 Dec 29 15:43 tcp_connections.sh
================================================== =
[root@localhost scripts]# egrep “mysql_user|mysql_pass” ss_get_mysql_stats.php
$mysql_user = ‘zabbix’;
$mysql_pass = ‘zabbix’;
================================================== =
mysql> show grants for zabbix@‘localhost’;
±--------------------------------------------------------------
| Grants for zabbix@localhost
±--------------------------------------------------------------
| GRANT SUPER, REPLICATION CLIENT ON . TO ‘zabbix’@‘localhost’
±--------------------------------------------------------------
1 row in set (0.00 sec)
================================================== =
[root@localhost ~]# /usr/local/zabbix/bin/zabbix_get -s 192.168.1.18 -k MySQL.running-slave
1
[root@localhost ~]# /usr/local/zabbix/bin/zabbix_get -s 192.168.1.18 -k MySQL.Open-tables
[root@localhost ~]#
================================================== =
zabbix-server log
[root@localhost ~]# tail -f /tmp/zabbix_server.log
3732:20160115:175324.148 error reason for “ZHDX_18:MySQL.thread-hash-memory” changed: Received value is not suitable for value type [Numeric (float)]
3732:20160115:175324.148 error reason for “ZHDX_18:MySQL.Threads-cached” changed: Received value is not suitable for value type [Numeric (float)]
3732:20160115:175324.148 error reason for “ZHDX_18:MySQL.Threads-connected” changed: Received value is not suitable for value type [Numeric (float)]
3732:20160115:175324.148 error reason for “ZHDX_18:MySQL.Threads-created” changed: Received value is not suitable for value type [Numeric (float)]
3732:20160115:175324.148 error reason for “ZHDX_18:MySQL.Threads-running” changed: Received value is not suitable for value type [Numeric (float)]
3730:20160115:175329.156 error reason for “ZHDX_18:MySQL.total-mem-alloc” changed: Received value is not suitable for value type [Numeric (float)]
3730:20160115:175329.156 error reason for “ZHDX_18:MySQL.uncheckpointed-bytes” changed: Received value is not suitable for value type [Numeric (float)]
3730:20160115:175329.156 error reason for “ZHDX_18:MySQL.unflushed-log” changed: Received value is not suitable for value type [Numeric (float)]