# I can't get any values **URL:** \ **Category:** Percona Monitoring Plugins\ **Created:** [January 15, 2016, 5:06am UTC](https://forums.percona.com/t/i-cant-get-any-values/4667 "2016-01-15T05:06:36Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![uppeng](https://avatars.discourse-cdn.com/v4/letter/u/48db29/32.png) [@uppeng](https://forums.percona.com/u/uppeng)\ **Post date:** [January 15, 2016, 5:06am UTC](https://forums.percona.com/t/i-cant-get-any-values/4667/1 "2016-01-15T05:06:36Z")
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)] ---
**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\ **Post date:** [January 20, 2016, 7:47am UTC](https://forums.percona.com/t/i-cant-get-any-values/4667/2 "2016-01-20T07:47:58Z")
Try: ```auto php ss_get_mysql_stats.php --host localhost--items gg --nocache 1 ``` ---
**Author:** ![pintu\_ag23](https://avatars.discourse-cdn.com/v4/letter/p/97f17d/32.png) [@pintu\_ag23](https://forums.percona.com/u/pintu_ag23)\ **Post date:** [February 12, 2016, 12:14pm UTC](https://forums.percona.com/t/i-cant-get-any-values/4667/3 "2016-02-12T12:14:41Z")
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