The IP Location Database

The ET/BWMGR includes database of IP addresses with 39M records that identifies the location, organization and usage type of each address block. The DB also identifies over 6400 VPN address blocks and 10K proxies and TORs which you can use to filter or identify malicious traffic. You can also use the database to identify traffic from various organizations, such as Apple, NetFlix, Google or Facebook.

The database is very large (4GB) and is entirely optional to install and use. If you’re not using the automanager to idetify traffic origin (ie country) you do not need to load it on your system

Getting the Location DB

The Location database is a package that can be installed using bwmgrUpgrader. Installation requires a 2 step process and because it may take a very long time to download the package we require that you do the 2nd step manually.

First, create the database:

bwmgr# mysqladmin create iplocation

Nextget the Package

etbwmgr# bwmgrUpgrader install V8LOC

This will take a while. No sense sitting there and looking at the screen. Make a sandwich. Eat the sandwich. Make a pot of coffee.

/usr/local/var/mysql/iplocation/ip2Location.MYDusr/local/var/mysql/iplocation/ip2Location.MYD
/var/db/mysql_secure/iplocation/sdi

While MySQL v5 was able to read the new database by simply refreshing, v8 requires another step. We’ve automated it for you in the bwmgrUpgrader utility. Once your files are in place, you can install the DB with the following command: