- 21 Sep, 2020 3 commits
-
-
Peter Müller authored
When importing inetnums, we might import various small networks which are not relevant for us as long as they do not have a different country code than their parent network. Therefore we delete all these entries to keep the database smaller without losing any information. The second version of this patch introduces a SQL statement parallelised across all CPUs available, while the DELETE-statement of the first version literally took ages to complete. However, cleaning up those data still takes about 26 hours (!) on our location02 testing machine, making daily updates of the location database impossible to the current knowledge. real 1521m30.620s user 38m45.521s sys 9m6.027s Special thanks goes to Michael for spending numerous hours on this, setting up a testing environment, doing PostgreSQL magic and providing helpful advice while debugging. Partially fixes: #12458 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>
-
Peter Müller authored
The extended feeds do not have enough detailed information for us, so that we need to import inetnums from RIRs where possible. Filtering private networks is necessary as RIR data may contain 0.0.0.0/0 or similar entries for administrative purposes or due to misfilings. Special thanks goes to Michael for spending numerous hours on this, setting up a testing environment and providing helpful advice while debugging. Partially fixes: #12458 Cc: Michael Tremer <michael.tremer@ipfire.org> Signed-off-by:
-
Peter Müller authored
Signed-off-by:
-
- 18 Sep, 2020 6 commits
-
-
Michael Tremer authored
Signed-off-by: -
Michael Tremer authored
We can use this to avoid formatting the network in a string representation which is then parsed again later to determine the first and last addresses. Signed-off-by: -
Michael Tremer authored
This avoids recomputing the last address multiple times. Signed-off-by: -
Michael Tremer authored
Signed-off-by: -
Michael Tremer authored
It is unnecessary to write any subnets in the output, because they might already be included in a bigger parent network. Since the tree is ordered, we only need to check if the network to be written is a subnet of the previous one. If so, we skip it. Signed-off-by: -
Stefan Schantl authored
Signed-off-by:
Stefan Schantl <stefan.schantl@ipfire.org> Signed-off-by:
-
- 10 Sep, 2020 4 commits
-
-
Stefan Schantl authored
Signed-off-by:
-
Stefan Schantl authored
Signed-off-by:
-
Stefan Schantl authored
Signed-off-by:
-
Stefan Schantl authored
This function can be used to get the stored name for a given country code. Signed-off-by:
-
- 31 Aug, 2020 3 commits
-
-
Stefan Schantl authored
Signed-off-by:
-
Stefan Schantl authored
Signed-off-by:
-
Stefan Schantl authored
This function can be used to check if a given address or network has one of the following network flags. * LOC_NETWORK_FLAG_ANONYMOUS_PROXY * LOC_NETWORK_FLAG_SATELLITE_PROVIDER * LOC_NETWORK_FLAG_ANYCAST It will return true if the given flag is set. Signed-off-by:
-
- 24 Aug, 2020 1 commit
-
-
Stefan Schantl authored
This function can be use to give the numer of an Autonomous System and get back the stored name from the used location database. Signed-off-by:
-
- 21 Aug, 2020 3 commits
-
-
Stefan Schantl authored
Signed-off-by:
-
Stefan Schantl authored
The generated database is used by the testsuite of the perl binding. Signed-off-by:
-
Stefan Schantl authored
This function is used to the stored countries of a database, which easily can be assigned to an array. Signed-off-by:
-
- 04 Aug, 2020 1 commit
-
-
Michael Tremer authored
Signed-off-by:
-
- 03 Aug, 2020 1 commit
-
-
Stefan Schantl authored
Signed-off-by:
-
- 28 Jul, 2020 1 commit
-
-
Michael Tremer authored
Signed-off-by:
-
- 24 Jul, 2020 1 commit
-
-
Michael Tremer authored
If the route server is now a socket, the importer will connect to it and fetch the routing table. This is a lot faster than telnet. Signed-off-by:
-
- 13 Jul, 2020 1 commit
-
-
Michael Tremer authored
Compilers on ARM do not seem to initialise the buffer. Signed-off-by:
-
- 10 Jul, 2020 5 commits
-
-
Michael Tremer authored
Signed-off-by: -
Stefan Schantl authored
Signed-off-by: -
Stefan Schantl authored
Signed-off-by: -
Michael Tremer authored
Signed-off-by: -
Michael Tremer authored
Signed-off-by:
-
- 06 Jul, 2020 1 commit
-
-
Michael Tremer authored
The results where incorrectly ordered so that the DISTINCT clause removed the wrong rows matching an incorrect parent subnet. Signed-off-by:
-
- 29 Jun, 2020 4 commits
-
-
Michael Tremer authored
Signed-off-by: -
Michael Tremer authored
Signed-off-by: -
Michael Tremer authored
It could happen that a network was marked, but the AS was not. Since the AS is checked first, we won't check the network and therefore write the wrong information into the database. Signed-off-by: -
Michael Tremer authored
Signed-off-by:
-
- 22 Jun, 2020 1 commit
-
-
Peter Müller authored
Signed-off-by:
-
- 15 Jun, 2020 4 commits
-
-
Michael Tremer authored
Signed-off-by: -
Michael Tremer authored
Signed-off-by: -
Michael Tremer authored
Signed-off-by: -
Michael Tremer authored
Signed-off-by:
-
