Re: [rrd-users] Extracting single values using rrdtool
for that there is the PRINT function in rrdtool graph, instead of the GPRINT. PRINT prints it to the stdout. Bredi wrote: The problem is that I get a list of values over the last hour as opposed to a single value representing the average over the hour. You can get one value if you use 'rrdtool xport' with the same start and endtime. Using 'rrdtool last' will give you the latest update time. You can use this time for the 'rrdtool xport' but you have to substract the step in second of your database. I'm sorry but I don't know why you have to do this. ;-) This disatvantage of this procedure is to parse the xport output with an XML tool. Best regards, Bredi. smime.p7s Description: S/MIME Cryptographic Signature ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Automatic Timestamp in RRD graphs
add something like COMMENT:`date` On Wed, 26 Nov 2008 05:16:45 -0800 (PST), Martin Knoblauch [EMAIL PROTECTED] wrote: Hi, is there an rrdtool option to add a time stamp to the RRD graphs? That would be good for docimantation purposes. One can of course add them manually, but I am lazy :-) Cheers Martin -- Martin Knoblauch email: k n o b i AT knobisoft DOT de www: http://www.knobisoft.de ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] I need help with my rrd file
[EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] User-Agent: RoundCube Webmail/0.1b Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit eth0_in=`/usr/bin/snmpwalk -c public -v 1 localhost -r 3 -t 9 -Oqv IF-MIB::ifInOctets.2` eth0_out=`/usr/bin/snmpwalk -c public -v 1 localhost -r 3 -t 9 -Oqv IF-MIB::ifOutOctets.2` echo $eth0_in:$eth0_out /usr/local/rrdtool-1.0.48/bin/rrdtool update test.rrd N:$eth0_in:$eth0_out On Mon, 29 Sep 2008 04:14:51 -0700 (PDT), alucard95 [EMAIL PROTECTED] wrote: Hi all!! I try with your synthax, this time the result is : test_script.sh: 2: input: not found test_script.sh: 4: output: not found The problem must be with my variables, i'll try to find how resolv it. Maybe i have to declare them, i don't know... ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] I need help with my rrd file
or use snmpwalk -Oqv -c public localhost no parsing needed rrdtool update file.rrd N:`snmpwalk -Oqv -c public localhost 1.3.6.1.2.1.2.2.1.16.4`:`snmpwalk -Oqv -c public localhost 1.3.6.1.2.1.2.2.1.16.4` and you only need to graph it On Fri, 26 Sep 2008 13:58:20 +0200, Andreas Maus [EMAIL PROTECTED] wrote: [EMAIL PROTECTED]:~$ snmpget -Oq -v2c -c public 192.168.1.222 1.3.6.1.2.1.2.2.1.16.4 IF-MIB::ifOutOctets.4 269735286 [EMAIL PROTECTED]:~$ snmpget -Oq -v2c -c public 192.168.1.222 1.3.6.1.2.1.2.2.1.16.4 | cut -d ' ' -f 2 269736768 HTH, Andreas. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Aggregate/combine several RRDs
[EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] User-Agent: RoundCube Webmail/0.1b Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit On Fri, 20 Jun 2008 09:41:18 +0200, Raimund Berger [EMAIL PROTECTED] wrote: Jesper Skou Jensen [EMAIL PROTECTED] writes: Thank you for your answers guys, now I'll just have to whip up a little script to go through the RRD's. I'm not currently aware of rrdtool directly supporting this kind of intermediate RRDs, but would be interested to hear if somebody made an attempt on this and got it working. I once did something like this. it takes all the rrdfiles from the dir and graphs them in 1 PNG.(assuming that all the rrdfile have the same DS and RRA.) http://haas.oezie.org/~erik/allesbijelkaar.pl example output: http://haas.oezie.org/~erik/total.png the numbers are all the same because I copied the same file over and over again. Mvg, Erik ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] filter rrd data
add a CDEF with LIMIT. CDEF:new=old,100,LIMIT for example Mvg, Erik Maxim Kuleshov schreef: Hi! I could manually dump .rrd, edit xml and then restore it, but may be there is a tool (third-party?) performing filtering raw values (already stored in file) for specified boundary, substituting bad values for unknown? ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Combine average data to one CDEF
On Wed, 21 May 2008 09:25:18 +0200, Hans van Kilsdonk [EMAIL PROTECTED] wrote: Hello, rrdtool graph test.png -s -1d -e now -t 'test graph' \ -l 0 -r -c GRID#66 -c MGRID#88 -w 495 -h 200 -a PNG \ -v 'bits per second' \ 'DEF:kbin1:/home/data/1.rrd:ds0:AVERAGE' \ 'DEF:kbout1:/home/data/1.rrd:ds1:AVERAGE' \ 'DEF:kbin2:/home/data/2.rrd:ds0:AVERAGE' \ 'DEF:kbout2:/home/data/2.rrd:ds1:AVERAGE' \ 'DEF:kbin3:/home/data/3.rrd:ds0:AVERAGE' \ 'DEF:kbout3:/home/data/3.rrd:ds1:AVERAGE' \ 'CDEF:totalkbin=0,kbin1,+,kbin2,+,kbin3,+' \ 'CDEF:totalkbout=0,kbout1,+,kbout2,+,kbout3,+' \ 'AREA:totalkbin#CBCCCF:' \ 'LINE1:totalkbout#B43F2E:' This works like a charm. However, when I want to add another DEF where the data in the RRD file starts later the whole graph starts at that time. Any data before the latest start time is not shown in the graph. Is there a way to avoid this? Check for unknown, or use rrdtool 1.3.x there is a function to all NAN's tot good values. some thing like this. kbin1,UN,0,kbin1,IF,kbin2,UN,0,kbin2,IF,kbin3,UN,0,kbin3,IF,+,+ Thanks in advance. -- Hans Groeten, Erik ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Color effect
http://www.mail-archive.com/rrd-users@lists.oetiker.ch/msg09709.html Mvg, Erik On Thu, 17 Apr 2008 09:51:41 -0400, R Dicaire [EMAIL PROTECTED] wrote: On Thu, Apr 17, 2008 at 9:39 AM, Caio Brentano [EMAIL PROTECTED] wrote: I have a threshold value and when my data is about 85% of it, I need that the colour of my AREA graphs starts to turn red. I know how to do graphs that changes the colour. But this must depends on the value! rs ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] simple [?] question
from the manual: PERCENT This should follow a DEF or CDEF vname. The vname is popped, another number is popped which is a certain percentage (0..100). The data set is then sorted and the value returned is chosen such that percentage percent of the values is lower or equal than the result. Unknown values are considered lower than any finite number for this purpose so if this operator returns an unknown you have quite a lot of them in your data. Infinite numbers are lesser, or more, than the finite numbers and are always more than the Unknown numbers. (NaN -INF finite values INF) Example: VDEF:perc95=mydata,95,PERCENT rrdtool graph - \ DEF:mydata=/usr/share/cacti/site/rra/sw135s3_traffic_in_31.rrd:traffic_in:AVERAGE \ DEF:b=/usr/share/cacti/site/rra/sw135s3_traffic_in_31.rrd:traffic_out:AVERAGE \ VDEF:perc95=mydata,95,PERCENT PRINT:perc95:%.2lf %s with PRINT it prints it to the stdout and with GPRINT it is printed inside the graph. Mvg, Erik de Mare On Wed, 6 Feb 2008 19:00:18 -0800, John Bramlett [EMAIL PROTECTED] wrote: I need some help formulating a command to extract some data from rrd files created by cacti. All I want returned is a single number representing 95th percentile for an arbitrary time period (no graphical output; text only). I'm not as clueless as this question is but rrdtool is kind of tough since I just need this one thing I was hoping someone could help out with a general form for a command. Below is the command that cacti is using to generate the same number that I'm looking for. (The constant string 13.42 mb/s in the last COMMENT line is what I'm interested in retrieving, but don't know how cacti gets to that.) snip ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] A few Newbie questions
if you have 1.2.x it can be done this way: (from the manual http://oss.oetiker.ch/rrdtool/doc/rrdgraph_rpn.en.html) TOTAL Returns the rate from each defined time slot multiplied with the step size. This can, for instance, return total bytes transfered when you have logged bytes per second. The time component returns the number of seconds. Example: VDEF:total=mydata,TOTAL or with rrdtool 1.0.x here is a little part from my perl script push(@data,--start=-$span); push(@data,CDEF:totalin=in,UN,0,in,$span,*,IF); push(@data,CDEF:totalout=out,UN,0,out,$span,*,IF); push(@data,GPRINT:totalin:AVERAGE:Total traffic\\: %.2lf %s\\n); push(@data,GPRINT:totalout:AVERAGE:Total traffic\\: %.2lf %s); Mvg, Erik de Mare On Tue, 5 Feb 2008 23:17:47 +, Simon Hobson [EMAIL PROTECTED] wrote: apoch632 wrote: I have a set of .rrd databases which give the Internet usage of an IP address over a timeframe. How do I extract this data to be able to say on a webpage or terminal that 'This IP address' has downloaded X bytes this month Average = total/time therefore total = average * time Get average over period, multiply by timespan of period, you have total ! Just use 'gprint' to print out the average of the data, multiply it by time, you get total. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Area in different colors
I once made a little perl script for that. @color = ('00FF00','11FF00','22FF00','33FF00','44FF00','55FF00','66FF00','77FF00','88FF00','99FF00','AAFF00','BBFF00', 'CCFF00','DDFF00','EEFF00','00','FFEE00','FFDD00','FFCC00','FFBB00','FFAA00','FF9900','FF8800', 'FF7700','FF6600','FF5500','FF4400','FF3300','FF2200','FF1100','FF'); $letter = 'a'; for($i=0;$i@color;$i++){ $control = ($i+1)*($Size/@color); $fac = $Size/@color; $value = $i*($Size/@color); print CDEF:$letter=totaal,$control,GE,$fac,totaal,$value,-,0,LE,UNKN,totaal,$value,-,IF,IF\n; push(@data,CDEF:$letter=totaal,$control,GE,$fac,totaal,$value,-,0,LE,UNKN,totaal,$value,-,IF,IF); $letter++; } $letter = 'a'; push(@data,AREA:$letter#$color[0]); $letter++; for($i=1;$i@color;$i++){ print STACK:$letter#$color[$i]\n; push(@data,STACK:$letter#$color[$i]); $letter++; } makes something like this: http://haas.oezie.org/rrd/haas-day-proces.png Mvg, Erik Simone Felici schreef: Alex van den Bogaerdt ha scritto: On Tue, Dec 04, 2007 at 04:18:23PM +0100, Simone Felici wrote: Hi Alex! It's not exactly what I would create. This creates a graph with different colors, but where the values goes over 60 (in example), it takes the same color from 0 to over 60 and not 4 different colors. This issue comes up every now and then. Several examples are shown on the mailing list, please have a look in the archives. Also see the other response you just got. Ok, thank's anyway... search form is not the best one, bwt thank's to all, I'll look forward myself. Bye, Simon ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Graphing average temperatures
I think you are looking vor something like this: http://haas.oezie.org/rrd/temp/temp-year-vergelijk.png the thick lines are TREND lines with a window of 1 week. the thinner lines are the average values for that day, and the most thin lines are min and max values during that day. Petteri Matilainen schreef: If I'm reading your graphs correctly, you don't graph the average temperature at all. You only display it on the 'avg.' column. I specifically need to graph the average over 24 hrs, 1 week, 1 month and 1 year. I have read your 'how to do this' and it has been very useful. Here's a sample image of what I've managed to graph so far: http://www.kotikone.fi/pmatil/out_day.png. On the picture there is also the gap I mentioned. The average curve is plotted the way I described it on my earlier posts. cheers, Petteri On 11/21/07, *Paul Rimmer* [EMAIL PROTECTED] [snip] ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Graphing average temperatures
I use RRA's to calculate the averages. my stepsize is 5 min(300sec) with a script I read it from a DS1820 maxim IC. I have the following RRA's defined. RRA:AVERAGE:0.5:1:766 - 2,5 days of 5 min samples. RRA:AVERAGE:0.5:6:766 - 2 weeks data with the average of 30 mins(6*300sec) RRA:AVERAGE:0.5:24:766 - 2 months data with average of 2 hours(24*300sec) RRA:AVERAGE:0.5:288:766 - 2 years of data with the average of 1 day(288*300sec) I also have these for MIN and MAX. when I draw a year graph the last RRA will be used by rrdtool. but you can also graph 2 months with the last RRA, then you have to 'force' rrdtool to use that specific rra in the DEF statemen, example DEF:..:..:..:..:step=86400 the sliding average is just a CDEF with TREND. I hope this makes it a bit more clear to you. Mvg, Erik On Thu, 22 Nov 2007 07:40:06 +0200, Petteri Matilainen [EMAIL PROTECTED] wrote: Yes, I think the sliding window average (TREND) could work for me. So I need to define a 24 hr sliding window to plot 24 hr averages? Is the TREND curve same as if I graphed this: GPRINT:Inside:AVERAGE:\t%6.2lf °C (on the picture on my last post)? Erik De Mare: how do you graph the averages for each day? cheers, Petteri On 11/22/07, Erik de Mare [EMAIL PROTECTED] wrote: I think you are looking vor something like this: http://haas.oezie.org/rrd/temp/temp-year-vergelijk.png the thick lines are TREND lines with a window of 1 week. the thinner lines are the average values for that day, and the most thin lines are min and max values during that day. Petteri Matilainen schreef: If I'm reading your graphs correctly, you don't graph the average temperature at all. You only display it on the 'avg.' column. I specifically need to graph the average over 24 hrs, 1 week, 1 month and 1 year. I have read your 'how to do this' and it has been very useful. Here's a sample image of what I've managed to graph so far: http://www.kotikone.fi/pmatil/out_day.png. On the picture there is also the gap I mentioned. The average curve is plotted the way I described it on my earlier posts. cheers, Petteri On 11/21/07, *Paul Rimmer* [EMAIL PROTECTED] [snip] ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Need help with a CDEF/AREA setup
Hi, INF only graphs from 0 to infinity, so negative values will never be covered. you can add an other CDEF for the negative part with NEGINF. http://oss.oetiker.ch/rrdtool/doc/rrdgraph_rpn.en.html INF, NEGINF Pushes a positive or negative infinite value on the stack. When such a value is graphed, it appears at the top or bottom of the graph, no matter what the actual value on the y-axis is. so your other CDEF would be like: CDEF:night=LTIME,86400,%,$1,LT,NEGINF,LTIME,86400,%,$2,GT,NEGINF,UNKN,Basement,*,IF,IF Mvg, Erik Paul Rimmer schreef: Hi, The line that defines the CDEF used for night is: CDEF:night=LTIME,86400,%,$1,LT,INF,LTIME,86400,%,$2,GT,INF,UNKN,Basement,*,IF,IF \ Cheers, Paul ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Need a way to show 2(or more) lines on a graph thathave nearly identical values
Other than putting them in individual graphs, am I missing a simple solution? Hmmm ... In this case (CPU utilization of 4 severs I assume) I would use individual graphs. or use transperency with the lines. LINE[width]:value[#color][:[legend][:STACK]] color can be RRGGBBAA where AA is the level of transperency. (and I also would remove the max 100 in the graph and let rrdtool only graph the 5-15% part) Mvg, Erik ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool dump
rrdtool graph - DEF: CDEF: PRINT:.. On Wed, 4 Jul 2007 09:52:50 +0100, Geoff Garside [EMAIL PROTECTED] wrote: what kind of reports are that? with CDEF's and VDEF's you can do a lot, and let rrdtool print it to the commandline with PRINT and use it in your reports. example: VDEF:total_in=in,TOTAL PRINT:total_in:%.2lf Which rrdtool command would you use this with to print to a text file or stdout? I've looked through most of the documentation and commands like fetch just don't seem to let you do the same as graph. Mvg, Erik ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users Regards, Geoff Garside Open Hosting Ltd ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] change background for special timeperiods
for the nights it is: CDEF:werk=LTIME,86400,%,28800,LT,INF,LTIME,86400,%,64800,GT,INF,UNKN,buiten,*,IF,IF http://haas.oezie.org/rrd/temp/temperatuur-day.png for the weekends: CDEF:weekend=LTIME,604800,%,172800,GT,LTIME,604800,%,345600,LT,INF,UNKN,buiten,*,IF,UNKN,buiten,*,IF AREA:weekend#FF00FF33 see: http://haas.oezie.org/rrd/temp/temp-month.png Mvg, Erik On Mon, 02 Jul 2007 16:35:41 +0200, Markus Schmidberger [EMAIL PROTECTED] wrote: Thanks a lot. I still have some more questions: How can I highlight weekends: Friday 20:00 to Monday 6:00? CDEF:werk colors the day times. We want to color the night. What do we have to change? Thanks, Markus Erik de Mare schrieb: would be a little CDEF DEF:buiten=/root/rrd/temp/sensor0.rrd:C:AVERAGE CDEF:werk=LTIME,86400,%,28800,GT,LTIME,86400,%,64800,LT,INF,UNKN,buiten,*,IF,UNKN,buiten,*,IF where 28800(8:00) is the seconds since 0:00 when to start, and 64800(18:00) is the seconds since 0:00 when to stop. example graph: http://haas.oezie.org/rrd/temp/temperatuur-day.png Mvg, Erik On Mon, 02 Jul 2007 12:27:39 +0200, Markus Schmidberger [EMAIL PROTECTED] wrote: Hello, we use Nagios with PNP / RRDtool and want to have different background colors for night- (8pm-6am) and day-time (6am-8pm). (and weekend) Can you help me, how to do this? Thanks Markus ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool dump
what kind of reports are that? with CDEF's and VDEF's you can do a lot, and let rrdtool print it to the commandline with PRINT and use it in your reports. example: VDEF:total_in=in,TOTAL PRINT:total_in:%.2lf Mvg, Erik Roberto Dud schreef: Hi All, I�m new on list, but I have a problem. Im my company I collect values and I build reports, about bandwith for MRTG logs. But I have a Lot of MRTG graphs and I have a lot of problems with performance on my server, and change MRTG logs to rrdttol database, and I use MRTG-RRD to show graphics. But I need to build a reports and I don�t undestanding the format of rrd database. I don�t undestand this values on columns, how I do to change this values to bits or bytes? Thanks, Dud. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] change background for special timeperiods
would be a little CDEF DEF:buiten=/root/rrd/temp/sensor0.rrd:C:AVERAGE CDEF:werk=LTIME,86400,%,28800,GT,LTIME,86400,%,64800,LT,INF,UNKN,buiten,*,IF,UNKN,buiten,*,IF where 28800(8:00) is the seconds since 0:00 when to start, and 64800(18:00) is the seconds since 0:00 when to stop. example graph: http://haas.oezie.org/rrd/temp/temperatuur-day.png Mvg, Erik On Mon, 02 Jul 2007 12:27:39 +0200, Markus Schmidberger [EMAIL PROTECTED] wrote: Hello, we use Nagios with PNP / RRDtool and want to have different background colors for night- (8pm-6am) and day-time (6am-8pm). (and weekend) Can you help me, how to do this? Thanks Markus ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] can't sanity-check rrdtool with sample data ...please help
Hi, RRDtool uses when updating a timestamp, I think calculated the following way: timestamp - timastamp % stepsize when you update you are inserting data at each day at 8:00. try updateing it at 0:00 (what rrdtool fetch prints, 1141257600 = Thu, 02 Mar 2006 00:00:00 GMT) rrdtool update hits.rrd 1141257600:1 1141344000:10 1141430400:10 1141516800:12 1141603200:12 1141689600:12 rrdtool fetch hits.rrd MAX --start 114120 --end 1141718400 On Tue, 26 Jun 2007 19:47:32 -0700 (PDT), Gore Jarold [EMAIL PROTECTED] wrote: rrdtool update hits.rrd 1141286400:1 1141372800:10 1141459200:10 1141545600:12 1141632000:12 1141718400:12 So now look at the output of: rrdtool fetch hits.rrd MAX --start 114120 --end 1141718400 1141257600: 1.00e+00 1141344000: 7.00e+00 1141430400: 1.00e+01 1141516800: 1.13e+01 1141603200: 1.20e+01 1141689600: 1.20e+01 1, 10, 10, 12, 12, 12 and 'fetch' output: 1, 7, 10, 11.3, 12, 12 ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] Correct CDEF to get the spam count right?
hi Vincent, VDEF's aren't meant to make graphs, the are for aditional info in the legenda. VDEF's only return 1 value, like maximum value of the period graphed, of the total of that period. so for the graph you still need the CDEF's. mvg, Erik de Mare rrd-users@lists.oetiker.ch wrote: On Wed, 31 Jan 2007, erik wrote: hi, are you graphing 2 days of data? (172800 = 2 days) and what version are you using of rrdtool, if you use 1.2.x you can add VDEF's instead of CDEF's example: VDEF:vdef1=def1,TOTAL (http://oss.oetiker.ch/rrdtool/doc/rrdgraph_rpn.en.html) mvg, Erik Erik, Thanks for the advice, Now the number is much accurate for Blocked_SPAM,Passed_CLEAN except Blocked_BANNED. Another changes I noticed is that the graph is not in wave/pulse shap anymore, it is a straight horizontal smooth graph, any idea? Debug lines as: DEF:def0=_star/Blocked_BANNED.rrd:hits:AVERAGE VDEF:cdef0=def0,TOTAL AREA:cdef0#ff:Blocked BANNED GPRINT:cdef0:Total\:%5.1lf msgs DEF:def1=_star/Blocked_INFECTED.rrd:hits:AVERAGE VDEF:cdef1=def1,TOTAL STACK:cdef1#8e2323:Blocked INFECTED GPRINT:cdef1:Total\:%5.1lf msgs DEF:def2=_star/Blocked_SPAM.rrd:hits:AVERAGE VDEF:cdef2=def2,TOTAL STACK:cdef2#00:Blocked SPAM GPRINT:cdef2:Total\:%5.1lf msgs DEF:def3=_star/Passed_CLEAN.rrd:hits:AVERAGE VDEF:cdef3=def3,TOTAL STACK:cdef3#00ff00:Passed CLEAN GPRINT:cdef3:Total\:%5.1lf msgs Vincent http://bl0g.blogdns.com ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
[rrd-users] Re: color tones
I tried to make that also, what I got was this http://haas.oezie.org/rrd/haas-day-proces.png, from green to red. the problem now is that I can't graph negative numbers. her is a piece of perl code I made: @color = ('00FF00','11FF00','22FF00','33FF00','44FF00','55FF00','66FF00','77FF00','88FF00','99FF00','AAFF00','BBFF00', 'CCFF00','DDFF00','EEFF00','00','FFEE00','FFDD00','FFCC00','FFBB00','FFAA00','FF9900','FF8800', 'FF7700','FF6600','FF5500','FF4400','FF3300','FF2200','FF1100','FF'); $letter = 'a'; for($i=0;$i@color;$i++){ $control = ($i+1)*($Size/@color); $fac = $Size/@color; $value = $i*($Size/@color); # print CDEF:$letter=totaal,$control,GE,$fac,totaal,$value,-,0,LE,UNKN,totaal,$value,-,IF,IF\n; push(@data,CDEF:$letter=totaal,$control,GE,$fac,totaal,$value,-,0,LE,UNKN,totaal,$value,-,IF,IF); $letter++; } $letter = 'a'; push(@data,AREA:$letter#$color[0]); $letter++; for($i=1;$i@color;$i++){ push(@data,STACK:$letter#$color[$i]); $letter++; } where total is the DEF that you are graphing. push(@data,DEF:totaal=$file:hrStorageUsed:AVERAGE); maybe this will help you as a start. mvg Erik de Mare Alexander Krogloth wrote: hello, i want to know how to make rrdgraphs with these good-looking color tones -- http://people.ee.ethz.ch/~oetiker/webtools/rrdtool-1.0.x/gallery/beaumont-01.html i don't know how to set up the graph that there isn't a line where the color changes from red to yellow but the change the color slowly thx for help --alex -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://lists.ee.ethz.ch/rrd-users WebAdminhttp://lists.ee.ethz.ch/lsg2.cgi
[rrd-users] Re: Bandwidth per week
I posted this already earlier. but I think with some adjustments it can be used for your purpose. I don't know your perl-scripting skills but it is pretty simple script. here is a(working) sample for month and year stats, http://haas.oezie.org/cgi-bin/traffic.pl?jaar=2005maand=4 and http://haas.oezie.org/cgi-bin/traffic.pl?jaar=2005. the source of the scripts is at the bottom of the page. if there are any question, just ask. mvg Erik de Mare Anders Nielsen wrote: I am monitoring the bandwidth usage on the different network interfaces with rrd and it's great :) However, I would also like to know how much bandwidth we are using per week. How can I accomplish this with rrd? I am using Redhat Linux Thanks in advance Anders Nielsen -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://lists.ee.ethz.ch/rrd-users WebAdminhttp://lists.ee.ethz.ch/lsg2.cgi
[rrd-users] Re: Calculate total over a give period of time
Georges Toth wrote: Hi, I got an rrd db, which i use for counting the traffic on an ethernet interface. Is it possible to print the total of in- and out-bytes over a give period of time ? If so, how ? some old scripting what I did. http://haas.oezie.org/overzicht.html http://haas.oezie.org/overzicht.pl it is al perl script. later I made some adjustments to make some nice plots like gbgraph. http://haas.oezie.org/cgi-bin/traffic.pl?jaar=2005 or http://haas.oezie.org/cgi-bin/traffic.pl?jaar=2005maand=2 the source is at the bottom of the page. mvg Erik -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Data granularity
Serge Maandag wrote: snip I still would use the log file solution. It's way cleaner. I took mailgraph as an example for my scripts, and I build this with it: http://haas.oezie.org/rrd/httpd/ (and the script here http://haas.oezie.org/rrd/httpd.pl) it works like a tail -f logfile, and counts the new lines. strips them and count the apache errorcodes 200,404,502 etc. I will write som documentation about it like in http://haas.oezie.org/rrd/cpu.htm (sorry dutch only, maybe later in englisch). maybe you could take it also as an example and adjust i to your needs. mvg Erik de Mare Serge. - Op de inhoud van dit e-mailbericht en de daaraan gehechte bijlagen is de inhoud van de volgende disclaimer van toepassing: http://www.zeelandnet.nl/disclaimer.php -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: 'graph' command printing to stdout
[EMAIL PROTECTED] wrote: Hello, I'm making my first steps with RRD (used MRTG several years ago), and I'm noticing that 'rrdtool graph...' command prints out something to stdout. In my case it prints: 800x205 that is the size of the picture, 800x205 pixels nothing to worry about. Thanks, Otis P.S. There must be ready-made scripts that gather data for used/free disk space, network interface traffic, etc. I thought I found find those in contrib/, but they aren't there. Is there a collection that I could make use of somewhere, or do I need to reinvent the wheel? Thanks. I have made some scripts with perl to gather data of my system. maybe you could work with them and improve or adjust it to your wishes. http://haas.oezie.org/rrd/ mvg Erik -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: where to find help
Serge Maandag wrote: I don't recall seeing a question coming from your email-address. Serge. he asked 2 questions. 1: vieuwing values send 10-10-2004 5:42(awnsered by Serge Maandag om 10-10-2004 10:46), and 2: Correct Database Sizes send 11-10-2004 18:36.(not awnsered) -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Announcing yet another dynamic RRD cgi graph viewer
Haroon Rafique wrote: Hi list, The script is written in perl and is based off of Jan Yenya Kasprzak's script mrtg-rrd.cgi If it already uses perl why not make the data-collect script with a nice perl-NET::SNMP module? http://haas.oezie.org/rrd/ here are some script that I made with perl. -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Funny problem with RRD....
notice the capitale U DS:E-used:GAUGE:1500:0:U \ ERROR: No DS called 'E-Used' in 'pc.rrd' -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: expected 2 data source got 8
instead of snmpwalk -v 1 -c public addr 1.3.6.1.2.1.2.2.1.10.1 use snmpwalk -O vq -v 1 -c public addr 1.3.6.1.2.1.2.2.1.10.1 look at snmpwalk -h -O OUTOPTSToggle various defaults controlling output display: v: print values only (not OID = value) q: quick print for easier parsing use lib qw( C:/mrtg-2.10.13/bin/mrtg1); $local_dir=C:/mrtg-2.10.13/bin/mrtg1; $a=0; use RRDs; use Net::SNMP; while($a==0) { $in1=`snmpwalk -v 1 -c public addr 1.3.6.1.2.1.2.2.1.10.1`; $out1=`snmpwalk -v 1 -c public addr 1.3.6.1.2.1.2.2.1.16.1`; print $in1; print $out1; RRDs::update($local_dir/myrouter.rrd,N:$in1:$out1); my $ERR=RRDs::error; die ERROR while updating mydemo.rrd: $ERR\n if $ERR; sleep(300 ); } -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: win2k and rrd
hope you can do something with it. David Puckett wrote: Hello All, Can anyone send some examples of monitoring CPU and HDD on Win2k with RRD? THanks, david -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 2k (2278 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/users-zeehond.oezie.org.png -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 1k (1813 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/cpu-haas.oezie.org.png -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 2k (2926 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/disk-haas.oezie.org-3.png -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 2k (2557 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/processes-zeehond.oezie.org.png -- Attached file removed by Ecartis and put at URL below -- -- Type: text/plain -- Size: 11k (11553 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/traffic-disk-uptime-users-proce -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 4k (4460 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/traffic-haas.oezie.org-16777219 -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 2k (2474 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/uptime-haas.oezie.org.png -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: network total traffic with rrd
hi, what is calc.pl exactly doing? calculating traffic per day/month/year? some weeks ago i quickly put this script together(http://chaos.keyserver.org/~erik/overzicht.pl) this will generate an htmlpage like this http://chaos.keyserver.org/~erik/overzicht.html. now i'm make some graph's which are almoste the same as gbgraph(http://gbgraph.menthenberg.nl/) it is still in development. see attachments. maybe you can adjust the scripts so they can be useful for your situation. mvg Erik de Mare Guido Gavilanes Castillo wrote: I am using calc.pl to get total network traffic with mrtg .log files, but I am starting using RRDTool, and this same procedure valid for mrtg doesn't work with rrd files, I have rrd already installed, does it have to work? are there other kinds of scripts to do this for rrd files? I would appreciate some help, Thank you Guido Gavilanes -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 4k (4505 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/monthly.png -- Attached file removed by Ecartis and put at URL below -- -- Type: text/plain -- Size: 4k (4687 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/gbgraph-year.pl -- Attached file removed by Ecartis and put at URL below -- -- Type: text/plain -- Size: 4k (4972 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/gbgraph.pl -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 3k (3782 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/yearly.png -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: cuting peaks ?
Hugo van der Kooij wrote: On Thu, 8 Jan 2004, Alex van den Bogaerdt wrote: On Thu, Jan 08, 2004 at 11:24:24AM +0200, raptor wrote: Is there a method/way to cut high peaks so that other values do not flatten on the graphic... I have no MAX value set during creation of the RRD i.e. DS:x:COUNTER:0:U, i dont want to, but want to cut peaks if they show up.. Choose between these two: 1: specify a maximum (--upper-limit) and rigid (--rigid) 2: use a CDEF to change large rates into unknown So if my CPU graphs shows a glitch into the MEGA %s I could reduce it with: CDEF:rawuser=cpurawuser,100,GT,nan,IF Hugo. or you can use LIMIT * LIMIT* replaces the value with /*UNKNOWN*/ if it is outside the limits specified by the two values above it on the stack. CDEF:a=alpha,0,100,LIMIT Erik. -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Simple solution to a problem?
Hugo van der Kooij wrote: Hi, I have been looking for a relative simple way to setup databases, data gathering and some webpages to build a custom overview. In it's most simple form I want a simple form to ask for an IP address and a community name and have it gather all the information for me and setup a custom graphs and databases. As this will be a movable tool to help switching engineers to trouble shoot switching issues I need rather specific options I could not work out with tools like cricket and cacti. Is anyone working on such an animal? Building templates may be a bit harder as it will be done just once but getting the tool in place to monitor a switch or router should be relative simple. I may try to get some time allocated to build such a tool in company time as it will shorten troubleshooting with a significant amount of time. But if anyone is allready working on the exact issue It might be better to bundle our strengths. Hugo. I am working on something like that. I now have a script in perl that gathers from a host incomming and outgoing traffic of the interfaces that are up(OID .1.3.6.1.2.1.2.2.1.7). you can easy add an extra host to be monitored, the script wil make an .rrd file and start monitoring. It still needs a lot of work. for example wrong data is not checked. The same you can do with HardDisk(OID .1.3.6.1.2.1.25.2.3.1), Uptime(OID .1.3.6.1.2.1.25.1.1.0) or Load(OID .1.3.6.1.4.1.2021.10.1.3) monitoring. Erik de Mare attached a sample traffic monitor script -- Attached file removed by Ecartis and put at URL below -- -- Type: text/plain -- Size: 4k (4270 bytes) -- URL : http://www.ee.ethz.ch/~slist/pantomime/traffic.pl -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Disk Usage per SNMP?
Hugo van der Kooij wrote: Hi, I am trying to graph diskusage with RRDtools. (Finally changing from MRTG) but it seems it does not work to well. I initialized the database with: rrdtool create /etc/stats/aragorn.disk.usr.rrd \ DS:units:GAUGE:600:U:U \ DS:size:ABSOLUTE:600:U:U\ DS:used:ABSOLUTE:600:U:U\ RRA:AVERAGE:0.5:1:576 \ RRA:AVERAGE:0.5:6:672 \ RRA:AVERAGE:0.5:24:732 \ RRA:AVERAGE:0.5:288:732 \ RRA:MAX:0.5:1:576 \ RRA:MAX:0.5:6:672 \ RRA:MAX:0.5:24:732 \ RRA:MAX:0.5:288:732 I read the vaules in with: UNITS=`$SNMPGET -v1 -c mysnmpd aragorn 1.3.6.1.2.1.25.2.3.1.4.8|awk '{print $4}'` SIZE=`$SNMPGET -v1 -c mysnmpd aragorn 1.3.6.1.2.1.25.2.3.1.5.8|awk '{print $4}'` USED=`$SNMPGET -v1 -c mysnmpd aragorn 1.3.6.1.2.1.25.2.3.1.6.8|awk '{print $4}'` rrdtool update $STATDIR/aragorn.disk.usr.rrd N:$UNITS:$SIZE:$USED I checked the values with an additional echo command and the proper values are returned and fed to rrdtool. But graphing them seem to be a bit harder. I tried a simple version with: rrdtool graph $GRAPHS/aragorn-disk-home.$PERIOD.gif --start -$LENGTH\ -t aragorn DISK /home $TITEL \ DEF:units=$STATS/aragorn.disk.home.rrd:units:AVERAGE\ DEF:size=$STATS/aragorn.disk.home.rrd:size:AVERAGE \ DEF:used=$STATS/aragorn.disk.home.rrd:used:AVERAGE \ CDEF:disk=used,units,* \ AREA:normal#7EE600:used \ GPRINT:disk:AVERAGE:Gemiddeld\:%14.0lf B \ GPRINT:disk:MAX:Maximum\:%14.0lf B\n But the values shown are not what I would expect. The specific partition is rather large but I was under the impression the RRDtools could handle larger values ( 2^32). See also the df output: Filesystem 1K-blocks Used Available Use% Mounted on /dev/md7 111207864 103446296 2112320 98% /home In the long run I would like to use a three color approach. (green for 80%; orange for 80-95%; red for 95%) Hugo. hi, I tried that also, and wrote a script for that to monitor each drive on the computers in my network. It uses the Net::SNMP and the RRDs modules for perl, als stores the used and total data in the rrd file. Erik attached are 3 sample images and the script -- Attached file removed by Ecartis and put at URL below -- -- Type: text/plain -- Size: 7k (8181 bytes) -- URL : http://www.ee.ethz.ch/~slist/pantomime/hd.pl -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 2k (2802 bytes) -- URL : http://www.ee.ethz.ch/~slist/pantomime/jachtluipaard-2.png -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 2k (2817 bytes) -- URL : http://www.ee.ethz.ch/~slist/pantomime/jachtluipaard-3.png -- Attached file removed by Ecartis and put at URL below -- -- Type: image/png -- Size: 2k (2846 bytes) -- URL : http://www.ee.ethz.ch/~slist/pantomime/jachtluipaard-4.png -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi