Closed GoogleCodeExporter closed 9 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
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
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
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
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
ok
thank you
Original comment by Christ.S...@gmail.com
on 25 Jan 2010 at 12:47
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
Command-line arguments override the configuration file.
Original comment by baron.schwartz
on 25 Jan 2010 at 2:14
Original issue reported on code.google.com by
Christ.S...@gmail.com
on 21 Jan 2010 at 7:24