[rrd-users] Re: DNS Querie ( NEWBIE )

[Ronald Tse]

So you are using Linux?
First, create a database.
rrdtool create namedlog.rrd   DS:query:COUNTER:600:U:U
RRA:AVERAGE:0.5:1:600       RRA:AVERAGE:0.5:6:700     RRA:AVERAGE:0.5:24:775
RRA:AVERAGE:0.5:288:797      RRA:MAX:0.5:1:600      RRA:MAX:0.5:6:700
RRA:MAX:0.5:24:775         RRA:MAX:0.5:288:797

Then update it:
tmp=$(cat your_log_file | grep UDP | wc- l )
rrdtool update namedlog.rrd N:"$tmp"
[run this every five minutes by cron]

Then generate the graphs:
rrdtool graph namedlog.gif
--start -86400        \
DEF:rquery=namedlog.rrd:query:AVERAGE        \
AREA:rquery#00FF00"DNS Queries"            \
COMMENT:"\n"             \
COMMENT:"  DNS Queries:     Max:"    \
GPRINT:rquery:MAX:"%6.2lf  "               \
COMMENT:"     Min:"             \
GPRINT:rquery:MIN:"%6.2lf  "       \
COMMENT:"     Average:"         \
GPRINT:rquery:AVERAGE:"%6.2lf  "        \
COMMENT:"  GIF Generated at : $(date)"


Thanks
Ronald Tse

----- Original Message -----
From: "Patrick" <patrick at xsinet.com>
To: <rrd-users at list.ee.ethz.ch>
Sent: Friday, June 29, 2001 2:29 PM
Subject: [rrd-users] DNS Querie ( NEWBIE )


>
> hi this is a stupid question and im just starting with rrdtool
> this is what i would like 2 do
>
> i have a log which contains client connections 2 my dns server
> i would like 2 graph these
> what i would like 2 do is somthing like this
>
> EG of dns log
>
> Jun 29 08:00:01.091 client: client 196.15.188.132#64705: UDP request
> Jun 29 08:00:01.093 client: client 196.15.188.132#64705: query
> Jun 29 08:00:01.094 client: client 196.15.188.132#64705: send
> Jun 29 08:00:01.094 client: client 196.15.188.132#64705: sendto
> Jun 29 08:00:01.094 client: client 196.15.188.132#64705: senddone
> Jun 29 08:00:01.094 client: client 196.15.188.132#64705: next
> Jun 29 08:00:01.094 client: client 196.15.188.132#64705: endrequest
> Jun 29 08:00:01.565 client: client 196.15.188.132#64705: UDP request
> Jun 29 08:00:01.566 client: client 196.15.188.132#64705: query
> Jun 29 08:00:01.566 client: client 196.15.188.132#64705: send
> Jun 29 08:00:01.567 client: client 196.15.188.132#64705: sendto
> Jun 29 08:00:01.567 client: client 196.15.188.132#64705: senddone
> Jun 29 08:00:01.567 client: client 196.15.188.132#64705: next
> Jun 29 08:00:01.567 client: client 196.15.188.132#64705: endrequest
>
> that is 2 requests i would like 2 grep out the UDP's and then graph
> those
> i get about 1 000 000 in 24 hours
>
> ne ideas on where 2 get started
>
> Many Thanks Patrick
>
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Patrick
> XSInet Hostmaster
> Tel. 27 21 975 7001 (Ext 235)
> Fax. 27 21 975 5333
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> ------------------------------------------------------------
> Get your own free Internet access at http://www.xsinet.co.za/
> ------------------------------------------------------------
> Internet  communications  are  not  secure  and therefore the
> XSInet  does not accept legal responsibility for the contents
> of this  message. Any views or opinions presented are  solely
> those  of  the  author  and  do not   necessarily   represent
> those  of  XSInet.  The XSInet  e-mail facility  may  not  be
> used  for  the  distribution  of  chain  letters or offensive
> e-mail.   XSInet   hereby distances itself from  and  accepts
> no liability for the unauthorized use of its  e-mail facility
> or  the  sending  of  e-mail  communications for  other  than
> strictly  business  purposes.  Every possible precaution  has
> been  taken  to  ensure  that  this  message  is virus  free,
> however  XSInet can
>
>
>
>
> --
> Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
> Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
> Archive     http://www.ee.ethz.ch/~slist/rrd-users
> WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi


--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi