How to Install Piwik on an Ubuntu 12.04 Cloud Server

Article Number: 287 | Rating: Unrated | Last Updated: Sat, Jan 4, 2014 at 5:31 AM

Piwik is an open-source analytics system, which can be hosted at your cloud sever. It provides a more personalized solution than Google Analytics as it lets you have ownership and more control of your data, shows detailed traffic in real-time, and it has more stylistic graphs to see your data more effectively.

Prerequisites

First, update Ubuntu for the latest software versions.

apt-get update
apt-get upgrade

APT will inform you about the available upgrade's number and size. Just type "Y" and press ENTER.

During the Package Configuration, APT will ask you "What would you like to do about menu.lst?" Just press ENTER to choose the default option, "keep the local version currently installed." After a few seconds, it will ask you the same question. Press ENTER again.

Now, install LAMP (Linux-Apache-Mysql-PHP) in Ubuntu, by typing in the console:

tasksel

Use the down arrow key to go to the option, LAMP server, and select it by pressing the Space key. Press the TAB key to choose the OK button and hit ENTER. Tasksel installs the needed packages.

During the installation process, taskel is asking for a new password for the MYSQL root. Type the password of your choosing and press ENTER. At the next screen, type the same password once more and press ENTER.

After this, install some additional software that will be needed later on.

apt-get install unzip php5-gd

Type "Y" and press Enter to continue.

Installing Piwik

Go to the default root directory of Apache.

cd /var/www

Download latest Piwik zip file.

wget http://builds.piwik.org/latest.zip

Unzip the downloaded file.

unzip latest.zip

Clean up the unneeded files.

rm *html *zip

Set the correct file permissions.

chown -R www-data:www-data /var/www/piwik

Restart apache.

service apache2 restart

The rest of the process will go through the Web installer.

Complete the Piwik Installation Through the Web Installer

Open your web browser (Chrome, Safari, Firefox) and access the web installer of your Piwik installation by typing in the following URL:

http://<IP-address>/piwik/

You will enter into Piwik's Welcome Screen. Click Next:

WEB1

At the System Check Screen, everything should be with green checkmarks. Click Next if you see this. If not, confim if you are using Ubuntu 12.04 and ran all the software updates/upgrades.

At the Database Setup screen, set the database server to be "127.0.01". You can use the phrase, "root", as the login and the same password that you setup during tasksel's MySQL installation procedure. Set a name for your database, eg. "piwik", and click Next.

WEB3

Next screen should show: "Tables created with sucess!". Just click Next.

At the Super User screen, set the user login and password for logging into Piwik Analytics. Then, write your email address and your email preferences. Click Next when finished.

When you enter into Setup a Website screen, set the website's name and URL of the website where you will want to install the Piwik tracking code later. You may also configure the website's timezone, and set if it's an ecommerce site or not.

WEB6

The next screen gives you the Tracking code which should be copied and pasted just before the closing tag (</body>) of your website.

WEB7

If you use a CMS (Content Management System) like Wordpress or Drupal, there are two ways to install the piwik tracking code:
1. Either copy and paste the code from this screen at your HTML templates files.
Or
2. Follow the instructions that the piwik modules/extensions for these CMSes provide.

Congratulations! Your Piwik is now installed to your cloud server.

Now, to confirm if your Piwik is fully setup and accessible, enter the URL below at your web browser's address bar.