# SPINE: ERROR: Empty result : 'ss\_get\_mysql\_stats.php\` - 1.1.8

**URL:** <https://forums.percona.com/t/spine-error-empty-result-ss-get-mysql-stats-php-1-1-8/6254>\
**Category:** Percona Monitoring Plugins\
**Created:** [March 16, 2018, 2:59am UTC](https://forums.percona.com/t/spine-error-empty-result-ss-get-mysql-stats-php-1-1-8/6254 "2018-03-16T02:59:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nilaxan](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@nilaxan](https://forums.percona.com/u/nilaxan)\
**Post date:** [March 16, 2018, 2:59am UTC](https://forums.percona.com/t/spine-error-empty-result-ss-get-mysql-stats-php-1-1-8/6254/1 "2018-03-16T02:59:42Z")

</div>

Hi Guys

we’ve installed and configured percona -monitoring-plugins-1.1.8 together with cacti 1.1.36 for monitor MySQL instance in local and remote instances. But it seems like percona mysql monitoring plugin does not work properly.

2018/03/16 07:10:03 - SPINE: Poller[1] Device[1] TH[2] DS[54] SCRIPT: /usr/bin/php -q /usr/share/cacti/site/scripts/ss\_get\_mysql\_stats.php --host ‘localhost’ --items ku,kv,kw --user ‘’ --pass ‘’ --port ‘’ --server-id ‘’, output: U

I’ve properly added mysql username, password in config file according to documentation.

root@monitor:/etc/cacti# cat ss\_get\_mysql\_stats.php.cnf  
\<?php  
$mysql\_user = “\*_**";  
$mysql\_pass = "**_”;

When I execute the following command manually, it working fine and returns results.

/usr/bin/php -q /usr/share/cacti/site/scripts/ss\_get\_mysql\_stats.php --host ‘localhost’ --items it,iu,iv,iw,iy --user ‘_ **’ --pass '** _\*’ --port ‘3306’ --server-id ‘1’