dns management

[uwe]

Hello,

I've been further playing with ispcp to get it to work with pdns and pdnsadmin, well, so far i've been successful to do a number of things, probably in a primitive way, but it works, im able to add/delete domains to/from pdns tables when added/removed from ispcp interface concurrently with bind configs, and in a twisted way (which can be done in much cleaner way with a little patch applied to pdnsadmin) able to use usernames/passwords of ispcp users/resellers to access domain management interface (pdnsadmin) for their respective domains. i could post how to do it if someone is interested. in the future, im planning to generate bind configurations from the same data pdns uses.

Now there are some drawbacks/problems with that that i would like to share, maybe someone can suggest how its best done.

PowerDNS has a table called domains, this table has id of the domain and name of the domain and type (slave,master,native) in addition to other fields, pdnsadmin has a table called zones which has the userid and domain id, ispcp has table domain which has domain name, domain id and user id, now the thing is that integrating dns tables (domain and records) with ispcp seems sane to me, but the domain id and domain name would be in two places, which is unnecessary redunduncy i think, and which raises a question when using some dns management interface, how would/should deleteing subdomain from the dns management interface affect the entries for that subdomain (in apache for example), what about deleteing this domain from the dns ? and then re-creating it from there ... ( it would probably get a new id ). or should the domains be "undeletable", just the records would be flushed? and also what about giving dns management only for a user, would it appropriate to add to the dns domains that are not in ispcp, if yes, how to treat adding them later to pdns with existing dns data? or what if the dns is used to host slave domains? i hope i've described the potential problems or what i dont really know how it should really be done. please advise/give feedback. its not all clear to me

P.S.: no, I don't want to wait until 1.1 is out, and i belive this is doable withouth major changes, and i belive its good to start now so as when 1.1 is out, this feature would be mature