Graph draw Wrong value - Cacti 0.8.7g windows 2003 R2

[HongHa]

Dear all,

I'm a new guy using cacti. I just install Cacti 0.8.7g using packet Cacti-0.8.7g_1.95 from Mr.BSOD2600, and Cacti works fine. I like it!
Here is my Cacti information
Operating System: Windows server 2003 R2
Cacti Version 0.8.7g
Cacti OS win32
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.2.x
PHP Version 5.2.14
PHP OS WINNT
PHP uname Windows NT C91D6A87 5.2 build 3790
Apache Version Apache/2.2.16 (Win32) PHP/5.2.14

After that I writing a Perl script to get the HTTP response time and HTTP status code, and draw the graph.

There is an issue, between the transition graph draw wrong value although Poller return correct value and rrdtool update correct value. But the value on graph is wrong.


Pink line is the HTTP status code. In circle it has wrong value, HTTP status code should be 200 instead of 211.9.

Following is the log I captured

Clog: Poller return correct result
04/16/2012 05:35:07 PM - CMDPHP: Poller[0] Host[35] Description[Test Server] DS[167] Graphs['Test Server - HTTP Response Time 3'] CMD: perl C:/Apache2/htdocs/cacti/scripts/http_response_time6.pl m.youtube.com , output: success:1 time:473.51 code:200
04/16/2012 05:34:08 PM - CMDPHP: Poller[0] Host[35] Description[Test Server] DS[167] Graphs['Test Server - HTTP Response Time 3'] CMD: perl C:/Apache2/htdocs/cacti/scripts/http_response_time6.pl m.youtube.com , output: success:1 time:859.38 code:200
04/16/2012 05:33:08 PM - CMDPHP: Poller[0] Host[35] Description[Test Server] DS[167] Graphs['Test Server - HTTP Response Time 3'] CMD: perl C:/Apache2/htdocs/cacti/scripts/http_response_time6.pl m.youtube.com , output: success:1 time:609.38 code:200
04/16/2012 05:32:07 PM - CMDPHP: Poller[0] Host[35] Description[Test Server] DS[167] Graphs['Test Server - HTTP Response Time 3'] CMD: perl C:/Apache2/htdocs/cacti/scripts/http_response_time6.pl m.mobistore.vn , output: success:1 time:69.92 code:302
04/16/2012 05:31:07 PM - CMDPHP: Poller[0] Host[35] Description[Test Server] DS[167] Graphs['Test Server - HTTP Response Time 3'] CMD: perl C:/Apache2/htdocs/cacti/scripts/http_response_time6.pl m.mobistore.vn , output: success:1 time:95.05 code:302
04/16/2012 05:30:08 PM - CMDPHP: Poller[0] Host[35] Description[Test Server] DS[167] Graphs['Test Server - HTTP Response Time 3'] CMD: perl C:/Apache2/htdocs/cacti/scripts/http_response_time6.pl m.mobistore.vn , output: success:1 time:180.91 code:302

Clog: rrd update correct value
04/16/2012 05:35:09 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\Apache2\htdocs\cacti\rra\35\167.rrd --template success:time:code 1334568907:1:473.51:200
04/16/2012 05:34:10 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\Apache2\htdocs\cacti\rra\35\167.rrd --template success:time:code 1334568847:1:859.38:200
04/16/2012 05:33:10 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\Apache2\htdocs\cacti\rra\35\167.rrd --template success:time:code 1334568787:1:609.38:200
04/16/2012 05:32:08 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\Apache2\htdocs\cacti\rra\35\167.rrd --template success:time:code 1334568727:1:69.92:302
04/16/2012 05:31:09 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\Apache2\htdocs\cacti\rra\35\167.rrd --template success:time:code 1334568667:1:95.05:302
04/16/2012 05:30:09 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\Apache2\htdocs\cacti\rra\35\167.rrd --template success:time:code 1334568607:1:180.91:302

Graph xport wrong value (@ time 17:33:00)
Date,"Code 2xx","Code 3xx","Code 4xx","Code 5xx","No Resp.","Unreach.","Resp.Time","Resp.Code","col9-c"
2012-04-16 17:35:00,"5.1852816667e+002","NaN","NaN","NaN","0.0000000000e+000","NaN","5.1852816667e+002","2.0000000000e+002","5.1852816667e+002"
2012-04-16 17:34:00,"8.3021333333e+002","NaN","NaN","NaN","0.0000000000e+000","NaN","8.3021333333e+002","2.0000000000e+002","8.3021333333e+002"
2012-04-16 17:33:00,"5.4644300000e+002","NaN","NaN","NaN","0.0000000000e+000","NaN","5.4644300000e+002","2.1190000000e+002","5.4644300000e+002"
2012-04-16 17:32:00,"NaN","7.2851833333e+001","NaN","NaN","0.0000000000e+000","NaN","7.2851833333e+001","3.0200000000e+002","7.2851833333e+001"
2012-04-16 17:31:00,"NaN","1.0506700000e+002","NaN","NaN","0.0000000000e+000","NaN","1.0506700000e+002","3.0200000000e+002","1.0506700000e+002"
2012-04-16 17:30:00,"NaN","1.5683400000e+002","NaN","NaN","0.0000000000e+000","NaN","1.568340

Correct value shoult be 200 instead of 211.9 (I dont know where this value from).
04/16/2012 05:33:08 PM - CMDPHP: Poller[0] Host[35] Description[Test Server] DS[167] Graphs['Test Server - HTTP Response Time 3'] CMD: perl C:/Apache2/htdocs/cacti/scripts/http_response_time6.pl m.youtube.com , output: success:1 time:609.38 code:200
04/16/2012 05:33:10 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\Apache2\htdocs\cacti\rra\35\167.rrd --template success:time:code 1334568787:1:609.38:200
17:33:00,"5.4644300000e+002","NaN","NaN","NaN","0.0000000000e+000","NaN","5.4644300000e+002","2.1190000000e+002","5.4644300000e+002"

Futhermore, when I compare the response time in graph xport with Poller result and rrdtool update value, the values from Poller and rrdtool update are the same, however these do not match with value from graph xport. For example response time return is 473.51 ms but graph displays 518.52 ms.
04/16/2012 05:35:07 PM - CMDPHP: Poller[0] Host[35] Description[Test Server] DS[167] Graphs['Test Server - HTTP Response Time 3'] CMD: perl C:/Apache2/htdocs/cacti/scripts/http_response_time6.pl m.youtube.com , output: success:1 time:473.51 code:200
04/16/2012 05:35:09 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\Apache2\htdocs\cacti\rra\35\167.rrd --template success:time:code 1334568907:1:473.51:200
17:35:00,"5.1852816667e+002","NaN","NaN","NaN","0.0000000000e+000","NaN","5.1852816667e+002","2.0000000000e+002","5.1852816667e+002"

in Data Input Method, I set the Data Source Type is Gause for HTTP response time and status code

Here is the graph source
C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=1334567538 \
C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=1334568362 \
--end=1334568959 \
--title="Test Server - HTTP Response Time 3" \
--base=1000 \
--height=120 \
--width=680 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2012/04/16 17\:26\:02 To 2012/04/16 17\:35\:59\c" \
COMMENT:" \n" \
--vertical-label="ms" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/35/167.rrd":code:AVERAGE \
DEF:b="C\:/Apache2/htdocs/cacti/rra/35/167.rrd":success:AVERAGE \
DEF:c="C\:/Apache2/htdocs/cacti/rra/35/167.rrd":time:AVERAGE \
CDEF:cdefb=a,199,GT,a,299,GT,UNKN,c,IF,UNKN,IF \
CDEF:cdefc=a,299,GT,a,399,GT,UNKN,c,IF,UNKN,IF \
CDEF:cdefd=a,399,GT,a,499,GT,UNKN,c,IF,UNKN,IF \
CDEF:cdefe=a,499,GT,a,599,GT,UNKN,c,IF,UNKN,IF \
CDEF:cdeff=b,0,INF,IF \
CDEF:cdefg=b,UNKN,UNKN,IF \
CDEF:cdefbd=b,100,* \
COMMENT:"Legend\: " \
AREA:cdefb#7EE600FF:"Code 2xx" \
AREA:cdefc#FFF200FF:"Code 3xx" \
AREA:cdefd#FFAB00FF:"Code 4xx" \
AREA:cdefe#FF0000FF:"Code 5xx" \
AREA:cdeff#8D00BAFF:"No Resp." \
AREA:cdefg#FFFFFFFF:"Unreach.\n" \
LINE1:c#FF0000FF:"Resp.Time" \
GPRINT:c:LAST:"Current\:%8.0lf" \
GPRINT:c:AVERAGE:"Average \:%8.0lf" \
GPRINT:c:MAX:"Max \:%8.0lf\n" \
LINE1:a#FF00FFFF:"Resp.Code" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINT:cdefbd:AVERAGE:" Succ.Rate\: %6.2lf%%" \
COMMENT:" Site\: m.youtube.com\n" \
LINE1:c#005199FF:""

I'm wrong in setting somewhere ?
Please help me on this issue!

Thank all,
HongHa

[BSOD2600]

1) You do realize cacti 0.8.8 is the latest now, right? were did you get that old installer from? It's outdated by a LOT.

2) rrdtool is functioning as expected, as it averages data out over time. Read http://docs.cacti.net/manual:087:8_rrdt ... solidation and/or the rrdtool manual for the details.

[HongHa]

Hi BSOD2600,

I just installed Cacti 0.87g in March, after that I upgrade to 0.87i. It work fine until 26 March (day changing daylight time), graph not display. I try to reinstall 0.8.7g then upgrade to 0.8.7i or install 0.8.7i using your packet, but it's still not work normally so that I return to Cacti 0.8.7g. I will try to upgrade from 0.8.7g to 0.8.8.

I will read the rrdtool manual to know how it make the graph.

Thank for your reply.
HongHa

[HongHa]

Hi BSOD2600 and all

I Just copy cacti folder 0.8.8 overwrite to cacti 0.8.7g.
And it have problem with graph, it can not be displayed due to "invalid rpn expression"
I have change lib/rrd.php as gandalf said in topic http://forums.cacti.net/viewtopic.php?f=21&t=46971
and graphs are showed. However the graphs is blank since the time I upgrade cacti to 0.8.8. This issue likes last time I using cacti 0.8.7i.

In Clog I can see that rrdtool.exe update rrd file with the result from Poller.

Please let me know if you know about this issue. Thanks!

Thank & best regards,
HongHa

--------------

Graphs were display normally after I change the timezone to my zone in file C:\php\php.ini
date.timezone = date.timezone = Asia/Ho_Chi_Minh

Thanks all!