{"id":254,"date":"2007-03-21T04:04:53","date_gmt":"2007-03-21T01:04:53","guid":{"rendered":"http:\/\/www.void.gr\/kargig\/blog\/?p=254"},"modified":"2007-09-13T20:10:46","modified_gmt":"2007-09-13T17:10:46","slug":"round-trip-and-packet-loss-stats-with-rrdtool","status":"publish","type":"post","link":"https:\/\/www.void.gr\/kargig\/blog\/2007\/03\/21\/round-trip-and-packet-loss-stats-with-rrdtool\/","title":{"rendered":"Round Trip and Packet Loss stats with rrdtool"},"content":{"rendered":"

To get some nice graphs showing your round trip time and your packet loss, like the following image, follow the steps below:<\/p>\n

<\/p>\n

What you need before you start: rrdtool and a cron server (vixie-cron is fine).<\/p>\n

a) Execute the following
\n
\n\/usr\/bin\/rrdtool create \/var\/rrds\/ping\/ping_wan.rrd \\
\n --step 300 \\
\n DS:pl:GAUGE:600:0:100 \\
\n DS:rtt:GAUGE:600:0:10000000 \\
\n RRA:AVERAGE:0.5:1:800 \\
\n RRA:AVERAGE:0.5:6:800 \\
\n RRA:AVERAGE:0.5:24:800 \\
\n RRA:AVERAGE:0.5:288:800 \\
\n RRA:MAX:0.5:1:800 \\
\n RRA:MAX:0.5:6:800 \\
\n RRA:MAX:0.5:24:800 \\
\n RRA:MAX:0.5:288:800
\n<\/code><\/p>\n

You can change \/var\/rrds\/ping\/ping_wan.rrd to the path\/file.rrd you wish.<\/p>\n

b) Save the following to the file ping.sh
\n
\n#!\/bin\/bash
\nPING=\/bin\/ping
\nCOUNT=4
\nDEADLINE=10
\nping_host() {
\n local output=$($PING -q -n -c $COUNT -w $DEADLINE $1 2>&1)
\n # notice $output is quoted to preserve newlines
\n local temp=$(echo \"$output\"| awk '
\n BEGIN {pl=100; rtt=0.1}
\n \/packets transmitted\/ {
\n match($0, \/([0-9]+)% packet loss\/, matchstr)
\n pl=matchstr[1]
\n }
\n \/^rtt\/ {
\n # looking for something like 0.562\/0.566\/0.571\/0.024
\n match($4, \/(.*)\\\/(.*)\\\/(.*)\\\/(.*)\/, a)
\n rtt=a[2]
\n }
\n \/unknown host\/ {
\n # no output at all means network is probably down
\n pl=100
\n rtt=0.1
\n }
\n END {print pl \":\" rtt}
\n ')
\n RETURN_VALUE=$temp
\n}
\n# ping a host on the local lan
\nping_host www.ntua.gr
\n\/usr\/bin\/rrdtool update \\
\n \/var\/rrds\/ping\/ping_wan.rrd \\
\n --template \\
\n pl:rtt \\
\n N:$RETURN_VALUE
\n<\/code>
\nping.sh.gz<\/a>
\nChange the ping_host www.ntua.gr to the one of your choice. Make the script executable, chmod +x ping.sh.<\/p>\n

If you have changed the \/var\/rrds\/ping\/ping_wan.rrd on step (a) you have to change it here too.<\/p>\n

c) Save the following to ping-graph.sh and make it executable.
\n
\n#!\/bin\/sh
\ncd \/var\/rrds\/ping\/
\necho \"
\n<HTML>
\n<HEAD><TITLE>Round-Trip and Packet Loss Stats<\/TITLE><\/HEAD>
\n <BODY>
\n <H3>Hourly Round-Trip & Packetloss Stats(1min average)<\/H3>
\n\" > index.html
\nrrdtool graph ping_wan_hour.png -h 225 -w 600 -a PNG \\
\n --imginfo '<IMG SRC=\/stats\/%s WIDTH=%lu HEIGHT=%lu >' \\
\n --start -3600 --end -60 --x-grid MINUTE:10:HOUR:1:MINUTE:30:0:%R \\
\n -v \"Round-Trip Time (ms)\" \\
\n --rigid \\
\n --lower-limit 0 \\
\n DEF:roundtrip=ping_wan.rrd:rtt:AVERAGE \\
\n DEF:packetloss=ping_wan.rrd:pl:AVERAGE \\
\n CDEF:PLNone=packetloss,0,2,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL2=packetloss,2,8,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL15=packetloss,8,15,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL25=packetloss,15,25,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL50=packetloss,25,50,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL75=packetloss,50,75,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL100=packetloss,75,100,LIMIT,UN,UNKN,INF,IF \\
\n AREA:roundtrip#4444ff:\"Round Trip Time (millis)\" \\
\n GPRINT:roundtrip:LAST:\"Cur\\: %5.2lf\" \\
\n GPRINT:roundtrip:AVERAGE:\"Avg\\: %5.2lf\" \\
\n GPRINT:roundtrip:MAX:\"Max\\: %5.2lf\" \\
\n GPRINT:roundtrip:MIN:\"Min\\: %5.2lf\\n\" \\
\n AREA:PLNone#6c9bcd:\"0-2%\":STACK \\
\n AREA:PL2#00ffae:\"2-8%\":STACK \\
\n AREA:PL15#ccff00:\"8-15%\":STACK \\
\n AREA:PL25#ffff00:\"15-25%\":STACK \\
\n AREA:PL50#ffcc66:\"25-50%\":STACK \\
\n AREA:PL75#ff9900:\"50-75%\":STACK \\
\n AREA:PL100#ff0000:\"75-100%\":STACK \\
\n COMMENT:\"(Packet Loss Percentage)\"
\necho \"
\n<img src=\"ping_wan_hour.png\"><br>
\n<br>
\n<H3>Daily Round-Trip & Packetloss Stats(1min average)<\/H3>
\n\" >> index.html
\nrrdtool graph ping_wan_day.png -h 225 -w 600 -a PNG \\
\n --imginfo '<IMG SRC=\/stats\/%s WIDTH=%lu HEIGHT=%lu >' \\
\n --lazy --start -86400 --end -60 --x-grid MINUTE:30:HOUR:1:HOUR:2:0:%H \\
\n -v \"Round-Trip Time (ms)\" \\
\n --rigid \\
\n --lower-limit 0 \\
\n DEF:roundtrip=ping_wan.rrd:rtt:AVERAGE \\
\n DEF:packetloss=ping_wan.rrd:pl:AVERAGE \\
\n CDEF:PLNone=packetloss,0,2,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL2=packetloss,2,8,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL15=packetloss,8,15,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL25=packetloss,15,25,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL50=packetloss,25,50,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL75=packetloss,50,75,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL100=packetloss,75,100,LIMIT,UN,UNKN,INF,IF \\
\n AREA:roundtrip#4444ff:\"Round Trip Time (millis)\" \\
\n GPRINT:roundtrip:LAST:\"Cur\\: %5.2lf\" \\
\n GPRINT:roundtrip:AVERAGE:\"Avg\\: %5.2lf\" \\
\n GPRINT:roundtrip:MAX:\"Max\\: %5.2lf\" \\
\n GPRINT:roundtrip:MIN:\"Min\\: %5.2lf\\n\" \\
\n AREA:PLNone#6c9bcd:\"0-2%\":STACK \\
\n AREA:PL2#00ffae:\"2-8%\":STACK \\
\n AREA:PL15#ccff00:\"8-15%\":STACK \\
\n AREA:PL25#ffff00:\"15-25%\":STACK \\
\n AREA:PL50#ffcc66:\"25-50%\":STACK \\
\n AREA:PL75#ff9900:\"50-75%\":STACK \\
\n AREA:PL100#ff0000:\"75-100%\":STACK \\
\n COMMENT:\"(Packet Loss Percentage)\"
\necho \"
\n<img src=\"ping_wan_day.png\"><br>
\n<br>
\n<H3>Weekly Round-Trip & Packetloss Stats(1min average)<\/H3>
\n\" >> index.html
\nrrdtool graph ping_wan_week.png -h 225 -w 600 -a PNG \\
\n --imginfo '<IMG SRC=\/stats\/%s WIDTH=%lu HEIGHT=%lu >' \\
\n --lazy --start -604800 --end -1800 \\
\n -v \"Round-Trip Time (ms)\" \\
\n --rigid \\
\n --lower-limit 0 \\
\n DEF:roundtrip=ping_wan.rrd:rtt:AVERAGE \\
\n DEF:packetloss=ping_wan.rrd:pl:AVERAGE \\
\n CDEF:PLNone=packetloss,0,2,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL2=packetloss,2,8,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL15=packetloss,8,15,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL25=packetloss,15,25,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL50=packetloss,25,50,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL75=packetloss,50,75,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL100=packetloss,75,100,LIMIT,UN,UNKN,INF,IF \\
\n AREA:roundtrip#4444ff:\"Round Trip Time (millis)\" \\
\n GPRINT:roundtrip:LAST:\"Cur\\: %5.2lf\" \\
\n GPRINT:roundtrip:AVERAGE:\"Avg\\: %5.2lf\" \\
\n GPRINT:roundtrip:MAX:\"Max\\: %5.2lf\" \\
\n GPRINT:roundtrip:MIN:\"Min\\: %5.2lf\\n\" \\
\n AREA:PLNone#6c9bcd:\"0-2%\":STACK \\
\n AREA:PL2#00ffae:\"2-8%\":STACK \\
\n AREA:PL15#ccff00:\"8-15%\":STACK \\
\n AREA:PL25#ffff00:\"15-25%\":STACK \\
\n AREA:PL50#ffcc66:\"25-50%\":STACK \\
\n AREA:PL75#ff9900:\"50-75%\":STACK \\
\n AREA:PL100#ff0000:\"75-100%\":STACK \\
\n COMMENT:\"(Packet Loss Percentage)\"
\necho \"
\n<img src=\"ping_wan_week.png\"><br>
\n<br>
\n<H3>Monthly Round-Trip & Packetloss Stats(1min average)<\/H3>
\n\" >> index.html
\nrrdtool graph ping_wan_month.png -h 225 -w 600 -a PNG \\
\n --imginfo '<IMG SRC=\/stats\/%s WIDTH=%lu HEIGHT=%lu >' \\
\n --lazy --start -2592000 --end -7200 \\
\n -v \"Round-Trip Time (ms)\" \\
\n --rigid \\
\n --lower-limit 0 \\
\n DEF:roundtrip=ping_wan.rrd:rtt:AVERAGE \\
\n DEF:packetloss=ping_wan.rrd:pl:AVERAGE \\
\n CDEF:PLNone=packetloss,0,2,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL2=packetloss,2,8,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL15=packetloss,8,15,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL25=packetloss,15,25,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL50=packetloss,25,50,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL75=packetloss,50,75,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL100=packetloss,75,100,LIMIT,UN,UNKN,INF,IF \\
\n AREA:roundtrip#4444ff:\"Round Trip Time (millis)\" \\
\n GPRINT:roundtrip:LAST:\"Cur\\: %5.2lf\" \\
\n GPRINT:roundtrip:AVERAGE:\"Avg\\: %5.2lf\" \\
\n GPRINT:roundtrip:MAX:\"Max\\: %5.2lf\" \\
\n GPRINT:roundtrip:MIN:\"Min\\: %5.2lf\\n\" \\
\n AREA:PLNone#6c9bcd:\"0-2%\":STACK \\
\n AREA:PL2#00ffae:\"2-8%\":STACK \\
\n AREA:PL15#ccff00:\"8-15%\":STACK \\
\n AREA:PL25#ffff00:\"15-25%\":STACK \\
\n AREA:PL50#ffcc66:\"25-50%\":STACK \\
\n AREA:PL75#ff9900:\"50-75%\":STACK \\
\n AREA:PL100#ff0000:\"75-100%\":STACK \\
\n COMMENT:\"(Packet Loss Percentage)\"
\necho \"
\n<img src=\"ping_wan_month.png\"><br>
\n<br>
\n<H3>Yearly Round-Trip & Packetloss Stats(1min average)<\/H3>
\n\" >> index.html
\nrrdtool graph ping_wan_year.png \\
\n --imginfo '<IMG SRC=\/stats\/%s WIDTH=%lu HEIGHT=%lu >' \\
\n --lazy --start -31536000 --end -86400 -h 225 -w 600 -a PNG \\
\n -v \"Round-Trip Time (ms)\" \\
\n --rigid \\
\n --lower-limit 0 \\
\n DEF:roundtrip=ping_wan.rrd:rtt:AVERAGE \\
\n DEF:packetloss=ping_wan.rrd:pl:AVERAGE \\
\n CDEF:PLNone=packetloss,0,2,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL2=packetloss,2,8,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL15=packetloss,8,15,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL25=packetloss,15,25,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL50=packetloss,25,50,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL75=packetloss,50,75,LIMIT,UN,UNKN,INF,IF \\
\n CDEF:PL100=packetloss,75,100,LIMIT,UN,UNKN,INF,IF \\
\n AREA:roundtrip#4444ff:\"Round Trip Time (millis)\" \\
\n GPRINT:roundtrip:LAST:\"Cur\\: %5.2lf\" \\
\n GPRINT:roundtrip:AVERAGE:\"Avg\\: %5.2lf\" \\
\n GPRINT:roundtrip:MAX:\"Max\\: %5.2lf\" \\
\n GPRINT:roundtrip:MIN:\"Min\\: %5.2lf\\n\" \\
\n AREA:PLNone#6c9bcd:\"0-2%\":STACK \\
\n AREA:PL2#00ffae:\"2-8%\":STACK \\
\n AREA:PL15#ccff00:\"8-15%\":STACK \\
\n AREA:PL25#ffff00:\"15-25%\":STACK \\
\n AREA:PL50#ffcc66:\"25-50%\":STACK \\
\n AREA:PL75#ff9900:\"50-75%\":STACK \\
\n AREA:PL100#ff0000:\"75-100%\":STACK \\
\n COMMENT:\"(Packet Loss Percentage)\"
\necho \"
\n<img src=\"ping_wan_year.png\"><br>
\n<br>
\n<\/BODY>
\n<\/HTML>
\n\" >> index.html
\n<\/code>
\nIf you have changed \/var\/rrds\/ping on step (a) you need to change it here in the beggining of the script too.<\/p>\n

The above script creates a very simple index.html file inside \/var\/rrds\/ping (unless you’ve changed it) with 5 graphs: hourly, daily, weekly, monthly and yearly<\/p>\n

d) Add the following entries to your crontab:
\n
\n*\/5 * * * * \/etc\/mrtg\/ping.sh
\n1,6,11,16,21,26,31,36,41,46,51,56 * * * * \/path\/to\/ping-graph.sh
\n<\/code><\/p>\n

For better accuracy, you can change “–step 300” to “–step 60” in the rrd database creation script and then change the crontab entry for ping.sh from:
\n*\/5 * * * * \/etc\/mrtg\/ping.sh<\/code>
\nto
\n* * * * * \/etc\/mrtg\/ping.sh<\/code><\/p>\n

Original ping script and rrd config for the graphs from http:\/\/haroon.sis.utoronto.ca\/rrd\/scripts\/<\/a><\/p>\n

Enjoy your graphs. <\/p>\n","protected":false},"excerpt":{"rendered":"

To get some nice graphs showing your round trip time and your packet loss, like the following image, follow the steps below: What you need before you start: rrdtool and a cron server (vixie-cron is fine). a) Execute the following \/usr\/bin\/rrdtool create \/var\/rrds\/ping\/ping_wan.rrd \\ –step 300 \\ DS:pl:GAUGE:600:0:100 \\ DS:rtt:GAUGE:600:0:10000000 \\ RRA:AVERAGE:0.5:1:800 \\ RRA:AVERAGE:0.5:6:800 \\ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"footnotes":""},"categories":[3,8],"tags":[],"class_list":["post-254","post","type-post","status-publish","format-standard","hentry","category-linux","category-networking"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t