people/ms/libloc.git
19 hours agocountry: Terminate buffer when reading from database master
Michael Tremer [Mon, 13 Jul 2020 10:47:30 +0000 (10:47 +0000)] 
country: Terminate buffer when reading from database

Compilers on ARM do not seem to initialise the buffer.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
3 days agoconfigure: Bump version to 0.9.3 0.9.3
Michael Tremer [Fri, 10 Jul 2020 14:49:49 +0000 (14:49 +0000)] 
configure: Bump version to 0.9.3

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
3 days agolocation(8): Remove any temporary files after unsuccessful downloads
Stefan Schantl [Fri, 10 Jul 2020 14:47:54 +0000 (16:47 +0200)] 
location(8): Remove any temporary files after unsuccessful downloads

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
3 days agolocation(8): Fix pasing timestamp for systems not running on UTC
Stefan Schantl [Fri, 10 Jul 2020 14:40:33 +0000 (16:40 +0200)] 
location(8): Fix pasing timestamp for systems not running on UTC

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
3 days agolocation(8): Allow downloading a database without one on disk
Michael Tremer [Fri, 10 Jul 2020 10:43:46 +0000 (10:43 +0000)] 
location(8): Allow downloading a database without one on disk

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
3 days agolocation(8): Allow limiting updates to once a day, week, month
Michael Tremer [Fri, 10 Jul 2020 10:41:23 +0000 (10:41 +0000)] 
location(8): Allow limiting updates to once a day, week, month

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 days agoimporter: Correctly sort the results
Michael Tremer [Mon, 6 Jul 2020 16:44:20 +0000 (16:44 +0000)] 
importer: Correctly sort the results

The results where incorrectly ordered so that the DISTINCT clause
removed the wrong rows matching an incorrect parent subnet.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
2 weeks agoimporter: Also add networks that are not announced to the database
Michael Tremer [Mon, 29 Jun 2020 15:42:43 +0000 (15:42 +0000)] 
importer: Also add networks that are not announced to the database

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
2 weeks agoimporter: Write NULL into database when bool is not set
Michael Tremer [Mon, 29 Jun 2020 13:34:26 +0000 (13:34 +0000)] 
importer: Write NULL into database when bool is not set

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
2 weeks agoimporter: Walk through all options for flags
Michael Tremer [Mon, 29 Jun 2020 13:28:06 +0000 (13:28 +0000)] 
importer: Walk through all options for flags

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 <michael.tremer@ipfire.org>
2 weeks agodatabase: Always require SSL
Michael Tremer [Mon, 29 Jun 2020 13:27:52 +0000 (13:27 +0000)] 
database: Always require SSL

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
3 weeks agolocation.in: strip trailing whitespaces in database description while dumping
Peter Müller [Mon, 22 Jun 2020 17:55:17 +0000 (17:55 +0000)] 
location.in: strip trailing whitespaces in database description while dumping

Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoconfigure: Bump version to 0.9.2 0.9.2
Michael Tremer [Mon, 15 Jun 2020 17:09:11 +0000 (17:09 +0000)] 
configure: Bump version to 0.9.2

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoEnable debug logging for all tests
Michael Tremer [Mon, 15 Jun 2020 16:48:04 +0000 (16:48 +0000)] 
Enable debug logging for all tests

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoconfigure: Update home and contact address
Michael Tremer [Mon, 15 Jun 2020 16:38:07 +0000 (16:38 +0000)] 
configure: Update home and contact address

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoman: Update documentation on renamed --output-format parameter
Michael Tremer [Mon, 15 Jun 2020 16:33:18 +0000 (16:33 +0000)] 
man: Update documentation on renamed --output-format parameter

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoman: Document export command
Michael Tremer [Mon, 15 Jun 2020 16:31:19 +0000 (16:31 +0000)] 
man: Document export command

Fixes: #12437
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoman: Order commands alphabetically on location(8)
Michael Tremer [Mon, 15 Jun 2020 16:23:14 +0000 (16:23 +0000)] 
man: Order commands alphabetically on location(8)

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agolocation: Fix handling of families argument
Michael Tremer [Fri, 12 Jun 2020 14:44:20 +0000 (14:44 +0000)] 
location: Fix handling of families argument

This was ignored, because it was already converted before
and the export function was expecting a string.

Fixes: #12436
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoFix timezone-dependant interpretation of database timestamp
Michael Tremer [Fri, 12 Jun 2020 14:33:48 +0000 (14:33 +0000)] 
Fix timezone-dependant interpretation of database timestamp

The timestamp that is retrieved from DNS is in UTC and we must
not interpret as local time.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agopython: Correctly set and use __version__
Michael Tremer [Fri, 12 Jun 2020 14:21:55 +0000 (14:21 +0000)] 
python: Correctly set and use __version__

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agodebian: Also build for sid
Stefan Schantl [Wed, 10 Jun 2020 15:28:17 +0000 (17:28 +0200)] 
debian: Also build for sid

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoPrint ASes in format like: AS204867 - Lightning Wire Labs GmbH
Michael Tremer [Tue, 9 Jun 2020 11:03:03 +0000 (11:03 +0000)] 
Print ASes in format like: AS204867 - Lightning Wire Labs GmbH

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agodebian: Disable perl package.
Stefan Schantl [Mon, 8 Jun 2020 16:35:19 +0000 (18:35 +0200)] 
debian: Disable perl package.

The perl package cannot be cross-compiled correctly for other
architectures different from the hosts one.

So currently disable the perl package until we get this fixed at a later
time.

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
4 weeks agoimporter: Return the last block, too
Michael Tremer [Tue, 9 Jun 2020 10:59:04 +0000 (10:59 +0000)] 
importer: Return the last block, too

Fixes: #12427
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodebian: Create separate package for the importer
Michael Tremer [Fri, 5 Jun 2020 13:08:01 +0000 (13:08 +0000)] 
debian: Create separate package for the importer

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodebian: build.sh: Stop printing every command that is executed
Michael Tremer [Fri, 5 Jun 2020 11:22:29 +0000 (11:22 +0000)] 
debian: build.sh: Stop printing every command that is executed

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodebian: Do not destroy the build result
Michael Tremer [Fri, 5 Jun 2020 11:22:09 +0000 (11:22 +0000)] 
debian: Do not destroy the build result

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodebian: unstable is called bullseye
Michael Tremer [Fri, 5 Jun 2020 11:20:30 +0000 (11:20 +0000)] 
debian: unstable is called bullseye

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodatabase: Fix broken search for networks with flags
Michael Tremer [Fri, 5 Jun 2020 10:01:47 +0000 (10:01 +0000)] 
database: Fix broken search for networks with flags

The search was ended after the first network. No matter if
it matched, or not.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agoexport flagged networks with their faked country names, too
Michael Tremer [Fri, 5 Jun 2020 09:57:41 +0000 (09:57 +0000)] 
export flagged networks with their faked country names, too

This will lead to some networks showing up twice. Once with
their real country and once with their faked one.

It is likely that the first one will match.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agolocation(8): Export all countries by default
Michael Tremer [Fri, 5 Jun 2020 09:47:36 +0000 (09:47 +0000)] 
location(8): Export all countries by default

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agoAdd option to iterate over all countries and print them to the console
Michael Tremer [Fri, 5 Jun 2020 09:41:28 +0000 (09:41 +0000)] 
Add option to iterate over all countries and print them to the console

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agoMakefile: Remove accidentially committed hacks for Debian
Michael Tremer [Thu, 4 Jun 2020 10:37:50 +0000 (10:37 +0000)] 
Makefile: Remove accidentially committed hacks for Debian

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodebian: Mark all packages as "Multi-Arch: same"
Michael Tremer [Thu, 4 Jun 2020 10:37:28 +0000 (10:37 +0000)] 
debian: Mark all packages as "Multi-Arch: same"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodebian: Correctly define runtime dependencies for all packages
Michael Tremer [Thu, 4 Jun 2020 10:31:31 +0000 (10:31 +0000)] 
debian: Correctly define runtime dependencies for all packages

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodebian: Rename main package to "location"
Michael Tremer [Thu, 4 Jun 2020 09:54:18 +0000 (09:54 +0000)] 
debian: Rename main package to "location"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodebian: Update rootfiles
Michael Tremer [Thu, 4 Jun 2020 08:39:02 +0000 (08:39 +0000)] 
debian: Update rootfiles

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agopo: Import translation strings
Michael Tremer [Wed, 3 Jun 2020 19:08:00 +0000 (19:08 +0000)] 
po: Import translation strings

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agoMerge location-exporter(8) into location(8)
Michael Tremer [Wed, 3 Jun 2020 18:36:28 +0000 (18:36 +0000)] 
Merge location-exporter(8) into location(8)

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agoRename location-query(8) to location(8)
Michael Tremer [Wed, 3 Jun 2020 17:21:31 +0000 (17:21 +0000)] 
Rename location-query(8) to location(8)

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agodownloader: Change user-agent to location
Michael Tremer [Wed, 3 Jun 2020 17:15:27 +0000 (17:15 +0000)] 
downloader: Change user-agent to location

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agosystemd: Rename location-downloader to location-update
Michael Tremer [Wed, 3 Jun 2020 17:14:37 +0000 (17:14 +0000)] 
systemd: Rename location-downloader to location-update

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agolocation-downloader: Merge man page into location-query
Michael Tremer [Wed, 3 Jun 2020 17:10:35 +0000 (17:10 +0000)] 
location-downloader: Merge man page into location-query

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agoMove location-downloader functionality into location-query
Michael Tremer [Wed, 3 Jun 2020 17:06:13 +0000 (17:06 +0000)] 
Move location-downloader functionality into location-query

The commands are very long and confusion. Hence we merge this
all into one command.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agolocation-exporter: Warn, but do not fail on invalid input
Michael Tremer [Wed, 3 Jun 2020 16:33:44 +0000 (16:33 +0000)] 
location-exporter: Warn, but do not fail on invalid input

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agolocation-exporter: Do not mistake country AS for an AS number
Michael Tremer [Wed, 3 Jun 2020 16:31:44 +0000 (16:31 +0000)] 
location-exporter: Do not mistake country AS for an AS number

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
5 weeks agolocation-query: Require at least one flag
Michael Tremer [Wed, 3 Jun 2020 16:15:24 +0000 (16:15 +0000)] 
location-query: Require at least one flag

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
6 weeks agoMakefile: Remove Python path overrides for Debian
Michael Tremer [Mon, 1 Jun 2020 18:23:50 +0000 (18:23 +0000)] 
Makefile: Remove Python path overrides for Debian

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
6 weeks agolocation-downloader: Do not change content of open database files
Michael Tremer [Mon, 1 Jun 2020 13:47:44 +0000 (13:47 +0000)] 
location-downloader: Do not change content of open database files

The database might be opened by another process. When modified,
it will return random results.

Fixes: #12420
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
6 weeks agotest: Generate random temporary files
Michael Tremer [Thu, 28 May 2020 14:17:00 +0000 (14:17 +0000)] 
test: Generate random temporary files

Debian runs the testsuite in parallel which fails when mutliple
process write to the same file at the same time.

This patch will now create and later delete a temporary file.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agoBump version to 0.9.1 0.9.1
Michael Tremer [Mon, 25 May 2020 08:22:29 +0000 (08:22 +0000)] 
Bump version to 0.9.1

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agoRevert "debian: Drop perl package"
Michael Tremer [Thu, 21 May 2020 18:11:32 +0000 (18:11 +0000)] 
Revert "debian: Drop perl package"

This reverts commit 3d26288681601b273f034de1f2241dc4342791b5.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Enable location-download.timer after installation
Stefan Schantl [Thu, 21 May 2020 18:09:55 +0000 (20:09 +0200)] 
debian: Enable location-download.timer after installation

This timer periodly executes the location-downloader and keeps
the location database up to date.

Fixes #12412.

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Ship database signing key.
Stefan Schantl [Thu, 21 May 2020 17:38:11 +0000 (19:38 +0200)] 
debian: Ship database signing key.

This key is needed to download and verify the database.

Fixes #12410.

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agoexamples/create-database.py: Add hack to allow loading the module in build environment.
Stefan Schantl [Thu, 21 May 2020 17:15:19 +0000 (19:15 +0200)] 
examples/create-database.py: Add hack to allow loading the module in build environment.

This script is needed to generate the database which is used by the
testsuite of the perl binding of libloc.

This allows us to revert the following commits:

482eb94f165507ffcb6503e162535064d6dcecac
3d26288681601b273f034de1f2241dc4342791b5

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Do not add auto-generated files
Michael Tremer [Tue, 19 May 2020 17:56:53 +0000 (17:56 +0000)] 
debian: Do not add auto-generated files

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agoman: Document quiet mode switch
Michael Tremer [Tue, 19 May 2020 17:54:47 +0000 (17:54 +0000)] 
man: Document quiet mode switch

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agolocation: Print country name if possible
Michael Tremer [Tue, 19 May 2020 17:50:35 +0000 (17:50 +0000)] 
location: Print country name if possible

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agolocation-importer: Implement importing/exporting countries
Michael Tremer [Tue, 19 May 2020 17:44:59 +0000 (17:44 +0000)] 
location-importer: Implement importing/exporting countries

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agolocation-query: Fix typo in "aut-num"
Michael Tremer [Tue, 19 May 2020 17:38:18 +0000 (17:38 +0000)] 
location-query: Fix typo in "aut-num"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agostringpool: Always add an empty string
Michael Tremer [Tue, 19 May 2020 16:53:53 +0000 (16:53 +0000)] 
stringpool: Always add an empty string

This will create an empty string at the first byte of the pool
and is helpful for our database metadata (vendor, license, de-
scription) which can be zero and would therefore return the
first string in the pool.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agoformat: Reduce the length of the signature header
Michael Tremer [Tue, 19 May 2020 12:22:50 +0000 (12:22 +0000)] 
format: Reduce the length of the signature header

Since a single signature can only be up to 2048 bytes long,
we do not need 32 bits to tell us how many of those bytes
are being used.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agotest: Sign database twice with the same key
Michael Tremer [Tue, 19 May 2020 12:14:11 +0000 (12:14 +0000)] 
test: Sign database twice with the same key

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agopython: Support passing two signing keys
Michael Tremer [Tue, 19 May 2020 12:11:37 +0000 (12:11 +0000)] 
python: Support passing two signing keys

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodatabase: Add support for two signatures
Michael Tremer [Tue, 19 May 2020 12:03:05 +0000 (12:03 +0000)] 
database: Add support for two signatures

This allows us to sign the database with two different keys
in case the first key gets weakened or compromised in any other
way.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Build a source package, too
Michael Tremer [Tue, 19 May 2020 11:48:48 +0000 (11:48 +0000)] 
debian: Build a source package, too

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Remove code that would have built a native package
Michael Tremer [Tue, 19 May 2020 11:47:44 +0000 (11:47 +0000)] 
debian: Remove code that would have built a native package

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Build each build in their own directory
Michael Tremer [Tue, 19 May 2020 11:47:08 +0000 (11:47 +0000)] 
debian: Build each build in their own directory

Otherwise we will have all packages in one large directory

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Build for unstable
Michael Tremer [Tue, 19 May 2020 11:44:58 +0000 (11:44 +0000)] 
debian: Build for unstable

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Do not build for riscv64
Michael Tremer [Tue, 19 May 2020 11:33:29 +0000 (11:33 +0000)] 
debian: Do not build for riscv64

The build requirements could not be satisfied

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Setup build environment only once per release
Michael Tremer [Tue, 19 May 2020 11:28:11 +0000 (11:28 +0000)] 
debian: Setup build environment only once per release

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
7 weeks agodebian: Drop perl package
Michael Tremer [Tue, 19 May 2020 11:27:46 +0000 (11:27 +0000)] 
debian: Drop perl package

This has runtime requirements and won't build when there is
no functional Python module

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agodebian: Add script to build package for various arches
Michael Tremer [Mon, 18 May 2020 14:54:24 +0000 (14:54 +0000)] 
debian: Add script to build package for various arches

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agodebian: Fix rootfiles
Michael Tremer [Mon, 18 May 2020 14:53:56 +0000 (14:53 +0000)] 
debian: Fix rootfiles

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agodatabase: Clear signature length before feeding header into the hash function
Michael Tremer [Mon, 18 May 2020 13:47:18 +0000 (13:47 +0000)] 
database: Clear signature length before feeding header into the hash function

Fixes: #12399
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agodatabase: Check if we could read the full header
Michael Tremer [Mon, 18 May 2020 13:46:53 +0000 (13:46 +0000)] 
database: Check if we could read the full header

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agohexdump: Show how much data we are dumping
Michael Tremer [Mon, 18 May 2020 13:45:52 +0000 (13:45 +0000)] 
hexdump: Show how much data we are dumping

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agoRevert "Tests: Disable testing for valid signature"
Michael Tremer [Mon, 18 May 2020 13:02:33 +0000 (13:02 +0000)] 
Revert "Tests: Disable testing for valid signature"

This reverts commit 25deb4d89b7b3f3af6022472392ac26b99af2462.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-downloader: Load the right database version
Michael Tremer [Sat, 16 May 2020 13:57:13 +0000 (13:57 +0000)] 
location-downloader: Load the right database version

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agotest-database: Check opening files with no or random data
Michael Tremer [Sat, 16 May 2020 10:59:26 +0000 (10:59 +0000)] 
test-database: Check opening files with no or random data

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agoFix reading database in newer version
Michael Tremer [Sat, 16 May 2020 10:52:18 +0000 (10:52 +0000)] 
Fix reading database in newer version

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agoDo not attempt freeing the stringpool when it isn't allocated
Michael Tremer [Sat, 16 May 2020 10:33:05 +0000 (10:33 +0000)] 
Do not attempt freeing the stringpool when it isn't allocated

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agoBump database version to "1"
Michael Tremer [Sat, 16 May 2020 10:24:52 +0000 (10:24 +0000)] 
Bump database version to "1"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-importer: Remove unused regular expression
Michael Tremer [Sat, 16 May 2020 10:05:34 +0000 (10:05 +0000)] 
location-importer: Remove unused regular expression

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-importer: Abort when we could not get a greeting from route server
Michael Tremer [Sat, 16 May 2020 10:05:12 +0000 (10:05 +0000)] 
location-importer: Abort when we could not get a greeting from route server

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-query: Add command to show the database version
Michael Tremer [Fri, 15 May 2020 14:00:20 +0000 (14:00 +0000)] 
location-query: Add command to show the database version

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-impoter: Allow overriding country by AS override
Michael Tremer [Fri, 15 May 2020 13:54:46 +0000 (13:54 +0000)] 
location-impoter: Allow overriding country by AS override

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-importer: Fix typo in "aut-num"
Michael Tremer [Fri, 15 May 2020 12:56:33 +0000 (12:56 +0000)] 
location-importer: Fix typo in "aut-num"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-importer: Skip everything with /0
Michael Tremer [Fri, 15 May 2020 12:29:07 +0000 (12:29 +0000)] 
location-importer: Skip everything with /0

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-query: Include flags in dump output
Michael Tremer [Fri, 15 May 2020 12:08:52 +0000 (12:08 +0000)] 
location-query: Include flags in dump output

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-query: Show flags in lookup output
Michael Tremer [Fri, 15 May 2020 12:00:53 +0000 (12:00 +0000)] 
location-query: Show flags in lookup output

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-importer: Remove some debugging output
Michael Tremer [Fri, 15 May 2020 11:48:01 +0000 (11:48 +0000)] 
location-importer: Remove some debugging output

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-downloader: Give the database a proper name
Michael Tremer [Fri, 15 May 2020 11:02:28 +0000 (11:02 +0000)] 
location-downloader: Give the database a proper name

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agoAdd quiet mode
Michael Tremer [Fri, 15 May 2020 11:01:38 +0000 (11:01 +0000)] 
Add quiet mode

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agopython: Correctly set log level for root logger
Michael Tremer [Fri, 15 May 2020 10:58:25 +0000 (10:58 +0000)] 
python: Correctly set log level for root logger

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks ago.gitignore: Omit *.db and *.db.xz from git status output
Michael Tremer [Fri, 15 May 2020 10:50:27 +0000 (10:50 +0000)] 
.gitignore: Omit *.db and *.db.xz from git status output

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-importer: Fix SQL syntax error
Michael Tremer [Fri, 15 May 2020 10:49:38 +0000 (10:49 +0000)] 
location-importer: Fix SQL syntax error

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-importer: Speed up exporting the database
Michael Tremer [Fri, 15 May 2020 09:06:22 +0000 (09:06 +0000)] 
location-importer: Speed up exporting the database

This optimisation returns the same result, but in about
one fifteenth of the time than the previous version of
the query.

This can also be parallelised by PostgreSQL so that more
CPU cores will decrease the time it takes to generate
the network list.

On my system this went down from 75 to 5 minutes.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
8 weeks agolocation-import: Abort when we could not parse the prefix
Michael Tremer [Thu, 14 May 2020 16:19:41 +0000 (16:19 +0000)] 
location-import: Abort when we could not parse the prefix

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