I can't get any values

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)]

Try:

php ss_get_mysql_stats.php --host localhost--items gg --nocache 1

Hi Uppeng/Weber,

Did error go away or are you started seeing the graphs?

/var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php with username and password which is global for all our databases with @’%’.

from Zabbiz from end i see everything looks cool, but i am not sure what i am missing graphs are not getting generated.

Can you please do let me know if i need to do something extra?

Amit