BIND 9 stats remote with SSH ( without using SNMP )

[niobe]

Please see my update for bind 9.6 in sig below.
cheers,
N

[Mattz0r]

Hey there

I'm currently confused about this,

I'm trying to get this working, as a dns graph would be awesome right now!

Code: Select all

02/05/2012 12:56:24 PM - SPINE: Poller[0] Host[4] ERROR: Empty result [fr-01.get-sourced.net]: '/usr/share/cacti/site/scripts/AF/ssh-dns-bind95-stats.pl -h fr-01.get-sourced.net -u root'
02/05/2012 12:56:24 PM - SPINE: Poller[0] Host[4] DS[141] SCRIPT: /usr/share/cacti/site/scripts/AF/ssh-dns-bind95-stats.pl -h fr-01.get-sourced.net -u root, output: U
02/05/2012 12:56:24 PM - SPINE: Poller[0] Host[4] DEBUG: The NIFTY POPEN returned the following File Descriptor 7
02/05/2012 12:56:24 PM - SPINE: Poller[0] Host[4] ERROR: Empty result [fr-01.get-sourced.net]: '/usr/share/cacti/site/scripts/AF/ssh-dns-bind95-stats.pl -h fr-01.get-sourced.net -u root'

That is what is being displayed in the cacti.log

However, when I run that manually.....

Code: Select all

root@fr-02:/usr/share/cacti/site/scripts/AF# perl ssh-dns-bind95-stats.pl -h fr-01.get-sourced.net -u root
WARNING: key file (/etc/rndc.key) exists, but using default configuration file (/etc/rndc.conf)
A:102096 AAAA:36324 ANY:7765 AXFR:0 CNAME:23 IXFR:0 MX:1463 NS:993 PTR:9590 SOA:5 SRV:12 TXT:792 success:159751 nonauthoritative:20596 errors:41874 nxdomain:10986 recursion:5240 dropped:0

It works fine?

Regards,

Matt


EDIT: Found the updated xml file - Imported it, however... it's still borked.

The new log file states this:

Code: Select all

02/05/2012 01:40:55 PM - SPINE: Poller[0] Host[4] DS[141] SCRIPT: /usr/share/cacti/site/scripts/AF/ssh-dns-bind95-stats.pl -h fr-01.get-sourced.net -u root, output: A:102445 AAAA:36456 ANY:7766 AXFR:0 CNAME:23 IXFR:0 MX:1464 NS:999 PTR:9616 SOA:5 SRV:12 TXT:792 success:160266 nonauthoritative:20648 errors:41984 nxdomain:11033 recursion:5244 dropped:0

02/05/2012 01:40:55 PM - SPINE: Poller[0] Host[4] DEBUG: The NIFTY POPEN returned the following File Descriptor 7

Code: Select all

RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title='fr-01.get-sourced.net - Queries by minute & by type' \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label='Queries / min' \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":ANY:AVERAGE \
DEF:b="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":MX:AVERAGE \
DEF:c="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":NS:AVERAGE \
DEF:d="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":SOA:AVERAGE \
DEF:e="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":SRV:AVERAGE \
DEF:f="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":AXFR:AVERAGE \
DEF:g="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":IXFR:AVERAGE \
DEF:h="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":PTR:AVERAGE \
DEF:i="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":AAAA:AVERAGE \
DEF:j="/var/lib/cacti/rra/fr-01_get-sourced_net_cname_143.rrd":A:AVERAGE \
CDEF:cdefa=a,60,* \
CDEF:cdefe=b,60,* \
CDEF:cdefi=c,60,* \
CDEF:cdefbc=d,60,* \
CDEF:cdefbg=e,60,* \
CDEF:cdefca=f,60,* \
CDEF:cdefce=g,60,* \
CDEF:cdefci=h,60,* \
CDEF:cdefdc=i,60,* \
CDEF:cdefdg=j,60,* \
CDEF:cdefea=TIME,1328446474,GT,a,a,UN,0,a,IF,IF,TIME,1328446474,GT,b,b,UN,0,b,IF,IF,TIME,1328446474,GT,c,c,UN,0,c,IF,IF,TIME,1328446474,GT,d,d,UN,0,d,IF,IF,TIME,1328446474,GT,e,e,UN,0,e,IF,IF,TIME,1328446474,GT,f,f,UN,0,f,IF,IF,TIME,1328446474,GT,g,g,UN,0,g,IF,IF,TIME,1328446474,GT,h,h,UN,0,h,IF,IF,TIME,1328446474,GT,i,i,UN,0,i,IF,IF,TIME,1328446474,GT,j,j,UN,0,j,IF,IF,+,+,+,+,+,+,+,+,+,60,* \
AREA:cdefa#FFF200FF:"ANY"  \
GPRINT:cdefa:LAST:"  Now \:%8.2lf"  \
GPRINT:cdefa:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefa:MAX:"Max \:%8.2lf\n"  \
AREA:cdefe#FFF200FF:"MX":STACK \
GPRINT:cdefe:LAST:"   Now \:%8.2lf"  \
GPRINT:cdefe:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefe:MAX:"Max \:%8.2lf\n"  \
AREA:cdefi#FFF200FF:"NS":STACK \
GPRINT:cdefi:LAST:"   Now \:%8.2lf"  \
GPRINT:cdefi:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefi:MAX:"Max \:%8.2lf\n"  \
AREA:cdefbc#FFF200FF:"SOA":STACK \
GPRINT:cdefbc:LAST:"  Now \:%8.2lf"  \
GPRINT:cdefbc:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefbc:MAX:"Max \:%8.2lf\n"  \
AREA:cdefbg#FFF200FF:"SRV":STACK \
GPRINT:cdefbg:LAST:"  Now \:%8.2lf"  \
GPRINT:cdefbg:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefbg:MAX:"Max \:%8.2lf\n"  \
AREA:cdefca#FFC3C0FF:"AXFR":STACK \
GPRINT:cdefca:LAST:" Now \:%8.2lf"  \
GPRINT:cdefca:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefca:MAX:"Max \:%8.2lf\n"  \
AREA:cdefce#FFC3C0FF:"IXFR":STACK \
GPRINT:cdefce:LAST:" Now \:%8.2lf"  \
GPRINT:cdefce:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefce:MAX:"Max \:%8.2lf\n"  \
AREA:cdefci#FFAB00FF:"PTR":STACK \
GPRINT:cdefci:LAST:"  Now \:%8.2lf"  \
GPRINT:cdefci:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefci:MAX:"Max \:%8.2lf\n"  \
AREA:cdefdc#FF5576FF:"AAAA":STACK \
GPRINT:cdefdc:LAST:" Now \:%8.2lf"  \
GPRINT:cdefdc:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefdc:MAX:"Max \:%8.2lf\n"  \
AREA:cdefdg#FF5576FF:"A":STACK \
GPRINT:cdefdg:LAST:"    Now \:%8.2lf"  \
GPRINT:cdefdg:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefdg:MAX:"Max \:%8.2lf\n"  \
LINE1:cdefea#000000FF:"Total"  \
GPRINT:cdefea:LAST:"Now \:%8.2lf"  \
GPRINT:cdefea:AVERAGE:"Avg \:%8.2lf"  \
GPRINT:cdefea:MAX:"Max \:%8.2lf" 
RRDTool Says:
OK