Changeset 849

Timestamp:

09/01/22 13:17:46 (20 months ago)

Author:

Kris Deugau

Message:

/trunk

BIND export, unwinding dev saves, 2 of many many

• Start stubbing out reverse zone loop
• Add a templatable variable for BIND export pathnames

Location:

trunk

Files:

• DNSDB/ExportBIND.pm (modified) (2 diffs)
• dnsdb.conf (modified) (1 diff)

trunk/DNSDB/ExportBIND.pm

@@ -30 +30 @@
   my $dbh = $self->{dbh};
 
+  # to be a hash of views/locations, containing lists of zones
+  my %viewzones;
+
   # allow for future exports of subgroups of records
-  my $viewlist = $dnsdb->getLocList(curgroup => 1);
+  my $viewlist = $self->getLocList(curgroup => 1);
 
-  # Write the view list to a configuration fragment
+  # Fetch active zone list
+  my $revsth = $self->{dbh}->prepare("SELECT rdns_id,revnet,status,changed,default_location FROM revzones WHERE status=1 ".
+        "ORDER BY masklen(revnet) DESC, rdns_id");
+  # Unflag changed zones, so we can maybe cache the export and not redo everything every time
+  my $zonesth = $self->{dbh}->prepare("UPDATE revzones SET changed='n' WHERE rdns_id=?");
+  $revsth->execute();
+  while (my ($revid,$revzone,$revstat,$changed,$defloc) = $revsth->fetchrow_array) {
+    # fetch a list of views/locations present in the zone.  we need to publish a file for each one.
+    # in the event that no locations are present (~~ $viewlist is empty), /%view collapses to nothing in the zone path
+    my (@loclist) = $self->{dbh}->selectrow_array("SELECT DISTINCT location FROM records WHERE rdns_id = ?", undef, $revid);
+    push @loclist, $defloc;
+    my $zonepath = $self->{bind_export_zone_path};
+    my %zonefiles;  # to be a list of file handles.
+##fixme:  convert logical revzone into .arpa name
+    foreach my $loc (@loclist) {
+      local $zonepath =~ s/\%view/$loc/;
+print "open $zonefiles{$loc}, $zonepath\n";
+    }
+
+  } # revsth->fetch
+
+
+  # Write the view configuration last, because otherwise we have to be horribly inefficient
+  # at figuring out which zones are visible/present in which views
   if ($viewlist) {
     foreach my $view (@{$viewlist}) {
@@ -47 +73 @@
          print "  match-clients { ".join("; ", split(/[\s,]+/, $view->{iplist}))."; };\n";
       } else {
-#         print BINDCONF "  match-clients { any; };\n"
-         print "  match-clients { any; };\n"
+#         print BINDCONF "  match-clients { any; };\n";
+         print "  match-clients { any; };\n";
+      }
+      foreach my $zone (@{$viewzones{$view->{location}}}) {
+##fixme:  notify settings, maybe per-zone?
+        print qq(  zone "$zone" IN {\n\ttype master;\n\tnotify no;\n\tfile "db.$zone";\n  };\n);
       }
       print "};\n\n";

trunk/dnsdb.conf

@@ -27 +27 @@
 #  the DB or read from the existing cache file.
 #force_refresh = 1
+
+## BIND export options
+#bind_export_zone_path = /var/named/zones/%view/db.%zone
 
 ## DNS data template options