Hello all, I wrote a small 'C' application that takes the standard apache log files, looks up the IP address using the geoip-lookup function:
162.33.158.81 - - [12/May/2003:20:25:31 -0400] "GET /images/top.gif HTTP/1.1" 200 1412 "http://www.washingtongolf.com/Taylor_Made.htm"; "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) and writes out as: 162.33.158.81 "United States" - - [12/May/2003:20:25:31 -0400] "GET /images/top.gif HTTP/1.1" 200 1412 "http://www.washingtongolf.com/Taylor_Made.htm"; "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) geoip-lookup is part of the MaxMind geoip country PurePerl API that is available here: http://www.maxmind.com/download/geoip/api/perl/ The PurePerl version doesn't require the GEOIP 'C' library. Now if someone can figure out how to tell analog and rmagic to do something with this format, please let me know :^) Email me if you want the 'C' app, just compile with "gcc -o reformat reformat.c". Execute as "reformat file-in file-out". file-in is your regular apache log file, with unresolved IP addresses. file-out adds the country, if found, "-" otherwise. A temp file, "country.txt" is created in the current directory to hold the output of geoip-lookup. I use the -l option to get the long country name, leave off if you just want the 2 letter code. HTH, Bobby ----- Original Message ----- From: "Bobby Hitt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 28, 2003 11:12 AM Subject: Re: [analog-help] IP-to-country > Hello, > > Some more information. The country database is available for free from > www.MaxMind.com, along with the API's for several different languages, > including Perl, 'C', PHP and Ruby. As to how to incorporate this into > analog, haven't a clue. But the tools and database are available. > > HTH, > > Bobby > > ----- Original Message ----- > From: "Jeremy Wadsack" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 27, 2003 11:14 AM > Subject: Re: [analog-help] IP-to-country > > > > > > Alexander Chirkov ([EMAIL PROTECTED]; Tuesday, May 27, 2003 5:26 AM): > > > > > It would be great if I can use this DB in analog! > > > http://ip-to-country.com/database/ > > > > > > There was significant discussion of geotargeting on the list > > previously: > > > > http://www.mail-archive.com/[EMAIL PROTECTED]/msg13905.html > > http://www.mail-archive.com/[EMAIL PROTECTED]/msg14373.html > > > > But (as mentioned in the second message above), little consensus as to > > which service to implement, and they do not provide a common > > interface. The only way to do this currently would involve (a) hacking > > the code to generate a report for your specific GeoIP database, or (b) > > hijacking the Domain Report by changing the DNS lookups to match the > > GeoIP values. There is even a DNS server you can use to do this fairly > > simply. +------------------------------------------------------------------------ | TO UNSUBSCRIBE from this list: | http://lists.isite.net/listgate/analog-help/unsubscribe.html | | Digest version: http://lists.isite.net/listgate/analog-help-digest/ | Usenet version: news://news.gmane.org/gmane.comp.web.analog.general | List archives: http://www.analog.cx/docs/mailing.html#listarchives +------------------------------------------------------------------------
