Nextcloud can't open documents in Nextcloud Office

Hello everyone!
I’m having a problem opening documents in Nextcloud Office. I attach a picture of the error message of the developer console in the browser. My instance is hosted in a Docker container. I attach the docker-compose.yml, in front of which there is a reverse proxy that distributes the requests to the domains. I was able to store my collabora instance in Office Online. It’s just that I can’t open any documents. Does anyone have an idea what it could be?


Thank you!

version: '3.3'

services:
  nextcloud:
    image: nextcloud:latest
    container_name: nextcloud
    restart: always
    depends_on:
      - redis
#    network_mode: host
    ports:
      - 80:80
    networks:
      - default
    volumes:
      - ./nextcloud:/var/www/html
      - /mnt/ds_nextcloud/data:/var/www/html/data
#      - ./php-fpm.d:/usr/local/etc/php-fpm.d/
    environment:
      - MYSQL_PASSWORD=b4aSsLbUM23GWRVV
      - MYSQL_DATABASE=prod_nextcloud
      - MYSQL_USER=nextcloud
      - MYSQL_HOST=10.10.1.3
      - TRUSTED_PROXIES=*
      - OVERWRITEPROTOCOL=https
      - OVERWRITEURL=cloud.domain.de
      - REDIS_HOST=redis
      - REDIS_HOST_PASSWORD=Password
  collabora:
    image: collabora/code:latest
    container_name: collabora
    #network_mode: host
    cap_add:
      - MKNOD
    networks:
      - default
    environment:
      - domain=cloud.domain.de
      - username=admin
      - password=password
#      - "extra_params=--o:ssl.enable=false --o:ssl.termination=true"
    restart: always
    ports:
      - 9980:9980
  redis:
    image: redis:alpine
    container_name: redis
    ports:
      - 6379:6379
    networks:
      default:
        aliases:
        - redis
    restart: always
    command: redis-server --requirepass password

hi @Phil_DI welcome to the forum :handshake:

please take a look at this guide and work through the checklist

Nextcloud Collabora integration

The error
image
looks like you are trying to access some non-existing host/path/URL…

btw - if you are running systems behind reverse proxy you don’t need to expose container ports to the network:

using expose: ports connect only to the docker network and don’t connect with the host network making the system little more secure.

Hello @wwe! Thank you! :slight_smile:

Yeah, i checked your guide. I upload images to show you the results from your checklist.

btw - if you are running systems behind reverse proxy you don’t need to expose container ports to the network:
I need the exposed port, but my reverse proxy running on another vm in my hypervisor. And before the reverse proxy server, is a virtual firewall appliance :slight_smile:

so, it seems like the Nextcloud server can’t reach web services that are behind the reverse proxy. Everything that is in front of the reverse proxy, it can do. Any idea what that might be? This also explains why this collabora.domain.de does not get dissolved.


Hosting Discovery

<wopi-discovery>
    <net-zone name="external-http">

        <!-- Writer documents -->
        <app favIconUrl="https://collabora.phillipunzen.de/browser/91c166d/images/x-office-document.svg" name="writer">
            <action default="true" ext="sxw" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="odt" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="fodt" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Text template documents -->
            <action default="true" ext="stw" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="ott" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- MS Word -->
            <action default="true" ext="doc" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="dot" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- OOXML wordprocessing -->
            <action default="true" ext="docx" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="docm" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="dotx" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="dotm" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Others -->
            <action default="true" ext="wpd" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="pdb" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="hwp" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="wps" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="wri" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="lrf" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="mw" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="rtf" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="txt" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="fb2" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="cwk" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="pages" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="abw" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="602" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <app name="writer-global">
            <!-- Text master documents -->
            <action default="true" ext="sxg" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="odm" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Writer master document templates -->
            <action default="true" ext="otm" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <app name="writer-web">
            <action default="true" ext="oth" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Calc documents -->
        <app favIconUrl="https://collabora.phillipunzen.de/browser/91c166d/images/x-office-spreadsheet.svg" name="calc">
            <action default="true" ext="sxc" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="ods" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="fods" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Spreadsheet template documents -->
            <action default="true" ext="stc" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="ots" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- MS Excel -->
            <action default="true" ext="xls" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="xla" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- OOXML spreadsheet -->
            <action default="true" ext="xltx" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="xltm" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="xlsx" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="xlsb" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="xlsm" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Others -->
            <action default="true" ext="dif" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="slk" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="csv" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="dbf" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="wk1" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="gnumeric" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="numbers" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Impress documents -->
        <app favIconUrl="https://collabora.phillipunzen.de/browser/91c166d/images/x-office-presentation.svg" name="impress">
            <action default="true" ext="sxi" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="odp" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="fodp" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Presentation template documents -->
            <action default="true" ext="sti" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="otp" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- MS PowerPoint -->
            <action default="true" ext="ppt" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="pot" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- OOXML presentation -->
            <action default="true" ext="pptx" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="pptm" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="potx" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="potm" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="ppsx" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Others -->
            <action default="true" ext="cgm" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="key" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Draw documents -->
        <app name="draw">
            <action default="true" ext="sxd" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="odg" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="fodg" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Drawing template documents -->
            <action default="true" ext="std" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="otg" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <!-- Others -->
            <action ext="svg" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="dxf" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="emf" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="wmf" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="cdr" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="vsd" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="vsdx" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="vss" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="pub" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="p65" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="wpg" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action default="true" ext="fh" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action ext="bmp" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action ext="png" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action ext="gif" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action ext="tiff" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action ext="jpg" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action ext="jpeg" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
            <action ext="pdf" name="view_comment" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Math documents -->
        <!-- In fact Math documents are not supported at all.
             See: https://bugs.documentfoundation.org/show_bug.cgi?id=97006
        <app name="math">
            <action name="view" default="true" ext="sxm"/>
            <action name="edit" default="true" ext="odf"/>
        </app>
        -->

        <!-- Legacy MIME-type actions (compatibility) -->

        <app name="image/svg+xml">
            <action ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-powerpoint">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-excel">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Writer documents -->
        <app name="application/vnd.sun.xml.writer">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text-flat-xml">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Calc documents -->
        <app name="application/vnd.sun.xml.calc">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.spreadsheet">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.spreadsheet-flat-xml">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Impress documents -->
        <app name="application/vnd.sun.xml.impress">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.presentation">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.presentation-flat-xml">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Draw documents -->
        <app name="application/vnd.sun.xml.draw">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.graphics">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.graphics-flat-xml">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Chart documents -->
        <app name="application/vnd.oasis.opendocument.chart">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Text master documents -->
        <app name="application/vnd.sun.xml.writer.global">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text-master">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Math documents -->
        <!-- In fact Math documents are not supported at all.
             See: https://bugs.documentfoundation.org/show_bug.cgi?id=97006
        <app name="application/vnd.sun.xml.math">
            <action name="view" default="true" ext=""/>
        </app>
        <app name="application/vnd.oasis.opendocument.formula">
            <action name="edit" default="true" ext=""/>
        </app>
        -->
        <!-- Text template documents -->
        <app name="application/vnd.sun.xml.writer.template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text-template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Writer master document templates -->
        <app name="application/vnd.oasis.opendocument.text-master-template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Spreadsheet template documents -->
        <app name="application/vnd.sun.xml.calc.template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.spreadsheet-template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Presentation template documents -->
        <app name="application/vnd.sun.xml.impress.template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.presentation-template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Drawing template documents -->
        <app name="application/vnd.sun.xml.draw.template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.graphics-template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- MS Word -->
        <app name="application/msword">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/msword">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- MS Excel -->
        <app name="application/vnd.ms-excel">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- MS PowerPoint -->
        <app name="application/vnd.ms-powerpoint">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- OOXML wordprocessing -->
        <app name="application/vnd.openxmlformats-officedocument.wordprocessingml.document">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-word.document.macroEnabled.12">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.openxmlformats-officedocument.wordprocessingml.template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-word.template.macroEnabled.12">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- OOXML spreadsheet -->
        <app name="application/vnd.openxmlformats-officedocument.spreadsheetml.template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-excel.template.macroEnabled.12">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-excel.sheet.binary.macroEnabled.12">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-excel.sheet.macroEnabled.12">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- OOXML presentation -->
        <app name="application/vnd.openxmlformats-officedocument.presentationml.presentation">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-powerpoint.presentation.macroEnabled.12">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.openxmlformats-officedocument.presentationml.template">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-powerpoint.template.macroEnabled.12">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- Others -->
        <app name="application/vnd.wordperfect">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-aportisdoc">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-hwp">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-works">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-mswrite">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-dif-document">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="text/spreadsheet">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="text/csv">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-dbase">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.lotus-1-2-3">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/cgm">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/vnd.dxf">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/x-emf">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/x-wmf">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/coreldraw">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.visio2013">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.visio">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.ms-visio.drawing">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-mspublisher">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-sony-bbeb">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-gnumeric">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/macwriteii">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-iwork-numbers-sffnumbers">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text-web">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-pagemaker">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="text/rtf">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="text/plain">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-fictionbook+xml">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/clarisworks">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/x-wpg">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-iwork-pages-sffpages">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.openxmlformats-officedocument.presentationml.slideshow">
            <action default="true" ext="" name="edit" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-iwork-keynote-sffkey">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-abiword">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/x-freehand">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/vnd.sun.xml.chart">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/x-t602">
            <action default="true" ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/bmp">
            <action ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/png">
            <action ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/gif">
            <action ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/tiff">
            <action ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/jpg">
            <action ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="image/jpeg">
            <action ext="" name="view" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>
        <app name="application/pdf">
            <action ext="" name="view_comment" urlsrc="https://collabora.phillipunzen.de/browser/91c166d/cool.html?"/>
        </app>

        <!-- End of legacy MIME-type actions -->

        <app name="Capabilities">
            <action ext="" name="getinfo" urlsrc="https://collabora.phillipunzen.de/hosting/capabilities"/>
        </app>
    </net-zone>
<proof-key exponent="AQAB" modulus="xWHSWtfxD0+P/R+zIFUPeMAupAcZHeTo0taoV/LWkN1yE8OiQmcY9tCo8BHz3Ksrbe0MSRGwxMtLZl25LhG2OCsErsBHGIzXSK2/XZvdGMcr2N2Xam3PpFA/SdZ5io+zFpN8eQVPCV4Dm47UZ3av9nMKYFyuU4LoP69D2G+lJ/GH8tC6ddqEK95d5pd8sOyOrrx5f6MrgoONGt6gpzFSyumGCfRXkZpgvK71AJe/C7jx1tf9mPh8H2bVeOV4xGafVRyYVeY2M3knV1doSli+e/wLAoz8HV1FlBYW2pkJHjSc0v7Nb0V4XKisLFbF6p22Ke0QMIAlzNWZedL2o92gOw==" oldexponent="AQAB" oldmodulus="xWHSWtfxD0+P/R+zIFUPeMAupAcZHeTo0taoV/LWkN1yE8OiQmcY9tCo8BHz3Ksrbe0MSRGwxMtLZl25LhG2OCsErsBHGIzXSK2/XZvdGMcr2N2Xam3PpFA/SdZ5io+zFpN8eQVPCV4Dm47UZ3av9nMKYFyuU4LoP69D2G+lJ/GH8tC6ddqEK95d5pd8sOyOrrx5f6MrgoONGt6gpzFSyumGCfRXkZpgvK71AJe/C7jx1tf9mPh8H2bVeOV4xGafVRyYVeY2M3knV1doSli+e/wLAoz8HV1FlBYW2pkJHjSc0v7Nb0V4XKisLFbF6p22Ke0QMIAlzNWZedL2o92gOw==" oldvalue="BgIAAACkAABSU0ExAAgAAAEAAQA7oN2j9tJ5mdXMJYAwEO0ptp3qxVYsrKhceEVvzf7SnDQeCZnaFhaURV0d/IwCC/x7vlhKaFdXJ3kzNuZVmBxVn2bEeOV41WYffPiY/dfW8bgLv5cA9a68YJqRV/QJhunKUjGnoN4ajYOCK6N/ebyujuywfJfmXd4rhNp1utDyh/EnpW/YQ68/6IJTrlxgCnP2r3Zn1I6bA14JTwV5fJMWs4+KedZJP1Ckz21ql93YK8cY3Ztdv61I14wYR8CuBCs4thEuuV1mS8vEsBFJDO1tK6vc8xHwqND2GGdCosMTct2Q1vJXqNbS6OQdGQekLsB4D1Ugsx/9j08P8dda0mHF" value="BgIAAACkAABSU0ExAAgAAAEAAQA7oN2j9tJ5mdXMJYAwEO0ptp3qxVYsrKhceEVvzf7SnDQeCZnaFhaURV0d/IwCC/x7vlhKaFdXJ3kzNuZVmBxVn2bEeOV41WYffPiY/dfW8bgLv5cA9a68YJqRV/QJhunKUjGnoN4ajYOCK6N/ebyujuywfJfmXd4rhNp1utDyh/EnpW/YQ68/6IJTrlxgCnP2r3Zn1I6bA14JTwV5fJMWs4+KedZJP1Ckz21ql93YK8cY3Ztdv61I14wYR8CuBCs4thEuuV1mS8vEsBFJDO1tK6vc8xHwqND2GGdCosMTct2Q1vJXqNbS6OQdGQekLsB4D1Ugsx/9j08P8dda0mHF"/></wopi-discovery>

I edit the docker-compose.yml file. I uncomment the “no ssl line”. Because the Proxy generate a SSL-Certificate.

...
- "extra_params=--o:ssl.enable=false --o:ssl.termination=true"
...

I hope it helps?

try to understand the issue one step after another

  • does the DNS resolution works
  • if yes is plain TCP connection possible and not blocked by FW (e.g. telnet or nc)
  • if yes is https:// connection possible

your config with systems hosted on different VMs might be an issue. Double check your container can resolve the public DNS name of cloud.mydomain and office.mydomain either to public IP or public interface of your proxy (in case you are running local DNS server like PiHole or Adguard) - both containers must to talk to each other using public domain names.

1 Like

Yes, the containers can resolve the domain names. If i set a ping to this domain name, i get a response from the ip interface from the firewall. This is correct to here.

They nat from the firewall is not sending the packets to the reverse proxy.

Maybe I’m missing something but from you posted I see plain NC and CODE using http port - which is fine running behind reverse proxy. But in this config you can’t NAT https:// traffic from the firewall to the container. If I’m wrong please post more details regarding your setup.

found an old drawing regarding setup:

there is no firewall and NAT but you must NAT to the firewall and not to the container…

Okay, i added a second local dns server. And i set the IP for cloud.domain.de and office.domain.de to the IP from the reverse proxy.

Nextcloud can connect to the collabora Server. But i can’t documents now at this moment. It is the same error like yesterday.

please re-run all the checks and once successful, collect log files from all systems.

In my case, adding this in my nginx config solve the issue

   .... // others config

    # Add a location block to handle WebSocket connections
    location /push/ws {
        proxy_pass http://php-handler;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }

    location /cool {
        proxy_pass http://php-handler;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
1 Like

@ardinusawan welcome to the forum :handshake:

thank you for valuable update! would you mind to post full working Nginx config?

upstream php-handler {
   hash $request_uri consistent;
   server 127.0.0.1:11000;
   # server 127.0.0.1:9006;
   # server 127.0.0.1:9007;
}

server {
    listen 80;
    listen [::]:80;

    server_name cloud.ardinusawan.xyz;

    location / {
        proxy_pass http://php-handler;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header Host $host;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
        proxy_hide_header Upgrade;
        # proxy_redirect off;
        # proxy_buffering off;
        client_max_body_size 50G;
        client_body_timeout 300s;
        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/wasm 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;

        # The settings allow you to optimize the HTTP2 bandwidth.
        # See https://blog.cloudflare.com/delivering-http-2-upload-speed-improvements/
        # for tuning hints
        client_body_buffer_size 512k;

        # 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;
    }

    # Add a location block to handle WebSocket connections
    location /push/ws {
        proxy_pass http://php-handler;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }

    location /cool {
        proxy_pass http://php-handler;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
}
1 Like