Matomo: Difference between revisions
Dubiousjim (talk | contribs) (Category:SQL) |
mNo edit summary |
||
| Line 5: | Line 5: | ||
* [http://piwik.org Piwik] | * [http://piwik.org Piwik] | ||
= 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 = | |||
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 = | |||
{{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 = | |||
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
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
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.