Mark Burton MarkZither

Nextcloud on Raspberry Pi 3 Setup

This manual describes how to setup a Raspberry Pi 3 with nginx, PHP 7.0, MariaDB and use it as a Nextcloud server. Strong TLS encryption with Let's Encrypt certificates is also used. Of course, Owncloud can be used instead of Nextcloud. As of February 2017, the installation instructions are basically the same.

Useful links and knowledge sources for this step-by-step manual

Keybase proof

I hereby claim:

I am markzither on github.
I am markburton (https://keybase.io/markburton) on keybase.
I have a public key ASCrS96FEbA0I6nXifWt25s2n4nsKlaungrp3gvL1cY9sQo

To claim this, I am signing this object:

	-- based on https://stackoverflow.com/questions/3891331/find-non-ascii-characters-in-varchar-columns-using-sql-server
	DECLARE
	@sql varchar(max) = ''
	,@table sysname = '' -- enter your table here and uncomment below to just check 1 table
	,@datatype sysname = 'nvarchar' -- switch between varchar and nvarchar to avoid Msg 8623, Level 16, State 1, Line 1 The query processor ran out of internal resources...

	;with ColumnData as (
	select
	RowId = row_number() over (order by c.COLUMN_NAME)
	,c.COLUMN_NAME

	rsync -avz --exclude-from='exclude_me.txt' aleph.gutenberg.org::gutenberg /mnt/d/gut/aleph.gutenberg.org

	exclude_me.txt
	*.mp3
	.iso.
	*.rar