The mysql plugin does not work with cacti 1.1.6

[lukatendai]

I used to have an old version of the plugin and after updating server couple months ago it stopped working. I updated cacti and removed all Percona related things like "Data Input Methods", "Device Templet", "Graph Templates", "Data Source Templates", "CDEFs", "GPRINTs" and I imported the template XML file from the latest release of your plugin: cacti_host_template_percona_mysql_server_ht_0.8.6i-sver1.1.7.xml and I updated php scripts on the server

I readded everything to my devices and nothing works. All Percona graphs are empty... however, when I run the plugin manually plugin it gives me data, for example:
command:
/usr/bin/php -q /srv/www/cacti/scripts/ss_get_mysql_stats.php --host db-02.col.end --items iz,ir
output:
ir:4 iz:164219

Any idea what is going on?
Thanks

[deniskin82]

enable debug mode and write to file in ss_get_mysql_stats.php

[lukatendai]

I did it... and then what I should look for?

it gives my right output:

2017-05-25 11:08:04 at /srv/www/cacti/scripts/ss_get_mysql_stats.php:148
array (
  0 => 'Final result',
  1 =>
  array (
    0 => 'ir:4',
    1 => 'iz:173146',
  ),
)

[dbmiller]

Think this may be a the same issue I was having posted in #40 . If you leave the debug code enabled and let Cacti run through it, do you see blank script parameters listed in the debug log after the cache is hit?

@deniskin82 has a pull out that seems to address it, but I don't think it has been committed yet. #48 Might be worth trying out.