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> > > >
_______________________________________________ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
