Adding command to pdns_control

[Habbie]

Add the following commands to pdns_control:

1. pdns_control list_zone --type $type, where $type can be all (default), master or slave; this command return all zones managed by pdns of type $type

2. pdns_control delete $zone; this command will remove a zone (and all related records) from the backend

These commands can be used to create scripts for zone managing, for example for removing zone from superslaves

[Habbie]

Author: anon
Ticket was created based on a request on Pdns-users

This comment is added by Mark Scholten

1. $type can also be native for certain backends (at least for gmysql).

2. Sounds like a great idea.

Adding an additional option to get information regarding the last check for slave domains would be great. This way it is possible to create a script that checks to see if this value is at least a week old and after that orders the delete command. Something like this is already (easily, automated) done by a PHP script provided on Pdns-users.

[Habbie]

Author: anon
It would be nice to allow query for a certain domain only, e.g. pdns_control show . This could also dump useful info like: master IP (in case of slave), last check, next check ..., or dump nothing if the zone was not found.

[Habbie]

Author: anon
Hi,

Picking up on this older message, because this relates to the ticket #608.

I've created a patch as a fix for #608. The patch can be found here:
https://github.com/cyclops1982/powerdns/compare/master...608.diff

At the moment, this simply includes a list-all-zones and delete-zone command for pdnssec and pdns_control has gotten a list-zones and delete-zone command.
I've discussed pdns_control and pdnssec with Peter van Dijk and we're not planning on keeping the pdnssec implementation and dropping the pdns_control implementation.

The interesting part is that this patch would resolve 608 quite nicely, but would not help to find out which zone must be deleted.
I understand people look at the last_check field, but that is (at the moment) not outputted by list-all-zones (or any other commands).

I would like some feedback on this, as there are a number of options:

• Change list-all-zones to also show last_check (how would we format?)
• Change show-zone to output more information about the zone (this was also suggested in ticket Adding command to pdns_control #608)
• Create a delete-old-zones command which receives a last_check parameter and automatically deletes al zones that have a last_check field lower than the given command.

My preference would be to move to the 2nd option, but i'm not a big DNS operator so i have no clue if this is useful for you guys.

Any feedback is welcome!

Regards,
Ruben d'Arco

[cyclops1982]

The branch has moved to https://github.com/cyclops1982/pdns/tree/608
However, there was no comment on the last e-mail on the mailling list - so the status is "pending"

[Habbie]

If this is still wanted, please turn it into a pull. If silence is all you got on the list, closing the ticket is fine with me as well.

[cyclops1982]

All i got was silence. Closing #608

[andreacappelli]

Hi,
I tried the patch and solves the original request

I have only one question: for obtain a working system I need to add

domainmetadata
cryptokeys

to my mysql schema, until I'm not using DNSSEC, it's the intended behaviour?

[mij]

+1 for this request

[HOSTED-POWER]

Any sample scripts available? Comment here (#467) says they should, but don't see them at first sight

[Habbie]

Please ask support questions on IRC or the mailing list: https://www.powerdns.com/opensource.html