Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^13: Help with Geo::IP output

by Tux (Abbot)
on Jun 24, 2020 at 22:24 UTC ( #11118475=note: print w/replies, xml ) Need Help??


in reply to Re^12: Help with Geo::IP output
in thread Help with Geo::IP output

Can you please indicate what is unclear in the README?

$ perl ./geoip --fetch --DB=dbi:SQLite:dbname=geoip.db

Will do everything for you if you have a working DBD::SQLite.

A demo:

$ ls -l geoip.db /bin/ls: cannot access 'geoip.db': No such file or directory Exit 2

Be patient on the next one, it'll take a while to finish (my demo took 5 minutes). You will need enough memory and disk space. My process took 13 Gb of ram.

$ perl ./geoip --fetch --DB=dbi:SQLite:dbname=geoip.db Create table stamps Create table continent Create table country Create table ipv4 Create table provider Create table city Create table ipc4 2020-06-22 21:16:39 4689345 GeoLite2-ASN-CSV.zip 304 2020-06-22 21:16:39 4689345 GeoLite2-ASN-CSV.zip 2020-06-16 13:13:32 1805947 GeoLite2-Country-CSV.zip 304 2020-06-16 13:13:32 1805947 GeoLite2-Country-CSV.zip 2020-06-16 13:19:50 41827687 GeoLite2-City-CSV.zip 304 2020-06-16 13:19:50 41827687 GeoLite2-City-CSV.zip Reading Country info ... Reading Country IPv4 info ... Reading Provider IPv4 info ... Reading City info ... Reading City IPv4 info ...
$ ls -l geoip.db -rw-r--r-- 1 501100544 Jun 25 00:30 geoip.db

So there you go, 501 Mb of SQLite database.


Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11118475]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2020-11-25 15:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?