Unable to create graphs

[flb-iori]

Hi again,
Sorry for mass post, but I think it was not clear at all, I'm gonna try to explain my problem clearly and give a maximum of informations:
I followed this : http://docs.cacti.net/node/137, to create a graph on one of my devices, but when I click the "create"button, i got a Network Error (tcp_error). Previously I had a "exceeded timeout of 30 secondes" from php, but Changed the php.ini file. I don't think it is a server issue, because i have some other applications running and everything works great...

The devices look to be created (it appear in the devices list), but the main part of the time, I don't have the "snmp information" at the top of the page when i edit the device (mainly just "device is alive")

When I click on "create a graph", the data query part display that :
"This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information."

but if I try to run in debug mode, I have a tcp error again.

The poller don't seem to create the rrd files in /rra, I always have this kind of error:
"ERROR: opening '/opt/home/netadmin/src/cacti-0.8.7a/rra/sacctok106_sg_asia_5min_cpu_16.rrd': No such file or directory"

it looks like a permission issue but the user executing the poller (by crontab) and the owner of /rra are the same (anyway, for testing, I put 777 to /rra). Only the user for mysql database have a different name (but well informed in config.php.


All the path in settings looks corrects, file are found and working manually launched.

When I run poller.php or cmd.php manually, I have no display at all.

I'm not using SElinux.

I tryed to follow gandalf's file about suppressing nan, but I did find any solution.

I succeed to run the data query in debug mode for ucd/net - Get Monitored Partitions (not possible for snmp), it gives me that:
+ Running data query [2].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/opt/home/netadmin/src/cacti-0.8.7a/resource/snmp_queries/net-snmp_disk.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.2021.9.1.1'
+ No SNMP data returned
+ Found data query XML file at '/opt/home/netadmin/src/cacti-0.8.7a/resource/snmp_queries/net-snmp_disk.xml'
+ Found data query XML file at '/opt/home/netadmin/src/cacti-0.8.7a/resource/snmp_queries/net-snmp_disk.xml'
+ Found data query XML file at '/opt/home/netadmin/src/cacti-0.8.7a/resource/snmp_queries/net-snmp_disk.xml'


which look ok, but it still tell me "This data query returned 0 rows, perhaps there was a problem executing this data query"



Sorry again for my messy organiastion and thanks you very much!

[flb-iori]

EDIT: I was using the wrong php path, there is 2 installed on the server and look like one is not properly... Anyway, now it's working for unix request (load on localhost for example) but not for snmp request (interfaces statistics)
Here is the (big) cacti.log:

Code: Select all

12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
12/18/2007 06:05:00 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '299', Max Runtime '298'
, Poller Runs: '1'
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('poller_lastrun',11979
68700)"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/opt/h
ome/netadmin/src/cacti-0.8.7a')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "TRUNCATE TABLE poller_time"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
12/18/2007 06:05:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /opt/home/netad
min/src/cacti-0.8.7a/cmd.php 0 3]
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.l
ocal_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_o
utput.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "   SELECT * FROM host   WHERE (disabled = ''   AND id >= 0   AND
 id <= 3)   ORDER by id"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT *   FROM poller_item   WHERE (host_id >= 0   AND host_id
<= 3   AND rrd_next_step <= 0)   ORDER by host_id"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*)   FROM poller_item   WHERE (action=2   AND host_i
d >= 0   AND host_id <= 3   AND rrd_next_step <= 0)"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item   SET rrd_next_step = rrd_next_step - 300   WH
ERE (host_id >= 0   AND host_id <= 3)"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item   SET rrd_next_step = rrd_step - 300   WHERE (
rrd_next_step < 0   AND host_id >= 0   AND host_id <= 3)"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] PING: Host is alive
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fa
il_date = '0000-00-00 00:00:00', status_rec_date = '0000-00-00 00:00:00', status_last_error = '', min_time = '0.12000', max_ti
me = '0.34000', cur_time = '0.15', avg_time = '0.1850025', total_polls = '4', failed_polls = '0', availability = '100' where h
ostname = '127.0.0.1'"
12/18/2007 06:05:00 PM - 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
=1"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[3] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/linux_memory.pl
 MemFree:, output: 26832
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (3, 'mem_buffers', '2007-12-18 18:05:00', '26832')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[9] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_part
itions.pl get used /dev/cciss/c0d0p1, output: 14837
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (9, 'hdd_used', '2007-12-18 18:05:00', '14837')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[10] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get available /dev/cciss/c0d0p2, output: 1688316
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (10, 'hdd_free', '2007-12-18 18:05:00', '1688316')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[10] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get used /dev/cciss/c0d0p2, output: 2230356
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (10, 'hdd_used', '2007-12-18 18:05:00', '2230356')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[11] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get used /dev/cciss/c0d0p3, output: 1653868
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (11, 'hdd_used', '2007-12-18 18:05:00', '1653868')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[12] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get used /dev/cciss/c0d0p5, output: 17190060
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (12, 'hdd_used', '2007-12-18 18:05:00', '17190060')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[13] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get used /dev/cciss/c0d0p6, output: 28948
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (13, 'hdd_used', '2007-12-18 18:05:00', '28948')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[14] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get used /dev/cciss/c0d0p8, output: 239032
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (14, 'hdd_used', '2007-12-18 18:05:00', '239032')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[4] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/linux_memory.pl
 SwapFree:, output: 1900136
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (4, 'mem_swap', '2007-12-18 18:05:00', '1900136')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[5] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/loadavg_multi.p
l, output: 1min:3.34 5min:3.60 10min:3.27
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (5, '', '2007-12-18 18:05:00', '1min:3.34 5min:3.60 10min:3.27')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[6] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/unix_users.pl ,
 output: 8
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (6, 'users', '2007-12-18 18:05:00', '8')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/unix_processes.
pl, output: 152
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (7, 'proc', '2007-12-18 18:05:00', '152')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[9] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_part
itions.pl get available /dev/cciss/c0d0p1, output: 105055
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (9, 'hdd_free', '2007-12-18 18:05:00', '105055')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[11] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get available /dev/cciss/c0d0p3, output: 2264804
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (11, 'hdd_free', '2007-12-18 18:05:00', '2264804')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[12] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get available /dev/cciss/c0d0p5, output: 3173364
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (12, 'hdd_free', '2007-12-18 18:05:00', '3173364')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[13] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get available /dev/cciss/c0d0p6, output: 1930360
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (13, 'hdd_free', '2007-12-18 18:05:00', '1930360')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Host[1] DS[14] CMD: perl /opt/home/netadmin/src/cacti-0.8.7a/scripts/query_unix_par
titions.pl get available /dev/cciss/c0d0p8, output: 740600
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output)
 values (14, 'hdd_free', '2007-12-18 18:05:00', '740600')"
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] Time: 0.3692 s, Theads: N/A, Hosts: 2
12/18/2007 06:05:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values
(0, NOW(), NOW())"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.l
ocal_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_o
utput.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) "
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select   data_template_rrd.data_source_name,   data_input_fields
.data_name   from (data_template_rrd,data_input_fields)   where data_template_rrd.data_input_field_id=data_input_fields.id   a
nd data_template_rrd.local_data_id=5"
12/18/2007 06:05:01 PM - POLLER: Poller[0] Parsed MULTI output field '1min:3.34' [map 1min->load_1min]
12/18/2007 06:05:01 PM - POLLER: Poller[0] Parsed MULTI output field '5min:3.60' [map 5min->load_5min]
12/18/2007 06:05:01 PM - POLLER: Poller[0] Parsed MULTI output field '10min:3.27' [map 10min->load_15min]
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='12' and rrd_name='
hdd_free' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='11' and rrd_name='
hdd_free' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='7' and rrd_name='p
roc' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='9' and rrd_name='h
dd_free' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='6' and rrd_name='u
sers' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='5' and rrd_name=''
 and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='4' and rrd_name='m
em_swap' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='14' and rrd_name='
hdd_used' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='13' and rrd_name='
hdd_used' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='12' and rrd_name='
hdd_used' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='11' and rrd_name='
hdd_used' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='10' and rrd_name='
hdd_used' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='10' and rrd_name='
hdd_free' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='9' and rrd_name='h
dd_used' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='3' and rrd_name='m
em_buffers' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='13' and rrd_name='
hdd_free' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='14' and rrd_name='
hdd_free' and time='2007-12-18 18:05:00'"
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_12.rrd --template hdd_free:hdd_used 1197968700:3173364:17190060
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_11.rrd --template hdd_free:hdd_used 1197968700:2264804:1653868
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_proc_7.rrd --template proc 1197968700:152
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_9.rrd --template hdd_free:hdd_used 1197968700:105055:14837
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_users_6.rrd --template users 1197968700:8
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1197968700:3.34:3.60:3.27
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_mem_swap_4.rrd --template mem_swap 1197968700:1900136
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_14.rrd --template hdd_used:hdd_free 1197968700:239032:740600
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_13.rrd --template hdd_used:hdd_free 1197968700:28948:1930360
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_10.rrd --template hdd_used:hdd_free 1197968700:2230356:1688316
12/18/2007 06:05:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1197968700:26832
12/18/2007 06:05:01 PM - SYSTEM STATS: Time:1.1927 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSource
s:17 RRDsProcessed:11
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1
.1927 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:17 RRDsProcessed:11')"
12/18/2007 06:05:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"

[gandalf]

What does a verbose query of the interface data qiery return now?
Reinhard

[flb-iori]

A verbose query always give a tcp/network error

I used a bad version of php, with the good one it's ok for Unix request, but for snmp request, nothing, impossible to create a graph, and always this @%$! tcp error when trying verbose query

[TheWitness]

Two things to do.

1) Redirect standard error and output in Cacti's cron to a file for evaluation.
2) When running the reindex, look for errors in the Apache log.

Post both.

TheWitness

[flb-iori]

Hi, thanks again for reply, and sorry again for nuts answer:
By standard error and output, you mean cacti log?
When do I run reindex? I tryed to run it manually but I didn' found it in cacti's directory

Anyway, all I found in apache's error_log is (I mean for today) :

[Fri Dec 21 10:16:43 2007] [error] [client ad.dr.ess.ip File does not exist: /var/www/html/css/weblog.css, referer: http://server.address
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
[Fri Dec 21 13:23:10 2007] [error] [client ad.dr.ess.ip] File does not exist: /var/www/html/css/weblog.css, referer: http://server.address
[Fri Dec 21 13:23:23 2007] [error] [client ad.dr.ess.ip] File does not exist: /var/www/html/css/weblog.css, referer: http://server.address
[Fri Dec 21 13:23:26 2007] [error] [client ad.dr.ess.ip] File does not exist: /var/www/html/css/weblog.css, referer: http://server.address
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
[Fri Dec 21 13:57:04 2007] [error] [client ad.dr.ess.ip] File does not exist: /var/www/html/css/weblog.css, referer: http://server.address

[flb-iori]

I recently switch to spine, I don't know if that could help, but here is my poller's log (errors changed):

Content-type: text/html
X-Powered-By: PHP/4.3.2

12/21/2007 04:40:01 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '300', Max Runtime '298'
, Poller Runs: '1'
12/21/2007 04:40:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/spine/bin/spine, ARGS: 0 3
]
Waiting on 1/1 pollers.
read_config_store open failure on /var/net-snmp/spine.conf
read_config_store open failure on /var/net-snmp/snmpapp.conf
read_config_store open failure on /var/net-snmp/snmpapp.conf
12/21/2007 04:40:02 PM - POLLER: Poller[0] Parsed MULTI output field '1min:4.14' [map 1min->load_1min]
12/21/2007 04:40:02 PM - POLLER: Poller[0] Parsed MULTI output field '5min:3.99' [map 5min->load_5min]
12/21/2007 04:40:02 PM - POLLER: Poller[0] Parsed MULTI output field '10min:3.56' [map 10min->load_15min]
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/sacctok107_hdd_free_17.rrd --template hdd_used:hdd_free 1198222801:1695360:2223312
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/sacctok107_hdd_free_16.rrd --template hdd_free:hdd_used 1198222801:1686944:2231728
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/sacctok107_hdd_free_15.rrd --template hdd_used:hdd_free 1198222801105055
OK u:0.00 s:0.00 r:1.03
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/sacctok107_hdd_free_19.rrd --template hdd_free:hdd_used 1198222801:1928740:30568
OK u:0.00 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_14.rrd --template hdd_free:hdd_used 1198222801:740572:239060
OK u:0.00 s:0.00 r:1.04
OK u:0.00 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_13.rrd --template hdd_free:hdd_used 1198222801:1928740:30568
OK u:0.00 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_10.rrd --template hdd_free:hdd_used 1198222801:1686944:2231728
OK u:0.00 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_5min_cpu_8.rrd --template 5min_cpu 1198222801:U
OK u:0.00 s:0.00 r:1.04
OK u:0.00 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_12.rrd --template hdd_free:hdd_used 1198222801:3441424:16922004
OK u:0.00 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_11.rrd --template hdd_free:hdd_used 1198222801:2223312:1695360
OK u:0.00 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_9.rrd --template hdd_free:hdd_used 1198222801:105055:14837
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_proc_7.rrd --template proc 1198222801:132
OK u:0.00 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_users_6.rrd --template users 1198222801:5
OK u:0.01 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1198222801:4.14:3.99:3.56
OK u:0.01 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_mem_swap_4.rrd --template mem_swap 1198222801:2096956
OK u:0.01 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1198222801:25472
OK u:0.01 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/sacctok107_hdd_free_18.rrd --template hdd_free:hdd_used 1198222801:3441404:16922032
OK u:0.01 s:0.00 r:1.04
12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/sacctok107_hdd_free_20.rrd --template hdd_used:hdd_free 1198222801:239060:740572
OK u:0.01 s:0.00 r:1.04
12/21/2007 04:40:02 PM - SYSTEM STATS: Time:1.2581 Method:spine Processes:1 Threads:10 Hosts:3 HostsPerProcess:3 DataSources:3
0 RRDsProcessed:18
Loop Time is: 1.2616760730743
Sleep Time is: 298.73301005363
Total Time is: 1.2669899463654

[gandalf]

12/21/2007 04:40:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.2.26/bin/rrdtool update /opt/home/netadmin/src/cact
i-0.8.7a/rra/localhost_hdd_free_9.rrd --template hdd_free:hdd_used 1198222801:105055:14837
ERROR: reading the cookie off /opt/home/netadmin/src/cacti-0.8.7a/rra/localhost_hdd_free_9.rrd faild

Never saw this one before. Would it be an option to rename this rrd file? Cacti will recreate a new one, then. Or rrdtool dump and rrdtool resore this file to perhaps get more information
Reinhard

[TheWitness]

Likely using php-cgi and php's html functions are enabled for that call. Interesting. I need you to verify the following:

Code: Select all

php -v

Post the results. If it is the CGI version of PHP, I need you to file a bug report indicating as such. As this has never been a problem before, it may be with your Apache or PHP. Please post your tech support in an attachement.

TheWitness

[Tiago Cruz]

I did the upgrade of 0.8.6j to 0.8.7a and now I can't add new devices 'cause this command was failing:

Code: Select all

/usr/bin/rrdtool create /opt/cacti/htdocs/rra/projetobr_traffic_in_1399.rrd --step 300  DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797 RRA:LAST:0.5:1:600 RRA:LAST:0.5:6:700 RRA:LAST:0.5:24:775 RRA:LAST:0.5:288:797 \

Please, look at the slash ("\") on the end of command. If I get out this slash, the command works as well.

How can I solve this?

Thanks

[gandalf]

This is which OS and which rrdtool version?
Reinhard

[flb-iori]

hi, thanks for reply,

Code: Select all

/usr/bin/php -v
PHP 4.3.2 (cgi), Copyright (c) 1997-2003 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies

look like a cgi version

I posted a bug report (ID 0001129), sorry if did badly, my first time
Do you need anything else?

Thanks a lot for support guys!


EDIT: I just tryed to downgrade to 0.8.6j and I have the same issue, guess it should be related to php
BTW, strange thing, when I add a device, I have a big loading (like for verbose query) then a tcp error, but the device is created....twice!

[voyager]

Wish if somebody could help us in slash-end problem

/usr/bin/rrdtool create \
/var/www/cacti/rra/isb-iba2-edg-mx96-1_traffic_in_3256.rrd \
--step 300 \
DS:traffic_in:COUNTER:600:0:100000000 \
DS:traffic_out:COUNTER:600:0:100000000 \
RRA:AVERAGE:0.5:1:700 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:700 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

Agreed with the quote:
Please, look at the slash ("\") on the end of command. If I get out this slash, the command works as well.

The cacti is upgraded to 0.8.8b recently.

php -v
PHP 5.1.6 (cli) (built: Mar 18 2014 20:48:55)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies