Error

This guide seems to be broken for the current versions of open web analytics, we would be happy if you want to work on a solution and create a Pull Request. See also the related issue: https://github.com/Uberspace/lab/issues/1427

Open Web Analytics

Open Web Analytics is an open source web analytics software framework that you can use to track and analyze how people use your websites and applications.

Note

For this guide you should be familiar with the basic concepts of

Prerequisites

We’re using PHP in the stable version 7.2:

[isabell@stardust ~]$ uberspace tools version show php
Using 'PHP' version: '7.2'
[isabell@stardust ~]$

You’ll need your MySQL credentials. Get them with my_print_defaults:

[isabell@stardust ~]$ my_print_defaults client
--default-character-set=utf8mb4
--user=isabell
--password=MySuperSecretPassword
[isabell@stardust ~]$

Your website domain needs to be set up:

[isabell@stardust ~]$ uberspace web domain list
isabell.uber.space
[isabell@stardust ~]$

Installation

Create the database and download the latest version into the subdirectory owa under your DocumentRoot.

[isabell@stardust ~]$ mysql -e "CREATE DATABASE ${USER}_owa"
[isabell@stardust ~]$ cd /var/www/virtual/$USER/html/
[isabell@stardust html]$ mkdir owa && cd owa
[isabell@stardust owa]$ wget https://github.com/Open-Web-Analytics/Open-Web-Analytics/releases/download/1.6.8/owa_1.6.8_packaged.tar
(...)
[isabell@stardust owa]$ tar -xvf owa_1.6.8_packaged.tar
(...)
[isabell@stardust owa]$

Configuration

After the installation you need to open isabell.uber.space/owa in your browser to finish your setup.

Fill out your configuration settings:

Database Host: localhost
Database Name: isabell_owa
Database User: isabell
Database Password: credentials

Updates

Note

Check the update feed regularly to stay informed about the newest version.

Check Open Web Analytics’s stable releases for the latest versions. If a newer version is available, replace the version number 1.6.8 with the latest one.

Backup your owa/owa-config.php file, delete everything else in your owa directory.

[isabell@stardust ~]$ cd /var/www/virtual/$USER/html/owa/
[isabell@stardust owa]$ cp owa/owa-config.php ~
[isabell@stardust owa]$ rm -rf * .*
[isabell@stardust owa]$ wget https://github.com/Open-Web-Analytics/Open-Web-Analytics/releases/download/1.6.8/owa_1.6.8_packaged.tar
(...)
[isabell@stardust owa]$ tar -xvf owa_1.6.8_packaged.tar
(...)
[isabell@stardust owa]$ mv ~/owa-config.php ./
[isabell@stardust owa]$

Finish the update by open isabell.uber.space in your browser.

Tested with Open Web Analytics 1.6.8 and Uberspace 7.5.1

Written by: Thomas Johnson <https://johnson.tj/>