PDA

View Full Version : [all variants] Obtaining IP location from logs



KonfuseKitty
November 5th, 2010, 09:32 AM
I've signed up with a hosting company and have access to logs of visits to my website. How can I process these logs to obtain the geographic location of visitors from their IP number? If there's a way of bash scripting this, it would be ideal, or a dedicated softare that could read in the log file and output the location for each visit.


Any pointers in the right direction will be greatly appreciated.

sully101
November 5th, 2010, 10:44 AM
this might help http://manpages.ubuntu.com/manpages/intrepid/man3/Geo::IP.3pm.html

TSJason
November 5th, 2010, 02:26 PM
Or if you're looking for something a little more pretty, checkout awstats: http://awstats.sourceforge.net/

You can install it from the ubuntu repos.

KonfuseKitty
November 6th, 2010, 12:13 PM
Thanks, but I need something simpler. Is there a program that lets me open a log file and output IP locations? Or not even a log file, just a list of IPs. Awstats doesn't seem to be a desktop application, it needs a server as far as I can tell from its setup instructions, it's too complex for me.


All else failing, I'll just grep my logs down to a list of IPs and manually input them into an online tool, such as the one Maxmind offers. But it would be easier to have a local solution.

lykeion
November 6th, 2010, 01:20 PM
There's a PHP API for geoip. You can write a simple PHP script like this example: http://20linesorless.com/code/php-geoip-command-line-script/

You can parse the logs with PHP also and extract the IPs. There are lots of examples around. Like this: http://stackoverflow.com/questions/2812150/parsing-raw-apache-logs