How to install Open Web Analytics on OpenSUSE

Open Web Analytics is an open-source web analytics software that allows you to track and analyze the activity on your website. In this tutorial, we will guide you through the process of installing Open Web Analytics on OpenSUSE.

Requirements

• OpenSUSE Linux distro installed and running.
• Root privileges to install packages and make system changes.

Getting started

1. First, open the official website of Open Web Analytics https://www.openwebanalytics.com/ to download the Open Web Analytics package.

2. Once the file is downloaded, navigate to the directory where the file is saved and extract the files.

 $ tar -zxvf openwebanalytics-1.7.4.tar.gz

3. Open the terminal app and navigate to the extracted directory using the command below.

 $ cd openwebanalytics-1.7.4

4. Install the required dependencies needed for Open Web Analytics using the following command.

 $ sudo zypper install apache2 mysql-server php7 php7-mysql php-ZendFramework php7-pear php7-mbstring php7-gd php7-session php7-xmlwriter

5. Create a MySQL user that Open Web Analytics will use to install the required database tables.

 $ mysql -u root –p

6. Inside mysql shell run the following commands:

 $ CREATE USER ‘owa’@‘localhost’ IDENTIFIED BY 'password';
 $ CREATE DATABASE owa;
 $ GRANT ALL PRIVILEGES ON owa . * TO ‘owa’@‘localhost’;
 $ FLUSH PRIVILEGES;

7. Open the OpenSUSE terminal and navigate to the openwebanalytics-1.7.4 directory.

$ cd openwebanalytics-1.7.4

8. Execute the following command to start the installation wizard of Open Web Analytics.

$ sudo php index.php

9. Provide the required details for the installation wizard such as the database username, password, and database name created earlier. Also provide the admin data, there will be username, password and email fields.

10. Open the Apache default configuration file using the terminal command below.

$ sudo nano /etc/apache2/httpd.conf

11. Configure the Apache2 virtual host settings for Open Web Analytics:

<VirtualHost *:80>
    
    ServerAdmin webmaster@localhost
    DocumentRoot /var/www/html/owa/
    ServerName openwebanalytics.local
    
    <Directory /var/www/html/owa>
        Options Indexes FollowSymLinks MultiViews
        AllowOverride All
        Order allow,deny
        allow from all
    </Directory>
    
    ErrorLog /var/log/apache2/owa-error.log
    CustomLog /var/log/apache2/owa-access.log combined
</VirtualHost>

12. Save the file and exit the editor.

13. Start the Apache service to apply the new configurations.

$ sudo systemctl start apache2

14. Open a browser and go to the URL http://localhost/owa.

15. Once the installation wizard is completely finished, you can start using Open Web Analytics.

Congratulations! You have successfully installed Open Web Analytics on your OpenSUSE machine.

If you want to self-host in an easy, hands free way, need an external IP address, or simply want your data in your own hands, give IPv6.rs a try!

Alternatively, for the best virtual desktop, try Shells!