From mboxrd@z Thu Jan 1 00:00:00 1970 From: Peter =?utf-8?q?M=C3=BCller?= To: location@lists.ipfire.org Subject: [PATCH 2/4] location-importer: DELETE other unroutable IPv4 networks Date: Wed, 13 May 2020 19:33:13 +0000 Message-ID: <46f10017-357f-fd8a-5dc6-eec8da9941a2@ipfire.org> In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1559403202461877998==" List-Id: --===============1559403202461877998== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Signed-off-by: Peter M=C3=BCller --- src/python/location-importer.in | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/src/python/location-importer.in b/src/python/location-importer.in index c751332..91abf3e 100644 --- a/src/python/location-importer.in +++ b/src/python/location-importer.in @@ -520,6 +520,22 @@ class CLI(object): DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '172.16.0.0/12'; DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '192.168.0.0/16'; =20 + -- DELETE test, benchmark and documentation address space + DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '192.0.0.0/24'; + DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '192.0.2.0/24'; + DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '198.18.0.0/15'; + DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '198.51.100.0/24'; + DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '203.0.113.0/24'; + + -- DELETE CGNAT address space (RFC 6598) + DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '100.64.0.0/10'; + + -- DELETE link local address space + DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '169.254.0.0/16'; + + -- DELETE IPv6 to IPv4 (6to4) address space + DELETE FROM announcements WHERE family(network) =3D 4 AND network <<=3D= '192.88.99.0/24'; + -- Delete networks that are too small to be in the global routing table DELETE FROM announcements WHERE family(network) =3D 6 AND masklen(netwo= rk) > 48; DELETE FROM announcements WHERE family(network) =3D 4 AND masklen(netwo= rk) > 24; --=20 2.26.1 --===============1559403202461877998==--