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/>