More info »
IP Geolocation and Network Data

Enriching MMDB files with your own data using Go

by
Narsimham Chelluri

MaxMind DB (or MMDB) files facilitate the storage and retrieval of data in connection with IP addresses and IP address ranges, making queries for such data very fast and easy to perform. While MMDB files are usable on a variety of platforms and in a number of different programming languages, this article will focus on building MMDB files using the Go programming language .

MaxMind offers several prebuilt MMDB files, like the free GeoLite2 Country MMDB file. For many situations these MMDB files are useful enough as is. If, however, you have your own data associated with IP address ranges, you can create hybrid MMDB files, enriching existing MMDB contents with your own data. In this article, we’re going to add details about a fictional company’s IP address ranges to the GeoLite2 Country MMDB file. We’ll be building a new MMDB file, one that contains both MaxMind’s and our fictional company’s data.

If you don’t need any of the MaxMind data, but you still want to create a fast, easy-to-query database keyed on IP addresses and IP address ranges, you can consult this example code showing how to create an MMDB file from scratch .

Prerequisites

  • you must have git installed in order to clone the code and install the dependencies, and it must be in your $PATH
  • Go 1.14 or later must be installed, and go must be in your $PATH
  • the mmdbinspect tool must be installed and be in your $PATH
  • a copy of the GeoLite2 Country database must be in your working directory
  • your working directory (which can be located under any parent directory) must be named mmdb-from-go-blogpost (if you clone the code using the instructions below, this directory will be created for you)
  • a basic understanding of Go and of IP addresses and CIDR notation will be helpful, but allowances have been made for the intrepid explorer for whom these concepts are novel!

Using Docker or Vagrant

The code repository comes with a Dockerfile and a Vagrantfile included. If you’d like to begin work in an environment which has all of the necessary software dependencies pre-installed, see our documentation for getting started with Docker and Vagrant .

AcmeCorp’s data

For the purposes of this tutorial, I have mocked up some data for a fictional company, AcmeCorp. This method can be adapted for your own real data, as long as that data maps to IP addresses or IP address ranges.

AcmeCorp has three departments:

  • SRE, whose IP addresses come from the 56.0.0.0/16 range,
  • Development, whose IP addresses come from the 56.1.0.0/16 range, and
  • Management, whose IP addresses come from the 56.2.0.0/16 range.

Members of the SRE department have access to all three of AcmeCorp’s environments, development, staging, and production. Members of the Development and Management departments have access to the development and staging environments (but not to production).

Each valid record in GeoLite2 Country is a map, containing data about the country associated with the IP address.

For each of the AcmeCorp ranges, we’re going to add to the existing data the AcmeCorp.Environments and AcmeCorp.DeptName keys. More on this later.

The steps we’re going to take

We’re going to write some Go code that makes use of the MaxMind mmdbwriter Go module to:

  1. Load the GeoLite2 Country MaxMind DB.
  2. Add our own internal department data to the appropriate IP address ranges.
  3. Write the enriched database to a new MMDB file.
  4. Look up the new data in the enriched database to confirm our additions.
    • We will use the mmdbinspect tool to see our new data in the MMDB file we’ve built and compare a few ranges in it to those in the old GeoLite2 Country MMDB file.

The full code is presented in the next section. Let’s dive in!

The code, explained

The repo for this tutorial is available on GitHub . You can clone it locally and cd into the repo dir by running the following in a terminal window:

1me@myhost:~/dev $ git clone https://github.com/maxmind/mmdb-from-go-blogpost.git
2me@myhost:~/dev $ cd mmdb-from-go-blogpost

Now I’m going to break down the contents of main.go from the repo, the code that will perform steps 1-3 of the tutorial. If you prefer to read the code directly, you can skip to the next section.

All Go programs begin with a package main, indicating that this file will contain a main function, the start of our program’s execution. This program is no exception.

1package main

Most programs have a list of imported packages next. In our case, the list of packages imported include some from the standard library: log , which we use for outputting in error scenarios; net , for the net.ParseCIDR function and the net.IPNet type, which we use when inserting new data into the MMDB tree; and os , which we use when creating a new file into which we will write the MMDB tree. We also import some packages from MaxMind’s mmdbwriter repo, which are designed specifically for building MMDB files and for working with MMDB trees – you’ll see how we use those below.

1import (
2  "log"
3  "net"
4  "os"
5
6  "github.com/maxmind/mmdbwriter"
7  "github.com/maxmind/mmdbwriter/inserter"
8  "github.com/maxmind/mmdbwriter/mmdbtype"
9)

Now we’re at the start of the program execution. We begin by loading the existing database, GeoLite2-Country.mmdb, that we’re going to enrich.

1func main() {
2  // Load the database we wish to enrich.
3  writer, err := mmdbwriter.Load("GeoLite2-Country.mmdb", mmdbwriter.Options{})
4  if err != nil {
5    log.Fatal(err)
6  }

Having loaded the existing GeoLite2 Country database, we begin defining the data we wish to enrich it with. The second return value of the net.ParseCIDR() function is of type *net.IPNet , which is what we need for the first parameter for our upcoming writer.InsertFunc() call, so we use net.ParseCIDR() to go from the string-literal CIDR form "56.0.0.0/16" to the desired *net.IPnet.

1  // Define and insert the new data.
2  _, sreNet, err := net.ParseCIDR("56.0.0.0/16")
3  if err != nil {
4    log.Fatal(err)
5  }

sreData is the data we will be merging into the existing records for the SRE range. We must define this data in terms of the mmdbtype.DataType interface . mmdbwriter uses this interface to determine the data type to associate with the data when inserting it into the database.

As the existing GeoLite2 Country records are maps, we use a mmdbtype.Map as the top level data structure. This map contains our two new keys, AcmeCorp.DeptName and AcmeCorp.Environments.

AcmeCorp.DeptName is an mmdbtype.String containing the name of the department for the IP address range.

AcmeCorp.Environments is an mmdbtype.Slice . A slice contains an ordered list of values. In this case, it is a list of the environments that the IP address range is allowed to access. These environments are represented as mmdbtype.String values.

[An aside: If you look at the output of running the mmdbinspect -db GeoLite2-Country.mmdb 56.0.0.1 command in your terminal, examining the $.[0].Records[0].Record JSONPath (i.e. the sole record, stripped of its wrappers), then you’ll see that it is a JSON Object, which as expected corresponds to the mmdbtype.Map type.]

1  sreData := mmdbtype.Map{
2    "AcmeCorp.DeptName": mmdbtype.String("SRE"),
3    "AcmeCorp.Environments": mmdbtype.Slice{
4      mmdbtype.String("development"),
5      mmdbtype.String("staging"),
6      mmdbtype.String("production"),
7    },
8  }

Now that we’ve got our data, we insert it into the MMDB using InsertFunc . We use InsertFunc instead of Insert as it allows us to pass in an inserter function that will merge our new data with any existing data.

In this case, we are using the inserter.TopLevelMergeWith function. This updates the existing map with the keys from our new map.

After inserting, our MMDB tree will have the AcmeCorp SRE IP addresses in the 56.0.0.0/16 range, whose maps contain the new environment and department name keys in addition to whatever GeoLite2 Country data they returned previously. (Note that we carefully picked non-clashing, top-level keys; no key in the GeoLite2 Country data starts with AcmeCorp.)

What happens if there is an IP address for which no record exists? With the inserter.TopLevelMergeWith strategy, this IP address will also happily take our new top-level keys as well.

1  if err := writer.InsertFunc(sreNet, inserter.TopLevelMergeWith(sreData)); err != nil {
2    log.Fatal(err)
3  }

We repeat the process for the Development and Management departments, taking care to update the range itself, the list of environments, and the department name as we go.

 1  _, devNet, err := net.ParseCIDR("56.1.0.0/16")
 2  if err != nil {
 3    log.Fatal(err)
 4  }
 5  devData := mmdbtype.Map{
 6    "AcmeCorp.DeptName": mmdbtype.String("Development"),
 7    "AcmeCorp.Environments": mmdbtype.Slice{
 8      mmdbtype.String("development"),
 9      mmdbtype.String("staging"),
10    },
11  }
12  if err := writer.InsertFunc(devNet, inserter.TopLevelMergeWith(devData)); err != nil {
13    log.Fatal(err)
14  }
15
16  _, mgmtNet, err := net.ParseCIDR("56.2.0.0/16")
17  if err != nil {
18    log.Fatal(err)
19  }
20  mgmtData := mmdbtype.Map{
21    "AcmeCorp.DeptName": mmdbtype.String("Management"),
22    "AcmeCorp.Environments": mmdbtype.Slice{
23      mmdbtype.String("development"),
24      mmdbtype.String("staging"),
25    },
26  }
27  if err := writer.InsertFunc(mgmtNet, inserter.TopLevelMergeWith(mgmtData)); err != nil {
28    log.Fatal(err)
29  }

Finally we write the new database to disk.

 1  // Write the newly enriched DB to the filesystem.
 2  fh, err := os.Create("GeoLite2-Country-with-Department-Data.mmdb")
 3  if err != nil {
 4    log.Fatal(err)
 5  }
 6  _, err = writer.WriteTo(fh)
 7  if err != nil {
 8    log.Fatal(err)
 9  }
10}

Building the code and running it

So that’s our code! Now we build the program and run it. On my 2015-model laptop it takes under 10 seconds to run.

1me@myhost:~/dev/mmdb-from-go-blogpost $ go build
2me@myhost:~/dev/mmdb-from-go-blogpost $ ./mmdb-from-go-blogpost

This will have built the enriched database. Finally, we will compare some IP address and range queries on the original and enriched database using the mmdbinspect tool.

1me@myhost:~/dev/mmdb-from-go-blogpost $ mmdbinspect -db GeoLite2-Country.mmdb -db GeoLite2-Country-with-Department-Data.mmdb 56.0.0.1 56.1.0.0/24 56.2.0.54 56.3.0.1 | less

The output from this command, elided here for brevity, shows us that the AcmeCorp.Environments and AcmeCorp.DeptName keys are not present in the original MMDB file at all and that they are present in the enriched MMDB file when expected. The 56.3.0.1 IP address remains identical across both databases (without any AcmeCorp fields) as a control.

And that’s it! You’ve now built yourself a GeoLite2 Country MMDB file enriched with custom data.

Contacting Us

Feel free to open an issue in the repo if you have any questions or just want to tell us what you’ve created.

Anonymizer and Proxy Detection IP Network Data Technical Tutorials