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
  1. Open the terminal app and navigate to the extracted directory using the command below.
 $ cd openwebanalytics-1.7.4
  1. 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
  1. Create a MySQL user that Open Web Analytics will use to install the required database tables.
 $ mysql -u root –p
  1. 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;
  1. Open the OpenSUSE terminal and navigate to the openwebanalytics-1.7.4 directory.
$ cd openwebanalytics-1.7.4
  1. Execute the following command to start the installation wizard of Open Web Analytics.
$ sudo php index.php

  1. 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.

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

$ sudo nano /etc/apache2/httpd.conf
  1. 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>

  1. Save the file and exit the editor.

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

$ sudo systemctl start apache2

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

  2. 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.