#!/bin/sh
# Shell script by Georges Rosset
# To update and graph DNS stats
# Version 1.0 13.08.2004
# ====================================================================


# ====================================================================
# User defined variables
# --------------------------------------------------------------------
rrdfile="/usr/local/rrdtool/datas/DNSstats.rrd";	# RRD database
htmldir="/WWW/utilities/dns";				# Web pages
tempdir="/root/tmp";					# Temp dir
# ====================================================================


# ---------------------------------
# Retreive BIND Stats
# ---------------------------------
/root/Scripts/DNSstats.pl > $tempdir/dns_stats
DNSvalue=$(tail $tempdir/dns_stats);

# ---------------------------------
# Write stats to the RRD database
# ---------------------------------
/usr/local/rrdtool/bin/rrdtool update $rrdfile \
	 -tsuccess:referral:nxrrset:nxdomain:recursion:failure:total \
	 N:$DNSvalue;

# ---------------------------------
# Create 24hrs image
# ---------------------------------
/usr/local/rrdtool/bin/rrdtool graph $htmldir/dns.gif -h200 -w600 \
        --title="24 hrs variations (5 minutes average)" -l0 -v"Queries per second" \
	DEF:tot=$rrdfile:total:LAST     AREA:tot#DDDDEE:  LINE2:tot#0000DD:"Total" \
        DEF:suc=$rrdfile:success:LAST   LINE2:suc#00AA00:"Success" \
        DEF:nxr=$rrdfile:nxrrset:LAST   LINE1:nxr#333333:"NXrrset" \
        DEF:nxd=$rrdfile:nxdomain:LAST  LINE2:nxd#BB00BB:"NXdomain" \
	DEF:rec=$rrdfile:recursion:LAST LINE1:rec#00CCCC:"Recursion" \
        DEF:fai=$rrdfile:failure:LAST   LINE2:fai#FF0000:"Failure" \
        CDEF:nodat=tot,suc,+,UN,INF,UNKN,IF \
        AREA:nodat#FFEEAA:"NoData"

# ---------------------------------
# Create 7 days image
# ---------------------------------
/usr/local/rrdtool/bin/rrdtool graph $htmldir/dns2.gif -w600  -s-604800 \
         --title="7 days variations (30 minutes average)" -v"Queries per second" \
        DEF:tot=$rrdfile:total:AVERAGE    AREA:tot#DDDDEE:  LINE2:tot#0000DD:"Total" \
        DEF:suc=$rrdfile:success:AVERAGE  LINE2:suc#00AA00:"Success"  \
        DEF:nxd=$rrdfile:nxdomain:AVERAGE LINE2:nxd#BB00BB:"NXdomain" \
        DEF:fai=$rrdfile:failure:AVERAGE  LINE2:fai#FF0000:"Failure"  \
        CDEF:nodat=tot,suc,+,UN,INF,UNKN,IF \
        AREA:nodat#FFEEAA:"NoData"

# ---------------------------------
# Date and time of last update
# ---------------------------------
date >  $htmldir/lasttime.txt
cp -f $tempdir/dns_stats $htmldir/laststats.txt

# ====================================================================