rrdtool error

baby · Post by **baby** » Fri May 12, 2006 1:43 am

all device cant display graph

1.fedora 5
2.mysql-5.0.18
3.httpd-2.2.0
4. rrdtool-1.2.12
5.php-5.1.2
6. net-snmp-5.3.0.1

thx fix this problem

RRDTool Command:

/usr/local/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Router - CPU Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="/www/htdocs/cacti/rra/router_5min_cpu_10.rrd":5min_cpu:AVERAGE \
AREA:a#FF0000:"CPU Usage" \
GPRINT

LAST:"Current\:%8.0lf" \
GPRINT

AVERAGE:"Average\:%8.0lf" \
GPRINT

MAX:"Maximum\:%8.0lf"
RRDTool Says:

ERROR: opening '/www/htdocs/cacti/rra/router_5min_cpu_10.rrd': No such file or directory

jmadrid2 · Post by **jmadrid2** » Fri May 12, 2006 10:11 am

I would goto Console, then Data Sources and check any Data Source and turn on Debug mode in the top right-hand corner of the screen. Once that is on, i would take the command Cacti is going to execute and do it by hand from a terminal. Just sudo as cactiuser and then run the "rrdtool create" command. See if that gives any errors.

baby · Post by **baby** » Tue May 16, 2006 5:43 am

Data Source Debug

/usr/local/rrdtool/bin/rrdtool create \
/www/htdocs/cacti/rra/cisco_router_5min_cpu_70.rrd \
--step 300 \
DS:5min_cpu:GAUGE:600:0:100 \
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 \

jmadrid2 · Post by **jmadrid2** » Tue May 16, 2006 9:53 am

Goto a terminal and execute that command as the user you have set your cacti to run as. For example, do this. This will manually create the rrd that Cacit didnt create. Once that is done, i would put Cacti on full debug and see if this is running normally.

sudo -u cactiuser /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_5min_cpu_70.rrd --step 300 DS:5min_cpu:GAUGE:600:0:100 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

baby · Post by **baby** » Tue May 16, 2006 9:19 pm

ok....but no data display

RRDTool Command:

/usr/local/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Cisco Router - CPU Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="/www/htdocs/cacti/rra/cisco_router_5min_cpu_70.rrd":5min_cpu:AVERAGE \
AREA:a#FF0000:"CPU Usage" \
GPRINT

LAST:"Current\:%8.0lf" \
GPRINT

AVERAGE:"Average\:%8.0lf" \
GPRINT

MAX:"Maximum\:%8.0lf"
RRDTool Says:

OK

baby · Post by **baby** » Tue May 16, 2006 9:28 pm

ok....but no data display

RRDTool Command:

/usr/local/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Cisco Router - CPU Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="/www/htdocs/cacti/rra/cisco_router_5min_cpu_70.rrd":5min_cpu:AVERAGE \
AREA:a#FF0000:"CPU Usage" \
GPRINT

LAST:"Current\:%8.0lf" \
GPRINT

AVERAGE:"Average\:%8.0lf" \
GPRINT

MAX:"Maximum\:%8.0lf"
RRDTool Says:

OK

Post by **gandalf** » Wed May 17, 2006 10:53 am

Please post a screenshot of the failing page
Reinhard

baby · Post by **baby** » Wed May 17, 2006 8:30 pm

[img]

baby · Post by **baby** » Wed May 17, 2006 8:33 pm

baby · Post by **baby** » Wed May 17, 2006 8:35 pm

Post by **gandalf** » Thu May 18, 2006 9:29 am

Did you enter the crontab command as instructed in cacti's installation docs? See http://www.cacti.net/downloads/docs/htm ... _unix.html. If stil nogo, please switch Settings->logging Level to DEBUG for ONE polling cycle and check ./log/cacti.log for errors.
Reinhard

baby · Post by **baby** » Thu May 18, 2006 10:21 am

1. i set crontab command is */5**** cactiuser /www/php/bin/php /www/htdocs/cacti/poller.php > /dev/null 2>&1

2. i check in .log/cacti.log no error

many thx fix this problem!!

Post by **gandalf** » Thu May 18, 2006 1:15 pm

baby wrote:2. i check in .log/cacti.log no error

No log entry while running in DEBUG mode? You doublen checked permissions?
Then, please run su to cactiuser (or login as cactiuser) and run

Code: Select all

/www/php/bin/php /www/htdocs/cacti/poller.php

Reinhard

baby · Post by **baby** » Mon May 22, 2006 10:48 pm

all graph display to console ,but no data display

run your give me command result
*************************************************************
11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:20.9361 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:124 RRDsProcessed:66')"
05/23/2006 11:04:58 AM - SYSTEM STATS: Time:20.9361 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:124 RRDsProcessed:66
05/23/2006 11:04:58 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_97.rrd --template traffic_out:traffic_in 1148353478:0:0
05/23/2006 11:04:58 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_93.rrd --template traffic_out:traffic_in 1148353478:0:0
05/23/2006 11:04:58 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_79.rrd --template traffic_out:traffic_in 1148353478:3039765736:9623821
05/23/2006 11:04:58 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_89.rrd --template traffic_out:traffic_in 1148353478:0:0
05/23/2006 11:04:58 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_86.rrd --template traffic_out:traffic_in 1148353478:4190936073:1102003870
05/23/2006 11:04:58 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_95.rrd --template traffic_out:traffic_in 1148353478:0:0
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='97' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='79' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='89' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='95' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='97' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='86' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='93' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='93' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='79' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='89' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='86' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='95' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:58 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)"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] Time: 20.2831 s, Theads: N/A, Hosts: 2
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (93,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] Host[3] DS[93] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.23, output: 0
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (86,'traffic_in','2006-05-23 11:04:38','1102003870')"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] Host[3] DS[86] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.16, output: 1102003870
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (95,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] Host[3] DS[95] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.25, output: 0
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (89,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:58 AM - CMDPHP: Poller[0] Host[3] DS[89] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.19, output: 0
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (79,'traffic_in','2006-05-23 11:04:38','9623821')"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] Host[3] DS[79] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.9, output: 9623821
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (97,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] Host[3] DS[97] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.27, output: 0
05/23/2006 11:04:57 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_80.rrd --template traffic_out:traffic_in 1148353478:3035871198:3135179471
05/23/2006 11:04:57 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_71.rrd --template traffic_out:traffic_in 1148353478:1475721880:4150649342
05/23/2006 11:04:57 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_76.rrd --template traffic_out:traffic_in 1148353478:619015167:372663244
05/23/2006 11:04:57 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_84.rrd --template traffic_in:traffic_out 1148353478:2067671003:3096302058
05/23/2006 11:04:57 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_98.rrd --template traffic_in:traffic_out 1148353478:1447865320:1248034
05/23/2006 11:04:57 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_94.rrd --template traffic_in:traffic_out 1148353478:0:0
05/23/2006 11:04:57 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_43.rrd --template traffic_in:traffic_out 1148353478:3531551157:3710516034
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='43' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='76' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='71' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='80' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='98' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='84' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='80' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='94' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='71' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='76' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='84' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='98' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='94' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='43' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:57 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)"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (94,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] Host[3] DS[94] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.24, output: 0
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (98,'traffic_in','2006-05-23 11:04:38','1447865320')"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] Host[3] DS[98] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.28, output: 1447865320
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (84,'traffic_in','2006-05-23 11:04:38','2067671003')"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] Host[3] DS[84] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.14, output: 2067671003
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (80,'traffic_in','2006-05-23 11:04:38','3135179471')"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] Host[3] DS[80] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10, output: 3135179471
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (71,'traffic_in','2006-05-23 11:04:38','4150649342')"
05/23/2006 11:04:57 AM - CMDPHP: Poller[0] Host[3] DS[71] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: 4150649342
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (76,'traffic_in','2006-05-23 11:04:38','372663244')"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] Host[3] DS[76] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.6, output: 372663244
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (43,'traffic_out','2006-05-23 11:04:38','3710516034')"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] Host[3] DS[43] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, output: 3710516034
05/23/2006 11:04:56 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_97.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:56 AM - 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=271"

05/23/2006 11:04:56 AM - 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=270"
05/23/2006 11:04:56 AM - 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=97"
05/23/2006 11:04:56 AM - 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=97 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=97"
05/23/2006 11:04:56 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_98.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:56 AM - 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=273"

05/23/2006 11:04:56 AM - 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=272"
05/23/2006 11:04:56 AM - 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=98"
05/23/2006 11:04:56 AM - 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=98 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=98"
05/23/2006 11:04:56 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_49.rrd --template traffic_in:traffic_out 1148353478:696310254:3927584635
05/23/2006 11:04:56 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_65.rrd --template traffic_out:traffic_in 1148353478:0:0
05/23/2006 11:04:56 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_44.rrd --template traffic_in:traffic_out 1148353478:20508612:1953257072
05/23/2006 11:04:56 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_45.rrd --template traffic_in:traffic_out 1148353478:276254346:626964873
05/23/2006 11:04:56 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_47.rrd --template traffic_in:traffic_out 1148353478:372663244:619016163
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='49' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='47' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='45' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='44' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='49' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='65' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='65' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='44' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='45' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='47' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:56 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)"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (49,'traffic_out','2006-05-23 11:04:38','3927584635')"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] Host[3] DS[49] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.8, output: 3927584635
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (47,'traffic_out','2006-05-23 11:04:38','619016163')"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] Host[3] DS[47] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, output: 619016163
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (45,'traffic_out','2006-05-23 11:04:38','626964873')"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] Host[3] DS[45] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.4, output: 626964873
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (44,'traffic_out','2006-05-23 11:04:38','1953257072')"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] Host[3] DS[44] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, output: 1953257072
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (65,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:56 AM - CMDPHP: Poller[0] Host[3] DS[65] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.24, output: 0
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (98,'traffic_out','2006-05-23 11:04:38','1248034')"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] Host[3] DS[98] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.28, output: 1248034
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (97,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] Host[3] DS[97] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.27, output: 0
05/23/2006 11:04:55 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_92.rrd --template traffic_out:traffic_in N:0:0
05/23/2006 11:04:55 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_92.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:55 AM - 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=261"

05/23/2006 11:04:55 AM - 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=260"
05/23/2006 11:04:55 AM - 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=92"
05/23/2006 11:04:55 AM - 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=92 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=92"
05/23/2006 11:04:55 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_93.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:55 AM - 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=263"

05/23/2006 11:04:55 AM - 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=262"
05/23/2006 11:04:55 AM - 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=93"
05/23/2006 11:04:55 AM - 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=93 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=93"
05/23/2006 11:04:55 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_94.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:55 AM - 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=265"

05/23/2006 11:04:55 AM - 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=264"
05/23/2006 11:04:55 AM - 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=94"
05/23/2006 11:04:55 AM - 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=94 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=94"
05/23/2006 11:04:55 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_95.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:55 AM - 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=267"

05/23/2006 11:04:55 AM - 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=266"
05/23/2006 11:04:55 AM - 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=95"
05/23/2006 11:04:55 AM - 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=95 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=95"
05/23/2006 11:04:55 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_96.rrd --template traffic_in:traffic_out N:0:0
05/23/2006 11:04:55 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_96.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:55 AM - 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=269"

05/23/2006 11:04:55 AM - 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=268"
05/23/2006 11:04:55 AM - 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=96"
05/23/2006 11:04:55 AM - 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=96 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=96"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='96' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='92' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='92' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='96' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:55 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)"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (96,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] Host[3] DS[96] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.26, output: 0
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (96,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] Host[3] DS[96] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.26, output: 0
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (95,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] Host[3] DS[95] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.25, output: 0
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (94,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:55 AM - CMDPHP: Poller[0] Host[3] DS[94] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.24, output: 0
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (93,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] Host[3] DS[93] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.23, output: 0
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (92,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] Host[3] DS[92] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.22, output: 0
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (92,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] Host[3] DS[92] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.22, output: 0
05/23/2006 11:04:54 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_91.rrd --template traffic_out:traffic_in N:0:0
05/23/2006 11:04:54 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_91.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:54 AM - 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=259"

05/23/2006 11:04:54 AM - 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=258"
05/23/2006 11:04:54 AM - 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=91"
05/23/2006 11:04:54 AM - 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=91 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=91"
05/23/2006 11:04:54 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_88.rrd --template traffic_out:traffic_in 1148353478

15585
05/23/2006 11:04:54 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_89.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:54 AM - 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=255"

05/23/2006 11:04:54 AM - 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=254"
05/23/2006 11:04:54 AM - 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=89"
05/23/2006 11:04:54 AM - 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=89 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=89"
05/23/2006 11:04:54 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_90.rrd --template traffic_in:traffic_out N:0:0
05/23/2006 11:04:54 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_90.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:54 AM - 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=257"

05/23/2006 11:04:54 AM - 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=256"
05/23/2006 11:04:54 AM - 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=90"
05/23/2006 11:04:54 AM - 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=90 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=90"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='91' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='91' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='88' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='88' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='90' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='90' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:54 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)"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (91,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] Host[3] DS[91] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.21, output: 0
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (91,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] Host[3] DS[91] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.21, output: 0
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (90,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:54 AM - CMDPHP: Poller[0] Host[3] DS[90] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.20, output: 0
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (90,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] Host[3] DS[90] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.20, output: 0
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (89,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] Host[3] DS[89] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.19, output: 0
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (88,'traffic_out','2006-05-23 11:04:38','14123')"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] Host[3] DS[88] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.18, output: 14123
05/23/2006 11:04:53 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_88.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:53 AM - 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=253"

05/23/2006 11:04:53 AM - 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=252"
05/23/2006 11:04:53 AM - 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=88"
05/23/2006 11:04:53 AM - 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=88 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=88"
05/23/2006 11:04:53 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_84.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:53 AM - 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=245"

05/23/2006 11:04:53 AM - 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=244"
05/23/2006 11:04:53 AM - 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=84"
05/23/2006 11:04:53 AM - 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=84 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=84"
05/23/2006 11:04:53 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_85.rrd --template traffic_in:traffic_out N:0:0
05/23/2006 11:04:53 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_85.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:53 AM - 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=247"

05/23/2006 11:04:53 AM - 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=246"
05/23/2006 11:04:53 AM - 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=85"
05/23/2006 11:04:53 AM - 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=85 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=85"
05/23/2006 11:04:53 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_86.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:53 AM - 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=249"

05/23/2006 11:04:53 AM - 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=248"
05/23/2006 11:04:53 AM - 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=86"
05/23/2006 11:04:53 AM - 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=86 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=86"
05/23/2006 11:04:53 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_87.rrd --template traffic_in:traffic_out N:0:0
05/23/2006 11:04:53 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_87.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:53 AM - 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=251"

05/23/2006 11:04:53 AM - 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=250"
05/23/2006 11:04:53 AM - 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=87"
05/23/2006 11:04:53 AM - 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=87 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=87"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='85' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='85' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='87' and rrd_name='traffic_out' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='87' and rrd_name='traffic_in' and time='2006-05-23 11:04:38'"
05/23/2006 11:04:53 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)"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (88,'traffic_in','2006-05-23 11:04:38','15585')"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] Host[3] DS[88] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.18, output: 15585
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (87,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:53 AM - CMDPHP: Poller[0] Host[3] DS[87] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.17, output: 0
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (87,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] Host[3] DS[87] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.17, output: 0
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (86,'traffic_out','2006-05-23 11:04:38','4190936073')"
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] Host[3] DS[86] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.16, output: 4190936073
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (85,'traffic_in','2006-05-23 11:04:38','0')"
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] Host[3] DS[85] SNMP: v1: 10.2.25.228, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.15, output: 0
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (85,'traffic_out','2006-05-23 11:04:38','0')"
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] Host[3] DS[85] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.15, output: 0
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (84,'traffic_out','2006-05-23 11:04:38','3096302058')"
05/23/2006 11:04:52 AM - CMDPHP: Poller[0] Host[3] DS[84] SNMP: v1: 10.2.25.228, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.14, output: 3096302058
05/23/2006 11:04:52 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_80.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:52 AM - 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=237"

05/23/2006 11:04:52 AM - 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=236"
05/23/2006 11:04:52 AM - 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=80"
05/23/2006 11:04:52 AM - 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=80 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:52 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=80"
05/23/2006 11:04:52 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_81.rrd --template traffic_in:traffic_out N:1281919182:3228103162
05/23/2006 11:04:52 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_81.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:52 AM - 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=239"

05/23/2006 11:04:52 AM - 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=238"
05/23/2006 11:04:52 AM - 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=81"
05/23/2006 11:04:52 AM - 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=81 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"

05/23/2006 11:04:52 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=81"
05/23/2006 11:04:52 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /www/htdocs/cacti/rra/cisco_router_traffic_in_82.rrd --template traffic_in:traffic_out N:25509478:509612465
05/23/2006 11:04:52 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool create /www/htdocs/cacti/rra/cisco_router_traffic_in_82.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 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

05/23/2006 11:04:52 AM - 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=241"

05/23/2006 11:04:52 AM - 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=240"
05/23/2006 11:04:52 AM - 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_maxim

Post by **gandalf** » Tue May 23, 2006 5:38 am

There are some rrdtool create statements in your log. Please check, whether the files were generated and post your findings
Reinhard

rrdtool error

rrdtool error

Who is online