Auto-generated update

Auto-generated update

Auto-generated update

country-overrides: add AS48090 (PPTECHNOLOGY LIMITED)

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

country-overrides: add AS204655 (Novogara Ltd.)

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Auto-generated update

country-overrides: add AS56611 (REBA Communications BV)

Partially fixes: #12421

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

country-overrides: add AS57717 (FiberXpress BV)

Partially fixes: #12421

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

country-overrides: fix misspelled description

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

country-overrides: add AS202425 (IP Volume Inc.)

Partially fixes: #12421

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Auto-generated update

Auto-generated update

country-overrides: add 185.244.29.0/24 (Gerber EDV / Daniel Craig)

Partially fixes: #12421

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

country-overrides: add 2a02:e00:ffe7::/48 (Bradler & Krantz GmbH & Co. KG)

Partially fixes: #12421

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

country-overrides: add 95.181.152.0/21 (QWARTA LLC)

Partially fixes: #12421

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

countries: Add names

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

Auto-generated update

other: Fix spelling of "aut-num"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Auto-generated update

Fix typo in subnet mask

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

A{1,2} overrides: replace "net" by "aut-num" for ASNs

Cc: Michael Tremer <michael.tremer@ipfire.org>
Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

override-other.txt: add some ASNs with faked location

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

override-other.txt: drop non-routable IP networks

These are now handled by the location-importer, so we do not need to
maintain an additional list here.

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Drop all existing data

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Rename country-overrides -> overrides

We can basically override anything, so the name did not make
much sense any more

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Drop all code from this repository

This has been moved into libloc

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

override-a2.txt: rework A2 overrides

This patch reworks the A2 override file. Instead of setting "country"
nor "newcountry", networks of satellite internet providers are now flagged
by "is-satellite-provider: yes".

ASNs have been added again, as their usage is very helpful.

Cc: Michael Tremer <michael.tremer.ipfire.org>
Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

override-a1.txt: rework A1 overrides

This patch reworks the A1 override file. Instead of setting "country"
nor "newcountry", networks of anonymous proxy services are now flagged
by "is-anonymous-proxy: yes".

ASNs have been added again, as their usage is very helpful.

Cc: Michael Tremer <michael.tremer.ipfire.org>
Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Handle any error messages inlined into the response

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Add the correct WHOIS servers to each RIR

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Add a caching layer to WHOIS

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

AFRINIC: Add ASN names

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Fetch organization names for ASes from WHOIS

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Fix skipping the version line

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Attempt parsing lines without an organisation id

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Drop more dead code

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Add date of allocation to ASes and networks

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Remove dead code

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: This is no longer a LACNIC parser only any more

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Do not raise exception immediately

Was a debugging line that was left in

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Skip everything that isn't assigned (yet)

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Skip the version line and others

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Import data from all RIRs in new file format

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Mirgate to use extended format

This patch drops parsing the "whois" information and uses
the "new" "RIR Statistics Exchange Format":

  ftp://ftp.ripe.net/ripe/stats/RIR-Statistics-Exchange-Format.txt

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Add some more country codes.

* Bonaire, Sint Eustatius and Saba (BQ)
* Curacao (CW)
* South Sudan (SS)
* Sint Maarten (SX)

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

overrides: Rename newcountry to country

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

overrides: Remove all networks with an invalid subnet

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Import custom overrides

Fixes: #11755
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Set flags when parsing A1-A3

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Add countries to database

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Import

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Update all RIRs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Fix downloading databases in the default format

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

add networks with faked KP location

These networks claim to be located in North Korea, but are mostly used
for VPN or other anonymisation purposes. Therefore they are added to
A1 or "others" override files.

See https://blog.trendmicro.com/trendlabs-security-intelligence/a-closer-look-at-north-koreas-internet/
for details. 57.73.224.0/19 was reassigned since then and contains
valid data now, causing it to be omitted.

The second version of this patch superseds the first
one which was broken due to bugs in the MUAs GPG implementation.

Fixes #11757.

Signed-off-by: Peter Müller <peter.mueller@link38.eu>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Import for import of LACNIC

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Add parser for LACNIC

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Migrate to a binary-encoded database format

This approach is very similar to the one that we used before, but instead of storing
IP addresses as two integers, they are encoded as a big-endian 128 bit long binary
"string".

This is then stored as the BLOB data type of sqlite which has fewer limitations in
length, can be indexed and uses memcmp() which should be at least as fast as comparing
integers.

This allows a slightly easier query and seems to me significantly faster than the
PostgreSQL approach.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Update data for AFRINIC

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Fix merging the database with SQLite

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Revert "Replace sqlite with PostgreSQL"

This reverts commit 44c781ac664bf0f6670651e0a721fe2ddc446e66.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Update ARIN

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Update AfriNIC

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Ignore some blocks in the source from AfriNIC

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Update RIPE

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

A1 overrides: add missing PureVPN networks and clean up

GZ Systems Ltd. has some other networks which were not added to A1 overrides
by mistake. To clean up the list a little bit and make file processing faster,
some of the networks were allocated in bigger ones (>= /23).

Sorry for this large patch, but I guess it does not make much sense to add
a bunch of networks fist and then split them apart afterwards. :-|

Signed-off-by: Peter Müller
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

A1 overrides: add IAPS Security Services, L.L.C.

IAPS is a VPN provider claiming its networks to be located in VA.

Signed-off-by: Peter Müller <peter.mueller@link38.eu>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Update APNIC

These networks now contain the correct subnet

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Actually print the correct subnet to file

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

tools: Commit to database only once when importing data

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Import APNIC

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Replace sqlite with PostgreSQL

sqlite cannot match any subnets which makes it useless for us.

PostgreSQL has a data type for IP addresses which can be used
to match subnets against each other.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Set database vendor

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

add networks to overrides-other which must not be added

These networks are covered for special use by some RFCs
and must not be added to the database.

Signed-off-by: Peter Müller <peter.mueller@link38.eu>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

add A2 overrides

Add override entries for A2 networks (satellite internet providers).

Signed-off-by: Peter Müller <peter.mueller@link38.eu>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>