Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support
It is currently Fri Jul 25, 2014 6:18 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 37 posts ]  Go to page 1, 2, 3  Next
Author Message
 Post subject: PowerDNS Recursor Templates [updated 29/7/09]
PostPosted: Wed Jul 15, 2009 5:56 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4591
Location: United Kingdom
Here are a couple of graph templates for the PowerDNS recursor. They need a shell script to be installed on the DNS server, and an net-snmp config change.

Add the following to the snmpd.conf
Code:
extend pdns-rec /usr/local/bin/pdns_stats


Put pdns_stats in /usr/local/bin, so that snmpd can find it (rename from pdns_stats.txt). Make it executable.

Then import the templates.

You end up with two graphs - one showing queries/sec + cache efficiency, and another one showing "exceptions" - slow queries, resource limits hit, spoof detection, etc.

Update
I've uploaded a newer version of pdns_stats.txt which collects a few more statistics. You can use the existing templates with the new script, but the new version also allows you to use a couple more templates, which I've attached below. These are 'Performance' which shows the proportion of queries answered in particular time bands, and 'Concurrency' which shows the number of threads running.


Attachments:
cacti_graph_template_powerdns_recursor_-_concurrency.xml [12.25 KiB]
Downloaded 1025 times
cacti_graph_template_powerdns_recursor_-_performance.xml [39.32 KiB]
Downloaded 711 times
pdns_stats.txt [274 Bytes]
Downloaded 1366 times
cacti_graph_template_powerdns_recursor_-_exceptions.xml [34.75 KiB]
Downloaded 681 times
cacti_graph_template_powerdns_recursor_-_statistics.xml [23.44 KiB]
Downloaded 743 times

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Last edited by Howie on Wed Jul 29, 2009 4:41 am, edited 2 times in total.
Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 15, 2009 5:59 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4591
Location: United Kingdom
Some images from my testing.

Edit: Added the two new templates.


Attachments:
pdns-stats.png
pdns-stats.png [ 23.6 KiB | Viewed 13650 times ]
pdns-performance.png
pdns-performance.png [ 30.13 KiB | Viewed 13650 times ]
pdns-except.png
pdns-except.png [ 27.7 KiB | Viewed 13650 times ]
pdns-concurrency.png
pdns-concurrency.png [ 27.69 KiB | Viewed 13650 times ]

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Last edited by Howie on Wed Jul 29, 2009 4:40 am, edited 1 time in total.
Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 27, 2009 10:35 am 
Offline
Cacti User

Joined: Thu Mar 13, 2008 3:36 am
Posts: 112
Sweet - any chance of some templates / scripts for the authoritative part of powerdns?

Thanks - J.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 27, 2009 11:09 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4591
Location: United Kingdom
julian924s wrote:
Sweet - any chance of some templates / scripts for the authoritative part of powerdns?

Thanks - J.


I don't use that (yet). It'd be the same basic idea though, except with pdns_control instead of rec_control.

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 29, 2009 4:27 am 
Offline

Joined: Mon Jul 27, 2009 11:52 am
Posts: 8
Location: Netherlands
Maybe I'm wrong; but the statistics pulled from the recursor aren't reset so the lines are only going up ?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 29, 2009 4:30 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4591
Location: United Kingdom
xseries wrote:
Maybe I'm wrong; but the statistics pulled from the recursor aren't reset so the lines are only going up ?


You mean apart from the parts in the graph above that are clearly going down? :-)

No, the numbers from rec_control go up, but that's what the COUNTER type in Cacti/rrdtool is for.

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 29, 2009 4:35 am 
Offline

Joined: Mon Jul 27, 2009 11:52 am
Posts: 8
Location: Netherlands
Ah; ok; thanx !

But; before I can use it; i'll need to upgrade from 0.8.7b :-(


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 29, 2009 4:42 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4591
Location: United Kingdom
Yes, you will. I can't export from any other version that 0.8.7d, because that's what I am using...

Just added a couple more graph templates to the original post, too.

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 29, 2009 5:58 am 
Offline

Joined: Mon Jul 27, 2009 11:52 am
Posts: 8
Location: Netherlands
I;ve upgrade my cacti to most recent version; but there seems to be a problemen regarding snmpd :

ns0:/etc/snmp# snmpwalk -v2c -cpublic xxx.xxx.xxx.xxx pdns-rec
pdns-rec: Unknown Object Identifier (Sub-id not found: (top) -> pdns-rec)
ns0:/etc/snmp#

I've edited snmpd.conf and restarted it...
What's going wrong here ?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 29, 2009 6:09 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4591
Location: United Kingdom
xseries wrote:
I;ve upgrade my cacti to most recent version; but there seems to be a problemen regarding snmpd :

ns0:/etc/snmp# snmpwalk -v2c -cpublic xxx.xxx.xxx.xxx pdns-rec
pdns-rec: Unknown Object Identifier (Sub-id not found: (top) -> pdns-rec)
ns0:/etc/snmp#

I've edited snmpd.conf and restarted it...
What's going wrong here ?


That's not the OID. Try walking .1.3.6.1.4.1.8072.1.3.2.4.1.2

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 29, 2009 9:12 am 
Offline

Joined: Mon Jul 27, 2009 11:52 am
Posts: 8
Location: Netherlands
@Howie
After a upgrade to the latest cacti; changing some rights on files and directories and some more troubleshooting it's working :-)

Thanks !


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 11, 2009 1:21 pm 
Offline

Joined: Fri Sep 11, 2009 1:16 pm
Posts: 3
Location: Poland
xseries wrote:
@Howie
After a upgrade to the latest cacti; changing some rights on files and directories and some more troubleshooting it's working :-)

Thanks !


I have the same error. What have you done that worked?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 11, 2009 4:47 pm 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4591
Location: United Kingdom
tomasz.wostal wrote:
xseries wrote:
@Howie
After a upgrade to the latest cacti; changing some rights on files and directories and some more troubleshooting it's working :-)

Thanks !


I have the same error. What have you done that worked?


The error xseries had was using the wrong OID as far as I can see... :-?

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 12, 2009 12:22 am 
Offline

Joined: Fri Sep 11, 2009 1:16 pm
Posts: 3
Location: Poland
Howie wrote:
The error xseries had was using the wrong OID as far as I can see... :-?


I was walking this OID .1.3.6.1.4.1.8072.1.3.2.4.1.2. I will check my configuration one again :)


Top
 Profile  
 
 Post subject: Script for authoritative part of powerdns
PostPosted: Wed Sep 16, 2009 7:43 am 
Offline

Joined: Wed Sep 16, 2009 7:39 am
Posts: 1
Hello,

for the authoritative part of powerdns, you can't use pdns_control.
But, the Init-Script provide functionality for mrtg that you can use.

example: /etc/init.d/pdns mrtg udp-queries udp-answers

See pdns-Manual http://doc.powerdns.com/init-d-commands.html

And, sorry for my bad english :-)

Bye Amosery


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 37 posts ]  Go to page 1, 2, 3  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: Bing [Bot], um3n and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group