Servidor Nextcloud + Collabora Online

Passos Previs

1. Accedir a MySQL com a root

sudo mysql

2. Crear la base de dades

CREATE DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

• Substitueix `nextcloud` pel nom que vulguis per la base de dades.

3. Crear un usuari amb contrasenya

CREATE USER 'nextclouduser'@'localhost' IDENTIFIED BY 'supersecret';

• Substitueix `nextclouduser` i `supersecret` per l’usuari i contrasenya que vulguis.

4. Concedir tots els permisos sobre aquesta base de dades

GRANT ALL PRIVILEGES ON nextcloud.* TO 'nextclouduser'@'localhost';

5. Aplicar els canvis

FLUSH PRIVILEGES;

6. Comprovar

SHOW DATABASES;
SELECT User, Host FROM mysql.user;

Notes

• Aquest usuari tindrà permisos només sobre la base de dades `nextcloud`.
• No necessita permisos globals de root, augmentant la seguretat.

Instal·lació de Nextcloud + Collabora amb Docker Compose

1. Preparar el projecte

mkdir ~/nextcloud-docker
cd ~/nextcloud-docker

2. Crear fitxer docker-compose.yml

version: "3.8"

services:
  traefik:
    image: traefik:v3.0
    container_name: traefik
    restart: unless-stopped
    command:
      - "--providers.docker=true"
      - "--entrypoints.web.address=:80"
      - "--entrypoints.websecure.address=:443"
      - "--certificatesresolvers.myresolver.acme.tlschallenge=true"
      - "--certificatesresolvers.myresolver.acme.email=tuemail@domini.com"
      - "--certificatesresolvers.myresolver.acme.storage=/letsencrypt/acme.json"
    ports:
      - "80:80"
      - "443:443"
    volumes:
      - "/var/run/docker.sock:/var/run/docker.sock:ro"
      - "traefik_letsencrypt:/letsencrypt"

  db:
    image: mariadb:10.11
    container_name: nextcloud-db
    restart: unless-stopped
    command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
    environment:
      MYSQL_ROOT_PASSWORD: supersecretroot
      MYSQL_DATABASE: nextcloud
      MYSQL_USER: nextcloud
      MYSQL_PASSWORD: supersecret
    volumes:
      - db_data:/var/lib/mysql

  nextcloud:
    image: nextcloud:27
    container_name: nextcloud-app
    restart: unless-stopped
    environment:
      MYSQL_PASSWORD: supersecret
      MYSQL_DATABASE: nextcloud
      MYSQL_USER: nextcloud
      MYSQL_HOST: db
    volumes:
      - nextcloud_data:/var/www/html
    labels:
      - "traefik.enable=true"
      - "traefik.http.routers.nextcloud.rule=Host(`cloud.tudomini.com`)"
      - "traefik.http.routers.nextcloud.entrypoints=websecure"
      - "traefik.http.routers.nextcloud.tls.certresolver=myresolver"
      - "traefik.http.services.nextcloud.loadbalancer.server.port=80"
    depends_on:
      - db

  collabora:
    image: collabora/code
    container_name: collabora
    restart: unless-stopped
    environment:
      - domain=cloud\\.tudomini\\.com
      - username=admin
      - password=supersecret
      - extra_params=--o:ssl.enable=false
    labels:
      - "traefik.enable=true"
      - "traefik.http.routers.collabora.rule=Host(`office.tudomini.com`)"
      - "traefik.http.routers.collabora.entrypoints=websecure"
      - "traefik.http.routers.collabora.tls.certresolver=myresolver"
      - "traefik.http.services.collabora.loadbalancer.server.port=9980"

volumes:
  db_data:
  nextcloud_data:
  traefik_letsencrypt:

3. Llençar els serveis

docker compose up -d

4. Configurar Nextcloud per Collabora

1. Accedir a Nextcloud: https://cloud.tudomini.com
2. Instal·lar l'app Collabora Online des del Nextcloud App Store.
3. Configurar l’URL de Collabora: https://office.tudomini.com