Collabora+nextcloud work locally but not from remote server

Hi guys

I have installed nextcloud and collabora online CODE on the same stretch perfect server and so far so good, I can edit my file from nextcloud with CODE.
Now I’ve installed a second nextcloud on an other server and can’t connect to my collabora on the first server
I assume it’s related to firewall or iptables settings, but I couldn’t find a safe answer by myself and online.

Here some more detail

on my stretch perfect server I have

  • cloud.mydomain.net where nextcloud is working like a charm

  • office.mydomain.net set up using collabora online debian package and with a reverse proxy so I can access to collabora here

  • for both domain I have set up an SSL certificate using let’s encrypt so I skip some part of the revers proxy tuto provided by collabora

in nextcloud’s settings, I have set that collabora URL is https://office.mydomain.net:443
At this stage I can edit my file from nextcloud with collabora - yay !

Now, I have an other server on which I set a vhost and domain and installed a second instance of nextcloud.
Nextcloud is working like a charm, and I have defined that collabora url is also https://office.mydomain.net:443, however when I try to edit a file from nextcloud, it tries to open the file, but end up saying tha it can’t to connect to collabora…

I assume the issue comes from my perfect server settings, especially firewall, but I can’t find how to be sure that any inbound and outbound request from a given domain or IP are accepted ?
And if so, what could prevent my stuff to work ?

Thank’s in advance for your guidances.

Hi jbonlinea,

doy you have a look at data/nextcloud.log (nextcloud loglevel=3) and / or collabora debug log (setting at /etc/loolwsd/loolwsd.xml) ?

Do you have expand your collabora online config for the second new nextcloud server (domain ENV string) … ? But i do not know if this work or you have to set a swarm (= cluster) to do this.

Regards,
Ralfi

Hi,

thank’s for your reply @ralfi

I’m a bit puzzled on rather trivial stuff

First I can’t find any log file /var/log/loolwsd.log despite the settings defined here /etc/loolwsd.loolwsd.xml and even if I change

<logging>
    <color type="bool">true</color>
    <level type="string" desc="Can be 0-8, or none (turns off logging), fatal, critical, error, warning, notice, information, debug, trace" default="warning">warning</level>
    <file enable="false">
        <property name="path" desc="Log file path.">/var/log/loolwsd.log</property>
        <property name="rotation" desc="Log file rotation strategy. See Poco FileChannel.">never</property>
        <property name="archive" desc="Append either timestamp or number to the archived log filename.">timestamp</property>
        <property name="compress" desc="Enable/disable log file compression.">true</property>
        <property name="purgeAge" desc="The maximum age of log files to preserve. See Poco FileChannel.">10 days</property>
        <property name="purgeCount" desc="The maximum number of log archives to preserve. Use 'none' to disable purging. See Poco FileChannel.">10</property>
        <property name="rotateOnOpen" desc="Enable/disable log file rotation on opening.">true</property>
        <property name="flush" desc="Enable/disable flushing after logging each line. May harm performance. Note that without flushing after each line, the log lines from the different processes will not ap$
    </file>
    <anonymize>
        <filenames type="bool" desc="Enable to anonymize/obfuscate filenames in logs. If default is true, it was forced at compile-time and cannot be disabled." default="false">false</filenames>
        <usernames type="bool" desc="Enable to anonymize/obfuscate usernames in logs. If default is true, it was forced at compile-time and cannot be disabled." default="false">false</usernames>
    </anonymize>
</logging>

Second,

  • my collabora is installed on a regular vps runing debian stretch perfect server a detailes here
  • I have used IPSConfig to create the ssl certificate for the domain office.mydomain.net ; and thus skipped the ssl part of the vhost settings for the reverse proxy
  • my collabora settings are out of the box
  • I can say that I haven’t expand my colabora config gor the second nextcloud server
  • I don’t know what do you precisely refer to with “domain ENV string” as I can’t find anything similar in /etc/loolwsd.loolwsd.xml

in collabora config file, /etc/loolwsd.loolwsd.xml, there is this section which seems to echoes what you refer to ?

<net desc="Network settings">
  <proto type="string" default="all" desc="Protocol to use IPv4, IPv6 or all for both">all</proto>
  <listen type="string" default="any" desc="Listen address that loolwsd binds to. Can be 'any' or 'loopback'.">any</listen>
  <service_root type="path" default="" desc="Prefix all the pages, websockets, etc. with this path."></service_root>
  <post_allow desc="Allow/deny client IP address for POST(REST)." allow="true">
    <host desc="The IPv4 private 192.168 block as plain IPv4 dotted decimal addresses.">192\.168\.[0-9]{1,3}\.[0-9]{1,3}</host>
    <host desc="Ditto, but as IPv4-mapped IPv6 addresses">::ffff:192\.168\.[0-9]{1,3}\.[0-9]{1,3}</host>
    <host desc="The IPv4 loopback (localhost) address.">127\.0\.0\.1</host>
    <host desc="Ditto, but as IPv4-mapped IPv6 address">::ffff:127\.0\.0\.1</host>
    <host desc="The IPv6 loopback (localhost) address.">::1</host>
  </post_allow>
  <frame_ancestors desc="Specify who is allowed to embed the LO Online iframe (loolwsd and WOPI host are always allowed). Separate multiple hosts by space."></frame_ancestors>
</net>

Again, I can use collabora from the nextcloud instance installed on the same server, but not from a nextcloud instance installed on a second new (and physically distant) server

Hi, I treid to edit the above message but It do not work.

unauthorised WOPI-Host

that seems like a important clue

when i share a file with a link from my new nextcloud server and follow it without being logged in, I get this message.

after some smail search it seems it might come from CODE config in /etc/loolwsd.loolwsd.xml, or from my apache config

so here they are :

lool config

<config>
 <!--
 Note: 'default' attributes are used to document a setting's default value as well as to use as fallback. 
-->
 <!--
 Note: When adding a new entry, a default must be set in WSD in case the entry is missing upon deployment. 
-->
<allowed_languages desc="List of supported languages of Writing Aids (spell checker, grammar checker, thesaurus, hyphenation) on this instance. Allowing too many has negative effect on startup performance." default="de_DE en_GB en_US es_ES fr_FR it nl pt_BR pt_PT ru">de_DE en_GB en_US es_ES fr_FR it nl pt_BR pt_PT ru</allowed_languages>
<tile_cache_path desc="Path to a directory where to keep the tile cache." type="path" relative="false" default="/var/cache/loolwsd"/>
<sys_template_path desc="Path to a template tree with shared libraries etc to be used as source for chroot jails for child processes." type="path" relative="true" default="systemplate"/>
<lo_template_path desc="Path to a LibreOffice installation tree to be copied (linked) into the jails for child processes. Should be on the same file system as systemplate." type="path" relative="false" default="/opt/collaboraoffice6.0"/>
<child_root_path desc="Path to the directory under which the chroot jails for the child processes will be created. Should be on the same file system as systemplate and lotemplate. Must be an empty directory." type="path" relative="true" default="jails"/>
<server_name desc="Hostname:port of the server running loolwsd. If empty, it's derived from the request." type="string" default=""/>
<file_server_root_path desc="Path to the directory that should be considered root for the file server. This should be the directory containing loleaflet." type="path" relative="true" default="loleaflet/../"/>
<memproportion desc="The maximum percentage of system memory consumed by all of the LibreOffice Online, after which we start cleaning up idle documents" type="double" default="80.0"/>
<num_prespawn_children desc="Number of child processes to keep started in advance and waiting for new clients." type="uint" default="1">1</num_prespawn_children>
<per_document desc="Document-specific settings, including LO Core settings.">
<max_concurrency desc="The maximum number of threads to use while processing a document." type="uint" default="4">4</max_concurrency>
<document_signing_url desc="The endpoint URL of signing server, if empty the document signing is disabled" type="string" default="https://app.vereign.com">https://app.vereign.com</document_signing_url>
<redlining_as_comments desc="If true show red-lines as comments" type="bool" default="true">true</redlining_as_comments>
<idle_timeout_secs desc="The maximum number of seconds before unloading an idle document. Defaults to 1 hour." type="uint" default="3600">3600</idle_timeout_secs>
 <!--
 Idle save and auto save are checked every 30 seconds 
-->
<idlesave_duration_secs desc="The number of idle seconds after which document, if modified, should be saved. Defaults to 30 seconds." type="uint" default="30">30</idlesave_duration_secs>
<autosave_duration_secs desc="The number of seconds after which document, if modified, should be saved. Defaults to 5 minutes." type="uint" default="300">300</autosave_duration_secs>
<limit_virt_mem_kb desc="The maximum virtual memory allowed to each document process. 0 for unlimited, 1700 min." type="uint">0</limit_virt_mem_kb>
<limit_data_mem_kb desc="The maximum memory data segment allowed to each document process. 0 for unlimited." type="uint">0</limit_data_mem_kb>
<limit_stack_mem_kb desc="The maximum stack size allowed to each document process. 0 for unlimited." type="uint">8000</limit_stack_mem_kb>
<limit_file_size_mb desc="The maximum file size allowed to each document process to write. 0 for unlimited." type="uint">0</limit_file_size_mb>
<limit_num_open_files desc="The maximum number of files allowed to each document process to open. 0 for unlimited." type="uint">0</limit_num_open_files>
<limit_load_secs desc="Maximum number of seconds to wait for a document load to succeed. 0 for unlimited." type="uint" default="100">100</limit_load_secs>
</per_document>
<per_view desc="View-specific settings.">
<out_of_focus_timeout_secs desc="The maximum number of seconds before dimming and stopping updates when the browser tab is no longer in focus. Defaults to 60 seconds." type="uint" default="60">60</out_of_focus_timeout_secs>
<idle_timeout_secs desc="The maximum number of seconds before dimming and stopping updates when the user is no longer active (even if the browser is in focus). Defaults to 15 minutes." type="uint" default="900">900</idle_timeout_secs>
</per_view>
<loleaflet_html desc="Allows UI customization by replacing the single endpoint of loleaflet.html" type="string" default="loleaflet.html">loleaflet.html</loleaflet_html>
<logging>
<color type="bool">true</color>
<level type="string" desc="Can be 0-8, or none (turns off logging), fatal, critical, error, warning, notice, information, debug, trace" default="warning">warning</level>
<file enable="true">
<property name="path" desc="Log file path.">/var/log/loolwsd.log</property>
<property name="rotation" desc="Log file rotation strategy. See Poco FileChannel.">never</property>
<property name="archive" desc="Append either timestamp or number to the archived log filename.">timestamp</property>
<property name="compress" desc="Enable/disable log file compression.">true</property>
<property name="purgeAge" desc="The maximum age of log files to preserve. See Poco FileChannel.">10 days</property>
<property name="purgeCount" desc="The maximum number of log archives to preserve. Use 'none' to disable purging. See Poco FileChannel.">10</property>
<property name="rotateOnOpen" desc="Enable/disable log file rotation on opening.">true</property>
<property name="flush" desc="Enable/disable flushing after logging each line. May harm performance. Note that without flushing after each line, the log lines from the different processes will not appear in chronological order.">false</property>
</file>
<anonymize>
<filenames type="bool" desc="Enable to anonymize/obfuscate filenames in logs. If default is true, it was forced at compile-time and cannot be disabled." default="false">false</filenames>
<usernames type="bool" desc="Enable to anonymize/obfuscate usernames in logs. If default is true, it was forced at compile-time and cannot be disabled." default="false">false</usernames>
</anonymize>
</logging>
<loleaflet_logging desc="Logging in the browser console" default="false">false</loleaflet_logging>
<trace desc="Dump commands and notifications for replay. When 'snapshot' is true, the source file is copied to the path first." enable="false">
<path desc="Output path to hold trace file and docs. Use '%' for timestamp to avoid overwriting. For example: /some/path/to/looltrace-%.gz" compress="true" snapshot="false"/>
<filter>
<message desc="Regex pattern of messages to exclude"/>
</filter>
<outgoing>
<record desc="Whether or not to record outgoing messages" default="false">false</record>
</outgoing>
</trace>
<net desc="Network settings">
<proto type="string" default="all" desc="Protocol to use IPv4, IPv6 or all for both">all</proto>
<listen type="string" default="any" desc="Listen address that loolwsd binds to. Can be 'any' or 'loopback'.">any</listen>
<service_root type="path" default="" desc="Prefix all the pages, websockets, etc. with this path."/>
<post_allow desc="Allow/deny client IP address for POST(REST)." allow="true">
<host desc="The IPv4 private 192.168 block as plain IPv4 dotted decimal addresses.">192\.168\.[0-9]{1,3}\.[0-9]{1,3}</host>
<host desc="Ditto, but as IPv4-mapped IPv6 addresses">::ffff:192\.168\.[0-9]{1,3}\.[0-9]{1,3}</host>
<host desc="The IPv4 loopback (localhost) address.">127\.0\.0\.1</host>
<host desc="Ditto, but as IPv4-mapped IPv6 address">::ffff:127\.0\.0\.1</host>
<host desc="The IPv6 loopback (localhost) address.">::1</host>
<host desc="The IPv4 private 192.168 block as plain IPv4 dotted decimal addresses.">128.65.195.154</host>
</post_allow>
<frame_ancestors desc="Specify who is allowed to embed the LO Online iframe (loolwsd and WOPI host are always allowed). Separate multiple hosts by space."/>
</net>

<ssl desc="SSL settings">
<enable type="bool" desc="Controls whether SSL encryption is enable (do not disable for production deployment). If default is false, must first be compiled with SSL support to enable." default="true">true</enable>
<termination desc="Connection via proxy where loolwsd acts as working via https, but actually uses http." type="bool" default="true">false</termination>
<cert_file_path desc="Path to the cert file" relative="false">/etc/loolwsd/cert.pem</cert_file_path>
<key_file_path desc="Path to the key file" relative="false">/etc/loolwsd/key.pem</key_file_path>
<ca_file_path desc="Path to the ca file" relative="false">/etc/loolwsd/ca-chain.cert.pem</ca_file_path>
<cipher_list desc="List of OpenSSL ciphers to accept" default="ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH"/>
<hpkp desc="Enable HTTP Public key pinning" enable="false" report_only="false">
<max_age desc="HPKP's max-age directive - time in seconds browser should remember the pins" enable="true">1000</max_age>
<report_uri desc="HPKP's report-uri directive - pin validation failure are reported at this URL" enable="false"/>
<pins desc="Base64 encoded SPKI fingerprints of keys to be pinned">
<pin/>
</pins>
</hpkp>
</ssl>
<security desc="Altering these defaults potentially opens you to significant risk">
<seccomp desc="Should we use the seccomp system call filtering." type="bool" default="true">true</seccomp>
<capabilities desc="Should we require capabilities to isolate processes into chroot jails" type="bool" default="true">true</capabilities>
</security>
<storage desc="Backend storage">
<filesystem allow="false"/>
<wopi desc="Allow/deny wopi storage. Mutually exclusive with webdav." allow="true">
<host desc="Regex pattern of hostname to allow or deny." allow="true">localhost</host>
<host desc="Regex pattern of hostname to allow or deny." allow="true">10\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}</host>
<host desc="Regex pattern of hostname to allow or deny." allow="true">172\.1[6789]\.[0-9]{1,3}\.[0-9]{1,3}</host>
<host desc="Regex pattern of hostname to allow or deny." allow="true">172\.2[0-9]\.[0-9]{1,3}\.[0-9]{1,3}</host>
<host desc="Regex pattern of hostname to allow or deny." allow="true">172\.3[01]\.[0-9]{1,3}\.[0-9]{1,3}</host>
<host desc="Regex pattern of hostname to allow or deny." allow="true">192\.168\.[0-9]{1,3}\.[0-9]{1,3}</host>
<host desc="Regex pattern of hostname to allow or deny." allow="false">192\.168\.1\.1</host>
<max_file_size desc="Maximum document size in bytes to load. 0 for unlimited." type="uint">0</max_file_size>
</wopi>
<webdav desc="Allow/deny webdav storage. Mutually exclusive with wopi." allow="false">
<host desc="Hostname to allow" allow="false">localhost</host>
</webdav>
</storage>
<tile_cache_persistent desc="Should the tiles persist between two editing sessions of the given document?" type="bool" default="true">true</tile_cache_persistent>
<admin_console desc="Web admin console settings.">
<enable desc="Enable the admin console functionality" type="bool" default="true">true</enable>
<enable_pam desc="Enable admin user authentication with PAM" type="bool" default="false">false</enable_pam>
<username desc="The username of the admin console. Ignored if PAM is enabled.">Quagga</username>
<password desc="The password of the admin console. Deprecated on most platforms. Instead, use PAM or loolconfig to set up a secure password.">Qua66a.Ass0</password>
</admin_console>
<monitors desc="Addresses of servers we connect to on start for monitoring"> </monitors>
</config> 

apache config, again I got my ssl certificate from ISPConfig pannel

 Options -Indexes

  # Encoded slashes need to be allowed
  AllowEncodedSlashes NoDecode

  # keep the host
  ProxyPreserveHost On

  # static html, js, images, etc. served from loolwsd
  # loleaflet is the client part of Collabora Online
  ProxyPass           /loleaflet http://127.0.0.1:9980/loleaflet retry=0
  ProxyPassReverse    /loleaflet http://127.0.0.1:9980/loleaflet

  # WOPI discovery URL
  ProxyPass           /hosting/discovery http://127.0.0.1:9980/hosting/discovery retry=0
  ProxyPassReverse    /hosting/discovery http://127.0.0.1:9980/hosting/discovery

  # Capabilities
  ProxyPass           /hosting/capabilities http://127.0.0.1:9980/hosting/capabilities retry=0
  ProxyPassReverse    /hosting/capabilities http://127.0.0.1:9980/hosting/capabilities

  # Main websocket
  ProxyPassMatch "/lool/(.*)/ws$" ws://127.0.0.1:9980/lool/$1/ws nocanon

  # Admin Console websocket
  ProxyPass   /lool/adminws ws://127.0.0.1:9980/lool/adminws

  # Download as, Fullscreen presentation and Image upload operations
  ProxyPass           /lool http://127.0.0.1:9980/lool
  ProxyPassReverse    /lool http://127.0.0.1:9980/lool

and finally

Also this url https://office.mydomain.net/hosting/discovery

returns

<!-- Writer documents -->
    <app name="application/vnd.sun.xml.writer">
        <action ext="sxw" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.oasis.opendocument.text">
        <action ext="odt" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.oasis.opendocument.text-flat-xml">
        <action ext="fodt" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Calc documents -->
    <app name="application/vnd.sun.xml.calc">
        <action ext="sxc" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.oasis.opendocument.spreadsheet">
        <action ext="ods" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.oasis.opendocument.spreadsheet-flat-xml">
        <action ext="fods" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Impress documents -->
    <app name="application/vnd.sun.xml.impress">
        <action ext="sxi" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.oasis.opendocument.presentation">
        <action ext="odp" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.oasis.opendocument.presentation-flat-xml">
        <action ext="fodp" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Draw documents -->
    <app name="application/vnd.sun.xml.draw">
        <action ext="sxd" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.oasis.opendocument.graphics">
        <action ext="odg" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.oasis.opendocument.graphics-flat-xml">
        <action ext="fodg" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Chart documents -->
    <app name="application/vnd.oasis.opendocument.chart">
        <action ext="odc" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Text master documents -->
    <app name="application/vnd.sun.xml.writer.global">
        <action ext="sxg" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.oasis.opendocument.text-master">
        <action ext="odm" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.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" ext="sxm"/>
    </app>
<app name="application/vnd.oasis.opendocument.formula">
        <action name="edit" ext="odf"/>
    </app>
-->
<!-- Text template documents -->
<app name="application/vnd.sun.xml.writer.template">
        <action ext="stw" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.oasis.opendocument.text-template">
        <action ext="ott" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Writer master document templates -->
<app name="application/vnd.oasis.opendocument.text-master-template">
        <action ext="otm" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Spreadsheet template documents -->
<app name="application/vnd.sun.xml.calc.template">
        <action ext="stc" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.oasis.opendocument.spreadsheet-template">
        <action ext="ots" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Presentation template documents -->
<app name="application/vnd.sun.xml.impress.template">
        <action ext="sti" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.oasis.opendocument.presentation-template">
        <action ext="otp" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Drawing template documents -->
<app name="application/vnd.sun.xml.draw.template">
        <action ext="std" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.oasis.opendocument.graphics-template">
        <action ext="otg" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Base documents -->
<app name="application/vnd.oasis.opendocument.database">
        <action ext="odb" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Extensions -->
<app name="application/vnd.openofficeorg.extension">
        <action ext="oxt" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

    <!-- MS Word -->
    <app name="application/msword">
        <action ext="doc" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/msword">
        <action ext="dot" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

    <!-- MS Excel -->
    <app name="application/vnd.ms-excel">
        <action ext="xls" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

    <!-- MS PowerPoint -->
    <app name="application/vnd.ms-powerpoint">
        <action ext="ppt" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- OOXML wordprocessing -->
<app name="application/vnd.openxmlformats-officedocument.wordprocessingml.document">
        <action ext="docx" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.ms-word.document.macroEnabled.12">
        <action ext="docm" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.openxmlformats-officedocument.wordprocessingml.template">
        <action ext="dotx" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.ms-word.template.macroEnabled.12">
        <action ext="dotm" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- OOXML spreadsheet -->
<app name="application/vnd.openxmlformats-officedocument.spreadsheetml.template">
        <action ext="xltx" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.ms-excel.template.macroEnabled.12">
        <action ext="xltm" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">
        <action ext="xlsx" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.ms-excel.sheet.binary.macroEnabled.12">
        <action ext="xlsb" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.ms-excel.sheet.macroEnabled.12">
        <action ext="xlsm" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- OOXML presentation -->
<app name="application/vnd.openxmlformats-officedocument.presentationml.presentation">
        <action ext="pptx" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.ms-powerpoint.presentation.macroEnabled.12">
        <action ext="pptm" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.openxmlformats-officedocument.presentationml.template">
        <action ext="potx" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.ms-powerpoint.template.macroEnabled.12">
        <action ext="potm" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

<!-- Others -->
<app name="application/vnd.wordperfect">
        <action ext="wpd" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/x-aportisdoc">
        <action ext="pdb" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/x-hwp">
        <action ext="hwp" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.ms-works">
        <action ext="wps" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/x-mswrite">
        <action ext="wri" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/x-dif-document">
        <action ext="dif" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="text/spreadsheet">
        <action ext="slk" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="text/csv">
        <action ext="csv" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/x-dbase">
        <action ext="dbf" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.lotus-1-2-3">
        <action ext="wk1" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="image/cgm">
        <action ext="cgm" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="image/vnd.dxf">
        <action ext="dxf" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="image/x-emf">
        <action ext="emf" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="image/x-wmf">
        <action ext="wmf" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/coreldraw">
        <action ext="cdr" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.visio2013">
        <action ext="vsd" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/vnd.visio">
        <action ext="vss" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
<app name="application/x-mspublisher">
        <action ext="pub" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-sony-bbeb">
        <action ext="lrf" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-gnumeric">
        <action ext="gnumeric" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/macwriteii">
        <action ext="mw" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-iwork-numbers-sffnumbers">
        <action ext="numbers" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.oasis.opendocument.text-web">
        <action ext="oth" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-pagemaker">
        <action ext="p65" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/rtf">
        <action ext="rtf" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="text/rtf">
        <action ext="rtf" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="text/plain">
        <action ext="txt" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-fictionbook+xml">
        <action ext="fb2" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/clarisworks">
        <action ext="cwk" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.corel-draw">
        <action ext="cdr" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="image/x-wpg">
        <action ext="wpg" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/prs.plucker">
        <action ext="pdb" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-iwork-pages-sffpages">
        <action ext="pages" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.openxmlformats-officedocument.presentationml.slideshow">
        <action ext="ppsx" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-iwork-keynote-sffkey">
        <action ext="key" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-abiword">
        <action ext="abw" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="image/x-freehand">
        <action ext="fh" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.palm">
        <action ext="pdb" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.sun.xml.chart">
        <action ext="sxs" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.sun.xml.writer.web">
        <action ext="stw" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/x-t602">
        <action ext="602" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/vnd.sun.xml.report.chart">
        <action ext="odc" name="edit" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="image/bmp">
        <action ext="bmp" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="image/png">
        <action ext="png" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="image/gif">
        <action ext="gif" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="image/tiff">
        <action ext="tiff" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="image/jpg">
        <action ext="jpg" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="image/jpeg">
        <action ext="jpeg" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>
    <app name="application/pdf">
        <action ext="pdf" name="view" urlsrc="https://office.mydomain.net/loleaflet/305832f/loleaflet.html?"/>
    </app>

    <app name="Capabilities">
        <action ext="" name="getinfo" urlsrc="https://office.mydomain.net/hosting/capabilities"/>
    </app>
</net-zone>

put simply

I would like to use my collabora installed on office.mydomain.net from both

Hi jbonlinea,

first of all you should modify in the loolwsd.xml logging section file enable=true and logging level to debug. To store this after container modifications you must set a custom volume to /etc/loolwsd/ or to the file /etc/loolwsd/loolwsd.xml. And do not forget o set the log level for your second nextcloud server to 3, as you ca see in the docs.

Your …/hosting/discovery looks very well but your second server can not connect because the network and wopi config section of the lool server contains only values for internal servers with IPs like 10.x, 192.x, 172.x and like this. If you have a proper logfile setting for lool AND / OR your nextcloud container or server you will find the appr. error messages.

But again, i dont know if this works because my lool docker container image starts with the ENV variable domain=“my.\nextcloud.\fqdn.\tld” and IMHO for enabling a second nextcloud domain this should be set also for the second domain. Try it…

Regards, Ralfi

Hi @ralfi and thnak’s for your reply

I thinks I understood what you said, but still don’t know how to implement it all.

  • in the second nextcloud > webui > admin panel > log > every levels are checked, and I can’t see any relevant message. The default log level is 2, and it seems broader than 3, but I don not have any relevent message neither

  • on my collabora server, I edited my lolwsd.xml logging section as above, but still have no log file /var/log/loolwsd.log
    I installed collabora from the debian package, not on a docker container, so I’m not sure how should i understand the second part of your reply. What do you mean by set a custom volume, and do it make any sense when collabora is installed from a debian package ?

Ok, could you please paste here an extract of your lool setting so I can copy-paste it with the proper syntax (and replacing with my server-name / domain-name / ips) of course

:slight_smile:
Thank’s
all best

Ok it was a fight but I’ve found !!!

I just had to add this line in the wopi settings

<host desc="Regex pattern of hostname to allow or deny." n.netallow="true">myOtherDomain.net</host>

where myOtherDomain.net is where my second nextclous installation is !

the whole storage / wopi settings lookslike this

    <storage desc="Backend storage">
    <filesystem allow="false" />
    <wopi desc="Allow/deny wopi storage. Mutually exclusive with webdav." allow="true">
        <host desc="Regex pattern of hostname to allow or deny." allow="true">myOtherDomain.net</host>
        <host desc="Regex pattern of hostname to allow or deny." allow="true">localhost</host>
        <host desc="Regex pattern of hostname to allow or deny." allow="true">10\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}</host>
        <host desc="Regex pattern of hostname to allow or deny." allow="true">172\.1[6789]\.[0-9]{1,3}\.[0-9]{1,3}</host>
        <host desc="Regex pattern of hostname to allow or deny." allow="true">172\.2[0-9]\.[0-9]{1,3}\.[0-9]{1,3}</host>
        <host desc="Regex pattern of hostname to allow or deny." allow="true">172\.3[01]\.[0-9]{1,3}\.[0-9]{1,3}</host>
        <host desc="Regex pattern of hostname to allow or deny." allow="true">192\.168\.[0-9]{1,3}\.[0-9]{1,3}</host>
        <host desc="Regex pattern of hostname to allow or deny." allow="false">192\.168\.1\.1</host>
       <max_file_size desc="Maximum document size in bytes to load. 0 for unlimited." type="uint">0</max_file_size>
    </wopi>
    <webdav desc="Allow/deny webdav storage. Mutually exclusive with wopi." allow="false">
        <host desc="Hostname to allow" allow="false">localhost</host>
    </webdav>
</storage>

Yeah, as is said …
No sooner do you do it - than it already works!

Regards, Ralfi