Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
IP analysis by country
Author: Nick Gleason
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63641#349491
We'd be interested in doing some analysis of the country of origin for IPs
of requests that we see on some of our sites / servers. We have the IPs in
a db and could create a script to check those IPs against a database that
provides the country of origin information.
So, the question is whether there are public databases that are available
for this kind of thing. Are there places where we can check IPs for country
of origin without paying fees?
Thanks in advance,
Nick
Author: Nathan Strutz
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63641#349492
Google for IPLocation, you can get databases if you like, but I remember
seeing an old open source java/coldfusion project on sourceforge (ok, a
long time ago) that did all the work for you and just spit out a country
code, country name, sometimes even a state/province and city. Can't be too
hard to find.
nathan strutz
[www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz]
On Fri, Jan 13, 2012 at 3:38 PM, Nick Gleason
<n.gleason@citysoft.com>wrote:
----- Excess quoted text cut - see Original Post for more -----
Author: Alan Rother
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63641#349493
Hey Nick,
I agree with Nathan (usually do anyhow) Keep in mind these IP databases are
only so accurate, IP blocks can move around quite a bit, so last month
one segment might have been one part of Kansas, then the ISP moved them to
some part of Kentucky this month.
That kind of DB is fairly useful for analyzing past IP blocks, but if you
want to get a little more accurate and stay up to date with little or no
work - simply install Google Analytics on your site(s) and it'll do that
geo location work for you on all new visitors.
=]
----- Excess quoted text cut - see Original Post for more -----
Author: Nick Gleason
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63641#349494
Thanks Alan (and Nathan)! In this case, Google Analytics is probably not
going to work that well. These IPs are from many different client sites and
we don't have access to all of their GA accounts and many of them may not
have GA accounts to begin with. We do have request IPs in the various
client dbs and want to do some analysis using those.
Small movements in location would not be a problem (ie Kansas to Kentucky),
but larger movements (e.g. Kansas to China) would be problematic. We want
to get a sense of where potential spam, etc. is coming from so we can do
analysis on those requests more pro-actively. So, it would be great to be
able to run a script against these client databases and quickly see what
request IPs are coming from China, Ukraine, etc. (from where we would
usually not get a lot of legitimate traffic).
N
Author: Casey Dougall - Uber Website Solutions
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63641#349495
On Fri, Jan 13, 2012 at 5:38 PM, Nick Gleason
<n.gleason@citysoft.com>wrote:
> So, the question is whether there are public databases that are available
> for this kind of thing. Are there places where we can check IPs for
> country
> of origin without paying fees?
>
Depending on how many look ups you are going to be doing, you can use this
and funny thing is, the listing on the home page is incorrect but using
lookup it knows where I am.
Signups are free ipinfodb.com
And it's simple enough to sift through.
http://api.ipinfodb.com/v2/ip_query.php
<cfhttp
result="ipRequest"
url="http://api.ipinfodb.com/v2/ip_query.php?key=<Signup and put
that key here>&ip=#CGI.REMOTE_ADDR#
method="get"
/>
<!--- Parse the XML response. --->
<cfset ipInfo = xmlParse( ipRequest.fileContent ) />
<Response><Status>OK</Status><CountryCode>US</CountryCode><CountryName>United
States</CountryName><RegionCode>36</RegionCode><RegionName>New
York</RegionName><City>Saratoga
Springs</City><ZipPostalCode>12866</ZipPostalCode><Latitude></Latitude><Longitude></Longitude><Gmtoffset>0</Gmtoffset><Dstoffset>0</Dstoffset><TimezoneName/><Isdst/><Ip></Ip></Response>
Author: Russ Michaels
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63641#349496
do you still have the weblogs? if so then download smarterstats which will
do all that for you.
On Fri, Jan 13, 2012 at 11:27 PM, Casey Dougall - Uber Website Solutions <
casey@uberwebsitesolutions.com> wrote:
----- Excess quoted text cut - see Original Post for more -----
Author: Paul Hastings
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63641#349497
On 1/14/2012 6:09 AM, Alan Rother wrote:
> I agree with Nathan (usually do anyhow) Keep in mind these IP databases are
> only so accurate, IP blocks can move around quite a bit, so last month
> one segment might have been one part of Kansas, then the ISP moved them to
> some part of Kentucky this month.
i think maybe nathan was referring to our geoLocator project. the db is
out-of-date by now (the guy who does the updates is splitting his time between
remodeling his home in the UK & the middle east). the project was mainly
designed to pick up users' locale for i18n apps.
in any case, we've found the ip-to-country/locale to be >90% accurate, even
w/that dinosaur of a db. accuracy drops off the more detailed the location, in
some parts of the world <50% for city-level.
if you use one of the ip databases, i strongly urge you to use a binary version
of the db if it exists. http calls & sql queries suck wind in comparison
especially if you're aiming for anything like real time.
|
May 20, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
