All graphs are working but Command Counter not

[Frank Kirschner]

Hi,

all graphs are working but mysql command counters on cacti not.
"nan" is as values displayed. So I'm checked the script:

/usr/bin/php -q /var/www/cacti/scripts/ss_get_mysql_stats.php --host
10.30.30.188 --items c2,c3,c4,c5,c6,c7,c8,c9,ca,cb,cc --user cactiuser
--passxxxx --port 3306

displayes:

c2:215648245 c3:1441718 c4:4915987 c5:112038016 c6:3300478 c7:107481
c8:0 c9:0 ca:2 cb:0 cc:0

No errors in poller_log.
What can I do to find the problem ?

[Baron Schwartz]

Frank,

Have you worked through the Cacti troubleshooting guide and the FAQ in
the plugin documentation? That is usually the solution to problems such
as this. Most such problems are due to Cacti, not to the plugins.

[Frank Kirschner]

Hi Baron,

yes but now I'm on the end of my knowledge:

The script collects the values right:

03/02/2012 01:45:06 PM - CMDPHP: Poller[0] Host[18] DS[269] CMD:
/usr/bin/php -q /var/www/cacti/scripts/ss_get_mysql_stats.php --host
10.20.30.188 --items c2,c3,c4,c5,c6,c7,c8,c9,ca,cb,cc --user --pass --port ,
output: c2:219979796 c3:1463785 c4:4984915 c5:114307559 c6:3338972 c7:109045

c8:0 c9:0 ca:2 cb:0 cc:0

But now I'm missing the Poller's parsing of Multi Output fileds. The next
log is writing to the rrd file:

03/02/2012 01:45:06 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool
update /var/www/cacti/rra/mysql_5_master_com_select_269.rrd --template
1330692306:3.7713273666399E+86

How can I find out, why the poller doesn't parsing the outputs?

best,
Frank

Frank,

--
You received this message because you are subscribed to the Google Groups
"Percona Discussion" group.
To post to this group, send email to percona-d...@googlegroups.com.
To unsubscribe from this group, send email to
percona-discuss...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/percona-discussion?hl=en.

[Baron Schwartz]

Looks like a Cacti bug that you should take up on the Cacti forums or
mailing lists.

[Frank Kirschner]

Okay Thanks, I will do it so.

best Frank

[Baron Schwartz]

Frank,

I just noticed the values you're looking for, c5, c6, etc. This is the
Better Cacti Templates values. Those values are not the ones used by
the Percona Monitoring Plugins. You are encountering a known bug in
Cacti, which is fixed in a newer release. Also, we/I are not developing
the Better Cacti Templates anymore.

[Frank Kirschner]

Hi Baron,

I'sorry, had taken over the job since one week ago. Few seconds ago updated
cati tu currentstable version and now everything ist working well.
Sorry again and thanks for your help.