Changeset 1592 for trunk/pdns/pdns/backends/bind/zone2sql.cc

Timestamp:

04/30/10 22:49:09 (3 years ago)

Author:

ahu

Message:

teach zone2sql about dnssec 'auth' field

Files:

• trunk/pdns/pdns/backends/bind/zone2sql.cc (modified) (6 diffs)

trunk/pdns/pdns/backends/bind/zone2sql.cc

@@ -1 +1 @@
 /*
     PowerDNS Versatile Database Driven Nameserver
-    Copyright (C) 2002 - 2007  PowerDNS.COM BV
+    Copyright (C) 2002 - 2010  PowerDNS.COM BV
 
     This program is free software; you can redistribute it and/or modify
@@ -48 +48 @@
 using namespace boost;
 StatBag S;
+bool g_doDNSSEC;
 
 static const string sqlstr(const string &name)
@@ -124 +125 @@
   lastsoa_domain_id=dirty_hack_num;
 
+  bool auth = true;
+  if(qtype == "NS" && !pdns_iequals(stripDot(domain), lastsoa_qname)) {
+    // cerr<<"'"<<domain<<"' != '"<<lastsoa_qname<<"'\n";
+    auth=false;
+  }
+
   if(mode==MYSQL) {
-    cout<<"insert into records (domain_id, name,type,content,ttl,prio) values ("<< dirty_hack_num<<", "<<
-      sqlstr(stripDot(domain))<<", "<<
-      sqlstr(qtype)<<", "<<
-      sqlstr(stripDot(content))<<", "<<ttl<<", "<<prio<<");\n";
-  }
-  if(mode==POSTGRES) {
-    cout<<"insert into records (domain_id, name,type,content,ttl,prio) select id ,"<<
-      sqlstr(toLower(stripDot(domain)))<<", "<<
-      sqlstr(qtype)<<", "<<
-      sqlstr(stripDot(content))<<", "<<ttl<<", "<<prio<< 
-      " from domains where name="<<toLower(sqlstr(lastsoa_qname))<<";\n";
+    if(!g_doDNSSEC) {
+      
+      cout<<"insert into records (domain_id, name, type,content,ttl,prio) values ("<< dirty_hack_num<<", "<<
+        sqlstr(stripDot(domain))<<", "<<
+        sqlstr(qtype)<<", "<<
+        sqlstr(stripDot(content))<<", "<<ttl<<", "<<prio<<");\n";
+    } else {
+      cout<<"insert into records (domain_id, name, ordername, auth, type,content,ttl,prio) values ("<< dirty_hack_num<<", "<<
+        sqlstr(stripDot(domain))<<", "<<
+        sqlstr(toLower(labelReverse(domain)))<<", "<< auth <<" ,"<<
+        sqlstr(qtype)<<", "<<
+        sqlstr(stripDot(content))<<", "<<ttl<<", "<<prio<<");\n";
+    }
+  }
+  else if(mode==POSTGRES) {
+    if(!g_doDNSSEC) {
+      cout<<"insert into records (domain_id, name,type,content,ttl,prio) select id ,"<<
+        sqlstr(toLower(stripDot(domain)))<<", "<<
+        sqlstr(qtype)<<", "<<
+        sqlstr(stripDot(content))<<", "<<ttl<<", "<<prio<< 
+        " from domains where name="<<toLower(sqlstr(lastsoa_qname))<<";\n";
+    } else
+    {
+      cout<<"insert into records (domain_id, name, ordername, auth, type,content,ttl,prio) select id ,"<<
+        sqlstr(toLower(stripDot(domain)))<<", "<<
+        sqlstr(toLower(labelReverse(domain)))<<", "<<auth<<", "<<
+        sqlstr(qtype)<<", "<<
+        sqlstr(stripDot(content))<<", "<<ttl<<", "<<prio<< 
+        " from domains where name="<<toLower(sqlstr(lastsoa_qname))<<";\n";
+    }
   }
   else if(mode==ORACLE) {
@@ -180 +206 @@
     ::arg().setCmd("bare","Output in a bare format, suitable for further parsing");
     ::arg().setSwitch("verbose","Verbose comments on operation")="no";
+    ::arg().setSwitch("dnssec","Add DNSSEC related data")="no";
     ::arg().setSwitch("slave","Keep BIND slaves as slaves")="no";
     ::arg().setSwitch("transactions","If target SQL supports it, use transactions")="no";
@@ -219 +246 @@
     }
 
+    g_doDNSSEC=::arg().mustDo("dnssec");
+      
 
     dirty_hack_num=::arg().asNum("start-id");
     namedfile=::arg()["named-conf"];
     zonefile=::arg()["zone"];
+
+    
 
     int count=0, num_domainsdone=0;
@@ -312 +343 @@
       ZoneParserTNG zpt(zonefile, ::arg()["zone-name"]);
       DNSResourceRecord rr;
-      dirty_hack_num=-1; // trigger first SOA output
+      dirty_hack_num=::arg().asNum("start-id"); // trigger first SOA output
       while(zpt.get(rr)) 
         callback(0, rr.qname, rr.qtype.getName(), rr.content, rr.ttl, rr.priority);