Troubleshoot Partial/Corrupt(?) Install


#1

The Problem
Piwik shows no evidence of any tracked site activity.

Research
I read and worked through these to no avail…

  • Please READ before posting a new topic
  • Piwik doesn’t track any visits and pages, and shows “No Data” in all reports.

Environment
I’m using Gandi.net’s SimpleHosting
PHP Version 5.4.4-14+deb7u7.5
Piwik 2.1.0

Flawed install
The install wizard was flaky. For each page of the wizard, the first time submitting the form would crash the wizard and direct me to the start. The second time would work with a warning that I had already done that step (for example, the second time I tried to set up the database, it warned me that “tables already exist… delete them before proceeding”).

Admin interface
The interface seems to work well.
Adding sites and users works fine.
Under Settings>System Check, I’m only warned about my NFS filesystem and Geolocation server

Apache
My apache log registers the incoming javascript:
goodlookingsoftware.com - - [15/Apr/2014:14:55:58 +0000] “GET /piwik/piwik.php?action_name=Good%20Looking%20Software&idsite=1&rec=1&r=080766&h=10&m=55&s=59&url=http%3A%2F%2Fgoodlookingsoftware.com%2Fmouse&_id=8413d28339aafdd0&_idts=1397570843&_idvc=2&_idn=0&_refts=0&_viewts=1397570850&pdf=1&qt=1&realp=0&wma=1&dir=0&fla=1&java=1&gears=0&ag=1&cookie=1&res=3840x2400&gt_ms=343 HTTP/1.1” 200 43

PHP
Haven’t found a php error

MySQL
piwik_log_visit table is empty.
piwik_log_link_visit_action is not empty
piwik_log_action lists all of the pages on my site that have been visited since installing Piwik.

FPM log
I did get an error in fpm.log which is attached. I’m not able to recreate this error so it might be an automatic process or something else I fixed already. It was basically this (more below):
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “The Piwik URL http://goodlookingsoftware.com/piwik/index.php does not seem to be pointing to a Piwik server. Response was 'Usage: -R, allow-to-run-as-root”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Allow pool to run as root (disabled by default)"

Next Steps
Any ideas? I don’t know where to look next.

Thank you!

more from FPM log
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “Error in the last Piwik archive.php run: “
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “The Piwik URL http://goodlookingsoftware.com/piwik/index.php does not seem to be pointing to a Piwik server. Response was 'Usage: -R, allow-to-run-as-root”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Allow pool to run as root (disabled by default)”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " [-n] [-e] [-h] [-i] [-m] [-v] [-t] [-p ] [-g ] [-c ] [-d foo[=bar]] [-y ]”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -c | Look for php.ini file in this directory"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -n No php.ini file will be used"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -d foo[=bar] Define INI entry foo with value ‘bar’"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -e Generate extended information for debugger/profiler"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -h This help"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -i PHP information"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -m Show compiled in modules"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -v Version number"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -p, --prefix “
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Specify alternative prefix path to FastCGI process manager (default: php5-fpm).”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -g, --pid “
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Specify the PID file location.”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -y, --fpm-config “
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Specify alternative path to FastCGI process manager config file.”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -t, --test Test FPM configuration and exit"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “’.”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Here is the full errors output:"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “---------------------------”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “INIT”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “Querying Piwik API at: http://goodlookingsoftware.com/piwik/index.php
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “Running Piwik 2.1.0 as Super User: “
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “ERROR: The Piwik URL http://goodlookingsoftware.com/piwik/index.php does not seem to be pointing to a Piwik server. Response was 'Usage: -R, allow-to-run-as-root”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Allow pool to run as root (disabled by default)”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " [-n] [-e] [-h] [-i] [-m] [-v] [-t] [-p ] [-g ] [-c ] [-d foo[=bar]] [-y ]”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -c | Look for php.ini file in this directory"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -n No php.ini file will be used"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -d foo[=bar] Define INI entry foo with value ‘bar’"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -e Generate extended information for debugger/profiler"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -h This help"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -i PHP information"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -m Show compiled in modules"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -v Version number"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -p, --prefix “
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Specify alternative prefix path to FastCGI process manager (default: php5-fpm).”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -g, --pid “
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Specify the PID file location.”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -y, --fpm-config “
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " Specify alternative path to FastCGI process manager config file.”
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: " -t, --test Test FPM configuration and exit"
[15-Apr-2014 14:46:15] WARNING: [pool www] child 12577 said into stderr: “’.”


(Matthieu Aubry) #2

Thanks for the report. Can you please try with piwik 2.2.0 rc: 301 Moved Permanently

If you still have the problem please let me know (or create a ticket at dev.piwik.org) and we will investigate!