Piwik

[https://piwik.org/ Piwik] s a real time web analytics software program. It provides you with detailed reports on your website visitors: the search engines and keywords they used, the language they speak, your popular pages, and more.

= Install lighttpd, PHP, and MySql =
{{:Setting Up Lighttpd With FastCGI}}

Install extra packages:
{{Cmd|apk add php-mysql mysql mysql-client}}

= Installing and configuring Piwik =

Piwik needs some additional packages

{{Cmd|apk add php-zlib php-pdo_mysql}}

Create the a folder named ''webapps''

{{Cmd|mkdir -p /usr/share/webapps/}}

Download the source code

{{Cmd|cd /usr/share/webapps/
wget <nowiki>https://piwik.org/latest.zip</nowiki&gt;}}

Unpack the archive and remove it afterwards

{{Cmd|unzip latest.zip
rm How\ to\ install\ Piwik.html latest.zip}}

Change the folder permissions

{{Cmd|chmod -R 777 /usr/share/webapps/}}

Make a symlinks to the ''piwik'' folder

{{Cmd|ln -s /usr/share/webapps/piwik/ /var/www/localhost/htdocs/piwik}}

= Configuration and start MySql =

{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql
/etc/init.d/mysql start && rc-update add mysql default
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}

= Configuration of Piwik =

Browse to <nowiki>http://WEBSERVER_IP_ADDRESS/piwik/</nowiki> and the configuration process will start.

= Upgrading Piwik =
It's still possible to upgrade Piwik by replace the old files with new ones. But a faster way is to use the integrated upgrade mechanism of Piwik itself. Just follow the instructions mentioned in the web interface.

[[Category:Monitoring]]
[[Category:PHP]]
[[Category:SQL]]