From patchwork Wed May 13 19:32:51 2020 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: =?utf-8?q?Peter_M=C3=BCller?= X-Patchwork-Id: 3089 Return-Path: Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) server-digest SHA384 client-signature ECDSA (P-384) client-digest SHA384) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 49MlFp1YLQz3xQr for ; Wed, 13 May 2020 19:33:18 +0000 (UTC) Received: from mail02.haj.ipfire.org (mail02.haj.ipfire.org [172.28.1.201]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) server-digest SHA384 client-signature ECDSA (P-384) client-digest SHA384) (Client CN "mail02.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 49MlFm014czht; Wed, 13 May 2020 19:33:15 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 49MlFl05hdz2y9P; Wed, 13 May 2020 19:33:15 +0000 (UTC) Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 49MlFj4tfNz2y5J for ; Wed, 13 May 2020 19:33:13 +0000 (UTC) Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384)) (Client did not present a certificate) by mail01.ipfire.org (Postfix) with ESMTPSA id 49MlFh59Skzht for ; Wed, 13 May 2020 19:33:12 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1589398393; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=DEROragl6QBnG6e5MMUnSI39Ya7eHhzPW5flXaPXAjk=; b=y0izYCt9GG0MyoY3CY6VgXAsHkWmUJv5l3TbT1fZUe9G5mh7r5BYjOoHOuTXO5lILFCjGA 02n3FJ5dGfzjBxBg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1589398393; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=DEROragl6QBnG6e5MMUnSI39Ya7eHhzPW5flXaPXAjk=; b=WGPWqTRefg/pTshtBrt1iGoZhpbzKPfhVhL3IDrvhHiLzxer4gqXdHMCOVsaqn725X5/2/ q7wrjliynJOFIuyVosfMdt6xN9+i5cohKfEptIj1PeHu/wNBOAYugDQ5OmKzFmvYcwS1fI +M/OESZ65Lp/dMC4+wD96dJAZ+PU/b+oq7Foz0Kd+pTUxOFaDNZ38bFD8dZPPQfnHHlILb PvfeXWhe4dB+FnNl1blIa3OzVnXI1pVSIqQNTTPcXZdbhEKlI7Zk9DtonulGj+F/ghivXQ q0r/4VpadvG/IcaGo5y9IcQeuefCkiau8IHmeHc8VmvvrJYl1dW7h/53gC3VLQ== To: location@lists.ipfire.org From: =?utf-8?q?Peter_M=C3=BCller?= Subject: [PATCH 1/4] location-importer: DELETE local loopback address space Message-ID: Date: Wed, 13 May 2020 19:32:51 +0000 MIME-Version: 1.0 Content-Language: en-US X-BeenThere: location@lists.ipfire.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: location-bounces@lists.ipfire.org Sender: "Location" Authentication-Results: mail01.ipfire.org; none X-Rspamd-Queue-Id: 49MlFm014czht X-Spamd-Result: default: False [-4.29 / 11.00]; ARC_NA(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; BAYES_HAM(-3.00)[99.99%]; FROM_HAS_DN(0.00)[]; FORGED_SENDER_MAILLIST(0.00)[]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[location@lists.ipfire.org]; TO_DN_NONE(0.00)[]; HAS_LIST_UNSUB(-0.01)[]; RCPT_COUNT_ONE(0.00)[1]; RCVD_COUNT_THREE(0.00)[4]; NEURAL_HAM(-0.98)[-0.976]; MAILLIST(-0.20)[mailman]; FORGED_RECIPIENTS_MAILLIST(0.00)[]; MIME_TRACE(0.00)[0:+]; RCVD_TLS_LAST(0.00)[]; FROM_NEQ_ENVFROM(0.00)[peter.mueller@ipfire.org,location-bounces@lists.ipfire.org]; MID_RHS_MATCH_FROM(0.00)[] X-Rspamd-Server: mail01.haj.ipfire.org This should never appear in public BGP data, but since people tend to do really strange things on the interent, it's better to delete 127.0.0.0/8 data, just in case. Signed-off-by: Peter Müller --- src/python/location-importer.in | 3 +++ 1 file changed, 3 insertions(+) diff --git a/src/python/location-importer.in b/src/python/location-importer.in index 08c9ed7..c751332 100644 --- a/src/python/location-importer.in +++ b/src/python/location-importer.in @@ -512,6 +512,9 @@ class CLI(object): -- Delete anything that is not global unicast address space DELETE FROM announcements WHERE family(network) = 6 AND NOT network <<= '2000::/3'; + -- DELETE local loopback address space + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '127.0.0.0/8'; + -- DELETE RFC1918 address space DELETE FROM announcements WHERE family(network) = 4 AND network <<= '10.0.0.0/8'; DELETE FROM announcements WHERE family(network) = 4 AND network <<= '172.16.0.0/12'; From patchwork Wed May 13 19:33:13 2020 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: =?utf-8?q?Peter_M=C3=BCller?= X-Patchwork-Id: 3090 Return-Path: Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 49MlG83yM0z3xQr for ; Wed, 13 May 2020 19:33:36 +0000 (UTC) Received: from mail02.haj.ipfire.org (mail02.haj.ipfire.org [172.28.1.201]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail02.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 49MlG82wRCzht; Wed, 13 May 2020 19:33:36 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 49MlG80shyz2y9P; Wed, 13 May 2020 19:33:36 +0000 (UTC) Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 49MlG65Wdyz2y9P for ; Wed, 13 May 2020 19:33:34 +0000 (UTC) Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384)) (Client did not present a certificate) by mail01.ipfire.org (Postfix) with ESMTPSA id 49MlG56PGBzht for ; Wed, 13 May 2020 19:33:33 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1589398414; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=oLTt/cn/3ofcHSCM61Uw0/+fBjrRU1g2d3Sm7ChtxpM=; b=zYtGflAT9FDd1GNDDl7umfBp4alzWkVIuOdUjivL8FUNd7afUZR3/STtAIK+IfUxcDqZWE 9uFoTxzq1wT5klCg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1589398414; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=oLTt/cn/3ofcHSCM61Uw0/+fBjrRU1g2d3Sm7ChtxpM=; b=QRmQhOdjp1q7pQtE8KteMzrb1sD+MFCTZgI9FJ7bA1s8drW0zMBBgVgJhfktyR+zFx30O6 wUzVQKQspqJSREsL1OfwD3Qe88y2qegYvdOIB/64I7oL46GA0zgQxM4zQVVXs2Upj1Yb8W x0MzU5biTJ7aeB+rEDECs8mPDKVRGX2GVm7kkvgZ5ovn6PxpJfQZPuHxNEo4LcoUFfDCSR IoGccuZOr/Y3NvuPg4zgU4ru+iqVhci8LEApw1n9wYW/Rql8pA754gs0BIZSquDklRH+Eq 92mQ7GOpq4RvH5sUY5pCM5UhwYSiHFaIBIzji7Rr7xjS4VxP9f41fQChgasAjQ== Subject: [PATCH 2/4] location-importer: DELETE other unroutable IPv4 networks To: location@lists.ipfire.org References: From: =?utf-8?q?Peter_M=C3=BCller?= Message-ID: <46f10017-357f-fd8a-5dc6-eec8da9941a2@ipfire.org> Date: Wed, 13 May 2020 19:33:13 +0000 MIME-Version: 1.0 In-Reply-To: Content-Language: en-US X-BeenThere: location@lists.ipfire.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: location-bounces@lists.ipfire.org Sender: "Location" Authentication-Results: mail01.ipfire.org; none X-Rspamd-Queue-Id: 49MlG82wRCzht X-Spamd-Result: default: False [-4.28 / 11.00]; ARC_NA(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; BAYES_HAM(-3.00)[99.97%]; FROM_HAS_DN(0.00)[]; FORGED_SENDER_MAILLIST(0.00)[]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[location@lists.ipfire.org]; TO_DN_NONE(0.00)[]; HAS_LIST_UNSUB(-0.01)[]; RCPT_COUNT_ONE(0.00)[1]; RCVD_COUNT_THREE(0.00)[4]; NEURAL_HAM(-0.98)[-0.977]; MAILLIST(-0.20)[mailman]; FORGED_RECIPIENTS_MAILLIST(0.00)[]; RCVD_TLS_LAST(0.00)[]; MIME_TRACE(0.00)[0:+]; FROM_NEQ_ENVFROM(0.00)[peter.mueller@ipfire.org,location-bounces@lists.ipfire.org]; MID_RHS_MATCH_FROM(0.00)[] X-Rspamd-Server: mail01.haj.ipfire.org Signed-off-by: Peter Müller --- 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) = 4 AND network <<= '172.16.0.0/12'; DELETE FROM announcements WHERE family(network) = 4 AND network <<= '192.168.0.0/16'; + -- DELETE test, benchmark and documentation address space + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '192.0.0.0/24'; + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '192.0.2.0/24'; + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '198.18.0.0/15'; + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '198.51.100.0/24'; + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '203.0.113.0/24'; + + -- DELETE CGNAT address space (RFC 6598) + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '100.64.0.0/10'; + + -- DELETE link local address space + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '169.254.0.0/16'; + + -- DELETE IPv6 to IPv4 (6to4) address space + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '192.88.99.0/24'; + -- Delete networks that are too small to be in the global routing table DELETE FROM announcements WHERE family(network) = 6 AND masklen(network) > 48; DELETE FROM announcements WHERE family(network) = 4 AND masklen(network) > 24; From patchwork Wed May 13 19:33:32 2020 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: =?utf-8?q?Peter_M=C3=BCller?= X-Patchwork-Id: 3091 Return-Path: Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 49MlGW5v0Dz3xQr for ; Wed, 13 May 2020 19:33:55 +0000 (UTC) Received: from mail02.haj.ipfire.org (mail02.haj.ipfire.org [172.28.1.201]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail02.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 49MlGW4qCDz1tW; Wed, 13 May 2020 19:33:55 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 49MlGW3xLQz2yC8; Wed, 13 May 2020 19:33:55 +0000 (UTC) Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 49MlGV5wH9z2y9P for ; Wed, 13 May 2020 19:33:54 +0000 (UTC) Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384)) (Client did not present a certificate) by mail01.ipfire.org (Postfix) with ESMTPSA id 49MlGT6FQ9z1KZ for ; Wed, 13 May 2020 19:33:53 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1589398434; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=8B3e8Tq1tq3Hxp7v//FYDMbN8DFiiQGCzV0yiOHZllU=; b=4828RUTlWxPL0vUTY/9B8niAMyTDKF9IEXevpoqmMfVmhp2VpBA/BsKRZWtFHDWwftwAkh nu7TD9LkYr8p4FBg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1589398434; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=8B3e8Tq1tq3Hxp7v//FYDMbN8DFiiQGCzV0yiOHZllU=; b=jsXRrGPSof3dlE3IhKRkZMJ+hz5HDl+i30F+Jhjq6juM3sFNSdRwGPR/OTZ40L4oAU/9oe SJPd4dw1a2/pEkREB6sa5CQ9652ZVRpidQR401kxKRLliknI1G2VXgtW3VE5ecCZNonMHL qm35PoTU6wtI6ByutQUNVmliBnIHzW8ktt+iVwgZj9bKHOCT7y5+kIVS73704hqfjlOj5k o22Rg4aYBrwHN7C3U03tkuj/wwfjkg9U7kPPLpKwRkdrm0rNh11B33kYBltfoSny13WKCq 9vwyjsUz9txDgNuzQoFDF+93RJUdAgPitefcjaeBjwlZ/puiD0D/FrPXm8R2Pg== Subject: [PATCH 3/4] location-importer: DELETE "current network" address space To: location@lists.ipfire.org References: <46f10017-357f-fd8a-5dc6-eec8da9941a2@ipfire.org> From: =?utf-8?q?Peter_M=C3=BCller?= Message-ID: Date: Wed, 13 May 2020 19:33:32 +0000 MIME-Version: 1.0 In-Reply-To: <46f10017-357f-fd8a-5dc6-eec8da9941a2@ipfire.org> Content-Language: en-US X-BeenThere: location@lists.ipfire.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: location-bounces@lists.ipfire.org Sender: "Location" Authentication-Results: mail01.ipfire.org; none X-Rspamd-Queue-Id: 49MlGW4qCDz1tW X-Spamd-Result: default: False [-4.29 / 11.00]; ARC_NA(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; BAYES_HAM(-3.00)[99.99%]; FROM_HAS_DN(0.00)[]; FORGED_SENDER_MAILLIST(0.00)[]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[location@lists.ipfire.org]; TO_DN_NONE(0.00)[]; HAS_LIST_UNSUB(-0.01)[]; RCPT_COUNT_ONE(0.00)[1]; RCVD_COUNT_THREE(0.00)[4]; NEURAL_HAM(-0.98)[-0.982]; MAILLIST(-0.20)[mailman]; FORGED_RECIPIENTS_MAILLIST(0.00)[]; RCVD_TLS_LAST(0.00)[]; MIME_TRACE(0.00)[0:+]; FROM_NEQ_ENVFROM(0.00)[peter.mueller@ipfire.org,location-bounces@lists.ipfire.org]; MID_RHS_MATCH_FROM(0.00)[] X-Rspamd-Server: mail01.haj.ipfire.org Signed-off-by: Peter Müller --- src/python/location-importer.in | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/src/python/location-importer.in b/src/python/location-importer.in index 91abf3e..53c5cfe 100644 --- a/src/python/location-importer.in +++ b/src/python/location-importer.in @@ -512,10 +512,13 @@ class CLI(object): -- Delete anything that is not global unicast address space DELETE FROM announcements WHERE family(network) = 6 AND NOT network <<= '2000::/3'; + -- DELETE "current network" address space + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '0.0.0.0/8'; + -- DELETE local loopback address space DELETE FROM announcements WHERE family(network) = 4 AND network <<= '127.0.0.0/8'; - -- DELETE RFC1918 address space + -- DELETE RFC 1918 address space DELETE FROM announcements WHERE family(network) = 4 AND network <<= '10.0.0.0/8'; DELETE FROM announcements WHERE family(network) = 4 AND network <<= '172.16.0.0/12'; DELETE FROM announcements WHERE family(network) = 4 AND network <<= '192.168.0.0/16'; From patchwork Wed May 13 19:33:54 2020 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: =?utf-8?q?Peter_M=C3=BCller?= X-Patchwork-Id: 3092 Return-Path: Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 49MlGw6n2Xz3xQr for ; Wed, 13 May 2020 19:34:16 +0000 (UTC) Received: from mail02.haj.ipfire.org (mail02.haj.ipfire.org [172.28.1.201]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail02.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 49MlGw5gbFzTj; Wed, 13 May 2020 19:34:16 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 49MlGw4t7bz2yHP; Wed, 13 May 2020 19:34:16 +0000 (UTC) Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 49MlGw1jSFz2y9P for ; Wed, 13 May 2020 19:34:16 +0000 (UTC) Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384)) (Client did not present a certificate) by mail01.ipfire.org (Postfix) with ESMTPSA id 49MlGv1wq5zTj for ; Wed, 13 May 2020 19:34:14 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1589398455; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=MH3bN6e/cSFqnlJz0JtpBP65JfI/OLmvF1J0pzbX9Gk=; b=LM8ke0VaKrUFaZSeG2n7+pwvcKou6lRNo22U/mAyV6wa1i2E9UOx9i8k7w24O8CQMY58w1 jZLF2t5SqvA8QrDg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1589398455; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=MH3bN6e/cSFqnlJz0JtpBP65JfI/OLmvF1J0pzbX9Gk=; b=G6gOT/Klo4gHI9OQoMXY+hz96MPn1sdy+qVl3iEcN651i1UUTGK8QkHZwtfediDkR/yuEl GzH80EI0XZtJFdyOuEpSD92gRnrMfzBifLRK+UHJdO7tP91fvJfOvLxd2DOMooZlFDZ+oR OT2x6AxExWF+l2koGkwod+Noql8fYpprPuwSp9YMeGsZRq0SqBLNG3BhSSb0iaMkJW+2Ip pjnRlzD2ZFJj+tbOFX9wAm1FHtqRkIncEshNMb/iXMT8Itvk4WRi/5qnx/y7UkeTNfuZhI 5oFzWN2wrTtSoscMNnl4uz7AErNheA4Zl126UTn7aAq38zAwfHNFKsy4bWdMsw== Subject: [PATCH 4/4] location-importer: DELETE multicast and "reserved for future usage" address space To: location@lists.ipfire.org References: <46f10017-357f-fd8a-5dc6-eec8da9941a2@ipfire.org> From: =?utf-8?q?Peter_M=C3=BCller?= Message-ID: Date: Wed, 13 May 2020 19:33:54 +0000 MIME-Version: 1.0 In-Reply-To: Content-Language: en-US X-BeenThere: location@lists.ipfire.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: location-bounces@lists.ipfire.org Sender: "Location" Authentication-Results: mail01.ipfire.org; none X-Rspamd-Queue-Id: 49MlGw5gbFzTj X-Spamd-Result: default: False [-4.29 / 11.00]; ARC_NA(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; BAYES_HAM(-3.00)[99.99%]; FROM_HAS_DN(0.00)[]; FORGED_SENDER_MAILLIST(0.00)[]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[location@lists.ipfire.org]; TO_DN_NONE(0.00)[]; HAS_LIST_UNSUB(-0.01)[]; RCPT_COUNT_ONE(0.00)[1]; RCVD_COUNT_THREE(0.00)[4]; NEURAL_HAM(-0.98)[-0.982]; MAILLIST(-0.20)[mailman]; FORGED_RECIPIENTS_MAILLIST(0.00)[]; MIME_TRACE(0.00)[0:+]; RCVD_TLS_LAST(0.00)[]; FROM_NEQ_ENVFROM(0.00)[peter.mueller@ipfire.org,location-bounces@lists.ipfire.org]; MID_RHS_MATCH_FROM(0.00)[] X-Rspamd-Server: mail01.haj.ipfire.org Signed-off-by: Peter Müller --- src/python/location-importer.in | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/src/python/location-importer.in b/src/python/location-importer.in index 53c5cfe..79a024c 100644 --- a/src/python/location-importer.in +++ b/src/python/location-importer.in @@ -539,6 +539,10 @@ class CLI(object): -- DELETE IPv6 to IPv4 (6to4) address space DELETE FROM announcements WHERE family(network) = 4 AND network <<= '192.88.99.0/24'; + -- DELETE multicast and reserved address space + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '224.0.0.0/4'; + DELETE FROM announcements WHERE family(network) = 4 AND network <<= '240.0.0.0/4'; + -- Delete networks that are too small to be in the global routing table DELETE FROM announcements WHERE family(network) = 6 AND masklen(network) > 48; DELETE FROM announcements WHERE family(network) = 4 AND masklen(network) > 24;