• Table of contents
• Prepare The Server
• Install Apache 2
  • Configure Apache 2
  • Securing Apache with SSL
    • Forcing SSL on a Website
• Install MySQL 5.5
  • Configure a new MySQL database
• Install PHP 5
• Install Piwik

This is a simple guide for setting up Piwik on a LAMP server on Debian 7 (wheezy).

Prepare The Server¶

This guide is assumed that a Bare Debian install with only SSH Server access, a user that has sudo access.

• Obtain a root shell and upgrade the server:
  

  sudo -s
  apt-get update && apt-get upgrade
  

• Set the hostname in the hosts:
  

  vi /etc/hosts
  

  • And add/modify the following:
    

    127.0.1.1     piwik.example.com piwik
    

• And also edit the hostname file:
  

  vi /etc/hostname
  

  • And add/modify the following:
    

    piwik
    

• Reboot to apply the hostname settings:
  

  reboot
  

Install Apache 2¶

• Install apache:
  

  apt-get install apache2
  

Configure Apache 2¶

• Edit the default apache2 Vhost config:
  

  vi /etc/apache2/sites-available/default
  

  • And add/modify the following VirtualHost block:
    

    <VirtualHost *:80>
        ServerName piwik.example.com
    
        DocumentRoot /var/www           
        <Directory /var/www>
            Options -Indexes FollowSymLinks MultiViews
            AllowOverride All
            Order allow,deny
            allow from all
        </Directory>
    </VirtualHost>
    

  • NOTE: Make sure AllowOverride is set to ALL, or else the .htaccess file will not work.

• Restart apache2:
  

  service apache2 restart
  

• Now navigate to http://piwik.example.com and the default It Works! should be displayed.

Securing Apache with SSL¶

• Install openssl:
  

  apt-get install openssl
  

• Generate a strong SSL key and a CSR to send for signing by a CA:
  

  mkdir /etc/apache2/ssl && cd /etc/apache2/ssl
  openssl req -sha512 -out piwik.example.com.csr -new -newkey rsa:4096 -nodes -keyout piwik.example.com.key
  

• Make sure to securely copy the SSL certificate to www.example.com.crt

• Edit the apache2 default ssl Vhost config file:
  

  vi /etc/apache2/sites-available/default-ssl
  

  • And Add the following:
    

    <VirtualHost *:443>
        ServerName piwik.example.com
    
        DocumentRoot /var/www            
        <Directory /var/www>
            Options FollowSymLinks
            AllowOverride All
            Require all granted
        </Directory>
    
        SSLEngine on
    
        SSLCertificateFile /etc/apache2/ssl/piwik.example.com.crt
        SSLCertificateKeyFile /etc/apache2/ssl/piwik.example.com.key
    
        <FilesMatch "\.(cgi|shtml|phtml|php)$">
            SSLOptions +StdEnvVars
        </FilesMatch>
    
        BrowserMatch "MSIE [2-6]" nokeepalive ssl-unclean-shutdown downgrade-1.0 force-response-1.0
        BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown
    </VirtualHost>
    

• Change the SSL certificate and key ownership to the apache user:
  

  chown www-data:www-data /etc/apache2/ssl/piwik.example.com.{crt,key}
  chmod o-rwx /etc/apache2/ssl/piwik.example.com.key
  

• Enable the ssl apache modules:
  

  a2enmod ssl
  

Forcing SSL on a Website¶

• Enable forced SSL connection by setting the two lines from earlier in the .htaccess file. Open the file for editing:
  

  vi /var/www/.htaccess
  

  • Look for the following two lines, and remove the # characters before them:
    

    RewriteCond %{HTTPS} !=on
    RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
    

• Restart apache2:
  

  service apache2 restart
  

• Now the website will be accessible from https://piwik.example.com

Install MySQL 5.5¶

• Install MySQL server and client:
  

  apt-get install mysql-server mysql-client
  

  • NOTE: During the setup a prompt will appear to set the root MySQL user password. Set a strong password and do not forget it.

Configure a new MySQL database¶

• Log into the MySQL console:
  

  mysql -h localhost -u root -p
  

  • Create the piwikuser user with the SuperSecretPassword password and the piwikdb database:
    

    CREATE USER 'piwikuser'@'localhost' IDENTIFIED BY 'SuperSecretPassword';   
    CREATE DATABASE IF NOT EXISTS  `piwikdb` CHARACTER SET utf8 COLLATE utf8_general_ci;
    GRANT ALL PRIVILEGES ON `piwikdb`.* TO 'piwikuser'@'localhost';
    
    flush privileges;
    exit
    

Install PHP 5¶

• Install PHP 5 with the apache-php module and a few common PHP extensions:
  

  apt-get install php5 php5-dev libapache2-mod-php5 curl php5-cli php5-mysql php5-mcrypt php5-gd php5-curl
  

  • PHP has many extensions, run the following to get a list of all available extensions:
    

    apt-cache search php5-
    

• Restart apache for the php module to take effect:
  

  service apache2 restart
  

Install Piwik¶

• Install git
  

  apt-get install git
  

• Install Piwik:
  

  rm /var/www/*
  git clone https://github.com/piwik/piwik /var/www
  

• Install composer:
  

  cd /var/www
  curl -sS https://getcomposer.org/installer | php 
  php composer.phar install
  

• Set correct permissions:
  

  chown -R www-data:www-data /var/www
  chmod -R 0755 /var/www/tmp
  chmod -R 0755 /var/www/tmp/assets/
  chmod -R 0755 /var/www/tmp/cache/
  chmod -R 0755 /var/www/tmp/logs/
  chmod -R 0755 /var/www/tmp/tcpdf/
  chmod -R 0755 /var/www/tmp/templates_c/