Hi everbody! 
I am learning and trying to build an optimized docker-compose.yml to run Nextcloud with Collabora Online.
First, I want to get a fully funcional Nextcloud on my VPS using plain HTTP.
After everything is working right and hopefully, optimized, I will try to put this setup behind a docker container running Caddy (for HTTPS and certificates management).
I wrote the docker-compose.yml with two choices for database, Postgres or Mariadb. But discovered that Postgres container takes more time to be ready and Nextcloud installation (using environment variables) fails. With Mariadb install fails at first (you can see in logs) but retries and finalizes the installation.
Everything going well until I tried to “attach” Collabora Online container. I don’t know what is wrong, if is something only on Collabora container, other(s) conteiner(s) configuration or something to be done on Nextcloud settings (as admin).
Configuration on Settings / Nextcloud Office appears to be ok: I got the green circle on “Setting up a new server” after click “Use your own server”, fill the URL (using user:password, as I saw elsewhere) and then checking “Disable certificate verification (insecure)”.
http://user:password@collabora.example.com:9980
When I try to create a new document, Nextcloud let me choose a template, I click “Create” and then “Loading test.odt…” until “Document loading failed” - “Failed to load Nextcloud Office - please try again later”. The only option is to click on a close button that leads back to Nextcloud showing the “test.odt” document on the list of files.
Bellow, docker-compose.yml
version: '2'
services:
#nextcloud-db:
# image: postgres:12-alpine
# container_name: nextcloud-db
# restart: unless-stopped
# environment:
# POSTGRES_USER: nextcloud
# POSTGRES_PASSWORD: password
# volumes:
# - nextcloud-db:/var/lib/postgresql/data
# - /etc/localtime:/etc/localtime:ro
nextcloud-db:
image: mariadb
container_name: nextcloud-db
restart: unless-stopped
command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
environment:
MYSQL_ROOT_PASSWORD: password
MYSQL_PASSWORD: password
MYSQL_DATABASE: nextcloud
MYSQL_USER: nextcloud
volumes:
- nextcloud-db:/var/lib/mysql
nextcloud-cache:
image: redis:alpine
container_name: nextcloud-cache
restart: unless-stopped
mem_limit: 2048m
mem_reservation: 512m
command: redis-server --requirepass password
nextcloud-app:
image: nextcloud:fpm-alpine
container_name: nextcloud-app
restart: unless-stopped
depends_on:
- nextcloud-db
- nextcloud-cache
environment:
MYSQL_DATABASE: nextcloud
MYSQL_USER: nextcloud
MYSQL_PASSWORD: password
MYSQL_HOST: nextcloud-db
POSTGRES_DB: nextcloud
POSTGRES_USER: nextcloud
POSTGRES_PASSWORD: password
POSTGRES_HOST: nextcloud-db
NEXTCLOUD_ADMIN_USER: admin
NEXTCLOUD_ADMIN_PASSWORD: password
NEXTCLOUD_TRUSTED_DOMAINS: nextcloud.example.com collabra.example.com
REDIS_HOST: nextcloud-cache
REDIS_HOST_PASSWORD: password
SMTP_HOST: mail.example.com
SMTP_SECURE: tls
SMTP_PORT: 587
SMTP_AUTHTYPE: LOGIN
SMTP_NAME: mailer@example.com
SMTP_PASSWORD: password
MAIL_FROM_ADDRESS: no-reply
MAIL_DOMAIN: example.com
volumes:
- nextcloud-app:/var/www/html
nextcloud-web:
image: nginx:alpine
container_name: nextcloud-web
restart: unless-stopped
ports:
- 80:80
volumes:
- ./nginx.conf:/etc/nginx/nginx.conf:ro
volumes_from:
- nextcloud-app
nextcloud-collabora:
image: collabora/code
container_name: nextcloud-collabora
restart: unless-stopped
ports:
- 9980:9980
depends_on:
- nextcloud-web
cap_add:
- MKNOD
environment:
- username=admin
- password=password
- DONT_GEN_SSL_CERT=yes
- server_name=collabra.example.com
- dictionaries=en_US es_ES pt_BR
- extra_params=--o:ssl.enable=false
# Domain the service should be accessed from:
#- domain=${VIRTUAL_HOST}
#- domain=example.com
#
#- VIRTUAL_HOST=${COLLABORA_VIRTUAL_HOST}
#- VIRTUAL_HOST=collabra.example.com
#- LETSENCRYPT_HOST=${COLLABORA_VIRTUAL_HOST}
#- LETSENCRYPT_HOST=${COLLABORA_VIRTUAL_HOST}
#
# Extra parameters to Collabora, see also
# https://www.collaboraoffice.com/code/nginx-reverse-proxy/:
# SSL terminates at the proxy
#- extra_params=--o:ssl.enable=false --o:ssl.termination=true
volumes:
- /etc/localtime:/etc/localtime:ro
volumes:
nextcloud-app:
nextcloud-db:
networks:
default:
name: caddy_net
external: true
and nginx.conf
worker_processes auto;
error_log /var/log/nginx/error.log warn;
pid /var/run/nginx.pid;
events {
worker_connections 1024;
}
http {
include /etc/nginx/mime.types;
default_type application/octet-stream;
log_format main '$remote_addr - $remote_user [$time_local] "$request" '
'$status $body_bytes_sent "$http_referer" '
'"$http_user_agent" "$http_x_forwarded_for"';
access_log /var/log/nginx/access.log main;
sendfile on;
#tcp_nopush on;
# Prevent nginx HTTP Server Detection
server_tokens off;
keepalive_timeout 65;
#gzip on;
upstream php-handler {
server nextcloud-app:9000;
}
server {
listen 80;
# HSTS settings
# WARNING: Only add the preload option once you read about
# the consequences in https://hstspreload.org/. This option
# will add the domain to a hardcoded list that is shipped
# in all major browsers and getting removed from this list
# could take several months.
#add_header Strict-Transport-Security "max-age=15768000; includeSubDomains; preload;" always;
# set max upload size
client_max_body_size 512M;
fastcgi_buffers 64 4K;
# Enable gzip but do not remove ETag headers
gzip on;
gzip_vary on;
gzip_comp_level 4;
gzip_min_length 256;
gzip_proxied expired no-cache no-store private no_last_modified no_etag auth;
gzip_types application/atom+xml application/javascript application/json application/ld+json application/manifest+json application/rss+xml application/vnd.geo+json application/vnd.ms-fontobject application/x-font-ttf application/x-web-app-manifest+json application/xhtml+xml application/xml font/opentype image/bmp image/svg+xml image/x-icon text/cache-manifest text/css text/plain text/vcard text/vnd.rim.location.xloc text/vtt text/x-component text/x-cross-domain-policy;
# Pagespeed is not supported by Nextcloud, so if your server is built
# with the `ngx_pagespeed` module, uncomment this line to disable it.
#pagespeed off;
# HTTP response headers borrowed from Nextcloud `.htaccess`
add_header Referrer-Policy "no-referrer" always;
add_header X-Content-Type-Options "nosniff" always;
add_header X-Download-Options "noopen" always;
add_header X-Frame-Options "SAMEORIGIN" always;
add_header X-Permitted-Cross-Domain-Policies "none" always;
add_header X-Robots-Tag "none" always;
add_header X-XSS-Protection "1; mode=block" always;
# Remove X-Powered-By, which is an information leak
fastcgi_hide_header X-Powered-By;
# Path to the root of your installation
root /var/www/html;
# Specify how to handle directories -- specifying `/index.php$request_uri`
# here as the fallback means that Nginx always exhibits the desired behaviour
# when a client requests a path that corresponds to a directory that exists
# on the server. In particular, if that directory contains an index.php file,
# that file is correctly served; if it doesn't, then the request is passed to
# the front-end controller. This consistent behaviour means that we don't need
# to specify custom rules for certain paths (e.g. images and other assets,
# `/updater`, `/ocm-provider`, `/ocs-provider`), and thus
# `try_files $uri $uri/ /index.php$request_uri`
# always provides the desired behaviour.
index index.php index.html /index.php$request_uri;
# Rule borrowed from `.htaccess` to handle Microsoft DAV clients
location = / {
if ( $http_user_agent ~ ^DavClnt ) {
return 302 /remote.php/webdav/$is_args$args;
}
}
location = /robots.txt {
allow all;
log_not_found off;
access_log off;
}
# Make a regex exception for `/.well-known` so that clients can still
# access it despite the existence of the regex rule
# `location ~ /(\.|autotest|...)` which would otherwise handle requests
# for `/.well-known`.
location ^~ /.well-known {
# The rules in this block are an adaptation of the rules
# in `.htaccess` that concern `/.well-known`.
location = /.well-known/carddav { return 301 /remote.php/dav/; }
location = /.well-known/caldav { return 301 /remote.php/dav/; }
location /.well-known/acme-challenge { try_files $uri $uri/ =404; }
location /.well-known/pki-validation { try_files $uri $uri/ =404; }
# Let Nextcloud's API for `/.well-known` URIs handle all other
# requests by passing them to the front-end controller.
return 301 /index.php$request_uri;
}
# Rules borrowed from `.htaccess` to hide certain paths from clients
location ~ ^/(?:build|tests|config|lib|3rdparty|templates|data)(?:$|/) { return 404; }
location ~ ^/(?:\.|autotest|occ|issue|indie|db_|console) { return 404; }
# Ensure this block, which passes PHP files to the PHP process, is above the blocks
# which handle static assets (as seen below). If this block is not declared first,
# then Nginx will encounter an infinite rewriting loop when it prepends `/index.php`
# to the URI, resulting in a HTTP 500 error response.
location ~ \.php(?:$|/) {
# Required for legacy support
rewrite ^/(?!index|remote|public|cron|core\/ajax\/update|status|ocs\/v[12]|updater\/.+|oc[ms]-provider\/.+|.+\/richdocumentscode\/proxy) /index.php$request_uri;
fastcgi_split_path_info ^(.+?\.php)(/.*)$;
set $path_info $fastcgi_path_info;
try_files $fastcgi_script_name =404;
include fastcgi_params;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_param PATH_INFO $path_info;
#fastcgi_param HTTPS on;
fastcgi_param modHeadersAvailable true; # Avoid sending the security headers twice
fastcgi_param front_controller_active true; # Enable pretty urls
fastcgi_pass php-handler;
fastcgi_intercept_errors on;
fastcgi_request_buffering off;
}
location ~ \.(?:css|js|svg|gif)$ {
try_files $uri /index.php$request_uri;
expires 6M; # Cache-Control policy borrowed from `.htaccess`
access_log off; # Optional: Don't log access to assets
}
location ~ \.woff2?$ {
try_files $uri /index.php$request_uri;
expires 7d; # Cache-Control policy borrowed from `.htaccess`
access_log off; # Optional: Don't log access to assets
}
# Rule borrowed from `.htaccess`
location /remote {
return 301 /remote.php$request_uri;
}
location / {
try_files $uri $uri/ /index.php$request_uri;
}
}
}
So, “let’s get ready to rumble”! 