Skip to main content

Raymii.org Logo (IEC resistor symbol)logo

Quis custodiet ipsos custodes?
Home | About | All pages | RSS Feed | Gopher

Bind DNS Query Graph Charts with GNUPlot

Published: 13-08-2013 | Author: Remy van Elst | Text only version of this article


Table of Contents


bind

This is a very simple script which uses GNUplot to create graphs of Bind Querylogs.

If you like this article, consider sponsoring me by trying out a Digital OceanVPS. With this link you'll get $100 credit for 60 days). (referral link)

Bind logging

Enable query logging in Bind:

# /etc/bind/named.conf.options     logging{       channel system_log {         file "/var/log/named/sys.log" versions unlimited size 2g;         severity warning;         print-time yes;         print-severity yes;         print-category yes;       };       channel queries_log {         file "/var/log/named/queries.log" versions unlimited size 2g;         severity info;         print-time no;       };       category default{         system_log;       };       category queries{         queries_log;       };     };

Don't forget to create the /var/log/named folder:

mkdir /var/log/namedchown bind:bind /var/log/named

Why /var/log/named? Because AppArmor on Ubuntu allows bind to write to thispath, and I don't like messing with either AppArmor or SELinux.

Bind log parsing

Use the following command line to get the 20 most queries domains

awk '{ print $4 }' /var/log/named/queries.log | sort | uniq -c | sort -n | tail -n 20 > dns-data

Example data:

83094 metrics-api.librato.com83689 collector-2.newrelic.com84165 puppetmaster.int82445 ntp0.nl.net

The use the gnuplot script to create the graph:

gnuplot < plot.gplt

And there you go. This is the GNUPlot script if you don't want to check out therepo.

set term png truecolor size 800,600set output "data.png"set xlabel "Domains"set ylabel "Queries"set title "DNS Usage"set gridset xtics rotate by -45 axis out offset 0,1.5set boxwidth 1 relativeset style fill transparent solid 0.5 border rgb"black"plot "dns-data" u 1:xtic(2) w boxes lc rgb"blue"

Because GNUplot has no easy support for horizotal bar graphs, if you want ithorizontal, rotate it with Imagemagick:

convert data.png -rotate 90 data-90.png

You now have a nice image overview of DNS queries.

Links

License

Copyright (C) 2013 Remy van ElstThis program is free software: you can redistribute it and/or modifyit under the terms of the GNU General Public License as published bythe Free Software Foundation, either version 3 of the License, or(at your option) any later version.This program is distributed in the hope that it will be useful,but WITHOUT ANY WARRANTY; without even the implied warranty ofMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See theGNU General Public License for more details.You should have received a copy of the GNU General Public Licensealong with this program.  If not, see <http://www.gnu.org/licenses/>.
Tags: bind, chart, dns, gnuplot, graph, metrics, monitoring, software