UpdateÑ The MySQL Graph Collection - Version 2.5.0!

[shanjan]

Hi ,

I am only able to view graphs for Mysql-single statics and Mysql- Questions which are also blank.

Rest all the graphs shows no image option ..

I am using cacti 0.8.7g version

the script is running fine but i see following in cacti.log file :

....

06/22/2011 11:10:04 AM - CMDPHP: Poller[0] Host[2] DS[70] WARNING: Result from CMD not valid. Partial Result: bles cacti to read m
06/22/2011 11:10:04 AM - CMDPHP: Poller[0] Host[2] DS[71] WARNING: Result from CMD not valid. Partial Result: bles cacti to read m
06/22/2011 11:10:04 AM - CMDPHP: Poller[0] Host[2] DS[72] WARNING: Result from CMD not valid. Partial Result: bles cacti to read m
06/22/2011 11:10:05 AM - SYSTEM STATS: Time:4.1793 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:57 RRDsProcessed:39


Can someone help me on this ?

[noname]

06/22/2011 11:10:04 AM - CMDPHP: Poller[0] Host[2] DS[70] WARNING: Result from CMD not valid. Partial Result: bles cacti to read m

The above error string seems to be a part of 'mysql_stats.php'.

<?php
/* mysql_stats.php
* enables cacti to read mysql statistics
...

Is the script working properly?

[shanjan]

Thanks for the reply i found my error ...

But still all the graphs shown are blank .

latest cacti.log shows :


06/28/2011 08:25:01 AM - CMDPHP: Poller[0] Host[1] DS[38] WARNING: Result from CMD not valid. Partial Result: U
06/28/2011 08:25:02 AM - CMDPHP: Poller[0] Host[1] DS[36] WARNING: Result from CMD not valid. Partial Result: U
06/28/2011 08:25:02 AM - CMDPHP: Poller[0] Host[1] DS[37] WARNING: Result from CMD not valid. Partial Result: U
06/28/2011 08:25:02 AM - CMDPHP: Poller[0] Host[1] DS[39] WARNING: Result from CMD not valid. Partial Result: U
06/28/2011 08:25:02 AM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'10.41.38.52', and OID:'.1.3.6.1.4.1.9.2.1.58.0'
06/28/2011 08:25:02 AM - CMDPHP: Poller[0] Host[2] DS[19] WARNING: Result from SNMP not valid. Partial Result: U
06/28/2011 08:25:02 AM - CMDPHP: Poller[0] Host[2] DS[50] WARNING: Result from CMD not valid. Partial Result: U
06/28/2011 08:25:03 AM - CMDPHP: Poller[0] Host[2] DS[61] WARNING: Result from CMD not valid. Partial Result: U
06/28/2011 08:25:04 AM - CMDPHP: Poller[0] Host[2] DS[70] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
06/28/2011 08:25:04 AM - SYSTEM STATS: Time:3.1739 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:57 RRDsProcessed:54


What could be reason behind the blank graphs ?

[noname]

Only for this point,

06/28/2011 08:25:04 AM - CMDPHP: Poller[0] Host[2] DS[70] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet

I think it still has problem to execute that script..
Did you follow instructions for this template (README.txt)?

Remaining warnings about other host(1) and datasources(19,36,37,38,39,50,61) are not sure.
Does it relate with this template?

[shanjan]

Thanks for the reply ..

Now i m able to view all the graphs but mysql single statistics graph shows empty .

The script is running fine and followed all the steps according to README.TXT ..

[noname]

Now i m able to view all the graphs but mysql single statistics graph shows empty .

Did you set the specific variable which you want to see?

- Graph MySQL Stats : MySQL - Single Statistics

This graph does not display any particular variable and is free to be used for any singe variable.
This can be done by modifying the Internal Data Source Name within the Data Template

For example:
/usr/local/bin/php -q <path_cacti>/scripts/mysql_stats.php status <hostname> <username> <password> Slow_queries

[scottevil]

Please read:

http://crunchtools.com/software/cruncht ... Statistics

Thanks for the reply ..

Now i m able to view all the graphs but mysql single statistics graph shows empty .

The script is running fine and followed all the steps according to README.TXT ..

[shanjan]

Thanks a lot for all your help .

[bonj87]

i got your templates imported.. some are working, some are not..
the ones that arent, tell me
ERROR: invalid y-grid format

can you point me in the right direction?

[gandalf]

Either remove the wrong entry from "--y-grid" on the graph template or enter a valid value. See e.g. "man rrdgraph"
R.

[Bratell]

Seems as if crunchtools.com is pointing to somewhere else. Maybe it's been hijacked or something.

If you google the page you can se the cached version, displaying all the info you want.

[ARC1450]

Just curious. . .but has anyone ported this over to the Script Server?

[alexsw]

Hi
I did everything according to instructions, but I get the following error

CMDPHP: Poller[0] Host[25] DS[2555] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
CMDPHP: Poller[0] Host[25] DS[2555] CMD: /usr/local/bin/php -q /usr/local/share/cacti/scripts/mysql_stats.php traffic 127.0.0.1 cactiuser pass, output: Error: wrong parameter count
CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (2555, '', '2012-03-09 12:35:03', 'Error: wrong parameter count')"
CMDPHP: Poller[0] Host[25] DS[2554] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
CMDPHP: Poller[0] Host[25] DS[2554] CMD: /usr/local/bin/php -q /usr/local/share/cacti/scripts/mysql_stats.php thread 127.0.0.1 cactiuser pass, output: Error: wrong parameter count
CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (2554, '', '2012-03-09 12:35:03', 'Error: wrong parameter count')"
CMDPHP: Poller[0] Host[25] DS[2553] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
CMDPHP: Poller[0] Host[25] DS[2553] CMD: /usr/local/bin/php -q /usr/local/share/cacti/scripts/mysql_stats.php status 127.0.0.1 cactiuser pass , output: Error: wrong parameter count
CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (2553, 'value', '2012-03-09 12:35:03', 'Error: wrong parameter count')"
CMDPHP: Poller[0] Host[25] DS[2552] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
CMDPHP: Poller[0] Host[25] DS[2552] CMD: /usr/local/bin/php -q /usr/local/share/cacti/scripts/mysql_stats.php status 127.0.0.1 cactiuser pass Questions, output: Error: wrong parameter count
CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (2552, 'questions', '2012-03-09 12:35:03', 'Error: wrong parameter count')"
CMDPHP: Poller[0] Host[25] DS[2551] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
CMDPHP: Poller[0] Host[25] DS[2551] CMD: /usr/local/bin/php -q /usr/local/share/cacti/scripts/mysql_stats.php cache 127.0.0.1 cactiuser pass, output: Error: wrong parameter count
CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (2551, '', '2012-03-09 12:35:03', 'Error: wrong parameter count')"
CMDPHP: Poller[0] Host[25] DS[2550] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
CMDPHP: Poller[0] Host[25] DS[2550] CMD: /usr/local/bin/php -q /usr/local/share/cacti/scripts/mysql_stats.php handler 127.0.0.1 cactiuser pass, output: Error: wrong parameter count
CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (2550, '', '2012-03-09 12:35:03', 'Error: wrong parameter count')"
CMDPHP: Poller[0] Host[25] DS[2549] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
CMDPHP: Poller[0] Host[25] DS[2549] CMD: /usr/local/bin/php -q /usr/local/share/cacti/scripts/mysql_stats.php status 127.0.0.1 cactiuser pass Connections, output: Error: wrong parameter count
CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (2549, 'connections', '2012-03-09 12:35:03', 'Error: wrong parameter count')"
CMDPHP: Poller[0] Host[25] DS[2548] WARNING: Result from CMD not valid. Partial Result: Error: wrong paramet
CMDPHP: Poller[0] Host[25] DS[2548] CMD: /usr/local/bin/php -q /usr/local/share/cacti/scripts/mysql_stats.php command 127.0.0.1 cactiuser pass, output: Error: wrong parameter count
CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (2548, '', '2012-03-09 12:35:03', 'Error: wrong parameter count')"

How to fix it?

[dainiookas]

Guys,
I've updated the script and created a new template for "Query cache hits" statistics.
Attached both: script and template.

[AshleyW]

Hey,

I did a test:

Code: Select all

php mysql_stats.php status 192.11.13.4 cacti_stats 123123 Connections
16584

However, my graphs still show -nan