smtc0097 / mysql-cacti-templates

Automatically exported from code.google.com/p/mysql-cacti-templates
GNU General Public License v2.0
0 stars 0 forks source link

Result from CMD not valid. Partial Result: U #121

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] Host[12] DS[32] CMD: 
path_php_binary -q path_cacti/scripts/ss_get_mysql_stats.php --host 
hostname --items bj,bm --user username --pass password --port port, 
output: U  
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] Host[12] DS[32] WARNING: Result 
from CMD not valid. Partial Result: U  
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into 
poller_output (local_data_id, rrd_name, time, output) values 
(31, '', '2010-01-21 15:10:02', 'U')"  
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] Host[12] DS[31] CMD: 
path_php_binary -q path_cacti/scripts/ss_get_mysql_stats.php --host 
hostname --items d2,d3,d4,d5,d6,d7,d8,d9,da,db,dc,dd,de,df,dg,dh --user 
username --pass password --port port, output: U  
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] Host[12] DS[31] WARNING: Result 
from CMD not valid. Partial Result: U  
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into 
poller_output (local_data_id, rrd_name, time, output) values 
(30, '', '2010-01-21 15:10:02', 'U')"  
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] Host[12] DS[30] CMD: 
path_php_binary -q path_cacti/scripts/ss_get_mysql_stats.php --host 
hostname --items bd,be,bf,bi,bl,bn --user username --pass password --port 
port, output: U  
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] Host[12] DS[30] WARNING: Result 
from CMD not valid. Partial Result: U  
01/21/2010 03:10:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into 
poller_output (local_data_id, rrd_name, time, output) values 
(19, 'traffic_in', '2010-01-21 15:10:02', '37377333325')"  

=============================================================

[root@web3 scripts]# /usr/local/php/bin/php -q ss_get_mysql_stats.php --
host 192.168.1.112 --items bj,bm --user cacti --pass 51sshcacti
bj:10446 bm:64[root@web3 scripts]#

[root@web3 scripts]# /usr/local/php/bin/php -q ss_get_mysql_stats.php --
host 192.168.1.112 [root@web3 scripts]# /usr/local/php/bin/php -q 
ss_get_mysql_stats.php --host 192.168.1.112 --items bd,be,bf,bi,bl,bn --
user cacti --pass 51sshcacti
bd:2030 be:2180 bf:1025 bi:2 bl:1024 bn:5400938[root@web3 scripts]#

[root@web3 scripts]# sed -n '43,48p' ss_get_mysql_stats.php 
$mysql_user = 'cacti';
$mysql_pass = '51sshcacti';
$mysql_port = 3306;

$heartbeat  = '';      # db.tbl in case you use mk-heartbeat from Maatkit.
$cache_dir  = '/tmp/cacti/cache';  # If set, this uses caching to avoid 
multiple calls.

Sorry I`m english very pool.

but I can read a lot of english manual. I can`t spaek and wirte :(

Original issue reported on code.google.com by Christ.S...@gmail.com on 21 Jan 2010 at 7:24

GoogleCodeExporter commented 8 years ago
I am getting almost the same error with ss_get_by_ssh.php

in my cacti log i have:
1/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[66] WARNING: Result from 
CMD not
valid.  Partial Result: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[66] CMD: path_php_binary 
-q
path_cacti/scripts/ss_get_by_ssh.php --host hostname --type proc_stat --items 
aq,
output: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[67] WARNING: Result from 
CMD
not valid.  Partial Result: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[67] CMD: path_php_binary 
-q
path_cacti/scripts/ss_get_by_ssh.php --host hostname --type proc_stat --items
ag,ah,ai,aj,ak,al,am,an,ao, output: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[68] WARNING: Result from 
CMD
not valid.  Partial Result: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[68] CMD: path_php_binary 
-q
path_cacti/scripts/ss_get_by_ssh.php --host hostname --type proc_stat --items 
ar,
output: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[69] WARNING: Result from 
CMD
not valid.  Partial Result: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[69] CMD: path_php_binary 
-q
path_cacti/scripts/ss_get_by_ssh.php --host hostname --type proc_stat --items 
ap,
output: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[70] WARNING: Result from 
CMD
not valid.  Partial Result: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[70] CMD: path_php_binary 
-q
path_cacti/scripts/ss_get_by_ssh.php --host hostname --type w --items as, 
output: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[71] WARNING: Result from 
CMD
not valid.  Partial Result: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[71] CMD: path_php_binary 
-q
path_cacti/scripts/ss_get_by_ssh.php --host hostname --type memory --items
au,av,aw,ax,ay, output: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[72] WARNING: Result from 
CMD
not valid.  Partial Result: U
01/21/2010 12:04:02 PM - CMDPHP: Poller[0] Host[5] DS[72] CMD: path_php_binary 
-q
path_cacti/scripts/ss_get_by_ssh.php --host hostname --type w --items at, 
output: U

I am running:
cacti Version 0.8.7e  
better-cacti-templates 1.1.6

Original comment by smyll...@gmail.com on 21 Jan 2010 at 7:12

GoogleCodeExporter commented 8 years ago
yeah ! 

I`m running better-cacti-templates 1.1.6 too

but cacti Version o.8.7d

online wait !  

Original comment by Christ.S...@gmail.com on 22 Jan 2010 at 2:59

GoogleCodeExporter commented 8 years ago
Please see if you can figure it out by going through the Cacti
debugging steps, which are posted on their forums and their user
manual.  If the answer is that the scripts or templates need to be
updated, please file an issue report with the necessary changes.  I
would be surprised if that is the case.  It is usually something to be
done inside of Cacti, such as clearing the poller cache.

The scripts themselves are obviously working, as shown in the original poster's 
output.

Summary was: Create better cacti templates for mysql cacti log WARNING: Result 
from
CMD not valid. Partial Result

Original comment by baron.schwartz on 22 Jan 2010 at 5:06

GoogleCodeExporter commented 8 years ago
I am very glad to see you reply

You want to see this?

If not, please tell me how to do thank you

I am a rookie, please forgive me

I hope you can help me solve this problem. This is very important to me

=========================================================================

01/23/2010 10:25:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into 
poller_output (local_data_id, rrd_name, time, output) values (32, '', 
'2010-01-23 
22:25:02', 'U')"  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] Host[12] DS[32] CMD: path_php_binary 
-q 
path_cacti/scripts/ss_get_mysql_stats.php --host hostname --items bj,bm --user 
username --pass password --port port, output: U  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] Host[12] DS[32] WARNING: Result from 
CMD 
not valid. Partial Result: U  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into 
poller_output (local_data_id, rrd_name, time, output) values (31, '', 
'2010-01-23 
22:25:02', 'U')"  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] Host[12] DS[31] CMD: path_php_binary 
-q 
path_cacti/scripts/ss_get_mysql_stats.php --host hostname --items 
d2,d3,d4,d5,d6,d7,d8,d9,da,db,dc,dd,de,df,dg,dh --user username --pass password 
--
port port, output: U  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] Host[12] DS[31] WARNING: Result from 
CMD 
not valid. Partial Result: U  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into 
poller_output (local_data_id, rrd_name, time, output) values (30, '', 
'2010-01-23 
22:25:02', 'U')"  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] Host[12] DS[30] CMD: path_php_binary 
-q 
path_cacti/scripts/ss_get_mysql_stats.php --host hostname --items 
bd,be,bf,bi,bl,bn -
-user username --pass password --port port, output: U  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] Host[12] DS[30] WARNING: Result from 
CMD 
not valid. Partial Result: U  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into 
poller_output (local_data_id, rrd_name, time, output) values 
(19, 'traffic_in', '2010-01-23 22:25:02', '38625691307')"  
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] Host[12] DS[19] SNMP: v2: 
192.168.1.112, 
dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.2, output: 38625691307  

Original comment by Christ.S...@gmail.com on 23 Jan 2010 at 2:45

GoogleCodeExporter commented 8 years ago
Please follow the instructions at
http://www.cacti.net/downloads/docs/html/debugging.html to resolve your 
problem.  The
script works fine from the command-line, thus, it is not a problem with the 
script.

Original comment by baron.schwartz on 23 Jan 2010 at 4:17

GoogleCodeExporter commented 8 years ago
ok 
thank you 

Original comment by Christ.S...@gmail.com on 25 Jan 2010 at 12:47

GoogleCodeExporter commented 8 years ago
I think I found the problem.

I guess that is because the MYSQL user name password variables are not given 
CACTI。

see
01/23/2010 10:25:02 PM - CMDPHP: Poller[0] Host[12] DS[32] CMD: path_php_binary 
-q 
path_cacti/scripts/ss_get_mysql_stats.php --host hostname --items bj,bm --user 
username --pass password --port port, output: U 

hostname、username、password、port 

but I have edited this file has

[root@web3 scripts]# sed -n '43,48p' ss_get_mysql_stats.php 
$mysql_user = 'cacti';
$mysql_pass = '51sshcacti';
$mysql_port = 3306;

$heartbeat  = '';      # db.tbl in case you use mk-heartbeat from Maatkit.
$cache_dir  = '/tmp/cacti/cache';  # If set, this uses caching to avoid 
multiple calls.

CACTI should get to the --user=cacti --pass 51sshcacti

Original comment by Christ.S...@gmail.com on 25 Jan 2010 at 1:12

GoogleCodeExporter commented 8 years ago
Command-line arguments override the configuration file.

Original comment by baron.schwartz on 25 Jan 2010 at 2:14