> Sent: 30 October, 2012 1:13 > > Sent: Monday, October 29, 2012 3:17 PM Op 29-10-12 15:03, Peter van > > Dijk schreef: > > > Hello, On Oct 29, 2012, at 9:35 , Peter van Dijk wrote: > > >> Depending on your needs, you could write a script to do the cleanup > > >> yourself. The last_check column is a decent indicator of master > > >> uptime, in the current implementation. Note that THIS MIGHT CHANGE. > > > If someone happens to have, or intends to write, such a script, we > > > would be happy to put it in our contrib/ dir and include something > > > in the docs about it. > > In 2010 Mark Scholten posted such a script on the list. It can be > > found in the archives: > > http://mailman.powerdns.com/pipermail/pdns-users/2010- > July/006866.html > > > > I've used the script (in testmode first) and works for me as well. > > We use a slightly changed version in production at this moment. It now also > removes domain data in other (mainly DNSSEC related) tables. I will check it > tomorrow (combined with the extra information from Peter to what record > also can be checked) and after that I will send a new version to the list.
This version assumes DNSSEC is used with PowerDNS (at least the tables exists). If they don't exist this script will still work. At the top you can enter some configuration options. By default it only checks domains where the last_check number is at least 1 day old and after 7 failed checks it removes a domain from the database. At line 61 you can change the email account and after that you can uncomment it to get a daily email with failed domains so you check it before it is removed. I strongly suggest running this script (or something similar) once a day so you clean up old domains and with the warning you can check it before domains are removed (and with a week you have some time to notify customers if needed). There is a short copyright notice at the top, the short version: don't claim you created it and feel free to do whatever you want with it. Kind regards, Mark Scholten
<<attachment: pdns_clean.php>>
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
