Piwik installation

Since we are hosting many websites, we are going to need to define an Apache VirtualHost with the following configuration.

vi /etc/apache2/sites-available/piwik.arruixaqueplou.org

     ServerAdmin webmaster@piwik.arruixaqueplou.org
     ServerName piwik.arruixaqueplou.org
     ServerAlias piwik.arruixaqueplou.org
     DocumentRoot /var/www/public_html/
     ErrorLog /var/www/public_html/logs/error.log
     CustomLog /var/www/public_html/logs/access.log combined

After that, we will need to enable the site and restart apache:

a2ensite piwik.arruixaqueplou.org
service apache2 reload

We are going to need the latest Piwik version, available through their web servers, so we will need to go to the Piwik root directory were the installation is going to take place and pull the latest version.

wget http://piwik.org/latest.zip
unzip latest.zip -d public_html

Assign the right permissions for the web server:

chown -R www-data:www-data public_html/

Before running Piwik's installation script, we need to change the permissions of several directories. Piwik requires these permissions to remain set to function properly. Issue the following commands:

chmod a+w /var/www/public_html/tmp
chmod a+w /var/www/public_html/config

Now we are ready to go through web browser web based installation process by typing piwik.arruixaqueplou.org into the browser.

mySQL users
We had added a piwikuser accound with full privileges.

mysql> create user 'piwikuser'@'localhost' identified by 'piwikpass!';
mysql> grant all privileges on piwik.* to 'piwikuser'@'localhost' with grant option;

The next screen will ask us to create a Piwik account with full privileges.