Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Aug 17, 2017 10:45 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 32 posts ]  Go to page Previous  1, 2, 3  Next
Author Message
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Wed Jun 22, 2011 1:21 pm 
Offline

Joined: Wed Jun 22, 2011 12:56 pm
Posts: 5
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 ?


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Wed Jun 22, 2011 8:47 pm 
Offline
Cacti Guru User

Joined: Thu Aug 05, 2010 2:04 am
Posts: 1573
Location: Japan
shanjan wrote:
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'.
Quote:
<?php
/* mysql_stats.php
* enables cacti to read mysql statistics
...

Is the script working properly?


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Tue Jun 28, 2011 10:33 am 
Offline

Joined: Wed Jun 22, 2011 12:56 pm
Posts: 5
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 ?


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Tue Jun 28, 2011 8:08 pm 
Offline
Cacti Guru User

Joined: Thu Aug 05, 2010 2:04 am
Posts: 1573
Location: Japan
Only for this point,
shanjan wrote:
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?


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Wed Jun 29, 2011 3:42 am 
Offline

Joined: Wed Jun 22, 2011 12:56 pm
Posts: 5
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 ..


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Wed Jun 29, 2011 4:04 am 
Offline
Cacti Guru User

Joined: Thu Aug 05, 2010 2:04 am
Posts: 1573
Location: Japan
shanjan wrote:
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
Quote:
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


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Wed Jun 29, 2011 9:22 am 
Offline

Joined: Tue Nov 28, 2006 6:44 am
Posts: 24
Location: Akron
Please read:

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

shanjan wrote:
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 ..

_________________
Scott McCarty
Solutions Architect/Open Source Evangelist
Twitter: @fatherlinux
URL: http://crunchtools.com


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Wed Jun 29, 2011 9:40 am 
Offline

Joined: Wed Jun 22, 2011 12:56 pm
Posts: 5
Thanks a lot for all your help .


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Mon Sep 26, 2011 1:58 pm 
Offline
Cacti User

Joined: Fri Mar 26, 2010 7:42 am
Posts: 92
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?


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Sun Oct 23, 2011 10:08 am 
Offline
Developer
User avatar

Joined: Thu Dec 02, 2004 2:46 am
Posts: 22461
Location: Muenster, Germany
Either remove the wrong entry from "--y-grid" on the graph template or enter a valid value. See e.g. "man rrdgraph"
R.

_________________
Official Cacti Documentation
Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Tue Oct 25, 2011 8:51 am 
Offline

Joined: Tue Mar 22, 2005 3:00 pm
Posts: 5
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.


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Thu Nov 03, 2011 7:54 am 
Offline
Cacti User
User avatar

Joined: Wed Jun 24, 2009 9:42 am
Posts: 95
Just curious. . .but has anyone ported this over to the Script Server?

_________________
mount -o protected -t voluptuous,selfmaintaining /dev/woman /mnt/me
Attitude is no substitute for competence
See through faded, super jaded, out of my mind


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Fri Mar 09, 2012 3:46 am 
Offline

Joined: Mon Feb 20, 2012 11:53 am
Posts: 6
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?


Top
 Profile  
 
 Post subject: Re: The MySQL Graph Collection - Version 2.0.1!
PostPosted: Sun Mar 11, 2012 5:34 am 
Offline

Joined: Fri Dec 05, 2008 5:49 am
Posts: 34
Location: Vilnius, Lithuania
Guys,
I've updated the script and created a new template for "Query cache hits" statistics.
Attached both: script and template.


Attachments:
screenshot.png
screenshot.png [ 48.68 KiB | Viewed 3530 times ]
Query cache hits.zip [6.02 KiB]
Downloaded 254 times
Top
 Profile  
 
 Post subject: Re: UpdateÑ The MySQL Graph Collection - Version 2.5.0!
PostPosted: Tue Jul 09, 2013 11:48 am 
Offline

Joined: Tue Jul 09, 2013 10:34 am
Posts: 6
Hey,

I did a test:
Code:
php mysql_stats.php status 192.11.13.4 cacti_stats 123123 Connections
16584


However, my graphs still show -nan


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 32 posts ]  Go to page Previous  1, 2, 3  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group