Colin Rubbert

Posted on Aug 9, 2019 • Originally published at fivethirtyfour.com

Self-hosted web analytics with Matomo and Azure

#azure #devops #webdev #sysadmin

Matomo + Azure = 📈

What is Matomo?

Matomo is an all-in-one premium web analytics platform with the philosophy of 100% data ownership. Simply stated, you own your data, no one else. That means that no abuse of privacy via Google Analytics, Facebook analytics or any other third-party website analytics software.

Privacy has been a growing concern of mine and I'm starting, bit by bit, to take back some control of that and protect my end users from similar abuses. Be the change you want to see, so the saying goes.

What you'll need

Just like previous articles I'm an Azure user. Azure is great, it's friendly to use, simple, cost effective, and just good. That's what we'll be using.

Listed below are what we will need for required installation and configuration.

An account on Azure
Access to SSH to configure our virtual machine which will be Linux based (WSL, Linux, macOS, etc)

Getting started

Pre-requisites

Creating the virtual machine

Using the free account and credits for Azure we will leverage some of the other free marketplace Azure services.

Log into your newly created or existing Azure account and do a search for Free services

Select Free services and you'll be presented with a list of available free services. We're going to select the Linux Virtual Machine, this gives us 750 hours of free B1S this should provide us with some solid, cheap hours of use. Even after the free 750 hours credit it still would only cost, roughly, $8/mo. Pretty cheap, relatively speaking.

We need to configure our virtual machine, like so. Obviously fill in your own unique information. If you plan on accessing your VM from more than one computer that you select Password instead of SSH public key it's a bit less mucking about.

If everything was configured properly we should have passed validation, if you didn't fix your errors and try again. Then click Create to start creating your virtual machine.

Navigate to your VM and check what the Public IP Address is and then we will use that to ssh into our VM.

Configuring the Virtual Machine

SSH into your virtual machine by typing ssh [username]@[public IP address], replacing [username] with the username you specified in the creation of the virtual machine and then replacing [public IP address] with the public IP address of your virtual machine.

Once we're logged in update the virtual machine by running the following commands.

sudo apt install php7.3 php7.3-cli php7.3-fpm php7.3-curl php7.3-gd mysql-server php7.3-mysql php-xml php7.3-mbstring unzip -y
sudo apt update
sudo apt upgrade -y

Now that we're updated to the latest version(s) of our virtual machines software we can continue onto the install.

Creating a database

Before we can run Matomo we will need to create a database for Matomo to use. Let's sign into our MySQL as our root user.

mysql -u root -p

Create the database.

CREATE DATABASE matomo;

Create a new user for the new database.

CREATE USER `billybob@example.com` IDENTIFIED BY 'your_secret_password';

Grant new user the relevant permissions on the database.

GRANT ALL ON matomo.* TO `billybob@example.com`;

Flush privileges and exit the MySQL console.

FLUSH PRIVILEGES;
exit

Installing Matomo

Installing Nginx and configure Nginx for Matomo

Matomo will need some sort of web server software so that we can operate Matomo as intended. For the purpose of this tutorial we're going to instal Nginx.

sudo apt install -y nginx

Now that we've got Nginx installed we need to configure Nginx for our Matomo instance. First we'll need to create the file.

sudo nano /etc/nginx/sites-available/matomo.conf

Now we will need to populate the file with our server configurations. Obviously change the server_name with your specific server name.

server {

  listen [::]:443 ssl http2;
  listen 443 ssl http2;
  listen [::]:80;
  listen 80;

  server_name stats.fivethirtyfour.com;
  root /var/www/matomo/;
  index index.php;

  location ~ ^/(index|matomo|piwik|js/index).php {
    include snippets/fastcgi-php.conf;
    fastcgi_param HTTP_PROXY ""; 
    fastcgi_pass unix:/var/run/php/php7.3-fpm.sock; 
  }

  location = /plugins/HeatmapSessionRecording/configs.php {
    include snippets/fastcgi-php.conf;
    fastcgi_param HTTP_PROXY "";
    fastcgi_pass unix:/var/run/php/php7.3-fpm.sock;
  }

  location ~* ^.+\.php$ {
    deny all;
    return 403;
  }

  location / {
    try_files $uri $uri/ =404;
  }

  location ~ /(config|tmp|core|lang) {
    deny all;
    return 403;
  }

  location ~ \.(gif|ico|jpg|png|svg|js|css|htm|html|mp3|mp4|wav|ogg|avi|ttf|eot|woff|woff2|json)$ {
    allow all;
  }

  location ~ /(libs|vendor|plugins|misc/user) {
    deny all;
    return 403;
  }

}

Now we will need to activate the new matomo.conf configuration by linking the file to the sites-enabled directory.

sudo ln -s /etc/nginx/sites-available/matomo.conf /etc/nginx/sites-enabled

Test the Nginx configuration for syntax errors.

sudo nginx -t

Reload the Nginx service

sudo systemctl reload nginx.service

Download & Extract Matomo

Before we download and install Matomo we need to create and move into our webserver's directory.

sudo mkdir -p /var/wwww/ && cd /var/www/

Now we need to download Matomo first before we can install it. From our console run the following commands. The first section is downloading the file, the second section is unzipping our file we just downloaded and the third section is to clean up the .zip file we downloaded.

wget https://builds.matomo.org/matomo.zip && unzip matomo.zip && rm matomo.zip

Finally let's change ownership of the /var/www/matomo directory to www-data user

sudo chown -R www-data:www-data /var/www/matomo

Installing a Let's Encrypt certificate for ssl

It's important to run our services and websites over SSL. Not only does it give us our privacy but it provides the confidence and privacy of our users.

First we need to install the required repositories to run LetsEncrypt

sudo add-apt-repository ppa:certbot/certbot
sudo apt update
sudo apt upgrade -y
sudo apt install certbot python-certbot-nginx -y

Now that the software is installed we need to create our certificate using the Nginx certbot plugin. Obviously changing the domain for what your site will be.

sudo certbot --nginx -d stats.fivethirtyfour.com

Now if we look at our /etc/nginx/sites-available/matomo.conf file we should see that certbot has added our SSL configurations for us.

######################################
## SNIPPET OF THE MATOMO.CONF FILE  ##
######################################

ssl_certificate /etc/letsencrypt/live/stats.fivethirtyfour.com/fullchain.pem; # managed by Certbot
    ssl_certificate_key /etc/letsencrypt/live/stats.fivethirtyfour.com/privkey.pem; # managed by Certbot
}

server {
    if ($host = stats.fivethirtyfour.com) {
        return 301 https://$host$request_uri;
    } # managed by Certbot

  listen [::]:80;
  listen 80;
  server_name stats.fivethirtyfour.com;
    return 404; # managed by Certbot
}

Now head over to your website where you deployed your site and you should see the Matomo installation page.

Completing the Matomo Analytics setup

Now go through the Matomo installation process and once you get to the Database Setup section make sure to file this in with the information you created in the Creating a database section earlier in this guide.

Continue going through the configuration and once you get to the Tracking code section make sure you copy your tracking code snippet. This is what you will use to add to your website to gather the analytics information.

Congratulations you now have Matomo Analytics running in Azure cloud instance!!!

Originally posted at https://fivethirtyfour.com
Matomo Web Analytics and Azure

DEV Community