Graphs aren't being created
Moderators: Developers, Moderators
Graphs aren't being created
I've gotten Cacti installed and having created a device for the localhost, but images/graphs aren't being created in the RRA folder (I've setup permissions and even extended it to the everyone/modify to make sure it isn't a permissions issue. I'm stumped at this point and would appreciate any help.
My installation is this:
Windows 2003 SP1
MySQL 4.1
PHP 4.4.2
Cacti0.8.6h
Cactid0.8.6g
Net-snmp 5.3.0-1
RRDTool1.2.10
I tried testing out the php poller function and this is what was returned in command prompt (below that I've copied the cacti.log, which appears to be much the same info):
:\Inetpub\wwwroot\Cacti>php poller.php
X-Powered-By: PHP/4.4.2
Content-type: text/html
02/21/2006 12:02:29 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 9]
Waiting on 1/1 pollers.
ERROR: change root is not supported by your OS or at least by this copy of rrdto
ol
Waiting on 1/1 pollers.
02/21/2006 12:02:32 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe cre
ate C:/Inetpub/wwwroot/Cacti/rra/localhost_traffic_in_53.rrd --step 300 DS:t
raffic_out:COUNTER:600:0:100000000 DS:traffic_in:COUNTER:600:0:100000000 RRA:A
VERAGE: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
02/21/2006 12:02:32 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\Cacti\rra\localhost_traffic_in_53.rrd --template traffic_
out:traffic_in N:1391506:1391506
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe cre
ate C:/Inetpub/wwwroot/Cacti/rra/localhost_hdd_total_52.rrd --step 300 DS:hd
d_used:GAUGE:600:0:U DS:hdd_total:GAUGE:600:0:U RRA:AVERAGE:0.5:1:600 RRA:AVE
RAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:6
00 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\Cacti\rra\localhost_hdd_total_52.rrd --template hdd_total
:hdd_used N:17166123008:5208231936
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe cre
ate C:/Inetpub/wwwroot/Cacti/rra/localhost_traffic_in_54.rrd --step 300 DS:t
raffic_out:COUNTER:600:0:100000000 DS:traffic_in:COUNTER:600:0:100000000 RRA:A
VERAGE: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
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\Cacti\rra\localhost_traffic_in_54.rrd --template traffic_
out:traffic_in N:5806974:6275619
02/21/2006 12:02:33 PM - SYSTEM STATS: Time:2.5529 Method:cmd.php Processes:1 Th
reads:N/A Hosts:2 HostsPerProcess:2 DataSources:6 RRDsProcessed:3
Cacti log:
02/21/2006 12:02:29 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
02/21/2006 12:02:29 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
02/21/2006 12:02:29 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/Inetpub/wwwroot/Cacti')"
02/21/2006 12:02:29 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
02/21/2006 12:02:29 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 9]
02/21/2006 12:02:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= 9) ORDER by id"
02/21/2006 12:02:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 9) ORDER by host_id"
02/21/2006 12:02:30 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= 9))"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/21/2006 12:02:31 PM - 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)"
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: GETCWD: c:/inetpub/wwwroot/cacti
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: DIRNAM: c:/inetpub/wwwroot/cacti
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: FILENM: c:\inetpub\wwwroot\cacti\script_server.php
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] PHP Script Server Started Properly
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] Host[9] SNMP: Host responded to SNMP
02/21/2006 12:02:31 PM - 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 = '4.43000', max_time = '40.40000', cur_time = '9.11', avg_time = '13.1283333333', total_polls = '6', failed_polls = '0', availability = '100' where hostname = 'localhost'"
02/21/2006 12:02:31 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=9"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] Host[9] RECACHE: Processing 3 items in the auto reindex cache for 'localhost'.
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='54693' where host_id='9' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='54694' where host_id='9' and data_query_id='8' and arg1='.1.3.6.1.2.1.1.3.0'"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='54694' where host_id='9' and data_query_id='9' and arg1='.1.3.6.1.2.1.1.3.0'"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] Host[9] DS[53] SNMP: v1: localhost, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, output: 1391506
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (53,'traffic_out','2006-02-21 12:02:30','1391506')"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] Host[9] DS[53] SNMP: v1: localhost, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: 1391506
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (53,'traffic_in','2006-02-21 12:02:30','1391506')"
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get used 2'
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=9 and field_name='hrStorageAllocationUnits' and snmp_index='2'"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/21/2006 12:02:32 PM - 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)"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='53' and rrd_name='traffic_out' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='53' and rrd_name='traffic_in' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=53"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=53 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_rrd.id, data_template_rrd.rrd_heartbeat, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_type_id from data_template_rrd where data_template_rrd.local_data_id=53"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=165"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=164"
02/21/2006 12:02:32 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe create C:/Inetpub/wwwroot/Cacti/rra/localhost_traffic_in_53.rrd --step 300 DS:traffic_out:COUNTER:600:0:100000000 DS:traffic_in: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
02/21/2006 12:02:32 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Cacti\rra\localhost_traffic_in_53.rrd --template traffic_out:traffic_in N:1391506:1391506
02/21/2006 12:02:32 PM - PHPSVR: Poller[0] SERVER: C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php ss_host_disk localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get used 2 output 5208231936
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Host[9] DS[52] SERVER: C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php ss_host_disk localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get used 2, output: 5208231936
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (52,'hdd_used','2006-02-21 12:02:30','5208231936')"
02/21/2006 12:02:32 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get total 2'
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=9 and field_name='hrStorageAllocationUnits' and snmp_index='2'"
02/21/2006 12:02:32 PM - PHPSVR: Poller[0] SERVER: C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php ss_host_disk localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get total 2 output 17166123008
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Host[9] DS[52] SERVER: C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php ss_host_disk localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get total 2, output: 17166123008
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (52,'hdd_total','2006-02-21 12:02:30','17166123008')"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Host[9] DS[54] SNMP: v1: localhost, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.65539, output: 5806974
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (54,'traffic_out','2006-02-21 12:02:30','5806974')"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Host[9] DS[54] SNMP: v1: localhost, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.65539, output: 6275619
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (54,'traffic_in','2006-02-21 12:02:30','6275619')"
02/21/2006 12:02:32 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Time: 1.7543 s, Theads: N/A, Hosts: 1
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/21/2006 12:02:33 PM - 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)"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='52' and rrd_name='hdd_total' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='52' and rrd_name='hdd_used' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='54' and rrd_name='traffic_out' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='54' and rrd_name='traffic_in' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=52"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=52 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_rrd.id, data_template_rrd.rrd_heartbeat, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_type_id from data_template_rrd where data_template_rrd.local_data_id=52"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=163"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=162"
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe create C:/Inetpub/wwwroot/Cacti/rra/localhost_hdd_total_52.rrd --step 300 DS:hdd_used:GAUGE:600:0:U DS:hdd_total:GAUGE:600:0:U 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
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Cacti\rra\localhost_hdd_total_52.rrd --template hdd_total:hdd_used N:17166123008:5208231936
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=54"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=54 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_rrd.id, data_template_rrd.rrd_heartbeat, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_type_id from data_template_rrd where data_template_rrd.local_data_id=54"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=167"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=166"
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe create C:/Inetpub/wwwroot/Cacti/rra/localhost_traffic_in_54.rrd --step 300 DS:traffic_out:COUNTER:600:0:100000000 DS:traffic_in: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
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Cacti\rra\localhost_traffic_in_54.rrd --template traffic_out:traffic_in N:5806974:6275619
02/21/2006 12:02:33 PM - SYSTEM STATS: Time:2.5529 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:6 RRDsProcessed:3
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:2.5529 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:6 RRDsProcessed:3')"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
My installation is this:
Windows 2003 SP1
MySQL 4.1
PHP 4.4.2
Cacti0.8.6h
Cactid0.8.6g
Net-snmp 5.3.0-1
RRDTool1.2.10
I tried testing out the php poller function and this is what was returned in command prompt (below that I've copied the cacti.log, which appears to be much the same info):
:\Inetpub\wwwroot\Cacti>php poller.php
X-Powered-By: PHP/4.4.2
Content-type: text/html
02/21/2006 12:02:29 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 9]
Waiting on 1/1 pollers.
ERROR: change root is not supported by your OS or at least by this copy of rrdto
ol
Waiting on 1/1 pollers.
02/21/2006 12:02:32 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe cre
ate C:/Inetpub/wwwroot/Cacti/rra/localhost_traffic_in_53.rrd --step 300 DS:t
raffic_out:COUNTER:600:0:100000000 DS:traffic_in:COUNTER:600:0:100000000 RRA:A
VERAGE: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
02/21/2006 12:02:32 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\Cacti\rra\localhost_traffic_in_53.rrd --template traffic_
out:traffic_in N:1391506:1391506
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe cre
ate C:/Inetpub/wwwroot/Cacti/rra/localhost_hdd_total_52.rrd --step 300 DS:hd
d_used:GAUGE:600:0:U DS:hdd_total:GAUGE:600:0:U RRA:AVERAGE:0.5:1:600 RRA:AVE
RAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:6
00 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\Cacti\rra\localhost_hdd_total_52.rrd --template hdd_total
:hdd_used N:17166123008:5208231936
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe cre
ate C:/Inetpub/wwwroot/Cacti/rra/localhost_traffic_in_54.rrd --step 300 DS:t
raffic_out:COUNTER:600:0:100000000 DS:traffic_in:COUNTER:600:0:100000000 RRA:A
VERAGE: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
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\Cacti\rra\localhost_traffic_in_54.rrd --template traffic_
out:traffic_in N:5806974:6275619
02/21/2006 12:02:33 PM - SYSTEM STATS: Time:2.5529 Method:cmd.php Processes:1 Th
reads:N/A Hosts:2 HostsPerProcess:2 DataSources:6 RRDsProcessed:3
Cacti log:
02/21/2006 12:02:29 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
02/21/2006 12:02:29 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
02/21/2006 12:02:29 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/Inetpub/wwwroot/Cacti')"
02/21/2006 12:02:29 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
02/21/2006 12:02:29 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 9]
02/21/2006 12:02:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= 9) ORDER by id"
02/21/2006 12:02:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 9) ORDER by host_id"
02/21/2006 12:02:30 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= 9))"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/21/2006 12:02:31 PM - 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)"
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: GETCWD: c:/inetpub/wwwroot/cacti
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: DIRNAM: c:/inetpub/wwwroot/cacti
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: FILENM: c:\inetpub\wwwroot\cacti\script_server.php
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] PHP Script Server Started Properly
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] Host[9] SNMP: Host responded to SNMP
02/21/2006 12:02:31 PM - 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 = '4.43000', max_time = '40.40000', cur_time = '9.11', avg_time = '13.1283333333', total_polls = '6', failed_polls = '0', availability = '100' where hostname = 'localhost'"
02/21/2006 12:02:31 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=9"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] Host[9] RECACHE: Processing 3 items in the auto reindex cache for 'localhost'.
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='54693' where host_id='9' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='54694' where host_id='9' and data_query_id='8' and arg1='.1.3.6.1.2.1.1.3.0'"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='54694' where host_id='9' and data_query_id='9' and arg1='.1.3.6.1.2.1.1.3.0'"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] Host[9] DS[53] SNMP: v1: localhost, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, output: 1391506
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (53,'traffic_out','2006-02-21 12:02:30','1391506')"
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] Host[9] DS[53] SNMP: v1: localhost, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: 1391506
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (53,'traffic_in','2006-02-21 12:02:30','1391506')"
02/21/2006 12:02:31 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get used 2'
02/21/2006 12:02:31 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=9 and field_name='hrStorageAllocationUnits' and snmp_index='2'"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/21/2006 12:02:32 PM - 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)"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='53' and rrd_name='traffic_out' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='53' and rrd_name='traffic_in' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=53"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=53 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_rrd.id, data_template_rrd.rrd_heartbeat, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_type_id from data_template_rrd where data_template_rrd.local_data_id=53"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=165"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=164"
02/21/2006 12:02:32 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe create C:/Inetpub/wwwroot/Cacti/rra/localhost_traffic_in_53.rrd --step 300 DS:traffic_out:COUNTER:600:0:100000000 DS:traffic_in: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
02/21/2006 12:02:32 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Cacti\rra\localhost_traffic_in_53.rrd --template traffic_out:traffic_in N:1391506:1391506
02/21/2006 12:02:32 PM - PHPSVR: Poller[0] SERVER: C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php ss_host_disk localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get used 2 output 5208231936
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Host[9] DS[52] SERVER: C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php ss_host_disk localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get used 2, output: 5208231936
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (52,'hdd_used','2006-02-21 12:02:30','5208231936')"
02/21/2006 12:02:32 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get total 2'
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=9 and field_name='hrStorageAllocationUnits' and snmp_index='2'"
02/21/2006 12:02:32 PM - PHPSVR: Poller[0] SERVER: C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php ss_host_disk localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get total 2 output 17166123008
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Host[9] DS[52] SERVER: C:\Inetpub\wwwroot\Cacti\scripts\ss_host_disk.php ss_host_disk localhost 9 1:161:500:Sea-SNMPString:!WSTSEA-Scripting: :MD5::[None] get total 2, output: 17166123008
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (52,'hdd_total','2006-02-21 12:02:30','17166123008')"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Host[9] DS[54] SNMP: v1: localhost, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.65539, output: 5806974
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (54,'traffic_out','2006-02-21 12:02:30','5806974')"
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Host[9] DS[54] SNMP: v1: localhost, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.65539, output: 6275619
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (54,'traffic_in','2006-02-21 12:02:30','6275619')"
02/21/2006 12:02:32 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] Time: 1.7543 s, Theads: N/A, Hosts: 1
02/21/2006 12:02:32 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/21/2006 12:02:33 PM - 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)"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='52' and rrd_name='hdd_total' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='52' and rrd_name='hdd_used' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='54' and rrd_name='traffic_out' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='54' and rrd_name='traffic_in' and time='2006-02-21 12:02:30'"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=52"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=52 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_rrd.id, data_template_rrd.rrd_heartbeat, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_type_id from data_template_rrd where data_template_rrd.local_data_id=52"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=163"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=162"
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe create C:/Inetpub/wwwroot/Cacti/rra/localhost_hdd_total_52.rrd --step 300 DS:hdd_used:GAUGE:600:0:U DS:hdd_total:GAUGE:600:0:U 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
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Cacti\rra\localhost_hdd_total_52.rrd --template hdd_total:hdd_used N:17166123008:5208231936
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=54"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=54 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_rrd.id, data_template_rrd.rrd_heartbeat, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_type_id from data_template_rrd where data_template_rrd.local_data_id=54"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=167"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=166"
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe create C:/Inetpub/wwwroot/Cacti/rra/localhost_traffic_in_54.rrd --step 300 DS:traffic_out:COUNTER:600:0:100000000 DS:traffic_in: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
02/21/2006 12:02:33 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Cacti\rra\localhost_traffic_in_54.rrd --template traffic_out:traffic_in N:5806974:6275619
02/21/2006 12:02:33 PM - SYSTEM STATS: Time:2.5529 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:6 RRDsProcessed:3
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:2.5529 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:6 RRDsProcessed:3')"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
02/21/2006 12:02:33 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
Last edited by Xrysmu on Tue Feb 21, 2006 7:13 pm, edited 1 time in total.
Looks like you're collecting valid data, so it's a permission problem. You said there are no rrd files in the cacti/rrd folder? Make sure the IUSR_XXX has read/execute rights on cmd.exe and rrdtool.exe. Plus, IUSR_XXX and IIS_WPG will need Modify rights to /cacti/log and /cacti/rrd folders.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Graphs aren't being created
Hmm, I gave read/execute on the rrdtool.exe file (located in c:\rrdtools) and had already set the permissions on the cmd.exe. I'd had the permissions set for the IIS_WPG account, but added the IUSR_XXX account. However, I'm confused about something. When I extracted the Cacti zip to wwwroot\Cacti there was/is no rrd subfolder. There is a rra folder, but I don't know if this is the same thing. I did extend the permissions to that folder. I believe all the other permissions are correct as per the installation instructions. When I turn on the graph debug I get this info for one of the graphs:
RRDTool Command:
c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Costello - File Server - CPU Utilization - CPU0" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="c\:/inetpub/wwwroot/cacti/rra/costello_file_server_cpu_58.rrd":cpu:AVERAGE \
AREA:a#FF0000:"CPU Utilization" \
GPRINT
LAST:"Current\:%8.0lf" \
GPRINT
AVERAGE:"Average\:%8.0lf" \
GPRINT
MAX:"Maximum\:%8.0lf"
RRDTool Says:
ERROR: opening 'c:/inetpub/wwwroot/cacti/rra/costello_file_server_cpu_58.rrd': No such file or directory
RRDTool Command:
c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Costello - File Server - CPU Utilization - CPU0" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="c\:/inetpub/wwwroot/cacti/rra/costello_file_server_cpu_58.rrd":cpu:AVERAGE \
AREA:a#FF0000:"CPU Utilization" \
GPRINT
GPRINT
GPRINT
RRDTool Says:
ERROR: opening 'c:/inetpub/wwwroot/cacti/rra/costello_file_server_cpu_58.rrd': No such file or directory
Graphs aren't being created
I ran filemon when I ran the php poller.php command. See the attached to see what results I got. I'm not seeing any failures, but there are a number of not found and invalid parameter errors being thrown. They don't mean anything to me, but hopefully to someone out there. Again, I've set the permissions on the RRA folder allowing modify access for the IUSR_XXX account and the IIS_WPG account.
- Attachments
-
- PHPPoll.txt
- (10.36 KiB) Downloaded 124 times
Yes, you're suppose to have a /rra folder which holds .rrd files ![;-)](./images/smilies/icon_wink.gif)
What happens when an administrator account runs: php <cactipath>\poller.php ? Are the rrd files created then?
Try using Filemon when cacti is polling the devices. The stuff you captured doesn't show much more than cacti opening the rrd files.
![;-)](./images/smilies/icon_wink.gif)
What happens when an administrator account runs: php <cactipath>\poller.php ? Are the rrd files created then?
Try using Filemon when cacti is polling the devices. The stuff you captured doesn't show much more than cacti opening the rrd files.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Graphs aren't being created
I'm appreciating the help and direction, but I wanted to clarify something,
the documentation specifies a /rrd directory, but looking at the forum I see people referring to the /rra directory are they one and the same and is the /rrd a typo? Just want to clarify that point.
The attachment I posted previously was from running the poller.php and doing a filemon capture, did what you found in there not match what would be expected? The rrd files are not created.
I haven't setup polling. I believe in the instructions on your website you do this using the scheduled task and kicking off the cactid correct? I apologize if I'm being obtuse there, but I'm not at work today and wanted to clarify. I had set the scheduler as it didn't appear the graphs were being created, but I can certain set that up even in the absence. Thanks again for the assistance.
the documentation specifies a /rrd directory, but looking at the forum I see people referring to the /rra directory are they one and the same and is the /rrd a typo? Just want to clarify that point.
The attachment I posted previously was from running the poller.php and doing a filemon capture, did what you found in there not match what would be expected? The rrd files are not created.
I haven't setup polling. I believe in the instructions on your website you do this using the scheduled task and kicking off the cactid correct? I apologize if I'm being obtuse there, but I'm not at work today and wanted to clarify. I had set the scheduler as it didn't appear the graphs were being created, but I can certain set that up even in the absence. Thanks again for the assistance.
Re: Graphs aren't being created
Typo / confusion. rra <-> rrd basically means the same thing.Xrysmu wrote:I'm appreciating the help and direction, but I wanted to clarify something,
the documentation specifies a /rrd directory, but looking at the forum I see people referring to the /rra directory are they one and the same and is the /rrd a typo? Just want to clarify that point.
Did you filter out a lot of processes or something? There should be a LOT more file activity when cacti is polling devices. Did you run the poller as an administrator?Xrysmu wrote:The attachment I posted previously was from running the poller.php and doing a filemon capture, did what you found in there not match what would be expected? The rrd files are not created.
Yes, poller.php will launch either cmd.php or cactid.exe.Xrysmu wrote:I believe in the instructions on your website you do this using the scheduled task and kicking off the cactid correct?
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Graphs aren't being created
BSOD2600,
Thanks for your help on this issue, I'm impressed at the support you've been providing. I happened to google an error message that was a part of my initial post (regarding changing directory...rrdtool) and came up with an old answer from you to someone else, which was to change the rrdtool to the cgywin version. Anyway, that did the trick. I will be writing up a set of install instructions once I repeat the install and have it working successfully and I'd happily send that to you if you want to review it and/or supplement your install instructions.
One final question I do have for you is on the patches that are recommended I can get to them, but I'm not clear as to what files they are replacing as running the patch command didn't work (I'm sure I'm doing something wrong, but am unclear what it is and/or if there is something that I should have installed that runs the patch command). Thanks again, all your help has been useful and appreciated (even when I googled your old answers:)
-Chris
Thanks for your help on this issue, I'm impressed at the support you've been providing. I happened to google an error message that was a part of my initial post (regarding changing directory...rrdtool) and came up with an old answer from you to someone else, which was to change the rrdtool to the cgywin version. Anyway, that did the trick. I will be writing up a set of install instructions once I repeat the install and have it working successfully and I'd happily send that to you if you want to review it and/or supplement your install instructions.
One final question I do have for you is on the patches that are recommended I can get to them, but I'm not clear as to what files they are replacing as running the patch command didn't work (I'm sure I'm doing something wrong, but am unclear what it is and/or if there is something that I should have installed that runs the patch command). Thanks again, all your help has been useful and appreciated (even when I googled your old answers:)
-Chris
My current install guide as well as a FAQ states one must use the cygwin version of rrdtool instead of the win32 one. There is also a sticky at the top of this forum about that.
As for patching, if you don't want to use the cygwin patch tool, then you can download the files in the pre-patched directory and manually replace them. If you want to see what the patch will modify, run it with --dry-run.
As for patching, if you don't want to use the cygwin patch tool, then you can download the files in the pre-patched directory and manually replace them. If you want to see what the patch will modify, run it with --dry-run.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Who is online
Users browsing this forum: No registered users and 2 guests