[[PageOutline(2-5, Table of Contents, floated)]]
= Piwik Web Stats =
This page is to document the [http://piwik.org/ Piwik] server that is to be installed on the DevelopmentServer.
== Install ==
{{{
cd /web/
mkdir piwik.transitionnetwork.org
cd piwik.transitionnetwork.org/
wget http://piwik.org/latest.zip
unzip latest.zip
}}}
Then set up apache, see /etc/apache2/sites-available/piwik.transitionnetwork.org and run the web installer and:
{{{
cd /web/piwik.transitionnetwork.org/piwik/
chown -R www-data:www-data tmp/
chown -R www-data:www-data config/
}}}
Then a MySQL user and database was added using phpMyAdmin which ran the following SQL:
{{{
CREATE USER 'piwik'@'localhost' IDENTIFIED BY '********';
GRANT USAGE ON * . * TO 'piwik'@'localhost' IDENTIFIED BY '********' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS `piwik` ;
GRANT ALL PRIVILEGES ON `piwik` . * TO 'piwik'@'localhost';
}}}
The installer suggested this JS tracking code, see the docs at http://piwik.org/docs/javascript-tracking/ :
{{{
}}}
And this image tracking code:
{{{
}}}
The following parameters can also be passed to the image URL:
* rec - (required) The parameter &rec=1 is required to force the request to be recorded
* idsite - (required) Defines the Website ID being tracked
* action_name - Defines the custom Page Title for this page view
* idgoal - The request will trigger the given Goal
* urlref - The Referrer URL: must be set to the referrer URL used before landing on the page containing the Image tracker. For example, in PHP this value is accessible via
{{{$_SERVER['HTTP_REFERER']}}}
* revenue - Used with idgoal, defines the custom revenue for this conversion
== Requirements ==
The [http://piwik.org/docs/requirements/ requirements are]:
* PHP version 5.1.3 or greater, We highly recommend using at least PHP 5.3 as it is much more memory efficient than previous PHP versions, we have: PHP 5.2.6-1+lenny10 with Suhosin-Patch 0.9.6.2 (cli), when the server is migrated to squeeze we will get a new php, it can wait till then.
* MySQL version 4.1 or greater, we have 5.0.51a-24+lenny5-log
* (enabled by default) PHP extension pdo and pdo_mysql, weh have these already installed and they are configured via /etc/php5/apache2/conf.d/pdo.ini and /etc/php5/apache2/conf.d/pdo_mysql.ini
* PHP GD extension, installed already
* Increase your PHP memory_limit value in your php.ini config file to be at least memory_limit = 128M, we have 256M already in /etc/php5/apache2/php.ini