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

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 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

[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<-