Steps to reproduce
- Navigate to a .ods file
- Click on the file
Collabora opens in a iframe, howing a spinner and "connecting"
Expected result:
-> The document is loaded for editing
Actual result:
-> Nothing, the spinner keeps spinning above the text "connecting" (it still is, so no timeout/error message is shown)
The last modified date of the file is April 26, and I'm fairly certain I edited it through Collabora that time, or at least not much longer ago.
Some time after updating NC to 12 this week I noticed it didn't work anymore.
I only updated the docker image (and my apache config) after I already noticed editing being broken, that didn't help.
Server configuration
Operating system: Linux tubul.net 4.9.0-2-amd64 #1 SMP Debian 4.9.18-1 (2017-03-30) x86_64
Web server: Apache (apache2handler)
Database: pgsql PostgreSQL 9.4.11 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit
PHP version: 7.0.18-1~dotdeb+8.1
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, standard, apache2handler, igbinary, msgpack, PDO, xml, apcu, bz2, calendar, ctype, curl, dom, enchant, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, imagick, imap, interbase, intl, json, ldap, exif, mcrypt, memcached, PDO_Firebird, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, readline, recode, redis, shmop, SimpleXML, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, Zend OPcache
Nextcloud version: 12.0 beta 2 - 12.0.0.18
Updated from 12 beta 1 to beta 2 (And 11 before that)
Where did you install Nextcloud from: Beta channel, through the updater
Signing status: No errors have been found.
App list
Enabled:
- activity: 2.5.2
- admin_audit: 1.2.0
- calendar: 1.5.2
- contacts: 1.5.3
- dav: 1.3.0
- federatedfilesharing: 1.2.0
- federation: 1.2.0
- files: 1.7.2
- files_external: 1.3.0
- files_markdown: 1.0.1
- files_pdfviewer: 1.1.1
- files_sharing: 1.4.0
- files_texteditor: 2.4.1
- files_trashbin: 1.2.0
- files_versions: 1.5.0
- files_videoplayer: 1.1.0
- firstrunwizard: 2.1
- issuetemplate: 0.2.1
- logreader: 2.0.0
- lookup_server_connector: 1.0.0
- news: 11.0.0
- nextcloud_announcements: 1.1
- notifications: 2.0.0
- provisioning_api: 1.2.0
- richdocuments: 1.1.26
- serverinfo: 1.2.0
- sharebymail: 1.2.0
- socialsharing_email: 1.0.1
- survey_client: 1.0.0
- tasks: 0.9.5
- theming: 1.3.0
- twofactor_backupcodes: 1.1.0
- twofactor_totp: 1.3.0
- updatenotification: 1.2.0
- workflowengine: 1.2.0
Disabled:
- apporder
- bookmarks
- comments
- deck
- encryption
- gallery
- mail
- password_policy
- spreed
- systemtags
- user_external
- user_ldap
config.php
{
"instanceid": "ocaed749a93a",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"datadirectory": "\/var\/www\/nextcloud\/data",
"dbtype": "pgsql",
"version": "12.0.0.18",
"installed": true,
"forcessl": true,
"loglevel": 2,
"theme": "",
"maintenance": false,
"defaultapp": "news",
"enable_previews": true,
"preview_libreoffice_path": "\/usr\/bin\/libreoffice",
"enabledPreviewProviders": [
"OC\\Preview\\PNG",
"OC\\Preview\\JPEG",
"OC\\Preview\\GIF",
"OC\\Preview\\BMP",
"OC\\Preview\\XBitmap",
"OC\\Preview\\MP3",
"OC\\Preview\\TXT",
"OC\\Preview\\MarkDown",
"OC\\Preview\\Illustrator",
"OC\\Preview\\Movie",
"OC\\Preview\\MSOffice2003",
"OC\\Preview\\MSOffice2007",
"OC\\Preview\\MSOfficeDoc",
"OC\\Preview\\OpenDocument",
"OC\\Preview\\PDF",
"OC\\Preview\\Photoshop",
"OC\\Preview\\Postscript",
"OC\\Preview\\StarOffice",
"OC\\Preview\\SVG",
"OC\\Preview\\TIFF",
"OC\\Preview\\Font"
],
"trusted_domains": [
"fnp.tubul.net",
"public.tubul.net",
"tubul.net",
"webmail.tubul.net",
"cloud.tubul.net"
],
"dbname": "owncloud",
"dbhost": "localhost",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"forceSSLforSubdomains": true,
"mail_from_address": "nextcloud",
"mail_smtpmode": "php",
"mail_domain": "tubul.net",
"updatechecker": true,
"updater.server.url": "https:\/\/updates.nextcloud.com\/updater_server\/",
"updater.release.channel": "beta",
"apps_paths": [
{
"path": "\/var\/www\/nextcloud\/public\/apps",
"url": "\/apps",
"writable": true
}
],
"appstoreenabled": true,
"appcodechecker": false,
"appstore.experimental.enabled": true,
"appstoreurl": "https:\/\/apps.nextcloud.com\/api\/v0",
"memcache.local": "\\OC\\Memcache\\APCu",
"trashbin_retention_obligation": "auto",
"asset-pipeline.enabled": true,
"overwrite.cli.url": "https:\/\/fnp.tubul.net",
"htaccess.RewriteBase": "\/",
"updater.secret": "***REMOVED SENSITIVE VALUE***"
}
External storage/encryption/an external user-backend: no, no, no
Client configuration
Browser: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36
Operating system:
Devuan:
# uname -a
Linux tubul.net 4.9.0-2-amd64 #1 SMP Debian 4.9.18-1 (2017-03-30) x86_64 GNU/Linux
Apache config
nextcloud.conf
<VirtualHost *:443>
ServerName fnp.tubul.net
ServerAlias cloud.tubul.net
ServerAlias public.tubul.net
ServerAdmin [email protected]
AssignUserID www-nextcloud www-nextcloud
SSLEngine On
DocumentRoot /var/www/nextcloud/public
<Directory /var/www/nextcloud/public>
Options -Indexes +FollowSymLinks -MultiViews
AllowOverride All
Require all granted
SetEnv HOME /var/www/nextcloud
SetEnv HTTP_HOME /var/www/nextcloud/public
</Directory>
<IfModule mod_dav.c>
Dav off
</IfModule>
ErrorLog ${APACHE_LOG_DIR}/nextcloud/error.log
CustomLog ${APACHE_LOG_DIR}/nextcloud/access.log combined
</VirtualHost>
collabora.conf
<VirtualHost *:443>
ServerName collabora.tubul.net
# Encoded slashes need to be allowed (added NoDecode in an attempt to fix this issue, didn't help)
AllowEncodedSlashes NoDecode
AssignUserID www-nextcloud www-nextcloud
# Container uses a unique non-signed certificate
SSLProxyEngine On
SSLProxyVerify None
SSLProxyCheckPeerCN Off
SSLProxyCheckPeerName Off
# keep the host
ProxyPreserveHost On
# static html, js, images, etc. served from loolwsd
# loleaflet is the client part of LibreOffice Online
ProxyPass /loleaflet https://127.0.0.1:9980/loleaflet retry=0
ProxyPassReverse /loleaflet https://127.0.0.1:9980/loleaflet
# WOPI discovery URL
ProxyPass /hosting/discovery https://127.0.0.1:9980/hosting/discovery retry=0
ProxyPassReverse /hosting/discovery https://127.0.0.1:9980/hosting/discovery
# Main websocket (added nocanon in an attempt to fix this issue, didn't help)
ProxyPassMatch "/lool/(.*)/ws$" wss://127.0.0.1:9980/lool/$1/ws nocanon
# Admin Console websocket
ProxyPass /lool/adminws wss://127.0.0.1:9980/lool/adminws
# Download as, Fullscreen presentation and Image upload operations
ProxyPass /lool https://127.0.0.1:9980/lool
ProxyPassReverse /lool https://127.0.0.1:9980/lool
Header set X-Frame-Options "ALLOW_FROM https://fnp.tubul.net"
Header unset Content-Security-Policy
</VirtualHost>
Logs
nextcloud.log
{"reqId":"XXjpd1oxhk70WcayBC6K","level":3,"time":"2017-05-10T20:57:25+00:00","remoteAddr":"212.92.123.232","user":"richard","app":"PHP","method":"GET","url":"\/core\/preview.png?file=%2FDocuments%2Fspreadsheets%2FMaximedia%2Foveruren.ods&c=14fdb702e2210198973a33febae052b4&x=36&y=36&forceIcon=0","message":"unlink(\/tmp\/oc_tmp_RWRPoi-.pdf): No such file or directory at \/var\/www\/nextcloud\/public\/lib\/private\/Preview\/Office.php#61","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/57.0.2987.98 Safari\/537.36","version":"12.0.0.18"}
{"reqId":"XXjpd1oxhk70WcayBC6K","level":3,"time":"2017-05-10T20:57:25+00:00","remoteAddr":"212.92.123.232","user":"richard","app":"core","method":"GET","url":"\/core\/preview.png?file=%2FDocuments%2Fspreadsheets%2FMaximedia%2Foveruren.ods&c=14fdb702e2210198973a33febae052b4&x=36&y=36&forceIcon=0","message":"unable to open image `\/tmp\/oc_tmp_RWRPoi-.pdf': No such file or directory @ error\/blob.c\/OpenBlob\/2712","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/57.0.2987.98 Safari\/537.36","version":"12.0.0.18"}
{"reqId":"wp0iqqUkZa9wUQrPxsz3","level":3,"time":"2017-05-10T20:57:25+00:00","remoteAddr":"212.92.123.232","user":"richard","app":"PHP","method":"GET","url":"\/core\/preview.png?file=%2FDocuments%2Fspreadsheets%2FMaximedia%2Fvrije+dagen.ods&c=60aa67f65737726b9d9b2726968bbb07&x=36&y=36&forceIcon=0","message":"unlink(\/tmp\/oc_tmp_pRKqkE-.pdf): No such file or directory at \/var\/www\/nextcloud\/public\/lib\/private\/Preview\/Office.php#61","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/57.0.2987.98 Safari\/537.36","version":"12.0.0.18"}
{"reqId":"wp0iqqUkZa9wUQrPxsz3","level":3,"time":"2017-05-10T20:57:25+00:00","remoteAddr":"212.92.123.232","user":"richard","app":"core","method":"GET","url":"\/core\/preview.png?file=%2FDocuments%2Fspreadsheets%2FMaximedia%2Fvrije+dagen.ods&c=60aa67f65737726b9d9b2726968bbb07&x=36&y=36&forceIcon=0","message":"unable to open image `\/tmp\/oc_tmp_pRKqkE-.pdf': No such file or directory @ error\/blob.c\/OpenBlob\/2712","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/57.0.2987.98 Safari\/537.36","version":"12.0.0.18"}
Docker
started with
docker run -t -d -p 127.0.0.1:9980:9980 -e 'domain=fnp\\.tubul\\.net' --restart always --cap-add MKNOD collabora/code
# docker logs
Generating RSA private key, 2048 bit long modulus
................................+++
........................................................+++
e is 65537 (0x10001)
Generating RSA private key, 2048 bit long modulus
...........................+++
..+++
e is 65537 (0x10001)
Signature ok
subject=/C=DE/ST=BW/L=Stuttgart/O=Dummy Authority/CN=localhost
Getting CA Private Key
loolforkit version details: 2.1.0 - b2e736a3
office version details: { "ProductName": "Collabora Office", "ProductVersion": "5.3", "ProductExtension": ".10.10", "BuildId": "77b0d93c0f6ff6490e909dbd81b1994862a31b3a" }
(Opening document in nextcloud now)
wsd-00025-00033 20:34:45.790185 [ websrv_poll ] WRN WOPI host did not pass optional access_token_ttl| wsd/FileServer.cpp:327
wsd-00025-00035 20:34:46.928058 [ docbroker_001 ] ERR WOPI::CheckFileInfo is missing JSON payload| wsd/Storage.cpp:475
wsd-00025-00035 20:34:46.932977 [ docbroker_001 ] ERR Invalid fileinfo for URI [https://fnp.tubul.net/apps/richdocuments/wopi/files/101420_ocaed749a93a?access_token=vBQsC8CnMpPSZB0Rp384QwB8gofc72zj&access_token_ttl=0&permission=edit].| wsd/DocumentBroker.cpp:494
wsd-00025-00035 20:34:46.934693 [ docbroker_001 ] ERR Failed to load document with URI [https://fnp.tubul.net/apps/richdocuments/wopi/files/101420_ocaed749a93a?access_token=vBQsC8CnMpPSZB0Rp384QwB8gofc72zj&access_token_ttl=0&permission=edit].| wsd/DocumentBroker.cpp:814
wsd-00025-00035 20:34:46.938563 [ docbroker_001 ] ERR Exception while invoking poll [docbroker_001] callback: Failed to load document with URI [https://fnp.tubul.net/apps/richdocuments/wopi/files/101420_ocaed749a93a?access_token=vBQsC8CnMpPSZB0Rp384QwB8gofc72zj&access_token_ttl=0&permission=edit].| ./net/Socket.hpp:382
wsd-00025-00035 20:34:46.940719 [ docbroker_001 ] WRN Child session [0002] not found to forward message: load url=https://fnp.tubul.net/apps/richdocuments/wopi/files/101420_ocaed749a93a?access_token=vBQsC8CnMpPSZB0Rp384QwB8gofc72zj&access_token_ttl=0&permission=edit readonly=1 lang=en-GB| wsd/DocumentBroker.cpp:1270
wsd-00025-00035 20:34:51.710951 [ docbroker_001 ] WRN Attempted ping on non-upgraded websocket!| ./net/WebSocketHandler.hpp:287
wsd-00025-00035 20:34:51.718805 [ docbroker_001 ] ERR Socket #18 SSL BIO error: closed (0).| ./net/SslSocket.hpp:255
wsd-00025-00035 20:34:51.722669 [ docbroker_001 ] ERR Socket #18 SSL BIO error: error:140D00CF:SSL routines:SSL_write:protocol is shutdown (errno: Success)| ./net/SslSocket.hpp:273
wsd-00025-00035 20:34:51.744565 [ docbroker_001 ] WRN ToClient-0002: Exception while closing socket for docKey [/apps/richdocuments/wopi/files/101420_ocaed749a93a]: error:140D00CF:SSL routines:SSL_write:protocol is shutdown| wsd/ClientSession.cpp:783