No Graphs..

[thechancer]

Poller seems to be running, and returns the right info as below :
10/26/2011 10:09:01 PM - SYSTEM STATS: Time:1.4980 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:7 RRDsProcessed:7
10/26/2011 10:09:01 PM - POLLER: Poller[0] CACTI2RRD: c:/spine/rrdtool.exe update G:\\webroot\\cacti\\rra\\router_up_snr_16.rrd --template up_snr 1319630941:80
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Time: 0.0497 s, Theads: N/A, Hosts: 2
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] DS[16] SNMP: v2: 192.168.2.1, dsname: up_snr, oid: .1.3.6.1.2.1.10.94.1.1.2.1.4.11, output: 80
10/26/2011 10:09:01 PM - POLLER: Poller[0] CACTI2RRD: c:/spine/rrdtool.exe update G:\\webroot\\cacti\\rra\\router_down_snr_15.rrd --template down_snr 1319630941:200
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] DS[15] SNMP: v2: 192.168.2.1, dsname: down_snr, oid: .1.3.6.1.2.1.10.94.1.1.3.1.4.11, output: 200
10/26/2011 10:09:01 PM - POLLER: Poller[0] CACTI2RRD: c:/spine/rrdtool.exe update G:\\webroot\\cacti\\rra\\router_up_att_12.rrd --template up_att 1319630941:315
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] DS[12] SNMP: v2: 192.168.2.1, dsname: up_att, oid: .1.3.6.1.2.1.10.94.1.1.2.1.5.11, output: 315
10/26/2011 10:09:01 PM - POLLER: Poller[0] CACTI2RRD: c:/spine/rrdtool.exe update G:\\webroot\\cacti\\rra\\router_down_att_11.rrd --template down_att 1319630941:535
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] DS[11] SNMP: v2: 192.168.2.1, dsname: down_att, oid: .1.3.6.1.2.1.10.94.1.1.3.1.5.11, output: 535
10/26/2011 10:09:01 PM - POLLER: Poller[0] CACTI2RRD: c:/spine/rrdtool.exe update G:\\webroot\\cacti\\rra\\router_5min_cpu_10.rrd --template 5min_cpu 1319630941:2
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] DS[10] SNMP: v2: 192.168.2.1, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, output: 2
10/26/2011 10:09:01 PM - POLLER: Poller[0] CACTI2RRD: c:/spine/rrdtool.exe update G:\\webroot\\cacti\\rra\\router_down_speed_13.rrd --template down_speed 1319630941:1536000
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] DS[13] SNMP: v2: 192.168.2.1, dsname: down_speed, oid: .1.3.6.1.2.1.10.94.1.1.4.1.2.11, output: 1536000
10/26/2011 10:09:01 PM - POLLER: Poller[0] CACTI2RRD: c:/spine/rrdtool.exe update G:\\webroot\\cacti\\rra\\router_up_speed_14.rrd --template up_speed 1319630941:256000
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] DS[14] SNMP: v2: 192.168.2.1, dsname: up_speed, oid: .1.3.6.1.2.1.10.94.1.1.5.1.2.11, output: 256000
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] RECACHE DQ[1] OID: .1.3.6.1.2.1.1.3.0, output: 824107
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] RECACHE DQ[1] OID: .1.3.6.1.2.1.1.3.0
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] RECACHE: Processing 1 items in the auto reindex cache for \'192.168.2.1\'.
10/26/2011 10:09:01 PM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
10/26/2011 10:09:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q \"g:/webroot/cacti/cmd.php\" 0 3]

Yet no graphs appear. If I try to run the http://192.168.2.9/cacti/graph_image.ph ... 7&rra_id=1 manually I get "cannot be displayed because it contains errors".

Any ideas / pointers ?

[thechancer]

The Poller Output table I am assuming should have some data - but I'm not seeing any in there - by db connection details have been checked, yet I don't see a mysql insert or update in the log... I'm going to assume this is it, but don't know how to resolve.. any pointers ?

[BSOD2600]

What cacti version?

It appears the poller is collecting data, as the rrdtool update commands contain valid numbers.

You sure the ntfs permissions on G:\\webroot\\cacti\\rra\ allow the cacti scheduled task user to modify files?

[thechancer]

version is 0.8.7h - all other version info is in the tech info.txt attachment.

I have set (for testing) EVERYONE to have full read/write access over the whole cacti folder, and no specific deny set either - so unlikely to be that.

[BSOD2600]

Well cacti appears to be collecting data, so the problem lays with rrdtool. double-check the rra folder has the correct NTFS permissions and a rrd file or two. What rrdtool version you using?

[thechancer]

rrdtool is 1.2.x

I have removed the .rrd files and they are created again in the next polling cycle, and all are 46kb - is this about right ?

In firefox I get the message that the image contains errors, yet in IE I just get the red X.

If I remove the header type from the graph_image.php file I do get what seems to be a proper PNG, but thrown out in text as expected - so it seems as though it is trying..

If I run this command - I do get a response from the RRD..

C:\cacti>rrdtool fetch g:\webroot\cacti\rra\router_down_speed_13.rrd AVERAGE --s
tart 1319747000 --end 1319747933
down_speed

1319747100: -1.#IND000000e+000
1319747400: -1.#IND000000e+000
1319747700: -1.#IND000000e+000
1319748000: 1.5360000000e+006

Although I've yet to get it to create a graph - will update later when I manage it...

[thechancer]

Still no graphs, however - from the graph management - debug - I got this :

RRDTool Command:

c:/cacti/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Router - Line Speed" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="G\:/webroot/cacti/rra/router_up_speed_14.rrd":up_speed:AVERAGE \
DEF:b="G\:/webroot/cacti/rra/router_down_speed_13.rrd":down_speed:AVERAGE \
AREA:a#00BED9FF:"Upstream Speed" \
GPRINTLAST:" Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n" \
LINE2:b#F51D30FF:"Downstream Speed" \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s"

RRDTool Says:

OK

And turned it into the normal command to run for RRD and run as the local server admin... yet the response wasn't OK as RRDTool says through CACTI...

C:\cacti>c:/cacti/rrdtool.exe graph --imgformat=PNG --start=-86400 --end=-300 --
title="Router - Line Speed" --rigid --base=1000 --height=120 --width=500 --alt-a
utoscale-max --lower-limit=0 --vertical-label="bits per second" --slope-mode --f
ont TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="G:/webroot/c
acti/rra/router_up_speed_14.rrd":up_speed:AVERAGE DEF:b="G:/webroot/cacti/rra/ro
uter_down_speed_13.rrd":down_speed:AVERAGE AREA:a#00BED9FF:"Upstream Speed" GPR
INTLAST:" Current:%8.2lf %s" GPRINTAVERAGE:"Average:%8.2lf %s" GPRINT
MAX:"Maximum:%8.2lf %s\n" LINE2:b#F51D30FF:"Downstream Speed" GPRINTLAST:"Cur
rent:%8.2lf %s" GPRINTAVERAGE:"Average:%8.2lf %s" GPRINTMAX:"Maximum:%8.2l
f %s"

ERROR: Cannot parse DS in 'DEF:b=G:/webroot/cacti/rra/router_down_speed_13.rrd:d
own_speed:AVERAGE'

As the rrd is created by the use of CACTI - can anyone shed any light on why RRDtool would be unable to parse the datasource ?

[BSOD2600]

This must be a custom template as cacti doesn't separate up and down speeds into their own rrd file. Possible problem #1.

run rrdtool info on router_up_speed_14.rrd and router_down_speed_13.rrd. Do they have DS for up_speed and down_speed?

[thechancer]

It is a custom template - from http://www.alcatron.net/?p=42 - had to amend slightly as my OID's were a little different, but am now getting the right info back.

Anyway - the unable to parse DS, was due to the unescaped : in the filepath - so I changed it to the below - and then got another error..

Code: Select all

C:\cacti>c:/cacti/rrdtool.exe graph --imgformat=PNG --start=-86400 --end=-300 --
title="Router - Line Speed" --rigid --base=1000 --height=120 --width=500 --alt-a
utoscale-max --lower-limit=0 --vertical-label="bits per second" --slope-mode --f
ont TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="G\:/webroot/
cacti/rra/router_up_speed_14.rrd":up_speed:AVERAGE DEF:b="G\:/webroot/cacti/rra/
router_down_speed_13.rrd":down_speed:AVERAGE AREA:a#00BED9FF:"Upstream Speed"  G
PRINT:a:LAST:"  Current:%8.2lf %s" GPRINT:a:AVERAGE:"Average:%8.2lf %s"  GPRINT:
a:MAX:"Maximum:%8.2lf %s\n" LINE2:b#F51D30FF:"Downstream Speed" GPRINT:b:LAST:"C
urrent:%8.2lf %s" GPRINT:b:AVERAGE:"Average:%8.2lf %s" GPRINT:b:MAX:"Maximum:%8.
2lf %s" 

ERROR: parameter 'a' does not represent a number in line AREA:a#00BED9FF:Upstrea
m Speed

For completeness - This is the reult of the rrdtool info..

Code: Select all

C:\cacti>rrdtool info g:\webroot\cacti\rra\router_up_speed_14.rrd
filename = "g:\webroot\cacti\rra\router_up_speed_14.rrd"
rrd_version = "0003"
step = 300
last_update = 1319839141
ds[up_speed].type = "GAUGE"
ds[up_speed].minimal_heartbeat = 600
ds[up_speed].min = 0.0000000000e+000
ds[up_speed].max = NaN
ds[up_speed].last_ds = "256000"
ds[up_speed].value = 6.1696000000e+007
ds[up_speed].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 600
rra[0].cur_row = 109
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-001
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[1].cf = "AVERAGE"
rra[1].rows = 700
rra[1].cur_row = 236
rra[1].pdp_per_row = 6
rra[1].xff = 5.0000000000e-001
rra[1].cdp_prep[0].value = 1.2800000000e+006
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[2].cf = "AVERAGE"
rra[2].rows = 775
rra[2].cur_row = 259
rra[2].pdp_per_row = 24
rra[2].xff = 5.0000000000e-001
rra[2].cdp_prep[0].value = 5.8880000000e+006
rra[2].cdp_prep[0].unknown_datapoints = 0
rra[3].cf = "AVERAGE"
rra[3].rows = 797
rra[3].cur_row = 344
rra[3].pdp_per_row = 288
rra[3].xff = 5.0000000000e-001
rra[3].cdp_prep[0].value = 6.7328000000e+007
rra[3].cdp_prep[0].unknown_datapoints = 0
rra[4].cf = "MAX"
rra[4].rows = 600
rra[4].cur_row = 289
rra[4].pdp_per_row = 1
rra[4].xff = 5.0000000000e-001
rra[4].cdp_prep[0].value = NaN
rra[4].cdp_prep[0].unknown_datapoints = 0
rra[5].cf = "MAX"
rra[5].rows = 700
rra[5].cur_row = 564
rra[5].pdp_per_row = 6
rra[5].xff = 5.0000000000e-001
rra[5].cdp_prep[0].value = 2.5600000000e+005
rra[5].cdp_prep[0].unknown_datapoints = 0
rra[6].cf = "MAX"
rra[6].rows = 775
rra[6].cur_row = 225
rra[6].pdp_per_row = 24
rra[6].xff = 5.0000000000e-001
rra[6].cdp_prep[0].value = 2.5600000000e+005
rra[6].cdp_prep[0].unknown_datapoints = 0
rra[7].cf = "MAX"
rra[7].rows = 797
rra[7].cur_row = 157
rra[7].pdp_per_row = 288
rra[7].xff = 5.0000000000e-001
rra[7].cdp_prep[0].value = 2.5600000000e+005
rra[7].cdp_prep[0].unknown_datapoints = 0

I have attached the host xml template that I have just exported from my install as well if that may help...

Thanks for your continued help - it is much appreciated.

[thechancer]

I now have a graph... But not through Cacti...

It turns out the a error was due to their not being an outpout specified - so I placed the image name in, then it gave further errors, which were due to the colon not being escaped in the legend...

So this :

Code: Select all

c:/cacti/rrdtool.exe graph img.png --imgformat=PNG --start=-86400 --end=-300 --title="Router - Line Speed" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="bits per second" --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="G\:/webroot/cacti/rra/router_up_speed_14.rrd":up_speed:AVERAGE DEF:b="G\:/webroot/cacti/rra/router_down_speed_13.rrd":down_speed:AVERAGE AREA:a#00BED9FF:"Upstream Speed"  GPRINT:a:LAST:"  Current\:%8.2lf %s" GPRINT:a:AVERAGE:"Average\:%8.2lf %s"  GPRINT:a:MAX:"Maximum\:%8.2lf %s" LINE2:b#F51D30FF:"Downstream Speed" GPRINT:b:LAST:"Current\:%8.2lf %s" GPRINT:b:AVERAGE:"Average\:%8.2lf %s" GPRINT:b:MAX:"Maximum\:%8.2lf %s"

Now works, which proves the rrd files are corrrect, yet I still can't get Cacti to display the graphs...

I've removed the colons from the template (So Current: is now just Current etc...) but still no dice.

Code: Select all

c:/cacti/rrdtool.exe graph - \
--imgformat=PNG \
--start=1319801057 \
--end=1319887457 \
--title="Router - Line Speed" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2011/10/28 21\:24\:17 To 2011/10/29 21\:24\:17\c" \
COMMENT:"  \n" \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="G\:/webroot/cacti/rra/router_down_speed_13.rrd":down_speed:AVERAGE \
DEF:b="G\:/webroot/cacti/rra/router_up_speed_14.rrd":up_speed:AVERAGE \
LINE2:a#F51D30FF:"Downstream Speed"  \
GPRINT:a:LAST:"Current%8.2lf %s"  \
GPRINT:a:AVERAGE:"Average%8.2lf %s"  \
GPRINT:a:MAX:"Maximum%8.2lf %s"  \
AREA:b#00BED9FF:"Upstream Speed"  \
GPRINT:b:LAST:"  Current%8.2lf %s"  \
GPRINT:b:AVERAGE:"Average%8.2lf %s"  \
GPRINT:b:MAX:"Maximum%8.2lf %s\n" 

That is what Cacti returns, and works when the img.png it is set as the output when run from the command line - but still nothing from Cacti...

I've attached the img.png from the command line example (no comments on the crappy line speed ) as well as the corresponding .rrd files

[TheWitness]

You have to insure that the correct version of RRDtool is selected from Console->Settings->General.

TheWitness

[thechancer]

The rrdtool version is selected as 1.2.x - as reported from the technical information page. I downloaded the 1.2.30 from http://oss.oetiker.ch/rrdtool/pub/rrdto ... erl510.zip

[TheWitness]

Use firefox, install firebug, view a graph, activate firebug, goto the network tab, open the URI that includes 'graph_image.php' goto the response sub-tab and let us know what you find. Likely there is a PHP warning that is polluting the image as it's returned by the server.

If PHP is set to 'display_errors=Off' and you restart Apache/IIS, the problem may also go away.

TheWitness

[thechancer]

I set display_errors to off, and installed firebug (had to install the 1.9 alpha as no other works with firefox 7.0.1)

Responses don't give much (now I have found them...) no PHP errors anyway just that the image is corrupt or truncated.

One test I have done before and just done again was to remove the page headers from the graph PHP page, so I got the image almost as text thrown to the browser, and there are no spurious characters or errors thrown out before the image starts.

[thechancer]

Some more information...

rrd.php file :

Added the following :

Code: Select all

      $test = "graph $graph_opts$graph_defs$txt_graph_items";
      $test = str_replace("\\\n", " ", $test);      
      echo "rrdtool_execute($test, false, $output_flag, $rrdtool_pipe)";

Before the return rrdtool_execute line, and remove the image header from graph_image.php file to ensure output to the browser.

This gave the following :

Code: Select all

rrdtool_execute(graph - --imgformat=PNG --start=1319633523 --end=1319892539 --title="Router - Line Attenuation" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2011/10/26 22\:52\:03 To 2011/10/29 22\:48\:59\c" COMMENT:" \n" --vertical-label="decibels" --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="G\:/webroot/cacti/rra/router_up_att_12.rrd":up_att:AVERAGE DEF:b="G\:/webroot/cacti/rra/router_down_att_11.rrd":down_att:AVERAGE CDEF:cdefa=a,10,/ CDEF:cdefe=b,10,/ AREA:cdefa#96E78AFF:"Upstream Att." GPRINT:cdefa:LAST:" Current\:%8.2lf %s" GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" LINE2:cdefe#A150AAFF:"Downstream Att." GPRINT:cdefe:LAST:"Current\:%8.2lf %s" GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s" , false, 3, )

Replaced the initial - with an image name, removed false and 3 from the end which gave :

Code: Select all

C:\cacti>c:\cacti\rrdtool.exe graph img2.png --imgformat=PNG --start=1319633523
--end=1319892539 --title="Router - Line Attenuation" --rigid --base=1000 --heigh
t=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2011/10/26 2
2\:52\:03 To 2011/10/29 22\:48\:59\c" COMMENT:" \n" --vertical-label="decibels"
--slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF
:a="G\:/webroot/cacti/rra/router_up_att_12.rrd":up_att:AVERAGE DEF:b="G\:/webroo
t/cacti/rra/router_down_att_11.rrd":down_att:AVERAGE CDEF:cdefa=a,10,/ CDEF:cdef
e=b,10,/ AREA:cdefa#96E78AFF:"Upstream Att." GPRINT:cdefa:LAST:" Current\:%8.2lf
 %s" GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf
 %s\n" LINE2:cdefe#A150AAFF:"Downstream Att." GPRINT:cdefe:LAST:"Current\:%8.2lf
 %s" GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefe:MAX:"Maximum\:%8.2lf
 %s"

And the image was created... so as far as the creation stage goes of the image the call to rrdtool_function_graph is OK. The only stage left now is the rrdtool_execute() to debug and test...

One query I do have is how missing the $rrtool_pipe variable, and only have the (.... false, 3,) and finishing with the trailing comma would affect the execute command... may be an easy answer for one of the developers...