GeoIP v2 (List of improvements) #3442

Here's a list of possible improvements for the GeoIP integration:

Scheduled:

• Auto-updater for GeoIP Databases (along w/ automatic download of free one) #3456
• IPv6 support #3581
• show maps of last 100 visits, or 500 visits (use standard "limit" selector to change limit). The map would plot on lat/long a marker. the marker when clicked would show the Visitor information, and a link to view the visitor log restricted to this particular visit.

Ideas:

• Install GeoIP database when installing Piwik
• 'near' segment, ie, near=12.456,-12.593,20mi (see https://developers.google.com/maps/articles/phpsqlsearch_v3#findnearsql for how-to)
• Better fallback logic & tests for when/if a geoip location provider failed.
• Add shared memory support for php lib.
• test with Cloudflare proxy which pre-looks up the GEOIP and stores it in: $_SERVERHTTP_CF_IPCOUNTRY?

i do not know if it's possible because of the license type piwik is using:

but it would be very great to have 3 options to get the needed geoip data:
1) using free databases as download from maxmind
=> already included :-)
2) using advanced, non free databases as download from maxmind (onetime pay and pay for updates)
=> already included :-)
3) using advanced, non free databases as webservices (payed per use)
=> NEW !!
see
http://www.maxmind.com/en/web_services
and api details:
http://dev.maxmind.com/geoip/web-services

and of course the possibility to use other free and commercial databases is although very welcome!! => but i could not find any suitable provider...

here you can find other free and non free service and a short maybe not fully representative benchmark:
http://blog.nalis.fr/index.php?post/2012/04/28/geoip-geolocalisation-par-ip

the winner seems to be http://info.digitalelement.com/

I'll decrease priority, since except the Auto downloader, the other features wont be worked on by core team until after 2.0 - unless patch is provided of course.

maybe we should split this ticket into individual topics? So each one could have its own priority and milestone...

we'll create individual tickets for ideas we pick up, if we do (eg. if they are sponsored)

just contacted Maxmind, to ask if they aren't interested in sponsoring one of the features above. I think that would be a great benefit for all.
The email I mention for their answer was sponsors(at)piwik.org - hope this is the right one?

The IPv6 bug was reported in: http://forum.piwik.org/read.php?2,95830

See the error message at: http://i.imgbox.com/adnwLxNr.jpg

it would be nice if we could at least prevent an error from displayed on ipv6?

There are good suggestions of messages to improve with regards to geoip in this forum post: http://forum.piwik.org/read.php?2,95830,page=1#msg-95860

It seams to me, that the idea using cloudflare information like suggested in initial post somehow was overread. I think it's worth to take a look at.

Geo location now works well in Piwik :)

See geoip IPv6 support feature request: #3581