Matomo: Difference between revisions

From Alpine Linux
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Draft}}
[http://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.
[http://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.


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


Line 13: Line 7:
{{Cmd|apk add php-mysql mysql mysql-client}}
{{Cmd|apk add php-mysql mysql mysql-client}}


== Installing and configuring Piwik ==
= Installing and configuring Piwik =


Piwik needs some additional packages
Piwik needs some additional packages
Line 19: Line 13:
{{Cmd|apk add php-zlib php-pdo_mysql}}
{{Cmd|apk add php-zlib php-pdo_mysql}}


Make webapps folder
Create the a folder named ''webapps''


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


Download  
Download the source code


{{Cmd|cd /usr/share/webapps/
{{Cmd|cd /usr/share/webapps/
wget http://piwik.org/latest.zip}}
wget http://piwik.org/latest.zip}}


Unpack  
Unpack the archive and remove it afterwards


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


Change folder permissions
Change the folder permissions


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


Make symlinks to Piwik
Make a symlinks to the ''piwik'' folder


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


== Configuration and start MySql ==
= Configuration and start MySql =


{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql
{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql
Line 47: Line 41:
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}


==Create the Piwik database==
= Configuration of Piwik =
 
{{Cmd|mysql -u root -p}}
 


== Configuration of Piwik ==
Browse to http://WEBSERVER_IP_ADDRESS/piwik/ and the configuration process will start.


Browse
= 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.


http://WEBSERVER_IP_ADDRESS/piwiki/
[[Category:Monitoring]]
[[Category:PHP]]
[[Category:SQL]]

Revision as of 10:08, 12 January 2013

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

Basic Installation

For installing the additional packages first activate community packages and update the package index

Install the required packages:

# apk add lighttpd php82 fcgi php82-cgi

Configure Lighttpd

Edit lighttpd.conf (/etc/lighttpd/lighttpd.conf) and uncomment the line:

Contents of /etc/lighttpd/lighttpd.conf

... include "mod_fastcgi.conf" ...

Edit mod_fastcgi.conf (/etc/lighttpd/mod_fastcgi.conf), find and change /usr/bin/php-cgi to /usr/bin/php-cgi82.

Contents of /etc/lighttpd/mod_fastcgi.conf

... "bin-path" => "/usr/bin/php-cgi82" # php-cgi ...

Start lighttpd service and add it to default runlevel

# rc-service lighttpd start # rc-update add lighttpd default

Install extra packages:

apk add php-mysql mysql mysql-client

Installing and configuring Piwik

Piwik needs some additional packages

apk add php-zlib php-pdo_mysql

Create the a folder named webapps

mkdir -p /usr/share/webapps/

Download the source code

cd /usr/share/webapps/ wget http://piwik.org/latest.zip

Unpack the archive and remove it afterwards

unzip latest.zip rm How\ to\ install\ Piwik.html latest.zip

Change the folder permissions

chmod -R 777 /usr/share/webapps/

Make a symlinks to the piwik folder

ln -s /usr/share/webapps/piwik/ /var/www/localhost/htdocs/piwik

Configuration and start MySql

/usr/bin/mysql_install_db --user=mysql /etc/init.d/mysql start && rc-update add mysql default /usr/bin/mysqladmin -u root password 'password'

Configuration of Piwik

Browse to http://WEBSERVER_IP_ADDRESS/piwik/ 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.