Matomo: Difference between revisions

From Alpine Linux
(Category:SQL)
mNo edit summary
Line 5: Line 5:
* [http://piwik.org Piwik]
* [http://piwik.org Piwik]


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


Line 11: Line 11:
{{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 39: Line 39:
{{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 45: Line 45:
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}


== Configuration of Piwik ==
= Configuration of Piwik =


Browse to http://WEBSERVER_IP_ADDRESS/piwik/ and the configuration process will start.
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.


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

Revision as of 09:31, 31 May 2012

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
  • MySql
  • Piwik

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

Make webapps folder

mkdir -p /usr/share/webapps/

Download

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

Unpack

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

Change folder permissions

chmod -R 777 /usr/share/webapps/

Make symlinks to Piwik

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.