Raspberry Pi Nextcloud Server Build - Part 2

Administration: Overview
- Security & set-up warnings
- Enabled redis for caching
- Migrated to PostgreSQL
- Enable cron - manual "Background jobs"


-------------------------------------------------------------------------
PostgreSQL Conversion:

https://opensource.com/article/17/10/set-postgres-database-your-raspberry-pi

pi@pinas:~ $ sudo su postgres
postgres@pinas:/home/pi$ createuser ncadmin

postgres@pinas:/home/pi$ createuser ncadmin -P --interactive
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) y

postgres@pinas:/home/pi$ psql
psql (11.5 (Raspbian 11.5-1+deb10u1))
Type "help" for help.

postgres=# create database nextcloud
postgres-# ;
CREATE DATABASE

postgres@pinas:/etc/postgresql/11/main$ ls -lrt
total 52
-rw-r--r-- 1 postgres postgres 317 Jan 10 13:26 start.conf
-rw-r--r-- 1 postgres postgres 143 Jan 10 13:26 pg_ctl.conf
-rw-r----- 1 postgres postgres 1636 Jan 10 13:26 pg_ident.conf
-rw-r----- 1 postgres postgres 4686 Jan 10 13:26 pg_hba.conf
-rw-r--r-- 1 postgres postgres 315 Jan 10 13:26 environment
drwxr-xr-x 2 postgres postgres 4096 Jan 10 13:26 conf.d
-rw-r--r-- 1 postgres postgres 24077 Jan 10 13:26 postgresql.conf

pi@pinas:~ $ service postgresql status
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Fri 2020-01-10 13:53:05 GMT; 6s ago
Process: 4224 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 4224 (code=exited, status=0/SUCCESS)

Jan 10 13:53:05 pinas systemd[1]: Starting PostgreSQL RDBMS...
Jan 10 13:53:05 pinas systemd[1]: Started PostgreSQL RDBMS.


pi@pinas:~ $ sudo netstat -anpt | grep LISTEN
tcp 0 0 127.0.0.1:6379 0.0.0.0:* LISTEN 510/redis-server 12
tcp 0 0 0.0.0.0:5900 0.0.0.0:* LISTEN 459/vncserver-x11-c
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 503/sshd
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 8537/postgres
tcp6 0 0 ::1:6379 :::* LISTEN 510/redis-server 12
tcp6 0 0 :::5900 :::* LISTEN 459/vncserver-x11-c
tcp6 0 0 :::80 :::* LISTEN 537/apache2
tcp6 0 0 :::22 :::* LISTEN 503/sshd
tcp6 0 0 :::5432 :::* LISTEN 8537/postgres
tcp6 0 0 :::443 :::* LISTEN 537/apache2

-----------------------------------------------

Apps - File Access Control
--------------------------
Don't use this - looks like it's causing problems when sharing folders...


Moved Default Storage Location
------------------------------
"Moving Nextcloud's data folder" - https://pimylifeup.com/raspberry-pi-nextcloud-server/


Port Forwarding
---------------

config.php - 'trusted_domains'


SSL
---
"Setting up SSL for Nextcloud"


root@pinas:/var/www/html/nextcloud/config# cd /etc/apache2/ssl
root@pinas:/etc/apache2/ssl# ls -lrt
total 8
-rw------- 1 root root 3272 Jan 7 17:41 apache.key
-rw-r--r-- 1 root root 2090 Jan 7 17:42 apache.crt

root@pinas:/var/www/html/nextcloud/config# cd /etc/apache2/sites-available
root@pinas:/etc/apache2/sites-available# ls -lrt
total 16
-rw-r--r-- 1 root root 1450 Jan 7 17:51 000-default.conf
-rw-r--r-- 1 root root 6332 Jan 8 10:25 default-ssl.conf
-rw-r--r-- 1 root root 261 Jan 12 15:57 nextcloud.conf