thanks for your email, before ur msg i tried my self /derive and the graphs are normal. kindly look at attachment.
actually i fetch data from switches and i have tried option -v 2c but the result is same, 32 bit counter. can u explain it to me wat derive does and i dont have to worry about other thigns like calculating data etc my self, if you dont mind. can u also look at my graph generating cmd to verify if im not doing any thing wrong, rrdtool graph test.png --imgformat=PNG --start=-2day --end=-1day -S=300 "DEF:up=$UP:min:AVERAGE" "DEF:down=$DOWN:min:AVERAGE" AREA:down#2ECCFA:"Out traffic" AREA:up#013ADF:"Download" --vertical-label=bytes/sec --title="ADSL bandwidth graphs" GPRINT:up:LAST:"Current\:%8.2lf %s\n" GPRINT:up:AVERAGE:"Average\:%8.2lf %s\n" GPRINT:up:MAX:"Maximum\:%8.2lf %s\n" --font TITLE:12: --font AXIS:8: --font LEGEND:10: --font UNIT:8: AREA:up#013ADF:"In traffic" I am sorry if im teasing you, Shabbir. On Wed, May 15, 2013 at 7:36 PM, Martin Sperl <rrdt...@martin.sperl.org>wrote: > so you are using the 32bit counter. > > Then if you insert into the database, you: > either have to do the "wraparound" logic yourself prior to inserting the > values > or you insert the "absolute" counter values and use /derive (as explained > before) > if you use the rrd flatfile database via rrdcreate and update, then > (depending on the definition of the rrd-file) rrd will try to do the > "overflow" detection... > > Martin > > P.s: the 64bit counter are typically only available if you use snmp V2C - > google for "64 bit counter SNMP" and you should find enough information on > how to use it. > > > On 15.05.2013, at 10:07, Shabbir Ahmed wrote: > > quering the device snmpbulkget -c public 119.156.203.217 . > 1.3.6.1.2.1.2.2.1.10 -v 2c > returns 32bit integers > IF-MIB::ifInOctets.20971520 = Counter32: 0 > IF-MIB::ifInOctets.20972032 = Counter32: 0 > IF-MIB::ifInOctets.20972544 = Counter32: 1295822366 > IF-MIB::ifInOctets.20973056 = Counter32: 1295822366 > IF-MIB::ifInOctets.20973568 = Counter32: 1295822366 > IF-MIB::ifInOctets.20974080 = Counter32: 1295822366 > > > 2nd question is most of the values are always same is it the reason port > is down? > > 3rd question what if counter reaches its up limit and starts from 0 again, > how rrd tool manages it? or should we have to manage our self? > > kindly help further with this issue. > > thanks, > > > On Wed, May 15, 2013 at 11:53 AM, Martin Sperl > <rrdt...@martin.sperl.org>wrote: > >> Seems as if you are having "integer overflow" issues reading the 32bit >> SNMP values (or when calculating the delta of the counters in your program). >> >> These rollovers is something your application will need to figure out >> prior to inserting into the database - either by detecting a "rollover" >> (the "rrdtool update" command for rrd files - not used with the dbi backend >> - has a provision for that) or by querying the 64bit values on the router >> instead and then inserting those values. Alternatively the dbi backend can >> also "try" to do the calculations for you on the fly if you insert the >> absolute counter values - see the man-page for details of which option to >> use... (/derive after the data column) >> >> Martin >> >> >> >> On 14.05.2013, at 20:03, Shabbir Ahmed wrote: >> >> yes i used, this time i made graphs for my dsl router at home and they >> are doing better, but the connection is 4mb and the graph shows 1.5G, i hv >> checked database has large values, but these are ported from device, what i >> do i need to do now devid the values on something to get the desired value? >> >> >> >> >> On Tue, May 14, 2013 at 12:31 AM, Martin Sperl >> <rrdt...@martin.sperl.org>wrote: >> >>> Did you try the /rrdfillmissing=1/ as mentioned below as a workaround >>> for your "missing" data? >>> >>> Martin >>> >>> >>> >>> On 13.05.2013, at 18:27, Shabbir Ahmed wrote: >>> >>> some time when i query for snmp the get times out so i cant fill in the >>> table at that time, to fix this wat should i do ? >>> >>> 12:00 i queried db response recorded into mysql >>> 12:05 i queried but snmp get timeout, no entry into mysql >>> 12:06 i queried and got the response into mysql. >>> >>> >>> >>> >>> On Mon, May 13, 2013 at 11:36 AM, Martin Sperl <rrdt...@martin.sperl.org >>> > wrote: >>> >>>> Hi! >>>> >>>> One observation: actually you should see 4 lines not 2 or 1. >>>> >>>> The other is that your data is possibly not stored "equidistant", so >>>> that there are slight "gaps" of say 302 seconds between consecutive >>>> datapoints, which would mean that you are producing times like >>>> this: 0,302,603,...,3298,3601,... (so there would be a gap at time 3300 to >>>> 3599) >>>> >>>> For debugging purposes: can you please run rrdtool like this: >>>> RRDDEBUGSQL=1 *rrdtool graph test.png --imgformat=PNG --start=-1day >>>> --width=600 --height=80 -S=300 "DEF:min=$UP:min:AVERAGE" >>>> "LINE1:min#336600:value"* >>>> >>>> Then you will see the SQL that gets executed and then you can run the >>>> SQL on your own to understand how this "gaps" are generated from the >>>> database... >>>> >>>> But there is also an option to "fill in" "missing" gaps in rrd via the >>>> "/rrdfillmissing=" option. The idea here is similar to the "xff" argument >>>> to rrdcreate for the RRA definition. >>>> >>>> So you may try to add it to your DEF like this: UP="sql//mysql/host= >>>> 127.0.0.1/dbname=newdsl/username=root/password=nocb4enter<http://127.0.0.1/dbname=newdsl/username=root/password=nocb4enter//g3412306061/time/up/idx=201409600> >>>> /rrdfillmissing=1//g3412306061/time/up/idx=201409600<http://127.0.0.1/dbname=newdsl/username=root/password=nocb4enter//g3412306061/time/up/idx=201409600> >>>> " >>>> >>>> Ciao, >>>> Martin >>>> >>>> On 12.05.2013, at 15:05, Shabbir Ahmed wrote: >>>> >>>> Hi, i collect data from switches and save them into mysql, >>>> (snmpidx,time,up,down) >>>> >>>> now i want to draw graphs using >>>> >>>> DOWN="sql//mysql/host= >>>> 127.0.0.1/dbname=newdsl/username=root/password=nocb4enter//g3412306061/time/down/idx=201343232 >>>> " >>>> UP="sql//mysql/host= >>>> 127.0.0.1/dbname=newdsl/username=root/password=nocb4enter//g3412306061/time/up/idx=201409600 >>>> " >>>> >>>> *rrdtool graph test.png --imgformat=PNG --start=-1day --width=600 >>>> --height=80 -S=300 "DEF:min=$UP:min:AVERAGE" >>>> "LINE1:min#336600:value" "DEF:avg=$UP:avg:AVERAGE" >>>> "LINE1:avg#00FF11:average" "DEF:max=$UP:max:AVERAGE" >>>> "LINE1:max#FF0000:max" "DEF:dw=$DOWN:min:AVERAGE" "LINE1:dw#0033CC:value" >>>> >>>> * >>>> *1. the graphs drawn has gaps (i collect data every five mins) and >>>> draw them with 5 mins step but still the gape bw two occurences are empty. >>>> >>>> * >>>> *2. it doesnt draw two lines. >>>> >>>> * >>>> *Kindly help, >>>> * >>>> * >>>> * >>>> _______________________________________________ >>>> rrd-users mailing list >>>> rrd-users@lists.oetiker.ch >>>> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users >>>> >>>> >>>> >>> >>> >> <test.png> >> >> >> > >
<<attachment: test.png>>
_______________________________________________ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
