Re: [Pdns-users] Documentation on populating backend database tables

2011-04-25 Thread Sebastian Tennant
Quoth Maik Zumstrull : > On Mon, Apr 25, 2011 at 00:22, Sebastian Tennant > wrote: > >> One quick question (as the domains/zones table is undocumented) what should >> the >> value of the domains.type column be? My guess is 'IN'. > No, it should be one of 'NATIVE', 'MASTER', 'SLAVE'. PowerDNS w

Re: [Pdns-users] Documentation on populating backend database tables

2011-04-24 Thread Maik Zumstrull
On Mon, Apr 25, 2011 at 00:22, Sebastian Tennant wrote: > One quick question (as the domains/zones table is undocumented) what should > the > value of the domains.type column be?  My guess is 'IN'. No, it should be one of 'NATIVE', 'MASTER', 'SLAVE'. PowerDNS will just serve a native zone. For

Re: [Pdns-users] Documentation on populating backend database tables

2011-04-24 Thread Sebastian Tennant
Quoth Kenneth Marshall : > The only thing missing is the SOA record to actually define your > domain and you should be good to go. Do simple DNS queries work without an SOA record I wonder? The reason I ask is that I set up my own nameserver once before, years ago, which seemed (to me) to work fi

Re: [Pdns-users] Documentation on populating backend database tables

2011-04-24 Thread Sebastian Tennant
Quoth Maik Zumstrull : > Yes. This has an implied foreign key constraint, but it's up to you to > actually define one on the database level. It also should be NOT NULL. Thanks for the confirmation. One quick question (as the domains/zones table is undocumented) what should the value of the domain

Re: [Pdns-users] Documentation on populating backend database tables

2011-04-24 Thread Kenneth Marshall
On Sun, Apr 24, 2011 at 07:32:40AM +, Sebastian Tennant wrote: > Quoth Kenneth Marshall : > > Here is a basic desciption of the fields and queries that PDNS uses: > > > > http://doc.powerdns.com/generic-mypgsql-backends.html#id587910 > > Thanks. I see now. The first half of the 'Basic functi

Re: [Pdns-users] Documentation on populating backend database tables

2011-04-24 Thread Maik Zumstrull
On Sun, Apr 24, 2011 at 09:32, Sebastian Tennant wrote: > There are a couple of questions in there: > >  1. Does records.domain_id need to reference domains.id?  The manual says that >    each domain *must* have a unique domain_id, yet the default value is NULL? Yes. This has an implied foreign

Re: [Pdns-users] Documentation on populating backend database tables

2011-04-24 Thread Sebastian Tennant
Quoth Kenneth Marshall : > Here is a basic desciption of the fields and queries that PDNS uses: > > http://doc.powerdns.com/generic-mypgsql-backends.html#id587910 Thanks. I see now. The first half of the 'Basic functionality' section describes the records table. It might help if the words 'reco

Re: [Pdns-users] Documentation on populating backend database tables

2011-04-22 Thread Kenneth Marshall
On Fri, Apr 22, 2011 at 09:18:45PM +, Sebastian Tennant wrote: > > How, for example, do I set up pdns as an authoritative name server for foo.com > and publish the addresses of two subdomains (ns1 and ns2): > > My guess would be something like this: > > INSERT INTO domains (name,type) VALUE

[Pdns-users] Documentation on populating backend database tables

2011-04-22 Thread Sebastian Tennant
Hi all, Can anyone point me to some documentation on how to populate the backend database tables (assuming you're using a relational database backend), i.e., what values should you use in each column, and when? I've chosen to use sqlite3 as my backend, so my schema looks like this: --8<-