[Pdns-users] SQL Query

Sharan Harkisoon sharan at sharktek.net
Wed Jun 14 13:59:39 UTC 2006

This is quite easy to do if you use views in your database. This won't 
require modifying the source and recompiling.

Richard Mayhew - Nashua Broadband wrote:

> Hi,
> I’d like to know if it’s possible to modify the PDNS SQL query so that 
> I can check if the domain is suspended on our systems or still active.
> I.e. In the database there is a field “STATUS” which is set to “1” for 
> active or “0” for inactive. If a client has his domain suspended for 
> what ever reason, we can change this field to read 0 and his entries 
> will no longer be available. Once the domain is re-instated, the 
> status is updated again to 1 and all is well. This saves having to 
> move the data to a temp table or remove it completely. I can then add 
> another field for a date at which it was suspended and go through the 
> DB and remove all suspended domains/records after a certain date.
> Regards
> Richard
>Pdns-users mailing list
>Pdns-users at mailman.powerdns.com

More information about the Pdns-users mailing list