Piwik - Revision history

Vincent: Debian Stretch

2017-06-24T10:52:52Z

Debian Stretch

← Older revision		Revision as of 10:52, 24 June 2017
Line 23:		Line 23:
	=== Install Package ===		=== Install Package ===
	<syntaxhighlight lang="console">		<syntaxhighlight lang="console">
	$ sudo apt install piwik geoip-database~~/jessie-backports~~ geoip-database-extra~~/jessie-backports~~		$ sudo apt install piwik geoip-database geoip-database-extra
	</syntaxhighlight>		</syntaxhighlight>

2017-06-24T08:53:50Z

PHP7.0

← Older revision		Revision as of 08:53, 24 June 2017
Line 19:		Line 19:

	=== Configure PHP ===		=== Configure PHP ===
	~~Edit file <code>[[~~PHP~~#Common_configuration~~\|~~/etc/php5/mods-available/local-common.ini]]</code> and add <code>~~/usr/share/piwik/:/etc/piwik/:/var/lib/piwik/~~</code> to the <code>open_basedir</code> setting.~~		{{PHP/open_basedir\|folders=/usr/share/piwik/:/etc/piwik/:/var/lib/piwik/}}

	~~Reload PHP:~~
	~~<syntaxhighlight lang="console">~~
	~~$ sudo service php5-fpm reload~~
	~~</syntaxhighlight>~~

	=== Install Package ===		=== Install Package ===
Line 93:		Line 88:
	location = /index.php {		location = /index.php {
	include fastcgi.conf;		include fastcgi.conf;
	fastcgi_pass ~~php5~~;		fastcgi_pass php;
	}		}

	location = /piwik.php {		location = /piwik.php {
	include fastcgi.conf;		include fastcgi.conf;
	fastcgi_pass ~~php5~~;		fastcgi_pass php;
	}		}

2016-12-11T16:43:05Z

Complete installation transfer instructions

@@ Line 108: / Line 108: @@
          return 200 "User-agent: *\nAllow: /piwik.js\nAllow: /piwik.php\nDisallow: /\n";
+     }
+<nowiki>}</nowiki>
 }}
 [[Category:Linux Server]]
@@ Line 144: / Line 144: @@
 == Transfer Existing Installation ==
 === Copy Database ===
 On the old server, backup you database using<syntaxhighlight lang="console">
 $ mysqldump -u root -aqp piwik | gzip > piwik.sql.gz
-</syntaxhighlight>And restore it on the new server using<syntaxhighlight lang="console">
+</syntaxhighlight>Copy the file <code>piwik.sql.gz</code> to the new server.
 $ zcat piwik.sql.gz | mysql -u root -p piwik
 </syntaxhighlight>

2016-12-11T09:14:18Z

Initial setup

← Older revision		Revision as of 09:14, 11 December 2016
Line 108:		Line 108:
	return 200 "User-agent: *\nAllow: /piwik.js\nAllow: /piwik.php\nDisallow: /\n";		return 200 "User-agent: *\nAllow: /piwik.js\nAllow: /piwik.php\nDisallow: /\n";
	}		}
	~~<nowiki>~~}~~</nowiki>~~		}
	}}		}}
	[[Category:Linux Server]]		[[Category:Linux Server]]
Line 120:		Line 120:

	== Configure ==		== Configure ==

			=== Initial Setup ===
			Open your browser to your piwik website (<nowiki>https://piwik.example.org</nowiki>) and follow the instructions.

			You will need to enter the credentials for the database user that we just created. You will also create the first user of your website.

			Once this is done and you can log into your website properly, time to remove the temporary password from nginx.

			Edit file <code>/etc/nginx/sites-available/piwik.example.org</code> and remove the two lines that start with <code>auth_basic</code>.

			Reload Nginx with<syntaxhighlight lang="console">
			$ sudo systemctl reload nginx.service
			</syntaxhighlight>

	=== Cron ===		=== Cron ===

2016-12-11T07:55:04Z

$%^%$ ublock

← Older revision		Revision as of 07:55, 11 December 2016
Line 128:		Line 128:
	</syntaxhighlight>Once the cron is set, you can disable the reports in the UI. Open administration pages, go to section Settings / General and disable archiving in the UI		</syntaxhighlight>Once the cron is set, you can disable the reports in the UI. Open administration pages, go to section Settings / General and disable archiving in the UI

	== [[File:~~Piwik_archiving_setting~~.png\|~~frameless~~\|609x609px]]Transfer Existing Installation ==		[[File:PiwikArchivingSetting.png\|border\|609x609px]]

			== Transfer Existing Installation ==

	=== Copy Database ===		=== Copy Database ===

2016-12-10T23:28:31Z

fix img

← Older revision		Revision as of 23:28, 10 December 2016
Line 128:		Line 128:
	</syntaxhighlight>Once the cron is set, you can disable the reports in the UI. Open administration pages, go to section Settings / General and disable archiving in the UI		</syntaxhighlight>Once the cron is set, you can disable the reports in the UI. Open administration pages, go to section Settings / General and disable archiving in the UI

	[[File:~~Piwik archiving setting~~.png]]		== [[File:Piwik_archiving_setting.png\|frameless\|609x609px]]Transfer Existing Installation ==

	== Transfer Existing Installation ==

	=== Copy Database ===		=== Copy Database ===

2016-12-10T23:25:55Z

Cron report archiving

← Older revision		Revision as of 23:25, 10 December 2016
Line 108:		Line 108:
	return 200 "User-agent: *\nAllow: /piwik.js\nAllow: /piwik.php\nDisallow: /\n";		return 200 "User-agent: *\nAllow: /piwik.js\nAllow: /piwik.php\nDisallow: /\n";
	}		}
	}		<nowiki>}</nowiki>
	}}		}}
	[[Category:Linux Server]]		[[Category:Linux Server]]
Line 120:		Line 120:

	== Configure ==		== Configure ==

			=== Cron ===
			By default, Piwik will preprocess data when you see it in the browser. This can give a slow UI depending on the data that you have. To process can be replaced by a cron job for better performance.

			To set the cron job, edit file <code>/etc/cron.d/piwik-archive</code> to uncomment the line and replace the URL<syntaxhighlight lang="text">
			5 * * * * www-data [ -e /usr/share/piwik/console ] && [ -x /usr/bin/php ] && nice /usr/bin/php /usr/share/piwik/console core:archive --url="https://piwik.example.org/" >>/var/log/piwik/piwik-archive.log 2>&1
			</syntaxhighlight>Once the cron is set, you can disable the reports in the UI. Open administration pages, go to section Settings / General and disable archiving in the UI

			[[File:Piwik archiving setting.png]]

	== Transfer Existing Installation ==		== Transfer Existing Installation ==

2016-12-10T17:30:18Z

DB backup restore info

← Older revision		Revision as of 17:30, 10 December 2016
Line 125:		Line 125:
	=== Copy Database ===		=== Copy Database ===
	On the old server, backup you database using<syntaxhighlight lang="console">		On the old server, backup you database using<syntaxhighlight lang="console">
	$ mysqldump -aqp piwik \| gzip > piwik.sql.gz		$ mysqldump -u root -aqp piwik \| gzip > piwik.sql.gz
	</syntaxhighlight>And <syntaxhighlight lang="console">		</syntaxhighlight>And restore it on the new server using<syntaxhighlight lang="console">
	$ ~~mysqldump -aqp piwik \| gzip >~~ piwik.sql.gz		$ zcat piwik.sql.gz \| mysql -u root -p piwik
	</syntaxhighlight>		</syntaxhighlight>

2016-09-24T15:41:43Z

← Older revision		Revision as of 15:41, 24 September 2016
Line 113:		Line 113:
	[[Category:Debian Release]]		[[Category:Debian Release]]
	[[Category:TODO]]		[[Category:TODO]]

			=== Create Database ===
			For the rest of the guide, we will use a dedicated database and user named <code>piwik</code>.

			You can [[PhpMyAdmin/New Database\|create them using PhpMyAdmin]] or any other method.

			== Configure ==

			== Transfer Existing Installation ==

			=== Copy Database ===
			On the old server, backup you database using<syntaxhighlight lang="console">
			$ mysqldump -aqp piwik \| gzip > piwik.sql.gz
			</syntaxhighlight>And <syntaxhighlight lang="console">
			$ mysqldump -aqp piwik \| gzip > piwik.sql.gz
			</syntaxhighlight>

2016-09-10T11:18:13Z

DNS + Nginx

@@ Line 30: / Line 30: @@
 $ sudo apt install piwik geoip-database/jessie-backports geoip-database-extra/jessie-backports
 </syntaxhighlight>
 [[Category:Linux Server]]
 [[Category:Debian Release]]
 [[Category:TODO]]