Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Collabora fails to load #49

Closed
rigrig opened this issue May 10, 2017 · 3 comments
Closed

Collabora fails to load #49

rigrig opened this issue May 10, 2017 · 3 comments

Comments

@rigrig
Copy link

rigrig commented May 10, 2017

Steps to reproduce

  1. Navigate to a .ods file
  2. 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
@adrienfr44
Copy link

same issue

@rigrig
Copy link
Author

rigrig commented May 18, 2017

Just updated the app to 1.12.27, and now it works, so I guess that 9bb4007 fixed it :-)

@rigrig rigrig closed this as completed May 18, 2017
@adrienfr44
Copy link

adrienfr44 commented May 18, 2017 •
edited
Loading

ok for my instance nextcloud 12 in my test environnement
but my instance nextcloud 11.0.3 production with 1.11.27 is always ko

@adrienfr44 adrienfr44 mentioned this issue May 18, 2017
Closed
@JSoko JSoko mentioned this issue May 25, 2017
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@rigrig @adrienfr44