Use portable location for GeoIP database

[dns.git] / bin / mkgeo

diff --git a/bin/mkgeo b/bin/mkgeo
index 8cb4687e124fca590eece9372e4d28d55d7a74fa..3a69d89af6639e476e78c61cc910a8dbd73656a8 100755 (executable)
--- a/bin/mkgeo
+++ b/bin/mkgeo
@@ -9,14 +9,14 @@ use IO::File;
 use Math::Trig qw(deg2rad pip2 great_circle_distance);
 use JSON::XS;
 use LWP::UserAgent;
 use Math::Trig qw(deg2rad pip2 great_circle_distance);
 use JSON::XS;
 use LWP::UserAgent;

-use YAML;
+use YAML::XS qw(LoadFile DumpFile);

 
 my $originfile = shift @ARGV;
 my $clusterfile = shift @ARGV;
 my $zone = shift @ARGV;
 my $targetoriginfile = shift @ARGV;
 
 my $originfile = shift @ARGV;
 my $clusterfile = shift @ARGV;
 my $zone = shift @ARGV;
 my $targetoriginfile = shift @ARGV;

-my $origins = YAML::LoadFile($originfile);
-my $clusters = YAML::LoadFile($clusterfile);
+my $origins = LoadFile($originfile);
+my $clusters = LoadFile($clusterfile);

 my $gdnsname = shift @ARGV;
 my @servers;
 
 my $gdnsname = shift @ARGV;
 my @servers;
 


@@ -25,22 +25,23 @@ while (my($name,$cluster) = each %$clusters)
 {
     if ($cluster->{servers})
     {
 {
     if ($cluster->{servers})
     {

-        $cluster->{bandwidth} = 0;
+        $cluster->{requests} = 0;

 
         foreach my $server (@{$cluster->{servers}})
         {
             $server->{cluster} = $cluster;
 
         foreach my $server (@{$cluster->{servers}})
         {
             $server->{cluster} = $cluster;

-            $cluster->{bandwidth} = $cluster->{bandwidth} + $server->{bandwidth};
+            $cluster->{requests} = $cluster->{requests} + $server->{requests};

 
             push @servers, $server;
         }
     }
 
             push @servers, $server;
         }
     }

-    else
+    elsif ($cluster->{requests} > 0)

     {
         my $server = {
             cluster => $cluster,
             statuscake => $cluster->{statuscake},
     {
         my $server = {
             cluster => $cluster,
             statuscake => $cluster->{statuscake},

-            bandwidth => $cluster->{bandwidth},
+            requests => $cluster->{requests},
+            cname => $cluster->{cname},

             ipv4 => $cluster->{ipv4},
             ipv6 => $cluster->{ipv6}
         };
             ipv4 => $cluster->{ipv4},
             ipv6 => $cluster->{ipv6}
         };


@@ -49,6 +50,10 @@ while (my($name,$cluster) = each %$clusters)
 
         push @servers, $server;
     }
 
         push @servers, $server;
     }

+    else
+    {
+        $cluster->{servers} = [];
+    }

 
     $cluster->{name} = $name;
     $cluster->{status} = "down";
 
     $cluster->{name} = $name;
     $cluster->{status} = "down";


@@ -61,42 +66,50 @@ foreach my $server (@servers)
 }
 
 # If statuscake support is enabled then check which servers are up
 }
 
 # If statuscake support is enabled then check which servers are up

-if ($ENV{STATUSCAKE_USERNAME} && $ENV{STATUSCAKE_APIKEY})
+if ($ENV{STATUSCAKE_APIKEY})

 {
     my $ua = LWP::UserAgent->new;
     my $cache;
 
     $ua->agent("mkgeo/1.0");
 {
     my $ua = LWP::UserAgent->new;
     my $cache;
 
     $ua->agent("mkgeo/1.0");

-    $ua->default_header("Username", $ENV{STATUSCAKE_USERNAME});
-    $ua->default_header("API", $ENV{STATUSCAKE_APIKEY});
+    $ua->default_header("Authorization", "Bearer $ENV{STATUSCAKE_APIKEY}");

 
     if (-f "statuscake.yml")
     {
 
     if (-f "statuscake.yml")
     {

-        $cache = YAML::LoadFile("statuscake.yml");
+        $cache = LoadFile("statuscake.yml");

     }
     else
     {
         $cache = {};
     }
 
     }
     else
     {
         $cache = {};
     }
 

-    my $response = $ua->get("https://app.statuscake.com/API/Tests/");
+    my $page = 1;
+    my $pages = 1;

 
 

-    if ($response->is_success)
+    while ($page <= $pages)

     {
     {

-        my $tests = decode_json($response->content);
+        my $response = $ua->get("https://api.statuscake.com/v1/uptime?nouptime=true&limit=100&page=${page}");

 
 

-        foreach my $test (@$tests)
+        if ($response->is_success)

         {
         {

-            my $testid = $test->{TestID};
+            my $uptime = decode_json($response->content);

 
 

-            if ($test->{Status} eq "Up" && !$test->{Paused})
-            {
-                $cache->{$testid} = "up";
-            }
-            else
+            foreach my $test (@{$uptime->{data}})

             {
             {

-                $cache->{$testid} = "down";
+                my $testid = $test->{id};
+
+                if ($test->{status} eq "up" && !$test->{paused})
+                {
+                    $cache->{$testid} = "up";
+                }
+                else
+                {
+                    $cache->{$testid} = "down";
+                }

             }
             }

+
+            $page = $page + 1;
+            $pages = $uptime->{metadata}->{page_count};

         }
     }
 
         }
     }
 


@@ -119,7 +132,8 @@ if ($ENV{STATUSCAKE_USERNAME} && $ENV{STATUSCAKE_APIKEY})
         }
     }
 
         }
     }
 

-    YAML::DumpFile("statuscake.yml", $cache);
+    DumpFile("statuscake-$$.yml", $cache);
+    rename("statuscake-$$.yml", "statuscake.yml");

 }
 
 # Mark a cluster as up if any servers are up
 }
 
 # Mark a cluster as up if any servers are up


@@ -131,25 +145,30 @@ foreach my $server (@servers)
     }
     else
     {
     }
     else
     {

-        $server->{cluster}->{bandwidth} = $server->{cluster}->{bandwidth} - $server->{bandwidth};
+        $server->{cluster}->{requests} = $server->{cluster}->{requests} - $server->{requests};

     }
 }
 
     }
 }
 

+# Abort if no servers at all are up
+exit 0 unless grep { $_->{status} eq "up" } values(%$clusters);
+

 # Create target origins object
 my $targetorigins = {};
 
 # Initialise cluster details
 while (my($name,$cluster) = each %$clusters)
 {
 # Create target origins object
 my $targetorigins = {};
 
 # Initialise cluster details
 while (my($name,$cluster) = each %$clusters)
 {

-    $cluster->{bandwidth_limit} = $cluster->{bandwidth} * 1024 * 1024;
-    $cluster->{bandwidth_used} = 0;
+    $cluster->{requests_limit} = $cluster->{requests};
+    $cluster->{requests_used} = 0;
+
+    next if $cluster->{global};

 
     $targetorigins->{$cluster->{name}} = {
         code => $cluster->{name},
         name => $cluster->{name},
         lat => $cluster->{lat},
         lon => $cluster->{lon},
 
     $targetorigins->{$cluster->{name}} = {
         code => $cluster->{name},
         name => $cluster->{name},
         lat => $cluster->{lat},
         lon => $cluster->{lon},

-        bandwidth => 0
+        requests => 0

     };
 }
 
     };
 }
 


@@ -165,7 +184,16 @@ foreach my $origin (values %$origins)
         if ($cluster->{status} eq "up" && $match ne "denied")
         {
             my $priority = $match eq "preferred" ? 20 : 10;
         if ($cluster->{status} eq "up" && $match ne "denied")
         {
             my $priority = $match eq "preferred" ? 20 : 10;

-            my $distance = distance($origin->{lat}, $origin->{lon}, $cluster->{lat}, $cluster->{lon});
+            my $distance;
+
+            if ($cluster->{global})
+            {
+                $distance = 0;
+            }
+            else
+            {
+                $distance = distance($origin->{lat}, $origin->{lon}, $cluster->{lat}, $cluster->{lon});
+            }

 
             push @mappings, {
                 origin => $origin, cluster => $cluster,
 
             push @mappings, {
                 origin => $origin, cluster => $cluster,


@@ -179,7 +207,7 @@ foreach my $origin (values %$origins)
 allocate_clusters(@mappings);
 
 # If we failed to allocate every origin then loop, increasing
 allocate_clusters(@mappings);
 
 # If we failed to allocate every origin then loop, increasing

-# the bandwidth for each cluster by a little and retrying until
+# the requests for each cluster by a little and retrying until

 # we manage to allocate everything
 while (grep { !exists($_->{cluster}) } values %$origins)
 {
 # we manage to allocate everything
 while (grep { !exists($_->{cluster}) } values %$origins)
 {


@@ -189,17 +217,36 @@ while (grep { !exists($_->{cluster}) } values %$origins)
         delete $origin->{cluster};
     }
 
         delete $origin->{cluster};
     }
 

-    # Reset bandwidth usage for clusters and increase limits by 10%
+    # Reset requests usage for clusters and increase limits by 10%

     foreach my $cluster (values %$clusters)
     {
     foreach my $cluster (values %$clusters)
     {

-        $cluster->{bandwidth_used} = 0;
-        $cluster->{bandwidth_limit} = $cluster->{bandwidth_limit} * 1.1;
+        $cluster->{requests_used} = 0;
+        $cluster->{requests_limit} = $cluster->{requests_limit} * 1.1;

     }
 
     # Try the allocate again
     allocate_clusters(@mappings);
 }
 
     }
 
     # Try the allocate again
     allocate_clusters(@mappings);
 }
 

+# Report on allocation results
+foreach my $name (sort keys %$clusters)
+{
+    my $cluster = $clusters->{$name};
+    my $used = int($cluster->{requests_used} + 0.5);
+    my $limit = $cluster->{requests_limit};
+
+    if ($limit > 0)
+    {
+        my $proportion = int($used / $limit * 100 + 0.5);
+    
+        print "${name}: used ${used} of ${limit} (${proportion}%)\n";
+    }
+    else
+    {
+        print "${name}: used ${used} of ${limit}\n";
+    }
+}
+

 # Create JSON collection object
 my @json;
 
 # Create JSON collection object
 my @json;
 


@@ -214,39 +261,45 @@ $zonefile->print("var \U${zone}\E_RECORDS = [\n");
 foreach my $origin (sort { $a->{name} cmp $b->{name} } values %$origins)
 {
     my $cluster = $origin->{cluster};
 foreach my $origin (sort { $a->{name} cmp $b->{name} } values %$origins)
 {
     my $cluster = $origin->{cluster};

-    my $clon = $origin->{lon};
-    my $clat = $origin->{lat};
-    my $slon = $cluster->{lon};
-    my $slat = $cluster->{lat};
-
-    if ($clon > 0 && $slon < 0 && 360 + $slon - $clon < $clon - $slon)
-    {
-        $slon = $slon + 360;
-    }
-    elsif ($slon > 0 && $clon < 0 && 360 + $clon - $slon < $slon - $clon)
-    {
-        $clon = $clon + 360;
-    }

 
     if (!defined($gdnsname))
     {
         $zonefile->print("  CNAME(\"\L$origin->{code}\E.${zone}\", \"$cluster->{name}.${zone}.openstreetmap.org.\", TTL(\"10m\")),\n");
     }
 
 
     if (!defined($gdnsname))
     {
         $zonefile->print("  CNAME(\"\L$origin->{code}\E.${zone}\", \"$cluster->{name}.${zone}.openstreetmap.org.\", TTL(\"10m\")),\n");
     }
 

-    push @json, {
-        type => "Feature",
-        geometry => {
-            type => "LineString",
-            coordinates => [ [ $clon, $clat ], [ $slon, $slat ] ]
-        },
-        properties => {
-            origin => $origin->{name},
-            server => $cluster->{name},
-            colour => $cluster->{colour}
+    if ($cluster->{lon} && $cluster->{lat})
+    {
+        my $clon = $origin->{lon};
+        my $clat = $origin->{lat};
+        my $slon = $cluster->{lon};
+        my $slat = $cluster->{lat};
+
+        if ($clon > 0 && $slon < 0 && 360 + $slon - $clon < $clon - $slon)
+        {
+            $slon = $slon + 360;

         }
         }

-    };
+        elsif ($slon > 0 && $clon < 0 && 360 + $clon - $slon < $slon - $clon)
+        {
+            $clon = $clon + 360;
+        }
+
+        push @json, {
+            type => "Feature",
+            geometry => {
+                type => "LineString",
+                coordinates => [ [ $clon, $clat ], [ $slon, $slat ] ]
+            },
+            properties => {
+                origin => $origin->{name},
+                server => $cluster->{name},
+                colour => $cluster->{colour}
+            }
+        };
+    }

 
 

-    $targetorigins->{$cluster->{name}}->{bandwidth} += $origin->{bandwidth};
+    next if $cluster->{global};
+
+    $targetorigins->{$cluster->{name}}->{requests} += $origin->{requests};

 }
 
 # Skip default records if we don't need them
 }
 
 # Skip default records if we don't need them


@@ -302,7 +355,7 @@ if (defined($gdnsname))
     my $continent = "";
 
     $gdnsmapfile->print("${gdnsname} => {\n");
     my $continent = "";
 
     $gdnsmapfile->print("${gdnsname} => {\n");

-    $gdnsmapfile->print("  geoip2_db => /usr/share/GeoIP/GeoLite2-Country.mmdb\n");
+    $gdnsmapfile->print("  geoip2_db => /etc/gdnsd/geoip/GeoLite2-Country.mmdb\n");

     $gdnsmapfile->print("  datacenters => [" . join(",", sort(keys(%$clusters))) . "]\n");
     $gdnsmapfile->print("  map => {\n");
     $gdnsmapfile->print("    default => [" . join(",", sort(map { $_->{name} } grep { $_->{default} } values(%$clusters))) . "]\n");
     $gdnsmapfile->print("  datacenters => [" . join(",", sort(keys(%$clusters))) . "]\n");
     $gdnsmapfile->print("  map => {\n");
     $gdnsmapfile->print("    default => [" . join(",", sort(map { $_->{name} } grep { $_->{default} } values(%$clusters))) . "]\n");


@@ -339,7 +392,7 @@ if (defined($gdnsname))
     {
         my $name = $cluster->{name};
 
     {
         my $name = $cluster->{name};
 

-        if (@{$cluster->{servers}} > 1)
+        if (@{$cluster->{servers}} > 1 && grep { $_->{status} eq "up" } @{$cluster->{servers}})

         {
             $gdnsweightedfile->print("${name} => {\n");
 
         {
             $gdnsweightedfile->print("${name} => {\n");
 


@@ -348,9 +401,16 @@ if (defined($gdnsname))
                 if ($server->{status} eq "up")
                 {
                     my $number = sprintf("%02d", $index + 1);
                 if ($server->{status} eq "up")
                 {
                     my $number = sprintf("%02d", $index + 1);

-                    my $bandwidth = $server->{bandwidth};
-
-                    $gdnsweightedfile->print("  ${name}-${number} = [ ${name}-${number}.${zone}.openstreetmap.org., ${bandwidth} ]\n");
+                    my $requests = $server->{requests};
+
+                    if (my $cname = $server->{cname})
+                    {
+                        $gdnsweightedfile->print("  ${name}-${number} = [ ${cname}., ${requests} ]\n");
+                    }
+                    else
+                    {
+                        $gdnsweightedfile->print("  ${name}-${number} = [ ${name}-${number}.${zone}.openstreetmap.org., ${requests} ]\n");
+                    }

                 }
             }
 
                 }
             }
 


@@ -358,6 +418,10 @@ if (defined($gdnsname))
 
             $gdnsresourcefile->print("    ${name} => %weighted!${name}\n");
         }
 
             $gdnsresourcefile->print("    ${name} => %weighted!${name}\n");
         }

+        elsif (my $cname = $cluster->{cname})
+        {
+            $gdnsresourcefile->print("    ${name} => ${cname}.\n");
+        }

         else
         {
             $gdnsresourcefile->print("    ${name} => ${name}.${zone}.openstreetmap.org.\n");
         else
         {
             $gdnsresourcefile->print("    ${name} => ${name}.${zone}.openstreetmap.org.\n");


@@ -373,7 +437,7 @@ if (defined($gdnsname))
 }
 
 # Output the target details in origin format if required
 }
 
 # Output the target details in origin format if required

-YAML::DumpFile($targetoriginfile, $targetorigins) if $targetoriginfile;
+DumpFile($targetoriginfile, $targetorigins) if $targetoriginfile;

 
 exit 0;
 
 
 exit 0;
 


@@ -467,7 +531,7 @@ sub allocate_clusters
     my @mappings = sort { compare_mappings($a, $b) } @_;
 
     # Loop over the mappings, trying to assign each origin to the
     my @mappings = sort { compare_mappings($a, $b) } @_;
 
     # Loop over the mappings, trying to assign each origin to the

-    # nearest cluster, but subject to the bandwidth limits
+    # nearest cluster, but subject to the request limits

     while (my $mapping = shift @mappings)
     {
         my @group;
     while (my $mapping = shift @mappings)
     {
         my @group;


@@ -479,16 +543,16 @@ sub allocate_clusters
             push @group, shift @mappings;
         }
 
             push @group, shift @mappings;
         }
 

-        for my $mapping (sort compare_bandwidth @group)
+        for my $mapping (sort compare_requests @group)

         {
             my $origin = $mapping->{origin};
             my $cluster = $mapping->{cluster};
 
             if (!exists($origin->{cluster}) &&
         {
             my $origin = $mapping->{origin};
             my $cluster = $mapping->{cluster};
 
             if (!exists($origin->{cluster}) &&

-                $cluster->{bandwidth_used} + $origin->{bandwidth} <= $cluster->{bandwidth_limit})
+                $cluster->{requests_used} + $origin->{requests} <= $cluster->{requests_limit})

             {
                 $origin->{cluster} = $cluster;
             {
                 $origin->{cluster} = $cluster;

-                $cluster->{bandwidth_used} = $cluster->{bandwidth_used} + $origin->{bandwidth};
+                $cluster->{requests_used} = $cluster->{requests_used} + $origin->{requests};

             }
         }
     }
             }
         }
     }


@@ -511,10 +575,10 @@ sub compare_mappings
 #
 # Compare two mappings to decide which to try first
 #
 #
 # Compare two mappings to decide which to try first
 #

-sub compare_bandwidth
+sub compare_requests

 {
 {

-    my $a_used = ( $a->{cluster}->{bandwidth_used} * 100.0 ) / ( $a->{cluster}->{bandwidth_limit} * 1.0 );
-    my $b_used = ( $b->{cluster}->{bandwidth_used} * 100.0 ) / ( $b->{cluster}->{bandwidth_limit} * 1.0 );
+    my $a_used = ( $a->{cluster}->{requests_used} * 100.0 ) / ( $a->{cluster}->{requests_limit} * 1.0 );
+    my $b_used = ( $b->{cluster}->{requests_used} * 100.0 ) / ( $b->{cluster}->{requests_limit} * 1.0 );

 
     return $a_used <=> $b_used;
 }
 
     return $a_used <=> $b_used;
 }


@@ -533,7 +597,10 @@ sub output_server
     {
         if ($all || $server->{status} eq "up")
         {
     {
         if ($all || $server->{status} eq "up")
         {

-            $zonefile->printf("  A(\"${name}\", \"$server->{ipv4}\", TTL(\"10m\")),\n", $index + 1);
+            if ($server->{ipv4})
+            {
+                $zonefile->printf("  A(\"${name}\", \"$server->{ipv4}\", TTL(\"10m\")),\n", $index + 1);
+            }

 
             if ($server->{ipv6})
             {
 
             if ($server->{ipv6})
             {