All Apps and Add-ons

geoip lookup not returning a region for all IPs

justincy
Explorer

geoip is not returning a region for all IPs. Some only have a country assigned. This has the unfortunate side effect of making it look like we have an extraordinary amount of activity in Wichita, Kansas which is where IPs get mapped that only have the country of US.

See https://www.dropbox.com/s/9bqe6314v0j4vng/kansas.png

The IPs that are getting mapped to Wichita can be more correctly mapped by other IP lookup services. So I'm guessing this is caused by Geo Location Lookup Script using the GeoIPCityLite DB instead of a more accurate paid version. Is this correct? Is there anywhere to upgrade the lookup database?

0 Karma

grijhwani
Motivator

Well, funnily enough, the GeoIP database is exactly what is at fault here. Following up over 2 years on, but here's an article that references exactly this: http://fusion.net/story/287592/internet-mapping-glitch-kansas-farm/

0 Karma

grijhwani
Motivator

The GeoIP database cannot, by its nature, be 100% correct. IP blocks move around, and may be assigned to use which may not even be reliably geo-located. What sort of incidence are you talking about?

justincy
Explorer

https://www.dropbox.com/s/9bqe6314v0j4vng/kansas.png See the big dot in the middle of Kansas? I recognize the inexactness of IP mapping, but what I'm seeing is egregious.

0 Karma
Get Updates on the Splunk Community!

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...