BIND 9.7 (only) host template

Templates, scripts for templates, scripts and requests for templates.

Moderators: Moderators, Developers

Author
Message
User avatar
timi
Cacti User
Posts: 240
Joined: Wed Nov 09, 2005 8:35 am
Location: Timisoara, Romania
Contact:

BIND 9.7 (only) host template

#1 Post by timi » Fri Dec 16, 2011 7:39 am

see my signature for downloads
Attachments
rtt.png
rtt.png (57.22 KiB) Viewed 21335 times
resolver.png
resolver.png (70.24 KiB) Viewed 21335 times
queries.png
queries.png (68.7 KiB) Viewed 21335 times
io.png
io.png (50.1 KiB) Viewed 21335 times
Last edited by timi on Wed Oct 17, 2012 12:02 am, edited 1 time in total.

exseven
Posts: 13
Joined: Tue Jun 24, 2008 9:57 am

Re: BIND 9.7 host template

#2 Post by exseven » Fri Dec 16, 2011 1:01 pm

I edited your data template so i can have different community strings.

attached is the new data template

also changed the community string to variable $2 in bind-stats.pl

Code: Select all

#!/bin/sh

# $1=hostname $2=community string

/usr/local/bin/snmpget -v 2c -Ovq -c $2 $1 .1.3.6.1.4.1.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.1 | sed 's/"//g'
Attachments
cacti_data_template_bind_stats.xml
(33.57 KiB) Downloaded 2035 times

alanlopes
Posts: 6
Joined: Wed Aug 24, 2011 11:05 am

Re: BIND 9.7 host template

#3 Post by alanlopes » Fri Jan 27, 2012 12:33 pm

Hi, I need your help. I did what you said:
1) Unzip
2) Import XML file
3) add in snmpd.conf on bind server this: extend .1.3.6.1.4.1.18689.0.1 dnscache-stats /root/bin/runstats.sh
4) copy runstats.sh and dnsstats.pl to /root/bin on bind server, make them executable and make sure named.stats is in /var/cache/bind (this one I changed to other directory, editing runstats.sh)
5) copy bind-stats.sh to <path_cacti>/scripts/



But...
Nothing appears on my graphs. Did I make something wrong?
Missing anything else?

User avatar
timi
Cacti User
Posts: 240
Joined: Wed Nov 09, 2005 8:35 am
Location: Timisoara, Romania
Contact:

Re: BIND 9.7 host template

#4 Post by timi » Mon Jan 30, 2012 2:38 am

run the script runstats.sh and see if you get any results, if all the values are showen then go the cacti server and run the script bind-stats.sh if you get all the values
then it should work

alanlopes
Posts: 6
Joined: Wed Aug 24, 2011 11:05 am

Re: BIND 9.7 host template

#5 Post by alanlopes » Mon Jan 30, 2012 10:07 am

timi, thanks for your answer.


I tried like this:
./bind-stats.sh MY-IP
But there is no answer from host


Then I changed the community in the script:

/usr/bin/snmpget -v 2c -Ovq -c my-community $1 .1.3.6.1.4.1.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.1 | sed 's/"//g'

And tried again:
./bind-stats.sh MY-IP
No Such Object available on this agent at this OID

I think there is a problem with this OID.

User avatar
timi
Cacti User
Posts: 240
Joined: Wed Nov 09, 2005 8:35 am
Location: Timisoara, Romania
Contact:

Re: BIND 9.7 host template

#6 Post by timi » Mon Jan 30, 2012 10:16 am

did you restart snmpd after modifing the snmpd.conf ? can you snmpwalk 1.3.6.1.4.1.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 ? my snmpd version is 5.4.3

alanlopes
Posts: 6
Joined: Wed Aug 24, 2011 11:05 am

Re: BIND 9.7 host template

#7 Post by alanlopes » Mon Jan 30, 2012 12:16 pm

Yes, I did restart.

I added the line inthe end of snmpd.conf:
extend .1.3.6.1.4.1.18689.0.1 dnscache-stats /root/bin/runstats.sh
And restarted snmpd


When a run snmpwalk?
# snmpwalk -v2c -c my-community my-IP 1.3.6.1.4.1.18689.0.1
SNMPv2-SMI::enterprises.18689.0.1 = No more variables left in this MIB View (It is past the end of the MIB tree)

alanlopes
Posts: 6
Joined: Wed Aug 24, 2011 11:05 am

Re: BIND 9.7 host template

#8 Post by alanlopes » Tue Jan 31, 2012 10:07 am

I forgot to say: my BIND is 9.3.6

User avatar
timi
Cacti User
Posts: 240
Joined: Wed Nov 09, 2005 8:35 am
Location: Timisoara, Romania
Contact:

Re: BIND 9.7 host template

#9 Post by timi » Tue Jan 31, 2012 10:17 am

well read the title, this template only work with bind 9.7

kdmillerii
Posts: 12
Joined: Thu Nov 12, 2009 9:40 am
Location: University Park, PA

Re: BIND 9.7 host template

#10 Post by kdmillerii » Thu Feb 16, 2012 5:07 pm

when i walk...
SNMPv2-SMI::enterprises.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.1 = STRING: "/tmp/runstats.sh: Permission denied"

bdestephen
Posts: 2
Joined: Tue Sep 27, 2011 7:08 pm
Location: Ohio

Re: BIND 9.7 host template

#11 Post by bdestephen » Sat Mar 03, 2012 3:00 pm

Edit: See post 16 for solution.




I too am having some issues with the permissions via a snmp walk from my cacti box. Remote error is first, while the local succes is second. Other remote queries are working/graphing correctly. When running the scripts locally, output is returned. "sudo rndc stats" works successfully as well. It is not a high volume system at this time.

I have attempted adding the file locations (bind and scripts) to the /etc/sudoers file as well as associating the scripts to different groups without success. I think the issue revolves around the SNMP query running the script as a root process. Some searching led me to the sudoers file and permissions, but I have been unsuccessful.

While not a complete newbie, I certainly am not an expert. Any suggestions?

Ubuntu 10.04.4 64bit; Bind 9.7



Walk Error:

<user (non root)>@cacti:~$ snmpwalk -v2c -c <key> <IP> 1.3.6.1.4.1.18689.0.1
SNMPv2-SMI::enterprises.18689.0.1.1.0 = INTEGER: 3
SNMPv2-SMI::enterprises.18689.0.1.2.1.2.4.114.110.100.99 = STRING: "/etc/bind/rndc.key"
SNMPv2-SMI::enterprises.18689.0.1.2.1.2.11.110.97.109.101.100.46.115.116.97.116.115 = STRING: "/var/cache/bind/named.stats"
SNMPv2-SMI::enterprises.18689.0.1.2.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = STRING: "/usr/bin/runstats.sh"
SNMPv2-SMI::enterprises.18689.0.1.2.1.3.4.114.110.100.99 = ""
SNMPv2-SMI::enterprises.18689.0.1.2.1.3.11.110.97.109.101.100.46.115.116.97.116.115 = ""
SNMPv2-SMI::enterprises.18689.0.1.2.1.3.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = ""
SNMPv2-SMI::enterprises.18689.0.1.2.1.4.4.114.110.100.99 = ""
SNMPv2-SMI::enterprises.18689.0.1.2.1.4.11.110.97.109.101.100.46.115.116.97.116.115 = ""
SNMPv2-SMI::enterprises.18689.0.1.2.1.4.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = ""
SNMPv2-SMI::enterprises.18689.0.1.2.1.5.4.114.110.100.99 = INTEGER: 5
SNMPv2-SMI::enterprises.18689.0.1.2.1.5.11.110.97.109.101.100.46.115.116.97.116.115 = INTEGER: 5
SNMPv2-SMI::enterprises.18689.0.1.2.1.5.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = INTEGER: 5
SNMPv2-SMI::enterprises.18689.0.1.2.1.6.4.114.110.100.99 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.2.1.6.11.110.97.109.101.100.46.115.116.97.116.115 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.2.1.6.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.2.1.7.4.114.110.100.99 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.2.1.7.11.110.97.109.101.100.46.115.116.97.116.115 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.2.1.7.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.2.1.20.4.114.110.100.99 = INTEGER: 4
SNMPv2-SMI::enterprises.18689.0.1.2.1.20.11.110.97.109.101.100.46.115.116.97.116.115 = INTEGER: 4
SNMPv2-SMI::enterprises.18689.0.1.2.1.20.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = INTEGER: 4
SNMPv2-SMI::enterprises.18689.0.1.2.1.21.4.114.110.100.99 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.2.1.21.11.110.97.109.101.100.46.115.116.97.116.115 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.2.1.21.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.3.1.1.4.114.110.100.99 = STRING: "/etc/bind/rndc.key: Permission denied"
SNMPv2-SMI::enterprises.18689.0.1.3.1.1.11.110.97.109.101.100.46.115.116.97.116.115 = STRING: "/var/cache/bind/named.stats: Permission denied"
SNMPv2-SMI::enterprises.18689.0.1.3.1.1.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = STRING: "rm: cannot remove `/var/cache/bind/named.stats': Permission denied"
SNMPv2-SMI::enterprises.18689.0.1.3.1.2.4.114.110.100.99 = STRING: "/etc/bind/rndc.key: Permission denied"
SNMPv2-SMI::enterprises.18689.0.1.3.1.2.11.110.97.109.101.100.46.115.116.97.116.115 = STRING: "/var/cache/bind/named.stats: Permission denied"
SNMPv2-SMI::enterprises.18689.0.1.3.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = STRING: "rm: cannot remove `/var/cache/bind/named.stats': Permission denied
rndc: error: none:0: open: /etc/bind/rndc.key: permission denied
rndc: could not load rndc configuration
a:0 a6:0 aaaa:0 any:0 cname:0 mx:0 naptr:0 ns:1 ptr:2 soa:0 spf:0 srv:0 txt:0 rsnx:1 rsfail: rserr: rsipv4qs:2 rsipv4rr:2 rsmismatch: rsqr: rsqt: rsrtt10: rsrtt100500: rsrtt10100:2 rsrtt1600: rsrtt500800: rsrtt8001600: sockopen:4 sockclosed:2 sockbf: consest:2 recverr:"
SNMPv2-SMI::enterprises.18689.0.1.3.1.3.4.114.110.100.99 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.3.1.3.11.110.97.109.101.100.46.115.116.97.116.115 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.3.1.3.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = INTEGER: 4
SNMPv2-SMI::enterprises.18689.0.1.3.1.4.4.114.110.100.99 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.3.1.4.11.110.97.109.101.100.46.115.116.97.116.115 = INTEGER: 1
SNMPv2-SMI::enterprises.18689.0.1.3.1.4.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115 = INTEGER: 0
SNMPv2-SMI::enterprises.18689.0.1.4.1.2.4.114.110.100.99.1 = STRING: "/etc/bind/rndc.key: Permission denied"
SNMPv2-SMI::enterprises.18689.0.1.4.1.2.11.110.97.109.101.100.46.115.116.97.116.115.1 = STRING: "/var/cache/bind/named.stats: Permission denied"
SNMPv2-SMI::enterprises.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.1 = STRING: "rm: cannot remove `/var/cache/bind/named.stats': Permission denied"
SNMPv2-SMI::enterprises.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.2 = STRING: "rndc: error: none:0: open: /etc/bind/rndc.key: permission denied"
SNMPv2-SMI::enterprises.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.3 = STRING: "rndc: could not load rndc configuration"
SNMPv2-SMI::enterprises.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.4 = STRING: "a:0 a6:0 aaaa:0 any:0 cname:0 mx:0 naptr:0 ns:1 ptr:2 soa:0 spf:0 srv:0 txt:0 rsnx:1 rsfail: rserr: rsipv4qs:2 rsipv4rr:2 rsmismatch: rsqr: rsqt: rsrtt10: rsrtt100500: rsrtt10100:2 rsrtt1600: rsrtt500800: rsrtt8001600: sockopen:4 sockclosed:2 sockbf: consest:2 recverr:"
<user (not root)>@cacti:~$


Local run:

<user (not root)>@dns2:/usr/bin$ sudo sh runstats.sh
a:0 a6:0 aaaa:0 any:0 cname:0 mx:0 naptr:0 ns:1 ptr:2 soa:0 spf:0 srv:0 txt:0 rsnx:1 rsfail: rserr: rsipv4qs:2 rsipv4rr:2 rsmismatch: rsqr: rsqt: rsrtt10: rsrtt100500: rsrtt10100:2 rsrtt1600: rsrtt500800: rsrtt8001600: sockopen:4 sockclosed:2 sockbf: consest:2 recverr:<user (not root)>@dns2:/usr/bin$
Last edited by bdestephen on Wed Mar 14, 2012 9:18 pm, edited 1 time in total.

georgezip
Posts: 3
Joined: Sun Mar 11, 2012 7:01 am

Re: BIND 9.7 host template

#12 Post by georgezip » Sun Mar 11, 2012 7:11 am

Hey,
my graphs are empty but :

I can do:

snmpwalk -v 2c -Ovq -c public localhost .1.3.6.1.4.1.18689.0.1
1
"/root/bin/runstats.sh"
""
""
5
1
1
4
1
"Incoming Queries:++ Incoming Queries ++"
"Incoming Queries:++ Incoming Queries ++
Incoming Queries:152 A
Incoming Queries:8 NS
Incoming Queries:1 PTR
Incoming Queries:7 MX
Incoming Queries:5 TXT
Incoming Queries:40 AAAA
Outgoing Queries:++ Outgoing Queries ++
Outgoing Queries:[View: default]
Outgoing Queries:237 A
Outgoing Queries:11 NS
Outgoing Queries:5 PTR
Outgoing Queries:4 TXT
Outgoing Queries:134 AAAA
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Resolver Statistics:++ Resolver Statistics ++
Resolver Statistics:[Common]
Resolver Statistics:[View: default]
Resolver Statistics:322 IPv4 queries sent
Resolver Statistics:69 IPv6 queries sent
Resolver Statistics:279 IPv4 responses received
Resolver Statistics:16 NXDOMAIN received
Resolver Statistics:127 query retries
Resolver Statistics:43 query timeouts
Resolver Statistics:61 IPv4 NS address fetches
Resolver Statistics:63 IPv6 NS address fetches
Resolver Statistics:25 IPv6 NS address fetch failed
Resolver Statistics:152 queries with RTT 10-100ms
Resolver Statistics:126 queries with RTT 100-500ms
Resolver Statistics:1 queries with RTT 500-800ms
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Socket I/O Statistics:++ Socket I/O Statistics ++
Socket I/O Statistics:328 UDP/IPv4 sockets opened
Socket I/O Statistics:70 UDP/IPv6 sockets opened
Socket I/O Statistics:7 TCP/IPv4 sockets opened
Socket I/O Statistics:1 TCP/IPv6 sockets opened
Socket I/O Statistics:322 UDP/IPv4 sockets closed
Socket I/O Statistics:69 UDP/IPv6 sockets closed
Socket I/O Statistics:87 TCP/IPv4 sockets closed
Socket I/O Statistics:69 UDP/IPv6 socket connect failures
Socket I/O Statistics:322 UDP/IPv4 connections established
Socket I/O Statistics:88 TCP/IPv4 connections accepted
Socket I/O Statistics:69 UDP/IPv6 send errors
Socket I/O Statistics:69 UDP/IPv6 send errors
Socket I/O Statistics:69 UDP/IPv6 send errors
a:389 a6:0 aaaa:174 any:0 cname:0 mx:7 naptr:0 ns:19 ptr:6 soa:0 spf:0 srv:0 txt:9 rsnx:16 rsfail: rserr: rsipv4qs:322 rsipv4rr:279 rsmismatch: rsqr:127 rsqt:43 rsrtt10: rsrtt100500:126 rsrtt10100:152 rsrtt1600: rsrtt500800:1 rsrtt8001600: sockopen:328 sockclosed:322 sockbf: consest:322 recverr:"
73
0
"Incoming Queries:++ Incoming Queries ++"
"Incoming Queries:152 A"
"Incoming Queries:8 NS"
"Incoming Queries:1 PTR"
"Incoming Queries:7 MX"
"Incoming Queries:5 TXT"
"Incoming Queries:40 AAAA"
"Outgoing Queries:++ Outgoing Queries ++"
"Outgoing Queries:[View: default]"
"Outgoing Queries:237 A"
"Outgoing Queries:11 NS"
"Outgoing Queries:5 PTR"
"Outgoing Queries:4 TXT"
"Outgoing Queries:134 AAAA"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Resolver Statistics:++ Resolver Statistics ++"
"Resolver Statistics:[Common]"
"Resolver Statistics:[View: default]"
"Resolver Statistics:322 IPv4 queries sent"
"Resolver Statistics:69 IPv6 queries sent"
"Resolver Statistics:279 IPv4 responses received"
"Resolver Statistics:16 NXDOMAIN received"
"Resolver Statistics:127 query retries"
"Resolver Statistics:43 query timeouts"
"Resolver Statistics:61 IPv4 NS address fetches"
"Resolver Statistics:63 IPv6 NS address fetches"
"Resolver Statistics:25 IPv6 NS address fetch failed"
"Resolver Statistics:152 queries with RTT 10-100ms"
"Resolver Statistics:126 queries with RTT 100-500ms"
"Resolver Statistics:1 queries with RTT 500-800ms"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Socket I/O Statistics:++ Socket I/O Statistics ++"
"Socket I/O Statistics:328 UDP/IPv4 sockets opened"
"Socket I/O Statistics:70 UDP/IPv6 sockets opened"
"Socket I/O Statistics:7 TCP/IPv4 sockets opened"
"Socket I/O Statistics:1 TCP/IPv6 sockets opened"
"Socket I/O Statistics:322 UDP/IPv4 sockets closed"
"Socket I/O Statistics:69 UDP/IPv6 sockets closed"
"Socket I/O Statistics:87 TCP/IPv4 sockets closed"
"Socket I/O Statistics:69 UDP/IPv6 socket connect failures"
"Socket I/O Statistics:322 UDP/IPv4 connections established"
"Socket I/O Statistics:88 TCP/IPv4 connections accepted"
"Socket I/O Statistics:69 UDP/IPv6 send errors"
"Socket I/O Statistics:69 UDP/IPv6 send errors"
"Socket I/O Statistics:69 UDP/IPv6 send errors"
"a:389 a6:0 aaaa:174 any:0 cname:0 mx:7 naptr:0 ns:19 ptr:6 soa:0 spf:0 srv:0 txt:9 rsnx:16 rsfail: rserr: rsipv4qs:322 rsipv4rr:279 rsmismatch: rsqr:127 rsqt:43 rsrtt10: rsrtt100500:126 rsrtt10100:152 rsrtt1600: rsrtt500800:1 rsrtt8001600: sockopen:328 sockclosed:322 sockbf: consest:322 recverr:"

/usr/bin/snmpget -v 2c -Ovq -c public localhost .1.3.6.1.4.1.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.1
"Incoming Queries:++ Incoming Queries ++"


also I can:

/usr/share/cacti/site/scripts$ snmpwalk -v 2c -Ovq -c public localhost .1.3.6.1.4.1.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115
"Incoming Queries:++ Incoming Queries ++"
"Incoming Queries:314 A"
"Incoming Queries:15 NS"
"Incoming Queries:2 PTR"
"Incoming Queries:24 MX"
"Incoming Queries:40 TXT"
"Incoming Queries:44 AAAA"
"Incoming Queries:10 SPF"
"Outgoing Queries:++ Outgoing Queries ++"
"Outgoing Queries:[View: default]"
"Outgoing Queries:454 A"
"Outgoing Queries:17 NS"
"Outgoing Queries:10 PTR"
"Outgoing Queries:1 MX"
"Outgoing Queries:42 TXT"
"Outgoing Queries:300 AAAA"
"Outgoing Queries:2 SPF"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Outgoing Queries:[View: _bind]"
"Resolver Statistics:++ Resolver Statistics ++"
"Resolver Statistics:[Common]"
"Resolver Statistics:[View: default]"
"Resolver Statistics:716 IPv4 queries sent"
"Resolver Statistics:110 IPv6 queries sent"
"Resolver Statistics:666 IPv4 responses received"
"Resolver Statistics:57 NXDOMAIN received"
"Resolver Statistics:185 query retries"
"Resolver Statistics:50 query timeouts"
"Resolver Statistics:165 IPv4 NS address fetches"
"Resolver Statistics:167 IPv6 NS address fetches"
"Resolver Statistics:1 IPv4 NS address fetch failed"
"Resolver Statistics:97 IPv6 NS address fetch failed"
"Resolver Statistics:264 queries with RTT 10-100ms"
"Resolver Statistics:400 queries with RTT 100-500ms"
"Resolver Statistics:1 queries with RTT 500-800ms"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Resolver Statistics:[View: _bind]"
"Socket I/O Statistics:++ Socket I/O Statistics ++"
"Socket I/O Statistics:722 UDP/IPv4 sockets opened"
"Socket I/O Statistics:111 UDP/IPv6 sockets opened"
"Socket I/O Statistics:7 TCP/IPv4 sockets opened"
"Socket I/O Statistics:1 TCP/IPv6 sockets opened"
"Socket I/O Statistics:716 UDP/IPv4 sockets closed"
"Socket I/O Statistics:110 UDP/IPv6 sockets closed"
"Socket I/O Statistics:94 TCP/IPv4 sockets closed"
"Socket I/O Statistics:110 UDP/IPv6 socket connect failures"
"Socket I/O Statistics:716 UDP/IPv4 connections established"
"Socket I/O Statistics:95 TCP/IPv4 connections accepted"
"Socket I/O Statistics:110 UDP/IPv6 send errors"
"Socket I/O Statistics:1 UDP/IPv4 recv errors"
"Socket I/O Statistics:1 UDP/IPv4 recv errors"
"Socket I/O Statistics:1 UDP/IPv4 recv errors"
"a:768 a6:0 aaaa:344 any:0 cname:0 mx:25 naptr:0 ns:32 ptr:12 soa:0 spf:12 srv:0 txt:82 rsnx:57 rsfail: rserr: rsipv4qs:716 rsipv4rr:666 rsmismatch: rsqr:185 rsqt:50 rsrtt10: rsrtt100500:400 rsrtt10100:264 rsrtt1600: rsrtt500800:1 rsrtt8001600: sockopen:722 sockclosed:716 sockbf: consest:716 recverr:1"

and /root/bin/runstats.sh

usr/share/cacti/site/scripts$ /root/bin/runstats.sh
Incoming Queries:++ Incoming Queries ++
Incoming Queries:314 A
Incoming Queries:15 NS
Incoming Queries:2 PTR
Incoming Queries:24 MX
Incoming Queries:40 TXT
Incoming Queries:44 AAAA
Incoming Queries:10 SPF
Outgoing Queries:++ Outgoing Queries ++
Outgoing Queries:[View: default]
Outgoing Queries:454 A
Outgoing Queries:17 NS
Outgoing Queries:10 PTR
Outgoing Queries:1 MX
Outgoing Queries:42 TXT
Outgoing Queries:300 AAAA
Outgoing Queries:2 SPF
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Outgoing Queries:[View: _bind]
Resolver Statistics:++ Resolver Statistics ++
Resolver Statistics:[Common]
Resolver Statistics:[View: default]
Resolver Statistics:716 IPv4 queries sent
Resolver Statistics:110 IPv6 queries sent
Resolver Statistics:666 IPv4 responses received
Resolver Statistics:57 NXDOMAIN received
Resolver Statistics:185 query retries
Resolver Statistics:50 query timeouts
Resolver Statistics:165 IPv4 NS address fetches
Resolver Statistics:167 IPv6 NS address fetches
Resolver Statistics:1 IPv4 NS address fetch failed
Resolver Statistics:97 IPv6 NS address fetch failed
Resolver Statistics:264 queries with RTT 10-100ms
Resolver Statistics:400 queries with RTT 100-500ms
Resolver Statistics:1 queries with RTT 500-800ms
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Resolver Statistics:[View: _bind]
Socket I/O Statistics:++ Socket I/O Statistics ++
Socket I/O Statistics:722 UDP/IPv4 sockets opened
Socket I/O Statistics:111 UDP/IPv6 sockets opened
Socket I/O Statistics:7 TCP/IPv4 sockets opened
Socket I/O Statistics:1 TCP/IPv6 sockets opened
Socket I/O Statistics:716 UDP/IPv4 sockets closed
Socket I/O Statistics:110 UDP/IPv6 sockets closed
Socket I/O Statistics:95 TCP/IPv4 sockets closed
Socket I/O Statistics:110 UDP/IPv6 socket connect failures
Socket I/O Statistics:716 UDP/IPv4 connections established
Socket I/O Statistics:96 TCP/IPv4 connections accepted
Socket I/O Statistics:110 UDP/IPv6 send errors
Socket I/O Statistics:1 UDP/IPv4 recv errors
Socket I/O Statistics:1 UDP/IPv4 recv errors
Socket I/O Statistics:1 UDP/IPv4 recv errors
a:768 a6:0 aaaa:344 any:0 cname:0 mx:25 naptr:0 ns:32 ptr:12 soa:0 spf:12 srv:0 txt:82 rsnx:57 rsfail: rserr: rsipv4qs:716 rsipv4rr:666 rsmismatch: rsqr:185 rsqt:50 rsrtt10: rsrtt100500:400 rsrtt10100:264 rsrtt1600: rsrtt500800:1 rsrtt8001600: sockopen:722 sockclosed:716 sockbf: consest:716 recverr:1


what I did wrong? could you compare above command with mine? please help cuz I tryin to figure it out 3rd day and I'm gettin tired of this m****** :)

of course i'm using bind 9.7.3

georgezip
Posts: 3
Joined: Sun Mar 11, 2012 7:01 am

Re: BIND 9.7 host template

#13 Post by georgezip » Sun Mar 11, 2012 12:45 pm

in my cause i had to change oid from....115.1 to 115.82 in bind-stats. I don't know why but it works now.

User avatar
timi
Cacti User
Posts: 240
Joined: Wed Nov 09, 2005 8:35 am
Location: Timisoara, Romania
Contact:

Re: BIND 9.7 host template

#14 Post by timi » Tue Mar 13, 2012 5:59 am

runstats.sh should return something like "a:17167686897 a6:53754 aaaa:3689981833 any:1352142622 cname:1365281 mx:125851716 naptr:154009 ns:1393 ptr:797888771 soa:9302499 spf:3286476 srv:40069222 txt:51757159 rsnx:207275535 rsfail:36883538 rserr:1060725 rsipv4qs:2158126215 rsipv4rr:2075319772 rsmismatch:8674439 rsqr:183630056 rsqt:84041977 rsrtt10:215797754 rsrtt100500:684815276 rsrtt10100:1155013956 rsrtt1600:224065 rsrtt500800:5259455 rsrtt8001600:270739 sockopen:2163965593 sockclosed:2163965413 sockbf:6041455 consest:2157924135 recverr:13938627"

if not, there is a problem with your stats

georgezip
Posts: 3
Joined: Sun Mar 11, 2012 7:01 am

Re: BIND 9.7 host template

#15 Post by georgezip » Tue Mar 13, 2012 6:23 am

I've got a solution, on my system (debian) I have to read named.stats from end to begining (so I've edit runstats.sh like this:
in line: cat /var/cache/named.stats | /root/bin/dnsstats.pl | sed 1!G;h;$!d!
and now
under OID 115.1 I have got what I need and graphs are drawing now.
before change under OID 115.1 was
/usr/bin/snmpget -v 2c -Ovq -c public localhost .1.3.6.1.4.1.18689.0.1.4.1.2.14.100.110.115.99.97.99.104.101.45.115.116.97.116.115.1
"Incoming Queries:++ Incoming Queries ++"

but cacti was expected something like this:

a:768 a6:0 aaaa:344 any:0 cname:0 mx:25 naptr:0 ns:32 ptr:12 soa:0 spf:12 srv:0 txt:82 rsnx:57 rsfail: rserr: rsipv4qs:716 rsipv4rr:666 rsmismatch: rsqr:185 rsqt:50 rsrtt10: rsrtt100500:400 rsrtt10100:264 rsrtt1600: rsrtt500800:1 rsrtt8001600: sockopen:722 sockclosed:716 sockbf: consest:716 recverr:1

Post Reply