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" <[EMAIL PROTECTED]> To: <[email protected]> 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:[EMAIL PROTECTED] > Help mailto:[EMAIL PROTECTED] > Archive http://www.ee.ethz.ch/~slist/rrd-users > WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
