TurnKey Linux Virtual Appliance Library

Piwik

-

Self Hosted Real-Time Web Analytics

Piwik is the leading free software alternative to Google Analytics, used on more than 320,000 websites. Piwik lets you easily collect and visualize data from websites, apps & the Internet of Things. It can generate detailed reports of your website visitors, the search engines and keywords they used, the language they speak, your popular pages, and much more. Privacy is built-in.

Stable version: 14.1 (changelog)

This appliance includes all the standard features in TurnKey Core, and on top of that:

  • Piwik configurations:
    • Installed from official Piwik debian package archive (to /usr/share/piwik)

      Security note: Updates to Piwik may require supervision so they ARE NOT configured to install automatically. See below for updating Piwik.

  • SSL support out of the box.
  • Adminer administration frontend for MySQL (listening on port 12322 - uses SSL).
  • Postfix MTA (bound to localhost) to allow sending of email (e.g., password recovery).
  • Webmin modules for configuring Apache2, PHP, MySQL and Postfix.

Supervised Manual Piwik Update

To upgrade to the latest version of Piwik from the command line:

apt-get update
apt-get install piwik

We recommend subscribing to the Piwik changelog to be notified about new versions and security updates.

Usage details & Logging in for Administration

No default passwords: For security reasons there are no default passwords. All passwords are set at system initialization time.

Ignore SSL browser warning: browsers don't like self-signed SSL certificates, but this is the only kind that can be generated automatically without paying a commercial Certificate Authority.

Username for piwik:

Login as username admin

Web - point your browser at either:

  1. http://12.34.56.789/ - not encrypted so no browser warning
  2. https://12.34.56.789/ - encrypted with self-signed SSL certificate

Username for database administration:

Login as MySQL username root at

  1. https://12.34.56.789:12322/ - Adminer database management web app
  2. MySQL command line tool:
    $ mysql --user root --password
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql>
    

Username for OS system administration:

Login as root except on AWS marketplace which uses username admin.

  1. Point your browser to:
  2. Login with SSH client:
    ssh root@12.34.56.789
    

    Special case for AWS marketplace:

    ssh admin@12.34.56.789
    

* Replace 12.34.56.789 with a valid IP or hostname.