Okay, I am installing another Piwik on my webspace now and report every step here:
[ul]
[li] Downloaded the last Version 1.1.1 of Piwik
[/li][li] Opened the installation instructions on Installing Piwik - Analytics Platform - Matomo
[/li][li] Switched FTP Client to binary mode and uploaded the files without any problems
[/li][li] Opened the directory in the browser, welcome screen appeares
[/li][li] System check: No errors, one warning (Memory limit 64M. On a high traffic website, the archiving process may require more memory than currently allowed. If necessary, change the memory_limit directive in your php.ini file.) Should not be a problem for me, I don’t have so much traffic, I think.
[/li][li] Database setup: changed 127.0.0.1 to localhost and entered database name, pwd, … Go -> Tables created with success!
[/li][li] General Setup (entering superuser data) Go -> Success
[/li][li] Set up a website (entering the data of my website) -> No problems, I get the javascript code
[/li][li] Congratulations! Your Piwik installation is complete.
[/li][/ul]
Okay, I guess Piwik has been installed perfectly now!
I then inserted the code in my website.
Piwik locates me in the US, weird thing, since I am in Germany… I was in the US with my computer last year and my OS is in English, but how can that be?
Now I want to install the GeoIP Plugin:
[ul]
[li] I go to Plugin using GeoIP to accurately detect visitor countries, cities, and continent · Issue #5465 · matomo-org/matomo · GitHub and download the Piwik GeoIP Plugin.
[/li][li] Extract it and upload the extracted folder in the plugin directory, no problems.
[/li][li] I download the GeoLite City database from http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz
[/li][li] Extract it and load it to plugins/GeoIP/libs/GeoLiteCity.dat
[/li][li] The filesize on the server matches exactly the one on my harddisk, seems like a successfull upload.
[/li][li] I ignore the part “For more performance, it is recommanded to install the module apache mod_geoip. Configure your Apache according to: GeoIP Legacy Apache Module « MaxMind Developer Site” of the installation instructions, since I don’t have full access to the server.
[/li][li] I enable the Plugin in the Piwik settings…
[/li][/ul]
What happens now after the activation:
I see the page:
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.
Important note for large Piwik installations
* If you have a large Piwik database, updates might take too long to run in the browser. In this situation, you can execute the updates from your command line:
php /webspace/10/53299/statistics.good4media.de/index.php -- "module=CoreUpdater"
* If you are not able to use the command line updater and if Piwik fails to upgrade (due to a timeout of the database, a browser timeout, or any other issue), you could manually execute the SQL queries to update Piwik.
› Click here to view and copy the list of SQL queries that will get executed
# Note: if you manually execute these queries, it is expected that some of them fail. In this case, simply ignore the errors, and run the next ones in the list.
UPDATE piwik_option SET option_value = "0.9" WHERE option_name = "version_GeoIP";
and click on Upgrade Piwik.
-> Piwik has been successfully updated!
I go back to Piwik as the page tells me to.
Now I want to update my past reports:
[ul]
[li] I run the file /plugins/GeoIP/misc/geoipUpdateRows.php in my browser.
[/li][li] Here I get the warning:
[/li]Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /plugins/GeoIP/misc/geoipUpdateRows.php on line 17
[li] Maybe this was the problem before?
[/li][li] I edit the file and delete the line
set_time_limit(0);
. I upload the edited file and execute it again.
[/li][li] I see a blank page, hmm, at least no errors.
[/li][li] I drop the tables piwik_archive_blob_2011_01 and piwik_archive_numeric_2011_01
[/li][li] Half the visitors in Locations & Provider are listed as UserCountry_country_ the other half is from Germany as expected. In the continent section half Europe, half UserCountry_continent_. Also the providers are listed.
[/li][li] Still no cities listed here, nope, none at all. They should be in the Locations & Provider section, right?
[/li][li] The question is: What is the problem now? Why are no cities listed and why are many countries not detected at all?
[/li][/ul]
I hope you can help me to fix these problems with this detailed report.
I saw that the current version of CityLite Geo is from January 1st, 2010, could that be a reason for the problems? A new version will be available on February 1st, 2011, so I will see that soon.
I don’t understand, why no cities are shown at all! If the cities were wrong I would understand it, but that they are not shown at all? That seems to have something to do with Piwik…
When I tryed to locate my self via Your IP Address's GeoIP2 Data | MaxMind I was located in a neighbouring city. Okay, that would be fine.
I hope you can help me to fix the problem with this new info.
Thanks,
Stefan