Matomo: Difference between revisions

From Alpine Linux
(replace /etc/init.d with rc-service)
 
(12 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{Draft}}
[https://github.com/matomo-org/matomo Matomo] 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.
{{Warning|Piwik was renamed to Matomo in January 2019, the file paths below may need to be updated.}}


* 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 9:
{{Cmd|apk add php-mysql mysql mysql-client}}
{{Cmd|apk add php-mysql mysql mysql-client}}


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


Piwik needs some additional packages
Matomo needs some additional packages


{{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 https://builds.matomo.org/matomo-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
/etc/init.d/mysql start && rc-update add mysql default
rc-service mysql start && rc-update add mysql default
/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 <nowiki>http://WEBSERVER_IP_ADDRESS/piwik/</nowiki> 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]]

Latest revision as of 10:04, 17 November 2023

Matomo 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.

Warning: Piwik was renamed to Matomo in January 2019, the file paths below may need to be updated.


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 Matomo

Matomo 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 https://builds.matomo.org/matomo-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 rc-service 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.