{"id":1473,"date":"2018-10-24T01:17:12","date_gmt":"2018-10-24T01:17:12","guid":{"rendered":"https:\/\/www.appservgrid.com\/paw92\/?p=1473"},"modified":"2018-10-24T03:23:03","modified_gmt":"2018-10-24T03:23:03","slug":"piwik-analytics-on-nginx-linuxadmin-io","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2018\/10\/24\/piwik-analytics-on-nginx-linuxadmin-io\/","title":{"rendered":"Piwik Analytics on Nginx – LinuxAdmin.io"},"content":{"rendered":"

Piwik is a open source web site analytics software. It is free and opensource and can be used to track Nginx requests as well as Apache. This guide covers the Nginx configuration and installation of Pikwik. You can read more about Piwik here<\/a>.<\/p>\n

If you do not already have Nginx and PHP-PFM installed, please see the following guides<\/p>\n

How To Install Nginx<\/a><\/p>\n

How To Install PHP-FPM<\/a><\/p>\n

Install Pikwik<\/h2>\n

Create a new directory to contain the piwik analytics data<\/p>\n

mkdir \/etc\/nginx\/stats.domain.com<\/p>\n

Go to that directory<\/p>\n

cd \/etc\/nginx\/stats.domain.com<\/p>\n

Download the latest version of Piwik<\/p>\n

wget https:\/\/builds.piwik.org\/piwik.zip<\/p>\n

Un-compress it<\/p>\n

unzip piwik.zip<\/p>\n

Create a new database:<\/p>\n

mysql -e “create database pikwik;”<\/p>\n

Create a new database user:<\/p>\n

mysql -e “grant all on pikwik.* to [email protected]<\/a> idenfied by ‘PASSWORD’;”<\/p>\n

Configure Nginx<\/h2>\n

Create a new server configuration for stats.domain.com<\/p>\n

nano \/etc\/nginx\/stats.domain.com.conf<\/p>\n

Insert the following, updating references to stats.domain.com with your domain name.<\/p>\n

server {
\nlisten 80;
\nserver_name stats.domain.com;<\/p>\n

access_log \/etc\/nginx\/logs\/stats.domain.com_access.log;
\nerror_log \/etc\/nginx\/logs\/stats.domain.com_error.log;<\/p>\n

# Disable all methods besides HEAD, GET and POST.
\nif ($request_method !~ ^(GET|HEAD|POST)$ ) {
\nreturn 444;
\n}<\/p>\n

root \/etc\/nginx\/stats.domain.com\/;
\nindex index.php index.html;<\/p>\n

# Disallow any usage of piwik assets if referer is non valid.
\nlocation ~* ^.+.(?:jpg|png|css|gif|jpeg|js|swf)$ {
\n# Defining the valid referers.
\nvalid_referers none blocked *.domain.com;
\nif ($invalid_referer) {
\nreturn 444;
\n}
\nexpires max;
\nbreak;
\n}<\/p>\n

# Support for favicon. Return a 204 (No Content) if the favicon
\n# doesn’t exist.
\nlocation = \/favicon.ico {
\ntry_files \/favicon.ico =204;
\n}<\/p>\n

# Try all locations and relay to index.php as a fallback.
\nlocation \/ {
\ntry_files $uri \/index.php;
\n} #location ~* ^\/(?:index|piwik).php$ {
\nlocation ~ .php$ {
\ntry_files $uri =404;
\nfastcgi_pass 127.0.0.1:9000;
\nfastcgi_index index.php;
\nfastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
\ninclude fastcgi_params;<\/p>\n

}<\/p>\n

# Any other attempt to access PHP files returns a 404.
\n#location ~* ^.+.php$ {
\n# return 404;
\n#}<\/p>\n

# Return a 404 for all text files.
\nlocation ~* ^\/(?:README|LICENSE[^.]*|LEGALNOTICE)(?:.txt)*$ {
\nreturn 404;
\n}<\/p>\n

} # server<\/p>\n

Edit the main nginx configuration file:<\/p>\n

nano \/etc\/nginx\/nginx.conf<\/p>\n

Insert the following line at the end:<\/p>\n

Include \/etc\/nginx\/stats.domain.com.conf;<\/p>\n

Restart nginx<\/p>\n

service nginx restart<\/p>\n

Once you have done that go ahead and visit stats.domain.com it will ask you to input the MySQL credentials you created earlier. After it has populated the database, it will provide you with code to insert into the site you wish to track. Once that is in place it will start generating the data for you to view inside the pikwik installation.<\/p>\n

Jun 5, 2017LinuxAdmin.io<\/p>\n

Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Piwik is a open source web site analytics software. It is free and opensource and can be used to track Nginx requests as well as Apache. This guide covers the Nginx configuration and installation of Pikwik. You can read more about Piwik here. If you do not already have Nginx and PHP-PFM installed, please see … <\/p>\n

Continue reading “Piwik Analytics on Nginx – LinuxAdmin.io”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1473","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/1473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/comments?post=1473"}],"version-history":[{"count":1,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/1473\/revisions"}],"predecessor-version":[{"id":1538,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/1473\/revisions\/1538"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=1473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=1473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=1473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}