Support #573

Install Piwik on a Debian LAMP Server

Added by Daniel Curtis over 5 years ago. Updated over 5 years ago.

Web Server
Target version:
Start date:
Due date:
% Done:


Estimated time:
1.50 h
Spent time:


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: piwik
  • And also edit the hostname file:
    vi /etc/hostname
    • And add/modify the following:
  • Reboot to apply the hostname settings:

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>
          DocumentRoot /var/www           
          <Directory /var/www>
              Options -Indexes FollowSymLinks MultiViews
              AllowOverride All
              Order allow,deny
              allow from all
    • NOTE: Make sure AllowOverride is set to ALL, or else the .htaccess file will not work.
  • Restart apache2:
    service apache2 restart

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 -new -newkey rsa:4096 -nodes -keyout
  • Make sure to securely copy the SSL certificate to
  • Edit the apache2 default ssl Vhost config file:
    vi /etc/apache2/sites-available/default-ssl
    • And Add the following:
      <VirtualHost *:443>
          DocumentRoot /var/www            
          <Directory /var/www>
              Options FollowSymLinks
              AllowOverride All
              Require all granted
          SSLEngine on
          SSLCertificateFile /etc/apache2/ssl/
          SSLCertificateKeyFile /etc/apache2/ssl/
          <FilesMatch "\.(cgi|shtml|phtml|php)$">
              SSLOptions +StdEnvVars
          BrowserMatch "MSIE [2-6]" nokeepalive ssl-unclean-shutdown downgrade-1.0 force-response-1.0
          BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown
  • Change the SSL certificate and key ownership to the apache user:
    chown www-data:www-data /etc/apache2/ssl/{crt,key}
    chmod o-rwx /etc/apache2/ssl/
  • 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

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;

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 /var/www
  • Install composer:
    cd /var/www
    curl -sS | 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/

Related issues

Copied from GNU/Linux Administration - Support #568: Install a Linux, Apache2, MySQL, PHP Web Server on Debian Closed 02/21/2015


#1 Updated by Daniel Curtis over 5 years ago

  • Copied from Support #568: Install a Linux, Apache2, MySQL, PHP Web Server on Debian added

#2 Updated by Daniel Curtis over 5 years ago

  • Description updated (diff)
  • Status changed from New to Resolved
  • % Done changed from 0 to 100

#3 Updated by Daniel Curtis over 5 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF