ipgeolocation.io Database Reader

This is a step-by-step guide on how to deploy the ipgeolocation-database-reader-1.0.6.war Java API and consume API responses.

What's New

Fixed the DB-V caching and querying issue on providing include=security parameter

Requirements

JDK 8 (This reader is built and tested using JDK 1.8).
For CSV databases, at least 4-8 GB RAM (for smaller CSV databases) and maximum 16 GB RAM for larger databases like DB-IV, DB-VI, and DB-VII.
For MMDB databases, at least 2-4 GB RAM only.
ipgeolocation-database-reader-1.0.6.war provided with this archive.

Basic Usage

For Linux

Follow the steps below (commands against each step are also provided) to deploy and consume the IP to City+ISP+Proxy database:

Create ~/conf/ipgeolocation directory in the 'home' directory.
```
mkdir -p ~/conf/ipgeolocation
```
Create 'database-reader-config' file in the ~/conf/ipgeolocation directory.
```
vi ~/conf/ipgeolocation/database-reader-config
```

Write the following YAML config values in it (You can use any editor of your choice like nano. I am using vim.):
```
ipgeolocation:
  database:
    workingDirectory: "/etc/ipgeolocation"
    apiKey: "YOUR_API_KEY"
    version: "DB-VII"
    updateInterval: "week"
    type: "mmdb"
    autoFetchAndUpdate: false
```
- Against apiKey key, replace YOUR_API_KEY value with the API key from your database subscription.
- Against version key, replace DB-VII value with the database version that you've subscribed to. It can be DB-I, DB-II, DB-III, DB-IV, DB-V, DB-VI, or DB-VII.
- Against updateInterval key, replace week value with your database subscription update interval. It can be week, or month.
- Against type key, replace mmdb value with your choice of database to query from. It can be csv, or mmdb. It's default value is mmdb and can be skipped from configuration.
- Against autoFetchAndUpdate key, the value can be true or false.
  - If set to true, the database reader will download the latest database as soon as it is available and will restart to load the latest database in-memory.
  - If set to false, the database reader will not check for the updated database for you. You can send a POST request to /database/update endpoint to fetch and update the database in-memory if an update is available. For example, here is a cURL request: curl --location --request POST 'http://address-to-api:8080/database/update'
  - It's default value is true and can be skipped from configuration.

Run the WAR file
```
java -jar -Xms6G -Xmx10G /path/to/ipgeolocation-database-reader-1.0.6.war
```
Note: Use -Xms<ram_size1> flag to set the minimum RAM and -Xmx<ram_size2> to set the maximum RAM to be allocated to execute the 'ipgeolocation-database-reader-1.0.6.war' application. Note: ram_size1 is the minimum RAM, and ram_size2 is the maximum RAM allocated to the application. Note: You can deploy the WAR file in an embedded container like Apache Tomcat as well.

The database reader will download the latest database and load it in-memory while bootstrapping and will update the database as soon as the new update is available, if autoFetchAndUpdate is set to true.

Note: database reader needs to restart after fetching the latest database to cache the updated database in-memory because caching the database without restarting will require as much as double of the required RAM which is a very costly choice.

Other Ways to Provide Configurations

By default, the database reader will look at ~/conf/ipgeolocation/database-reader-config path for the YAML file. You can provide the YAML configurations from your custom location as well. Let's assume that you've created the YAML configurations at /etc/ipgeolocation/ipgeo-db-reader-conf. Here is how you can pass it to the database reader:

java -Dspring.config.import=file:/etc/ipgeolocation/ipgeo-db-reader-conf[.yaml] -jar -Xms6G -Xmx10G /path/to/ipgeolocation-database-reader-1.0.6.war

Note: [.yaml] is hint to the reader that configurations are in YAML format.

For Windows

Follow the steps below (commands against each step are also provided) to deploy and consume the IP to City+ISP+Proxy database:

Create C:\conf\ipgeolocation folders in the 'C' or any other drive of your choice.

C:
mkdir conf\ipgeolocation

Create 'database-reader-config' file in the C:\conf\ipgeolocation directory.
```
cd conf\ipgeolocation
copy NULL database-reader-config.yml
```

Write the following YAML config values in it (You can use any editor of your choice.):
```
ipgeolocation:
  database:
    workingDirectory: "C:\\conf\\ipgeolocation"
    apiKey: "YOUR_API_KEY"
    version: "DB-VII"
    updateInterval: "week"
    type: "mmdb"
    autoFetchAndUpdate: false
```
- Against apiKey key, replace YOUR_API_KEY value with the API key from your database subscription.
- Against version key, replace DB-VII value with the database version that you've subscribed to. It can be DB-I, DB-II, DB-III, DB-IV, DB-V, DB-VI, or DB-VII.
- Against updateInterval key, replace week value with your database subscription update interval. It can be week, or month.
- Against type key, replace mmdb value with your choice of database to query from. It can be csv, or mmdb. It's default value is mmdb and can be skipped from configuration.
- Against autoFetchAndUpdate key, the value can be true or false.
  - If set to true, the database reader will download the latest database as soon as it is available and will restart to load the latest database in-memory.
  - If set to false, the database reader will not check for the updated database for you. You can send a POST request to /database/update endpoint to fetch and update the database in-memory if an update is available. For example, here is a cURL request: curl --location --request POST 'http://address-to-api:8080/database/update'
  - It's default value is true and can be skipped from configuration.

Run the WAR file
```
java -jar -Xms4G -Xmx4G -Dspring.config.import=file:C:\\conf\\ipgeolocation\\database-reader-config.yml C:\path\to\ipgeolocation-database-reader-1.0.6.war
```
Note: Use -Xms<ram_size1> flag to set the minimum RAM and -Xmx<ram_size2> to set the maximum RAM to be allocated to execute the 'ipgeolocation-database-reader-1.0.6.war' application. Note: ram_size1 is the minimum RAM, and ram_size2 is the maximum RAM allocated to the application. Note: You can deploy the WAR file in an embedded container like Apache Tomcat as well.

The database reader will download the latest database and load it in-memory while bootstrapping and will update the database as soon as the new update is available, if autoFetchAndUpdate is set to true.

Note: database reader needs to restart after fetching the latest database to cache the updated database in-memory because caching the database without restarting will require as much as double of the required RAM which is a very costly choice.

Note: [.yaml] is hint to the reader that configurations are in YAML format.

Another way is not create a YAML file and provide the configurations as the command-line arguments to the war file. Here is how you can do that:

java -Dipgeolocation.database.workingDirectory=/etc/ipgeolocation -Dipgeolocation.database.api=YOUR_API_KEY -Dipgeolocation.database.version=DB-VII -Dipgeolocation.database.updateInterval=week -Dipgeolocation.database.type=week -Dipgeolocation.database.autoFetchAndUpdate=false -jar -Xms6G -Xmx10G /path/to/ipgeolocation-database-reader-1.0.6.war

How to Get IP Geolocation

ipgeolocation.io Database Reader runs at 8080 port by default. The reader will take about 10 seconds to 6 minutes to deploy the updated database files based on the chosen configurations.

Note: All the examples assume that the reader has been deployed on the localhost at port 8080.

Single IP Geolocation Lookup

For single IP Geolocation lookup for any IPv4 or IPv6 address with JSON response, the URL for this endpoint is http://localhost:8080/ipGeo and its full JSON response is below:

{
    "ip": "8.8.8.8",
    "continent_code": "NA",
    "continent_name": "North America",
    "country_code2": "US",
    "country_code3": "USA",
    "country_name": "United States",
    "country_capital": "Washington",
    "state_prov": "California",
    "district": "",
    "city": "Mountain View",
    "zipcode": "94043",
    "latitude": "37.4229",
    "longitude": "-122.085",
    "is_eu": false,
    "calling_code": "+1",
    "country_tld": ".us",
    "languages": "en-US,es-US,haw,fr",
    "country_flag": "https://ipGeolocation.io/static/flags/us_64.png",
    "isp": "Level 3 Communications",
    "connection_type": "",
    "organization": "Google Inc.",
    "geoname_id": "5375480",
    "currency": {
        "code": "USD",
        "name": "US Dollar",
        "symbol": "$"
    },
    "time_zone": {
        "name": "America/Los_Angeles",
        "offset": -8,
        "current_time": "2019-01-14 03:30:00.135-0800",
        "current_time_unix": 1547465400.135,
        "is_dst": false,
        "dst_savings": 1
    },
    "security": {
        "threat_score": 0,
        "is_tor": false,
        "is_proxy": false,
        "proxy_type": "",
        "is_anonymous": false,
        "is_known_attacker": false,
        "is_cloud_provider": false
    }
}

Passing an IPv4, or IPv6 Address

In order to find geolocation information for any IP address, pass it as a query parameter like below. This endpoint is meant to be called from the server side.

Get geolocation for an IPv4 IP Address = 1.1.1.1

curl 'http://localhost:8080/ipGeo?ip=1.1.1.1'

Get geolocation for an IPv6 IP Address = 2001:4860:4860::1

curl 'http://localhost:8080/ipGeo?ip=2001:4860:4860::1'

Without Passing an IP Address

When the IP address is not present, it returns the geolocation information of the device/client which is calling it. This endpoint is meant to be called from client side.

curl 'http://localhost:8080/ipGeo'

** IP address is always included in the API response

Bulk IP Geolocation Lookup

This endpoint allows you to perform the lookup of multiple IPv4 and IPv6 addresses (max. 50) at the same time.
To perform bulk IP Geolocation Lookup, send a POST request and pass the ips array as JSON data along with it. Here is an example:

curl -X POST 'http://localhost:8080/ipGeoBulk' -H 'Content-Type: application/json' -d '{ "ips": ["1.1.1.1", "1.2.3.4"] }'

Response in Multiple Languages

The geolocation information for an IP address can be retrieved in the following languages:

English (en)
German (de)
Russian (ru)
Japanese (ja)
French (fr)
Chinese Simplified (cn)
Spanish (es)
Czech (cs)
Italian (it)

By default, the reader responds in English. You can change the response language by passing the language code as a query parameter lang. Here are a few cURL examples:

Get geolocation for an IPv4 IP Address = 1.1.1.1 in Chinese language

curl 'http://localhost:8080/ipGeo?ip=1.1.1.1&lang=cn'

Get details for an IPv6 IP Address = 2001:4860:4860::1 in Russian

curl 'http://localhost:8080/ipGeo?ip=2001:4860:4860::1&lang=ru'

Filter Responses

We've built the reader to give you fine granularity. Specify what you want in query parameter and get only those fields. This will save processing time, bandwidth and improve the API response time.

You can filter the API response in two ways:

Get the Required Fields Only

First, you can filter the reader response by specifying names of the fields that you want instead of getting the full response. Names of the required fields must be passed as a query parameter fields in the request. Here are a few examples to get only the required fields:

Get City Information Only

curl 'http://localhost:8080/ipGeo?ip=1.1.1.1&fields=city'

{
    "ip": "1.1.1.1",
    "city": "South Brisbane"
}

Get Country Name and Country Code (ISO2) Only

curl 'http://localhost:8080/ipGeo?ip=1.1.1.1&fields=country_code2,country_name'

{
    "ip": "1.1.1.1",
    "country_code2": "AU",
    "country_name": "Australia"
}

Get the Time Zone Information Only

curl 'http://localhost:8080/ipGeo?ip=1.1.1.1&fields=time_zone'

{
    "ip": "1.1.1.1",
    "time_zone": {
        "name": "America/Los_Angeles",
        "offset": -8,
        "current_time": "2018-12-06 00:28:40.339-0800",
        "current_time_unix": 1544084920.339,
        "is_dst": false,
        "dst_savings": 1
    }
}

Get Only the Local Currency Information of Multiple IP Addresses

You can use the filters with Bulk IP Lookup as well. Here is an example:

curl -X POST 'http://localhost:8080/ipGeoBulk?fields=currency' -H 'Content-Type: application/json' -d '{ "ips": ["1.1.1.1", "1.2.3.4"] }'

[
    {
        "ip": "1.1.1.1",
        "currency": {
            "name": "Australian Dollar",
            "code": "AUD",
            "symbol": "A$"
        }
    },
    {
        "ip": "1.2.3.4",
        "currency": {
            "name": "Australian Dollar",
            "code": "AUD",
            "symbol": "A$"
        }
    }
]

Get Geo Location Only

We know, usually, the users are interested in geolocation information only. So, we have added a shortcut for you. You can specify just fields=geo in the query parameter.

curl 'http://localhost:8080/ipGeo?ip=1.1.1.1&fields=geo'

{
    "ip": "1.1.1.1",
    "country_code2": "AU",
    "country_code3": "AUS",
    "country_name": "Australia",
    "state_prov": "Queensland",
    "district": "Brisbane",
    "city": "South Brisbane",
    "zipcode": "4101",
    "latitude": "-27.4748",
    "longitude": "153.017"
}

Remove the Unnecessary Fields

Second, you can also filter the reader response by specifying the names of fields (except IP address) that you want to remove from the API response. Names of the fields must be passed as a query parameter excludes in the request. Here are a few examples to exclude the unnecessary fields from the API response:

Exclude Continent Code, Currency and, Time zone Objects

curl 'http://localhost:8080/ipGeo?ip=1.1.1.1&excludes=continent_code,currency,time_zone'

{
    "ip": "1.1.1.1",
    "continent_name": "Oceania",
    "country_code2": "AU",
    "country_code3": "AUS",
    "country_name": "Australia",
    "country_capital": "Canberra",
    "state_prov": "Queensland",
    "district": "Brisbane",
    "city": "South Brisbane",
    "zipcode": "4101",
    "latitude": "-27.4748",
    "longitude": "153.017",
    "is_eu": false,
    "calling_code": "+61",
    "country_tld": ".au",
    "languages": "en-AU",
    "country_flag": "https://ipGeolocation.io/static/flags/au_64.png",
    "isp": "Cloudflare Inc.",
    "connection_type": "",
    "organization": "",
    "geoname_id": "2207259"
}

Get the Geo Field and Exclude Continent Information

curl 'http://localhost:8080/ipGeo?ip=1.1.1.1&fields=geo&excludes=continent_code,continent_name'

{
    "ip": "1.1.1.1",
    "country_code2": "AU",
    "country_code3": "AUS",
    "country_name": "Australia",
    "state_prov": "Queensland",
    "district": "Brisbane",
    "city": "South Brisbane",
    "zipcode": "4101",
    "latitude": "-27.4748",
    "longitude": "153.017"
}

IP-Security Information for an IP Address

The reader also provides IP-Security information, but doesn't respond it by default. To get IP-Security information along with geolocation information, you must pass the include=security as a query parameter in the URL.

Here is an example to IP Geolocation lookup that includes IP security information for the IP address:

curl 'http://localhost:8080/ipGeo?ip=198.90.78.238&fields=geo&include=security'

{
    "ip": "198.90.78.238",
    "country_code2": "CA",
    "country_code3": "CAN",
    "country_name": "Canada",
    "state_prov": "Quebec",
    "district": "Sainte-Rose",
    "city": "Laval",
    "zipcode": "H7P 4W5",
    "latitude": "45.58160",
    "longitude": "-73.76980",
    "security": {
        "threat_score": 7,
        "is_tor": false,
        "is_proxy": true,
        "proxy_type": "VPN",
        "is_anonymous": true,
        "is_known_attacker": false,
        "is_cloud_provider": false
    }
}

Error Codes

The reader returns 200 HTTP status in case of a successful request.

While, in case of an illegal request, reader returns 4xx HTTP code alongs with a descriptive message as why the error occurred.

Here is the description of why a specific HTTP code is returned:

HTTP Status	Description
400	If the queried IP address or domain name is not valid.
404	If the queried IP address or domain name is not found in our database.
423	If the queried IP address is a bogon (reserved) IP address like private, multicast, etc.

Name		Name	Last commit message	Last commit date
Latest commit History 132 Commits
.mvn/wrapper		.mvn/wrapper
src		src
.attach_pid18991		.attach_pid18991
.gitignore		.gitignore
README.md		README.md
mvnw		mvnw
mvnw.cmd		mvnw.cmd
pom.xml		pom.xml

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

ipgeolocation.io Database Reader

What's New

Requirements

Basic Usage

For Linux

Other Ways to Provide Configurations

For Windows

How to Get IP Geolocation

Single IP Geolocation Lookup

Passing an IPv4, or IPv6 Address

Get geolocation for an IPv4 IP Address = 1.1.1.1

Get geolocation for an IPv6 IP Address = 2001:4860:4860::1

Without Passing an IP Address

Bulk IP Geolocation Lookup

Response in Multiple Languages

Get geolocation for an IPv4 IP Address = 1.1.1.1 in Chinese language

Get details for an IPv6 IP Address = 2001:4860:4860::1 in Russian

Filter Responses

Get the Required Fields Only

Get City Information Only

Get Country Name and Country Code (ISO2) Only

Get the Time Zone Information Only

Get Only the Local Currency Information of Multiple IP Addresses

Get Geo Location Only

Remove the Unnecessary Fields

Exclude Continent Code, Currency and, Time zone Objects

Get the Geo Field and Exclude Continent Information

IP-Security Information for an IP Address

Error Codes

About

Releases 2

Packages

Contributors 3

Languages

IPGeolocation/ipgeolocation-database-reader

Folders and files

Latest commit

History

Repository files navigation

ipgeolocation.io Database Reader

What's New

Requirements

Basic Usage

For Linux

Other Ways to Provide Configurations

For Windows

How to Get IP Geolocation

Single IP Geolocation Lookup

Passing an IPv4, or IPv6 Address

Get geolocation for an IPv4 IP Address = 1.1.1.1

Get geolocation for an IPv6 IP Address = 2001:4860:4860::1

Without Passing an IP Address

Bulk IP Geolocation Lookup

Response in Multiple Languages

Get geolocation for an IPv4 IP Address = 1.1.1.1 in Chinese language

Get details for an IPv6 IP Address = 2001:4860:4860::1 in Russian

Filter Responses

Get the Required Fields Only

Get City Information Only

Get Country Name and Country Code (ISO2) Only

Get the Time Zone Information Only

Get Only the Local Currency Information of Multiple IP Addresses

Get Geo Location Only

Remove the Unnecessary Fields

Exclude Continent Code, Currency and, Time zone Objects

Get the Geo Field and Exclude Continent Information

IP-Security Information for an IP Address

Error Codes

About

Resources

Stars

Watchers

Forks

Releases 2

Packages 0

Contributors 3

Languages

Packages