Nextcloud Office with Collabora Online - Built-in CODE Server - Failed to load document

Hallo
since a few week I have installed Nextcloud on an Ubuntu 22.04 Server an it is running fine.
But there is a problem with Nextcloud Office - I cannot open the files.
I tried the informations from the manual but could not find al solution. I also could not find log file from Collabora

Nextcloud is running from source, not from docker app.

The Basics

  • Nextcloud Server version (e.g., 29.x.x):
    • Nextcloud Hub 9 (30.0.4)
  • Operating system and version (e.g., Ubuntu 24.04):
    • Ubuntu 22.04
  • Web server and version (e.g, Apache 2.4.25):
    • Apache/2.4.52
  • PHP version (e.g, 8.3):
    • PHP 8.3.15
  • Is this the first time you’ve seen this error? (Yes / No):
    • Yes
  • When did this problem seem to first start?
    • First use
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
    • what?
  • Are you using CloudfIare, mod_security, or similar? (Yes / No)
    • ne

Summary of the issue you are facing:

same like:

Steps to replicate it (hint: details matter!):

This application can connect to a Collabora Online (or other) server (WOPI-like Client). Nextcloud is the WOPI Host. Please read the documentation to learn more about that.

enabled app: Edit files with LibreOffice 
This adds a new context menu item to the Files dropdown menu "Edit with LibreOffice". Clicking that item will open the file in LibreOffice via WebDAV.

Administration Settings: Nextcloud Office: Collabora Online server is reachable.

1:
Loading New Document.odt … 

2:
Failed to load Nextcloud Office - please try again later
Collabora Online - Built-in CODE Server

### Log entries

#### Nextcloud
log is empty

tried:

Administration Settings: Administration: Office: Advanced settings: Allow list for WOPI requests: 0.0.0.0/0
Failed to load Nextcloud Office - Please try again later -- Solved! - #4 by VirtualCloud

other:

 # find / -type f -name "*collabora*"

/tmp/systemd-private-467d066669994fccbcb69f1dc7cd69c7-apache2.service-ADLIGO/tmp/appimage_extracted_222f666ea4483c90de90f83678c32940/collabora-online.desktop
/tmp/systemd-private-467d033369994fccbcb69f1dc7cd69c7-apache2.service-ADLIGO/tmp/appimage_extracted_284f453ea4483c90de90f83678c32940/collabora-online.svg
/var/www/html/nextcloud/dist/files_sharing-collaboration.js.map.license
/var/www/html/nextcloud/dist/files_sharing-collaboration.js
/var/www/html/nextcloud/dist/files_sharing-collaboration.js.map
/var/www/html/nextcloud/dist/files_sharing-collaboration.js.license
/var/www/html/nextcloud/core/doc/admin/_images/files_access_control_collaborative_tags.png

# systemctl status loolwsd
Unit loolwsd.service could not be found.

# find / -name "*.log" 2>/dev/null | grep loolwsd
nothing

found now in apache error log:

[core:notice] [pid 189435] AH00094: Command line: '/usr/sbin/apache2'
dlopen(): error loading libfuse.so.2

AppImages require FUSE to run. 
You might still be able to extract the contents of this AppImage 
if you run it with the --appimage-extract option. 
See https://github.com/AppImage/AppImageKit/wiki/FUSE 
for more information

Logging at warning level to file: /tmp/coolwsd.26FfpkqvNb/coolwsd.log
sh: 1: /tmp/appimage_extracted_284f453ea4483c90de90f83678c32940/usr/bin/coolmount: not found

install fuse

apt install fuse
systemctl restart apache2

also in error.log:

Fontconfig error: No writable cache directories

set: chown -R www-data:www-data /var/cache/fontconfig

But also in error.log:

Ready to accept connections on port 9983 (CODE Port)

Update 2

Found some new informations from webbrowser:

Content-Security-Policy: The page’s settings blocked the loading of a resource (connect-src) at mynext.de is available for purchase - Sedo.com because it violates the following directive: “connect-src ‘self’”
[WARN] viewer: Some mimes were ignored because they are not enabled in the server previews config
[WARN] @nextcloud/files: Accessing “Node.attributes.displayname” is deprecated, access it directly on the Node instance.
File info for /New Document.odt fetched
Object { filename: Getter & Setter, basename: Getter & Setter, lastmod: Getter & Setter, size: Getter & Setter, type: Getter & Setter, etag: Getter & Setter, mime: Getter & Setter, tags: Getter & Setter, getcontentlength: Getter & Setter, getcontenttype: Getter & Setter, … }
viewer-main.mjs:9:13187
Feature Policy: Skipping unsupported feature name “clipboard-read”. vue.runtime.esm.js:7399:11
Feature Policy: Skipping unsupported feature name “clipboard-write”. vue.runtime.esm.js:7399:11
Feature Policy: Skipping unsupported feature name “clipboard-read”. logger-Ba6Q6YnM.chunk.mjs:3:52782
Feature Policy: Skipping unsupported feature name “clipboard-write”. logger-Ba6Q6YnM.chunk.mjs:3:52782
Content-Security-Policy: The page’s settings blocked the loading of a resource (connect-src) at mynext.de is available for purchase - Sedo.com because it violates the following directive: “connect-src ‘self’” xhr.js:195:12
Uncaught (in promise)
Object { stack: “Y@mynext.de is available for purchase - Sedo.com</</h.onerror@mynext.de is available for purchase - Sedo.com”, message: “Network Error”, name: “AxiosError”, code: “ERR_NETWORK”, config: {…}, request: XMLHttpRequest }
.
recommendations
Array [ {…} ]
SharingInput.vue:303

tried:

nano /var/www/html/nextcloud/config/config.php  
'overwriteprotocol' => 'https',
systemctl restart apache2

Info

with overwriteprotocol the message is no longer shown:

Failed to load Nextcloud Office - please try again later
Collabora Online - Built-in CODE Server

But never endling loading… and still message in browser inspector:

Content-Security-Policy: The page’s settings blocked the loading of a resource (connect-src) at https://cloud.mecloud.de/apps/richdocumentscode/proxy.php?status because it violates the following directive: “connect-src ‘self’”

continue:

  'overwriteprotocol' => 'https',
  'overwritehost' => 'cloud.mecloud.de',
systemctl restart apache2

nothing changed

new apache error log:

Logging at warning level to file: /tmp/coolwsd.HMORUwYhiR/coolwsd.log
sh: 1: /tmp/.mount_Collab8QYqxo/usr/bin/coolmount: not found
Security: coolforkit incorrect user-name, other than 'cool'
Init vcl
preload: xsec_xmlsec xmlsecurity merged ucpchelp1 wpftwriter wpftcalc wpftimpress wpftdraw msforms cached1 vbaswobj swd sw ucppkg1 sm msword slideshow pdfimport sdui sd scriptframe protocolhandler dlgprov solver pricing date vbaobj scd sc ucpdav1 oox dbaxml pcr pdffilter ldapbe2 log embobj migrationoo2 sdd deploymentgui smd dbase animcore t602filter flash flat PresentationMinimizer invocation stocservices chartcore writerfilter io uuresolver bootstrap scn dba calc sdbt chartcontroller reflection cui dbpool2 scfilt introspection mysql_jdbc cairocanvas writer binaryurp LanguageTool bib storagefd namingservice emboleobj svgfilter graphicfilter ucpcmis1 analysis migrationoo3 invocadapt mozbootstrap hwp textconversiondlgs proxyfac
Disabled: cmdmail rptxml rptui rpt dbp dbu abp odbc sdbc2 
Preload textencodings
Allowlisted languages: de_DE el en_GB en_US es_ES fr_FR hu it nl pt_BR pt_PT ru 
Preloading local dictionaries: de-DE en-US fr-FR it-IT nl-NL pt-BR ru-RU en-GB nl-BE pt-PT es-ES 
Preloading local thesauri: de-DE en-US fr-FR it-IT pt-BR ru-RU en-GB pt-PT es-ES 
Preloading breakiterator
Preload icons
Preload short cut accelerators
Preload languages
Preload fonts
Preload config
Ready to accept connections on port 9983.

likely your systems can not reach each other in the right way please review Collabora integration guide

  • I’m wondering you show port 9983 many times… by default the port is 9983 I’m not even aware of the way to change the port - doing so might be unsupported for collabora-built-in
  • please explain how mynext.deis related to you system? is your domain or some kind of placeholder?

where does this text comes from… This is not the way how this integration is supposed to work. are you using this app: Edit files with LibreOffice - Apps - App Store - Nextcloud

1 Like