docker-ip2proxy-mysql

This is a pre-configured, ready-to-run MySQL server with IP2Proxy Proxy IP database. It simplifies the development team to install and set up the proxy IP database in MySQL server. The setup script supports the commercial database packages⁠ and free LITE package⁠. Please register for a download account before running this image.

Usage

1. Run this image as daemon with your username, password, and download code registered from IP2Location⁠.

   docker run --name ip2proxy -d -e TOKEN={DOWNLOAD_TOKEN} -e CODE={DOWNLOAD_CODE} -e IP_TYPE=IPV4 -e MYSQL_PASSWORD={MYSQL_PASSWORD} ip2proxy/mysql
   

   Copy

   ENV VARIABLE

   TOKEN – Download token obtained from IP2Location.

   CODE – Database code. Codes available as below:

   • Free Database - PX1-LITE, PX2-LITE, PX3-LITE, PX4-LITE, PX5-LITE, PX6-LITE, PX7-LITE, PX8-LITE, PX9-LITE, PX10-LITE, PX11-LITE, PX12-LITE
   • Commercial Database - PX1, PX2, PX3, PX4, PX5, PX6, PX7, PX8, PX9, PX10, PX11, PX12

   IP_TYPE - (Optional) Download IPv4, IPv6 or both database. Script will download both database by default.

   • IPV4 - Download IPv4 database only.
   • IPV6 - Download IPv6 database only.
   • BOTH - Download IPv4 & IPv6 database.

   MYSQL_PASSWORD - (Optional) Password for MySQL admin. A random password will be generated by default.

2. The installation may take minutes to hour depending on your internet speed and hardware. You may check the installation status by viewing the container logs. Run the below command to check the container log:

    docker logs -f ip2proxy
   

   Copy

   You should see the line of > Setup completed if you have successfully complete the installation.

Connect to it from an application

docker run --link ip2proxy:ip2proxy-db -t -i application_using_the_ip2proxy_data

Make the query

mysql -u admin -pYOUR_MYSQL_PASSWORD -h ip2proxy-db ip2proxy_database -e 'SELECT * FROM `ip2proxy_database` WHERE INET6_ATON("8.8.8.8") BETWEEN ip_from AND ip_to LIMIT 1'

Notes: If not result returned, the lookup IP address is not a proxy IP address.

Update IP2Proxy Database

To update your IP2Proxy database to latest version, please run the following command:

docker exec -it ip2proxy ./update.sh

Sample Code Reference

https://www.ip2location.com/tutorials⁠