GeoIp plugin installation - File integrity check failed

orasis · September 21, 2011, 10:34pm

I followed the procedure to add GeoIp plugin to various installations of Piwik 1.5.1 as described here:

github.com/matomo-org/matomo

Plugin using GeoIP to accurately detect visitor countries, cities, and continent

opened 08:31PM - 03 Jan 08 UTC

closed 01:50PM - 11 Feb 14 UTC

mattab

Enhancement worksforme

**GeoIp Plugin** - When installed, the plugin will detect more accurately the co…untry of your visitors using the MaxMind database. - The existing reports for country and continent will be replaced by the more accurate GeoIp report in your Piwik interface. - Piwik will also detect the city of your visitors. You can see all cities by clicking on the country row in the table. - You can apply the GeoIp data to all your previous visits and re-generate your reports, see below. **Requirements** You need at least Piwik 0.2.33 to run the GeoIp plugin. **How to install?** - [Download Piwik GeoIp Plugin](http://issues.piwik.org/attachments/5465/GeoIP.zip?format=raw) - Unzip the plugin and copy the extracted directory "GeoIp" in the directory piwik/plugins/ - Configure the MaxMind database: - Either download MaxMind GeoLite City or GeoIP City database from http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz Uncompress this file and copy it in plugins/GeoIP/libs/GeoLiteCity.dat - For more performance, it is recommanded to install the module apache mod_geoip. Configure your Apache according to: http://www.maxmind.com/app/mod_geoip - Enable GeoIP plugin in Piwik. Go to Piwik > Settings > Plugins > Geoip, click Enable **How to apply the GeoIp to all your previous visits to fix your previous reports** You can apply GeoIP precise localization on your past data: - run geoipUpdateRows.php script, from command line (or from the browser, but risk of timing out if your database is large) - wait a few minutes until all your visitors data from the piwik_log_visit table have been processed. - you now need to force Piwik to re-process all the past reports: drop all piwik_archive_\* tables in your Piwik database. Piwik will automatically create them and re-process the reports. - You should see Visitors countries and cities in your Visitors>Location report. **Authors** - Mikael Letang - Maciej Zawadziski - Matthieu Aubry - Anthon Pang **Changelog** - version 0.7: cleaned up code, compatible with Piwik 0.2.33, improved documentation - version 0.8: fixed bug in geoIpUpdateRows.php (thanks looztra) - version 0.9: all fields now NULLable to make sure that insert still work fine after plugin is disabled - version 0.10: compatibility with 0.2.35 after API change in the AddWidget function - version 0.11: fixing bug with country detection - version 0.12: updated for auto loader - version 0.13: Compatible with Piwik 0.6 - version 0.14: - Fixed geoipUpdateRows script which was failing with errors. It also now checks that logged in user is Super User, and that the GeoIP plugin is enabled. - Fixed memory leak when using visitor generator. - Fixed .htaccess was blocking users from executing the script with the browser. - Added .htaccess to allow to execute the script directly from the browser. - Fixed Sparkline distinct countries - version 0.15: - Updated for Piwik 1.3 (refactoring for upgrade.php) - No match for country now set to 'xx' (unknown) - version 0.16: - fix bootstrap in geoipUpdateRows.php and clean-up package - geoipUpdateRows.php - MYSQLI compatibility - default to disk-based search; load into memory if multiple tracking requests - version 0.17: - fixes from peterb & mruge - version 0.18: compatible with Piwik 1.6 **Feedback** Please leave a comment if you have any feedback, suggestion, or bug report. Keywords: third-party-plugin

When I go to acticate the plugin in piwik settings, I get taken to a page that says the following:

Database Upgrade Required
Your Piwik database is out-of-date, and must be upgraded before you can continue.
The following plugins will be updated: GeoIP.
……
…
…
Ready to go?
The database upgrade process may take a while, so please be patient.

File integrity check failed and reported some errors. This is most likely due to a partial or failed upload of some of the Piwik files. You should reupload all the Piwik files in BINARY mode and refresh this page until it shows no error. Details
Continue to Piwik

When I click details I see this:
Integrity check failed: /home/username/public_html/piwik/config/global.ini.php

I fact I have used binary mode to upload piwik yes. So I have no idea why this comes up. If I refresh this page even after re-uploading everything in binary mode I still get the same.
When I click on Continue to Piwik, and then go to settings I see the plugin activated. If I deactivate it and activate it back, I don’t get taken to that error page.

What is wrong with it ? what should I do ?
thanks in advance

vipsoft · September 23, 2011, 1:39am

the message is complaining about global.ini.php. it has nothing to do with geoip.

it appears you locally edited the file, and the upgrade triggered an integrity check.

orasis · September 23, 2011, 1:46am

hi vipsoft thanks for your reply,
yes I had edited the file mentioned, to set enable_language_to_country_guess = 0 right before installing geoip.

glad it has nothing to do with geoip.
thanks again for your input

vipsoft · September 24, 2011, 12:36am

we recommend that local changes to the configuration be made in config.ini.php. This acts as an override to the settings in global.ini.php, and ensures that your change won’t be overwritten when we update global.ini.php in a subsequent release.

Just add a General section (if it doesn’t already exist) to your config.ini.php with the setting that you’re overriding, e.g.,


[General]
enable_language_to_country_guess = 0

orasis · September 24, 2011, 12:39am

yes I get it, thanks so much for your help

matthieu · October 21, 2012, 12:36pm

Good news: GeoIP is now integrated in Piwik, enabling Accurate Visitors Geolocation in your Analytics reports. To enable GeoIP go to the Settings > Geolocation admin page, and follow the short instructions.

You can also get an even more accurate Country & City Database from here to enjoy top accuracy in detecting your visitors locations.

See also the documentation about Geolocation - Analytics Reports in Piwik.