Problem 0.8.8 - CSV export graph has AREA item using CDEF

[HongHa]

Hi all,

I just upgrade Cacti 0.8.7g => 0.8.8, and I have a problem with CSV export with the graph have AREA item using CDEF.
When I change AREA => COMMENT, CSV export normally.

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=1334722139 \
--end=1334736539 \
--title="Test Server 2 - HTTP Response Time - Code" \
--base=1000 \
--height=120 \
--width=680 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2012/04/18 11\:08\:59 To 2012/04/18 15\:08\:59\c" \
COMMENT:" \n" \
--vertical-label="milliseconds" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/36/170.rrd":"avg":AVERAGE \
DEF:b="C\:/Apache2/htdocs/cacti/rra/36/170.rrd":"code":AVERAGE \
CDEF:cdefb="b,199,GT,b,299,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefc="b,299,GT,b,399,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefd="b,399,GT,b,499,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefe="b,499,GT,b,599,GT,UNKN,a,IF,UNKN,IF" \
COMMENT:" Code Legend\:" \
COMMENT:"2xx Successful " \
COMMENT:"3xx Redirection " \
COMMENT:"4xx Client Error " \
COMMENT:"5xx Server Error\n" \
COMMENT:"Status Code\:" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINTAVERAGE:" Average\:%8.0lf" \
GPRINTMAX:" Maximum\:%8.0lf\n" \
LINE1:a#0000FFFF:"Resp. Time\:" \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s" \

graph_xport.php?local_graph_id=150&rra_id=5&view_type=&graph_start=1334722163&graph_end=1334736563
=> Graph export OK

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=1334722207 \
--end=1334736607 \
--title="Test Server 2 - HTTP Response Time - Code" \
--base=1000 \
--height=120 \
--width=680 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2012/04/18 11\:10\:07 To 2012/04/18 15\:10\:07\c" \
COMMENT:" \n" \
--vertical-label="milliseconds" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/36/170.rrd":"avg":AVERAGE \
DEF:b="C\:/Apache2/htdocs/cacti/rra/36/170.rrd":"code":AVERAGE \
CDEF:cdefb="b,199,GT,b,299,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefc="b,299,GT,b,399,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefd="b,399,GT,b,499,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefe="b,499,GT,b,599,GT,UNKN,a,IF,UNKN,IF" \
COMMENT:" Code Legend\:" \
AREA:cdefb#7EE600FF:"2xx Successful " \
AREA:cdefc#FFF200FF:"3xx Redirection " \
AREA:cdefd#FFAB00FF:"4xx Client Error " \
AREA:cdefe#FF0000FF:"5xx Server Error\n" \
COMMENT:"Status Code\:" \
GPRINTLAST:" Current\:%8.0lf" \
GPRINTAVERAGE:" Average\:%8.0lf" \
GPRINTMAX:" Maximum\:%8.0lf\n" \
LINE1:a#0000FFFF:"Resp. Time\:" \
GPRINTLAST:" Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s" \

graph_xport.php?local_graph_id=150&rra_id=5&view_type=&graph_start=1334722241&graph_end=1334736641
=> Graph export no data, just have below rows

Title: Test Server 2 - HTTP Response Time - Code""
Vertical Label: milliseconds""
Start Date: 01-01-70 7:00
End Date: 01-01-70 7:00
Step:
Total Rows:
Graph ID: 150
Host ID: 36

Date


Does anyone know what's the problem?

Thanks all,
Best regards,
HongHa

PS: Here is my system information
Date Wed, 18 Apr 2012 15:50:02 +0700
Cacti Version 0.8.8
Cacti OS win32
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.2.x
Poller Information
Interval 60
Type cmd.php
PHP Version 5.2.14
PHP OS WINNT
PHP uname Windows NT C91D6A87 5.2 build 3790
OS: WIndows 2003 R2

[gandalf]

Are you sure this was working in 087g?
R.

[HongHa]

Hi gandalf

In 0.8.7g I can using CSV export data. Last time I use it to compare data between RRDtool update and CSV Export (http://forums.cacti.net/viewtopic.php?f=3&t=47041)

After upgrade to 0.8.8, I can not export so I think that maybe I just edit wrong somewhere in my template, so I chose another template (can using CSV export) using Area Item without CDEF to test again. After edit this template with Item Area using CDEF, it can not export data using CSV export like the other template having Area item with CDEF.

If I just using AREA no CDEF, I can use CSV export normally.

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=1334724369 \
--end=1334738769 \
--title="Test Server 2 - HTTP Response Time - Code" \
--base=1000 \
--height=120 \
--width=680 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2012/04/18 11\:46\:09 To 2012/04/18 15\:46\:09\c" \
COMMENT:" \n" \
--vertical-label="milliseconds" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/36/170.rrd":"avg":AVERAGE \
DEF:b="C\:/Apache2/htdocs/cacti/rra/36/170.rrd":"code":AVERAGE \
CDEF:cdefb="b,199,GT,b,299,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefc="b,299,GT,b,399,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefd="b,399,GT,b,499,GT,UNKN,a,IF,UNKN,IF" \
CDEF:cdefe="b,499,GT,b,599,GT,UNKN,a,IF,UNKN,IF" \
COMMENT:" Code Legend\:" \
COMMENT:"2xx Successful " \
COMMENT:"3xx Redirection " \
COMMENT:"4xx Client Error " \
COMMENT:"5xx Server Error\n" \
AREA:b#F5F800FF:"Status Code\:" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINTAVERAGE:" Average\:%8.0lf" \
GPRINTMAX:" Maximum\:%8.0lf\n" \
LINE1:a#0000FFFF:"Resp. Time\:" \
GPRINTLAST:" Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s" \

Thank & best regards,
Hong Ha

[HongHa]

Hi gandalf

Actually after upgrade to 0.8.8 I have a problem with graph, it can not be displayed due to "invalid rpn expression"
I have change lib/rrd.php as you said in topic http://forums.cacti.net/viewtopic.php?f=21&t=46971 and graphs are showed.
Now I have problem with CSV export.

Thanks for your reply,
Best regards,
HongHa

[gandalf]

Well, there is an additional issue in the function performing the export.
So please download latest lib/rrd.php from http://svn.cacti.net. This has the fix for xport as well.
We will package those fixes as 088a soon.
R.

[HongHa]

Hi gandalf

After I downloaded file rrd.php in this link http://svn.cacti.net/viewvc/cacti/branc ... ision=7110 and overwrite the old file, graph can not displayed. When I Turn On Graph Debug Mode, RRDTool Command says nothing.

Thank & Best reagards,
HongHa

[gandalf]

Any errors in either cacti.log or httpd's error log?
R.

[HongHa]

Hi gandalf,

In debug mode, There are no errors log in CLOG.
I don't know how to get httpd's log, so I can't show this for you.

Regards,
HongHa

[gandalf]

I had a type: I meant log/cacti.log
The other log may be located at /var/log/httpd/error_log
R.

[HongHa]

Hi gandalf,

I just check again, there only Cacti log in C:\Apache2\htdocs\cacti\log.
And in Clog, there are no Message Type Errors.

Brgs/HongHa