Open Web Analytics (OWA): Install & Launch on Your Server
Updated by Alex Fornuto Contributed by Douglas Colby
This is a Linode Community guide. If you’re an expert on something for which we need a guide, you too can get paid to write for us.
Before you Begin
This guide assumes that you have your Linode already set up and running, that you have followed:
- The Getting Started guide.
- The Securing Your Server guides.
- That the Linode’s hostname is set and has a FQDN.
The steps required in this guide require root privileges. Be sure to run the steps below as root or with the
sudoprefix. For more information on privileges see our Users and Groups guide.
Your server must be configured with a fully qualified domain name (FQDN) and not just an IP address. If needed, you can use the address provided in the Remote Access Tab next to your public IP address.
Make sure your system is up-to-date:
Debian & Ubuntu
apt-get update && apt-get upgrade
Install the supporting software packages:
yum install httpd php php-mysql mysql-server mariadb-server
NoteThis command is designed to work with CentOS 6, which uses MySQL as the default database and CentOS 7 which uses MariaDB. You will get a notice when installing that the other package is not available.
Debian & Ubuntu
apt-get install apache2 php5 php5-mysql mysql-server
CentOS users will need to enable and activate the
systemctl enable mariadb systemctl start mariadb systemctl enable httpd systemctl start httpd
chkconfig mysqld on service mysqld start chkconfig httpd on service httpd start
Debian and Ubuntu users will need to restart the Apache2 daemon:
service apache2 restart
Set up MySQL
mysql_secure_installationto secure your database:
You should answer yes to most of the prompts. CentOS users, make sure to set a strong password for the root user since it is initially blank. This is the root user for
mysqland is not related to the system’s root user.
Enter the MySQL CLI:
mysql -u root -p
You’ll need to enter the password you set in the step above, or when you installed
Create a database named
CREATE DATABASE owadb;
Create a user named
owadbuser. Replace the example password,
owadbpassword, with a strong password of your choice. This information will be needed later to configure OWA.
GRANT ALL PRIVILEGES ON owadb.* TO owadbuser@localhost IDENTIFIED BY 'owadbpassword';
Exit the MySQL CLI:
Navigate to your document root folder for your webserver, usually
Download the OWA package:
NoteVersion 1.5.7 is the current version and may be different by the time you read this. Please check The Open Web Analytics site for the latest information.
Unpack the downloaded file:
tar xf 1.*.tar.gz
Change ownership of the
owafolder to the Apache daemon user:
chown -R apache:apache Open*
Debian & Ubuntu
chown -R www-data:www-data Open*
Recommended: Rename the OWA folder:
mv Open-Web-Analytics-1.5.7 owa
Delete the tar file:
rm -rf 1.*.tar.gz
Navigate to the OWA installation page in your webbrowser. Replace
your.domainwith your Linode’s IP address or FQDN:
After clicking on Let’s Get Started, you should see a configuration page for your OWA installation. OWA will automatically fill in the first field with the path to your OWA installation. You will need to fill in the other fields on the page with the information you set in the MySQL CLI:
Create a user account and define a domain to track. You will log in to see your OWA statistics through this user account.
CautionThis process will display your password in plaintext once complete. Be careful if performing these steps in a public location.
Log in to your OWA installation. In your browser go to:
The first time you login OWA will present you with a tracking tag (a code snippet) for the domain you defined when you created your user account. This code should be added to the html pages of the site you wish to track.
Once the tracking tag has been added to your website pages, analysis data can be viewed under the “Reporting” section (click the button at the top of the page) which will take you to the Sites Roster page.
To add more sites to track, click “Add New” at the top left of the page.
On the resulting page you will see near the top a section named “Add a New Tracked Site Profile”. Enter the domain name of the site you want to track and click Save Profile. The other two fields are for your information only and are, therefore, optional.
CautionYou must click “Save Profile” before trying to enter any of the settings below this button. Failure to do so will result in a blank white page and your new site not being added. Recovery simply requires a click of the back button in your browser.
Click on “Reporting” in the top left corner to return to the Sites Roster page. In the list of tracked sites, find your new site and click “Get Tracking Code”.
Click “View Reports” in the Sites Roster page and begin happy analyzing!
You may wish to consult the following resources for additional information on this topic. While these are provided in the hope that they will be useful, please note that we cannot vouch for the accuracy or timeliness of externally hosted materials.
This guide is published under a CC BY-ND 4.0 license.