graphs with no values

[smor]

Graphs are being created but with no value, nothing is shown on them.
In cacti.log i get this

07/21/2007 08:40:02 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
07/21/2007 08:40:03 PM - CMDPHP: Poller[0] Host[2] DS[10] WARNING: Result from CMD not valid. Partial Result:
07/21/2007 08:40:03 PM - CMDPHP: Poller[0] Host[2] DS[11] WARNING: Result from CMD not valid. Partial Result:
07/21/2007 08:40:03 PM - SYSTEM STATS: Time:1.1094 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:3 RRDsProcessed:3

I searched forums and found similiar problems but none of them helped me to solve this :(
Any ideas??

[gandalf]

See first link of my signature for Debugging this issue
Reinhard

[smor]

I'm sorry, I read that link first but I found no solution there.

Here is the detailed output from log.

Code: Select all

[07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/www/cacti')"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
07/22/2007 10:06:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /httpd-office/cgi-bin/php4.new, ARGS: -q /www/cacti/cmd.php 0 3]
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 0     AND id <= 3)     ORDER by id"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 0     AND host_id <= 3)     ORDER by host_id"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 0    AND host_id <= 3))"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] Host[2] SNMP: Host responded to SNMP
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set  status = '3',  status_event_count = '0',  status_fail_date = '0000-00-00 00:00:00',  status_rec_date = '0000-00-00 00:00:00',  status_last_error = '',  min_time = '9.99999',  max_time = '565.83000',  cur_time = '90.09',  avg_time = '110.211739803',  total_polls = '862',  failed_polls = '0',  availability = '100'  where hostname = 'x.x.x.x'"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select     poller_reindex.data_query_id,     poller_reindex.action,     poller_reindex.op,     poller_reindex.assert_value,     poller_reindex.arg1     from poller_reindex     where poller_reindex.host_id=2"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] Host[2] RECACHE: Processing 1 items in the auto reindex cache for 'x.x.x.x'.
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='15555730' where host_id='2' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] Host[2] DS[10] WARNING: Result from CMD not valid.  Partial Result:
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] Host[2] DS[10] CMD: perl /www/cacti/scripts/linux_memory.pl MemFree:, output: U
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (10, 'mem_buffers', '2007-07-22 10:06:01', 'U')"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] Host[2] DS[11] WARNING: Result from CMD not valid.  Partial Result:
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] Host[2] DS[11] CMD: perl /www/cacti/scripts/linux_memory.pl SwapFree:, output: U
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (11, 'mem_swap', '2007-07-22 10:06:01', 'U')"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] Host[2] DS[15] CMD: perl /www/cacti/scripts/unix_processes.pl, output: 0
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (15, 'proc', '2007-07-22 10:06:01', '0')"
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] Time: 0.2821 s, Theads: N/A, Hosts: 3
07/22/2007 10:06:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  "
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='10' and rrd_name='mem_buffers' and time='2007-07-22 10:06:01'"
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='11' and rrd_name='mem_swap' and time='2007-07-22 10:06:01'"
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='15' and rrd_name='proc' and time='2007-07-22 10:06:01'"
07/22/2007 10:06:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.0.46/bin/rrdtool update /www/cacti/rra/hosting3_mem_buffers_10.rrd --template mem_buffers 1185091561:U
07/22/2007 10:06:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.0.46/bin/rrdtool update /www/cacti/rra/hosting3_mem_swap_11.rrd --template mem_swap 1185091561:U
07/22/2007 10:06:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.0.46/bin/rrdtool update /www/cacti/rra/hosting3_proc_15.rrd --template proc 1185091561:0
07/22/2007 10:06:02 AM - SYSTEM STATS: Time:1.0678 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:3 RRDsProcessed:3
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.0678 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:3 RRDsProcessed:3')"
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
07/22/2007 10:06:02 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"

When I'm checking method #3 I get no output??

Also, my poller cache is empty.

[gandalf]

perl /www/cacti/scripts/linux_memory.pl MemFree:, output: U

is clearly an error. Please run from cli to verify. Perhpas this perl script is not valid for your unix flavor. SAme holds for swap_free. IMHO, my howto talks about scripts returning U as a value, does it?
Reinhard