This tutorial shows you on how to import IP2Location DB3 (IP-Country-Region-City) into a MySQL database server and retrieve the geolocation information for viewing. First of all, we assumed that the Laravel Framework and MySQL database server had been properly set up before following this tutorial. Download the IP2Location DB3 (IP-Country-Region-City) database from https://www.ip2location.com. Unzip the […]
Add IP2Location Database as NetScaler’s Location File
This tutorial shows you on how to add the IP2Location database as the location file for NetScaler GLSB (Global Server Load Balancing) configuration. NetScaler supported 4 types of IP2Location database, the CSV format file, namely the IP-Country database (DB1 or DB1.LITE), IP-Country-ISP (DB2), IP-Country-Region-City (DB3 or DB3.LITE) and IP-Country-Region-City-ISP (DB4). The DB1, DB2, DB3 and DB4 are the commercial packages […]
IP Address Lookup in Bulk Using VB.NET and MySQL Database
In this tutorial, we demonstrate you on how to lookup IP address in bulk using VB.NET programming languages and IP2Location MySQL database. In this tutorial, we use the IP2Location LITE database to lookup country of origin from the visitor’s IP address. Free databases are available for download at IP2Location LITE database. […]
IP Address Lookup in Bulk Using C-Sharp and MySQL Database
In this tutorial, we demonstrate you on how to lookup IP address in bulk using C-Sharp programming languages and IP2Location MySQL database. In this tutorial, we use the IP2Location LITE database to lookup country of origin from the visitor’s IP address. Free databases are available for download at IP2Location LITE database. […]
IP Address Lookup in Bulk Using PHP and MySQL Database
In this tutorial, we demonstrate you on how to lookup IP address in bulk using PHP programming languages and IP2Location MySQL database. In this tutorial, we use the IP2Location LITE database to lookup country of origin from the visitor’s IP address. Free databases are available for download at IP2Location LITE database. […]
How to automate downloading, unzipping & loading of IP2Location DB24 data into Windows MySQL
Here is a guide for users to fully automate the updating of their IP2Location DB24 database. We will show how to download the IP2Location DB24 csv data from the web server and then unzip it before loading the data into a MySQL server on a Windows platform. We will explain […]
How to automate downloading, unzipping & loading of IP2Location DB24 data into Linux MySQL
Here is a guide for users to fully automate the updating of their IP2Location DB24 database. We will show how to download the IP2Location DB24 csv data from the web server and then unzip it before loading the data into a MySQL server on a Linux platform. The whole shell […]
How to automate downloading, unzipping & loading of IP2Proxy PX4 data into Linux MySQL
Here is a guide for users to fully automate the updating of their IP2Proxy PX4 database. We will show how to download the IP2Proxy PX4 csv data from the web server and then unzip it before loading the data into a MySQL server on a Linux platform. The whole shell […]
Simple GeoDNS using BIND and IP2Location
Implementing Geo-aware DNS using BIND with IP2Location Database This article illustrates how to use the IP2Location IP-Country Database (DB1) to implement a geolocation feature in a BIND DNS server easily. The two concepts we are applying to BIND are “Access Control List” and “Views”. There is no need to patch the BIND […]
Configure Country Access Control in CloudFront Using .NET
The following sample application gets the IP address of the end user and sends the IP address to the IP2Location.io IP Geolocation API. The API returns a JSON string containing the country code that corresponds with the end user’s IP address. The application then evaluates whether the value returned by […]