Issue installing Collabora following official guide

davidpiedra · September 13, 2016, 7:22pm

I’ve tried any opssible combination but no luck, now I don’t get the connection error, but the gray screen keeps showing off.

Using the Developer Tools I manage to see the error, perhaps someone could know how to fix it.

[quote]
Refused to frame ‘https://127.0.0.1:9980/loleaflet/1.8.2/loleaflet.html?WOPISrc=https%3A%2F%2…opi%2Ffiles%2F782&title=prueba.odt&lang=es&closebutton=1&revisionhistory=1’ because it violates the following Content Security Policy directive: “frame-src ‘self’ http://ajax.googleapis.com/ajax/libs/jquery/2.1.0/jquery.min.js http://cdnjs.cloudflare.com/ajax/libs/jquery-mousewheel/3.1.12/jquery.mousewheel.min.js ‘unsafe-eval’ https://xxxxx.xxx.xx.xx:443”.[/quote]

I installed a add-on to turn off the Content Security Policy y afterthat get a different error:

I have 2 ubuntu 16.04 servers 1 with Nextcloud 9.0.53 and the other with Collabora with both options, using docker or compiled version of LOOL.

Maybe someone could help me.

Thank you,

David

BMicraft · September 13, 2016, 11:21pm

I am getting the same “We are sorry, this is an unexpected connection error. Please try again” message.

But whe I looked into the dev-tools of chromium (and firefox) I noticed that a HTTP 101 “switching protocols” status code seems to be the last thing to be transmitted. AFAIK a 101 with “upgrade: websocket” is perfectly normal but there still seems to be some issue.

Does anybod know what to do with that information?

BMicraft · September 13, 2016, 11:32pm

Also, why is it using HTTP 1.1 instead of https?

EDIT: nevermind, firefox always shows http there.

aalaesar · September 14, 2016, 3:03pm

Hi
Same problem here (are you using nginx ?)
the response 101 mean the page have switch to secured websocket protocol (wss)
this is the secured websocket libreoffice uses to receive and transfert the graphical application and user actions on the edited file
the websocket is initialised and kept opened during the entire editing session but for some reason nothing go through.
The message box “We are sorry, this is an unexpected connection error. Please try again” appears once the reverse proxy connexion timeout is passed. it would also appears even if the websocket whould work normally but you have’nt done anything on the doc for the same amount of time.
no errors in logs both for the proxy and in the collabora docker.
Still havent found any solution for this problem.
sry

BMicraft · September 14, 2016, 3:53pm

I am using apache 2.4.18 with php 7.0.8 and docker 1.11.2 (latest in ubuntu 16.04).
Also, I am using php-apcu 5.1.3+4.0.11 and php-apcu-bc 1.0.3-2 from the ubuntu 16.10 repository because php-apcu-bc is not available for 16.04.

davidpiedra · September 14, 2016, 5:54pm

Have you found a solution for this?

David

bearchaser77 · September 14, 2016, 7:45pm

Hello Everyone,

First of all sorry for my poor English, but let me try to share my problem about collabora office and nexclud combo.

The SW enviroment is

ubuntu x64:
4.4.0-36-generic

docker:
Client:
Version: 1.12.1
API version: 1.24
Go version: go1.6.3
Git commit: 23cf638
Built: Thu Aug 18 05:33:38 2016
OS/Arch: linux/amd64
Server:
Version: 1.12.1
API version: 1.24
Go version: go1.6.3
Git commit: 23cf638
Built: Thu Aug 18 05:33:38 2016
OS/Arch: linux/amd64

Nextcloud 10.0

WebServer Apache/2.4.18 (Ubuntu)

my.cloude.domain.com has a DV certification from GeoTrust Inc. for a year.
my.office.domain.com has a DV certification from COMODO CA Limited. It is a 90 day valid free certification.

I’ve built this server for mediashareing by minidlna, ftp server by vsftp, samba server, torrent client by transmission, and cloud server by nextcloud migrated from owncloud 9.1.
All the mentioned services work properly. This server operates behind a router from my IS provider.

My issue is. I tried to follow all the details of collabora online’s installing process description wirten on this site.
At the end, when i want to open a documet in nextcloud, sometimes it works, sometimes it doesn’t. I get an unexpected connection error message.

I cheked the docker logs and i find an error message in the 89. line. BTW it seems, the online office open the document, and the service runs in docker.

1.    wsd-00024-04 00:17:01.845253 [ client_req_hdl ] Request from 172.17.0.1:38566: GET /hosting/discovery HTTP/1.1 / Host: <my.office.domain.com> / User-Agent: ownCloud Server Crawler / X-Forwarded-For: 192.168.0.1 / X-Forwarded-Host: <my.office.domain.com> / X-Forwarded-Server: <my.office.domain.com> / Connection: Keep-Alive
2.    wsd-00024-04 00:17:01.845392 [ client_ws_0006 ] Thread started.
3.    wsd-00024-04 00:17:01.855499 [ client_ws_0006 ] Sent discovery.xml successfully.
4.    wsd-00024-04 00:17:01.855768 [ client_ws_0006 ] Thread finished.
5.    wsd-00024-03 00:17:07.476260 [ client_req_hdl ] Request from 172.17.0.1:38574: POST /loleaflet/1.8.2/loleaflet.html?WOPISrc=https%3A%2F%2F<my.cloude.domain.com>%2Fowncloud%2Findex.php%2Fapps%2Frichdocuments%2Fwopi%2Ffiles%2F31698&title=H%C3%A1zip%C3%A9nzt%C3%A1r.xlsx&lang=hu-hu&closebutton=1&revisionhistory=1 HTTP/1.1 / Host: <my.office.domain.com> / User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0 / Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 / Accept-Language: hu-HU,hu;q=0.8,en-US;q=0.5,en;q=0.3 / Accept-Encoding: gzip, deflate, br / DNT: 1 / Upgrade-Insecure-Requests: 1 / Content-Type: application/x-www-form-urlencoded / X-Forwarded-For: 192.168.0.1 / X-Forwarded-Host: <my.office.domain.com> / X-Forwarded-Server: <my.office.domain.com> / Connection: Keep-Alive / Content-Length: 45
6.    wsd-00024-03 00:17:07.476585 [ client_req_hdl ] Preprocessing file: /usr/share/loolwsd//loleaflet/dist/loleaflet.html
7.    wsd-00024-05 00:17:08.545733 [ client_req_hdl ] Request from 172.17.0.1:38578: GET /lool/ws/https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi HTTP/1.1 / Host: <my.office.domain.com> / User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0 / Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 / Accept-Language: hu-HU,hu;q=0.8,en-US;q=0.5,en;q=0.3 / Accept-Encoding: gzip, deflate, br / DNT: 1 / Sec-WebSocket-Version: 13 / origin: https://<my.office.domain.com> / Sec-WebSocket-Extensions: permessage-deflate / Sec-WebSocket-Key: H06c8eByGptNljwfJxZbZg== / Pragma: no-cache / Cache-Control: no-cache / X-Forwarded-For: 192.168.0.1 / X-Forwarded-Host: <my.office.domain.com> / X-Forwarded-Server: <my.office.domain.com> / Upgrade: WebSocket / Connection: Upgrade
8.    wsd-00024-05 00:17:08.546004 [ client_ws_0007 ] Thread started.
9.    wsd-00024-05 00:17:08.546306 [ client_ws_0007 ] Starting GET request handler for session [0007].
10.    wsd-00024-05 00:17:08.546382 [ client_ws_0007 ] Sending to Client [statusindicator: find].
11.    wsd-00024-05 00:17:08.546601 [ client_ws_0007 ] getNewChild: Have 1 children, forking 1
12.    wsd-00024-05 00:17:08.546676 [ client_ws_0007 ] MasterToForKit: spawn 1
13.    wsd-00024-05 00:17:08.546755 [ client_ws_0007 ] Writing to pipe. Data: [spawn 1].
14.    frk-00033-00 00:17:08.437293 [ loolforkit ] readFIFO for pipe: wsd_pipe_rd returned: 8
15.    frk-00033-00 00:17:08.437411 [ loolforkit ] Read line from pipe: wsd_pipe_rd, line: [spawn 1], data: [].
16.    wsd-00024-05 00:17:08.547056 [ client_ws_0007 ] getNewChild: Returning new child [48].m
17.    frk-00033-00 00:17:08.437484 [ loolforkit ] ForKit command: [spawn 1].
18.    wsd-00024-05 00:17:08.547140 [ client_ws_0007 ] New DocumentBroker for docKey [<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698].
19.    frk-00033-00 00:17:08.437564 [ loolforkit ] Spawning 1 child per request.
20.    frk-00033-00 00:17:08.437636 [ loolforkit ] Creating 1 new child.39
21.    mwsd-00024-05 00:17:08.547254 [ client_ws_0007 ] DocumentBroker [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi] created. DocKey: [<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698]
22.    frk-00033-00 00:17:08.437681 [ loolforkit ] Forking a loolkit process.
23.    wsd-00024-05 00:17:08.547377 [ client_ws_0007 ] Validating: https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi
24.    wsd-00024-05 00:17:08.547439 [ client_ws_0007 ] Public URI [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi] considered WOPI.
25.    wsd-00024-05 00:17:08.547539 [ client_ws_0007 ] Storage ctor: https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi
26.    wsd-00024-05 00:17:08.547587 [ client_ws_0007 ] WopiStorage ctor with localStorePath: [], jailPath: [], uri: [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi].
27.    wsd-00024-05 00:17:08.547641 [ client_ws_0007 ] Getting info for wopi uri [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi].
28.    frk-00033-00 00:17:08.443247 [ loolforkit ] Forked kit [1211].
29.    kit-01211-00 00:17:08.444038 [ loolforkit ] Initializing kit
30.    kit-01211-00 00:17:08.444236 [ loolforkit ] Log level is [8].
31.    kit-01211-00 00:17:08.444467 [ loolkit ] Process started.
32.    kit-01211-00 00:17:08.444733 [ loolkit ] Jail path: /opt/lool/child-roots/1211/
33.    kit-01211-00 00:17:08.445425 [ loolkit ] symlink("../lo","/opt/lool/child-roots/1211/opt/collaboraoffice5.1")
34.    kit-01211-00 00:17:08.585821 [ loolkit ] skip redundant paths share/gallery
35.    kit-01211-00 00:17:08.602690 [ loolkit ] skip redundant paths share/Scripts
36.    kit-01211-00 00:17:08.602813 [ loolkit ] skip redundant paths share/template
37.    kit-01211-00 00:17:08.623920 [ loolkit ] skip redundant paths share/config/wizard
38.    kit-01211-00 00:17:08.862835 [ loolkit ] skip redundant paths share/basic
39.    kit-01211-00 00:17:09.342070 [ loolkit ] skip redundant paths program/wizards
40.    kit-01211-00 00:17:09.440010 [ loolkit ] Initialized jail files.
41.    kit-01211-00 00:17:09.440717 [ loolkit ] chroot("/opt/lool/child-roots/1211/")
42.    kit-01211-00 00:17:09.440990 [ loolkit ] Capabilities first: = cap_fowner,cap_sys_chroot,cap_mknod+eip cap_chown,cap_dac_override,cap_fsetid,cap_kill,cap_setgid,cap_setuid,cap_setpcap,cap_net_bind_service,cap_net_raw,cap_audit_write,cap_setfcap+i
43.    kit-01211-00 00:17:09.441137 [ loolkit ] Capabilities now: = cap_fowner,cap_mknod+eip cap_chown,cap_dac_override,cap_fsetid,cap_kill,cap_setgid,cap_setuid,cap_setpcap,cap_net_bind_service,cap_net_raw,cap_sys_chroot,cap_audit_write,cap_setfcap+i
44.    kit-01211-00 00:17:09.441268 [ loolkit ] Capabilities first: = cap_fowner,cap_mknod+eip cap_chown,cap_dac_override,cap_fsetid,cap_kill,cap_setgid,cap_setuid,cap_setpcap,cap_net_bind_service,cap_net_raw,cap_sys_chroot,cap_audit_write,cap_setfcap+i
45.    kit-01211-00 00:17:09.441399 [ loolkit ] Capabilities now: = cap_fowner+eip cap_chown,cap_dac_override,cap_fsetid,cap_kill,cap_setgid,cap_setuid,cap_setpcap,cap_net_bind_service,cap_net_raw,cap_sys_chroot,cap_mknod,cap_audit_write,cap_setfcap+i
46.    kit-01211-00 00:17:09.441513 [ loolkit ] Capabilities first: = cap_fowner+eip cap_chown,cap_dac_override,cap_fsetid,cap_kill,cap_setgid,cap_setuid,cap_setpcap,cap_net_bind_service,cap_net_raw,cap_sys_chroot,cap_mknod,cap_audit_write,cap_setfcap+i
47.    kit-01211-00 00:17:09.441620 [ loolkit ] Capabilities now: = cap_chown,cap_dac_override,cap_fowner,cap_fsetid,cap_kill,cap_setgid,cap_setuid,cap_setpcap,cap_net_bind_service,cap_net_raw,cap_sys_chroot,cap_mknod,cap_audit_write,cap_setfcap+i
48.    kit-01211-00 00:17:09.441709 [ loolkit ] Initialized jail nodes, dropped caps.
49.    wsd-00024-10 00:17:09.940434 [ loolwsd ] Total memory used: 255972
50.    kit-01211-00 00:17:10.659689 [ loolkit ] Process is ready.
51.    wsd-00024-07 00:17:10.770542 [ prsnr_req_hdl ] Request from 127.0.0.1:35650: GET /loolws/newchild?pid=1211 HTTP/1.0 / Connection: Upgrade / Upgrade: websocket / Sec-WebSocket-Version: 13 / Sec-WebSocket-Key: ZaTjHcGgIirEYRsAU2QREg== / Host: 127.0.0.1:9981
52.    wsd-00024-07 00:17:10.770630 [ prison_ws ] Child connection with URI [/loolws/newchild?pid=1211].
53.    wsd-00024-07 00:17:10.770733 [ prison_ws ] New child [1211].
54.    wsd-00024-07 00:17:10.770948 [ prison_ws ] ChildProcess ctor [1211].
55.    kit-01211-00 00:17:10.661470 [ loolkit ] SocketProcessor starting.
56.    mwsd-00024-07 00:17:10.771059 [ prison_ws ] Have 1 child.
57.    wsd-00024-00 00:17:10.770977 [ prison_ws ] SocketProcessor starting.
58.    wsd-00024-05 00:17:13.959445 [ client_ws_0007 ] WOPI::CheckFileInfo header for URI [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi]:
59.    Date: Wed, 14 Sep 2016 17:17:48 GMT /   Server: Apache/2.4.18 (Ubuntu) /        Strict-Transport-Security: max-age=15552000; preload /  Set-Cookie: nc_sameSiteCookiestrict=true; path=/owncloud; httponly;secure; expires=Fri, 31-Dec-2100 23:59:59 GMT; SameSite=strict /  Set-Cookie: nc_sameSiteCookielax=true; path=/owncloud; httponly;secure; expires=Fri, 31-Dec-2100 23:59:59 GMT; SameSite=lax /   Set-Cookie: oc_sessionPassphrase=a4Woyv9yN156NE8iFAwjkk4vnxiqICFquaFPw9qoEJ16OzpPBGUnJOk0ZXY7zyGWOpd%2FMbsHH1gKQd%2BqM3%2BvArUkveYkbwjenFS9G1HsRD6KbPy%2FlWbG6m96HQ7dgpti; path=/owncloud; secure; HttpOnly /        Set-Cookie: oc8krjxzwmfp=fh86cloksk1vqgkvtbkntm4ip1; path=/owncloud; HttpOnly /         Expires: Thu, 19 Nov 1981 08:52:00 GMT /     Cache-Control: no-cache, must-revalidate /      Pragma: no-cache /      Content-Security-Policy: default-src 'none';script-src 'self' 'unsafe-eval';style-src 'self' 'unsafe-inline';img-src 'self' data: blob:;font-src 'self';connect-src 'self';media-src 'self' /        Content-Length: 77 /    X-Content-Type-Options: nosniff /       X-XSS-Protection: 1; mode=block /       X-Robots-Tag: none /    X-Frame-Options: SAMEORIGIN /   X-Download-Options: noopen /         X-Permitted-Cross-Domain-Policies: none /       Connection: close /     Content-Type: application/json; charset=utf-8 /
60.    wsd-00024-05 00:17:13.959599 [ client_ws_0007 ] WOPI::CheckFileInfo returned: {"BaseFileName":"H\u00e1zip\u00e9nzt\u00e1r.xlsx","Size":30200,"Version":"0"}
61.    wsd-00024-05 00:17:13.960286 [ client_ws_0007 ] Validated [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi].
62.    wsd-00024-05 00:17:13.960378 [ client_ws_0007 ] MasterProcessSession ctor [ToClient-0007].
63.    wsd-00024-05 00:17:13.960437 [ client_ws_0007 ] DocBroker to Child: session 0007 <my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698
64.    wsd-00024-05 00:17:13.960661 [ client_ws_0007 ] Giving editing lock to the first session [0007].
65.    mkit-00048-00 00:17:13.851095 [ loolkit ] ChildControllerWS: recv [session 0007 <my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698].wsd-00024-05 00:17:13.960740 [ client_ws_0007 ] <my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698, ws_sessions++: 1
66.    wsd-00024-05 00:17:13.960903 [ client_ws_0007 ] Sending to Client [statusindicator: connect].
67.    0m
68.    wsd-00024-05 00:17:13.961051 [ client_ws_0007 ] Waiting for client session [0007] to connect.
69.    kit-00048-00 00:17:13.851459 [ loolkit ] New session [0007] request on url [<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698].
70.    kit-00048-00 00:17:13.851607 [ loolkit ] Document ctor for url [<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698] on child [48] LOK_VIEW_CALLBACK=0.
71.    kit-00048-00 00:17:13.851679 [ loolkit ] Creating first view for url: <my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698 for sessionId: 0007 on jailId: 48
72.    wsd-00024-07 00:17:13.961916 [ prsnr_req_hdl ] Request from 127.0.0.1:35654: GET /loolws/child?sessionId=0007&jailId=48&docKey=<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698 HTTP/1.0 / Connection: Upgrade / Upgrade: websocket / Sec-WebSocket-Version: 13 / Sec-WebSocket-Key: njCpTQWKuSkn8XYH2UI8Cg== / Host: 127.0.0.1:9981
73.    wsd-00024-07 00:17:13.962000 [ prison_ws ] Child connection with URI [/loolws/child?sessionId=0007&jailId=48&docKey=<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698].
74.    wsd-00024-07 00:17:13.962100 [ prison_ws_0007 ] Thread started.
75.    wsd-00024-07 00:17:13.962148 [ prison_ws_0007 ] Child socket for SessionId: 0007, jailId: 48, docKey: <my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698 connected.
76.    wsd-00024-07 00:17:13.962208 [ prison_ws_0007 ] Loading from URI: https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi
77.    wsd-00024-07 00:17:13.962280 [ prison_ws_0007 ] jailPath: /user/docs/48, jailRoot: /opt/lool/child-roots/48
78.    wsd-00024-07 00:17:13.962328 [ prison_ws_0007 ] Public URI [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi] considered WOPI.
79.    wsd-00024-07 00:17:13.962404 [ prison_ws_0007 ] Storage ctor: https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi
80.    wsd-00024-07 00:17:13.962438 [ prison_ws_0007 ] WopiStorage ctor with localStorePath: [/opt/lool/child-roots/48], jailPath: [/user/docs/48], uri: [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi].
81.    wsd-00024-07 00:17:13.962479 [ prison_ws_0007 ] Getting info for wopi uri [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi].
82.    wsd-00024-07 00:17:14.498601 [ prison_ws_0007 ] WOPI::CheckFileInfo header for URI [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi]:
83.    Date: Wed, 14 Sep 2016 17:17:48 GMT /   Server: Apache/2.4.18 (Ubuntu) /        Strict-Transport-Security: max-age=15552000; preload /  Set-Cookie: nc_sameSiteCookiestrict=true; path=/owncloud; httponly;secure; expires=Fri, 31-Dec-2100 23:59:59 GMT; SameSite=strict /  Set-Cookie: nc_sameSiteCookielax=true; path=/owncloud; httponly;secure; expires=Fri, 31-Dec-2100 23:59:59 GMT; SameSite=lax /   Set-Cookie: oc_sessionPassphrase=EzoUy512FfdhrEJMcr3n88gMjNV1Ws%2BqExtwYAHRp2iblEA%2BX5VfOcn1imyGGNv%2BqlQwR%2Ffz4Yo8ILYNkfPK1LFBhcXoexwUIpUtVEg0wGlXsttybQBdg2mb0qcB7G7e; path=/owncloud; secure; HttpOnly /        Set-Cookie: oc8krjxzwmfp=35hth2cag1n6q61hs6c96955n7; path=/owncloud; HttpOnly /         Expires: Thu, 19 Nov 1981 08:52:00 GMT /     Cache-Control: no-cache, must-revalidate /      Pragma: no-cache /      Content-Security-Policy: default-src 'none';script-src 'self' 'unsafe-eval';style-src 'self' 'unsafe-inline';img-src 'self' data: blob:;font-src 'self';connect-src 'self';media-src 'self' /        Content-Length: 77 /    X-Content-Type-Options: nosniff /       X-XSS-Protection: 1; mode=block /       X-Robots-Tag: none /    X-Frame-Options: SAMEORIGIN /   X-Download-Options: noopen /         X-Permitted-Cross-Domain-Policies: none /       Connection: close /     Content-Type: application/json; charset=utf-8 /
84.    wsd-00024-07 00:17:14.498749 [ prison_ws_0007 ] WOPI::CheckFileInfo returned: {"BaseFileName":"H\u00e1zip\u00e9nzt\u00e1r.xlsx","Size":30200,"Version":"0"}
85.    wsd-00024-07 00:17:14.499270 [ prison_ws_0007 ] Downloading URI [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi].
86.    wsd-00024-07 00:17:14.499368 [ prison_ws_0007 ] Getting info for wopi uri [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi].
87.    wsd-00024-10 00:17:14.969335 [ loolwsd ] Total memory used: 255976
88.    wsd-00024-05 00:17:18.961381 [ client_ws_0007 ] ToClient-0007: Failed to connect to lokit process. Client cannot serve now.
89.    wsd-00024-05 00:17:18.961754 [ client_ws_0007 ] Error in client request handler: Service is unavailable. Please try again later and report to your administrator if the issue persists.
90.    wsd-00024-05 00:17:18.961885 [ client_ws_0007 ] Abnormal close handshake.
91.    wsd-00024-05 00:17:18.962276 [ client_ws_0007 ] Thread finished.
92.    wsd-00024-07 00:17:19.887419 [ prison_ws_0007 ] WOPI::CheckFileInfo header for URI [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi]:
93.    Date: Wed, 14 Sep 2016 17:17:54 GMT /   Server: Apache/2.4.18 (Ubuntu) /        Strict-Transport-Security: max-age=15552000; preload /  Set-Cookie: nc_sameSiteCookiestrict=true; path=/owncloud; httponly;secure; expires=Fri, 31-Dec-2100 23:59:59 GMT; SameSite=strict /  Set-Cookie: nc_sameSiteCookielax=true; path=/owncloud; httponly;secure; expires=Fri, 31-Dec-2100 23:59:59 GMT; SameSite=lax /   Set-Cookie: oc_sessionPassphrase=i2%2FWtaJtDD7NtIIyqlWOv0ob9TOod6fUWopIDbXFU2DMb1VTgDX6rYluEi6AwdXesg9sCTasLJjNJ9Z7uZAdvcYxMMnCQ4uQTAzWvHchrsYOIUF3PyBQmrynOyMDZBDd; path=/owncloud; secure; HttpOnly /      Set-Cookie: oc8krjxzwmfp=me1s1n2pg4s2kp6uucd7mtsud1; path=/owncloud; HttpOnly /         Expires: Thu, 19 Nov 1981 08:52:00 GMT /     Cache-Control: no-cache, must-revalidate /      Pragma: no-cache /      Content-Security-Policy: default-src 'none';script-src 'self' 'unsafe-eval';style-src 'self' 'unsafe-inline';img-src 'self' data: blob:;font-src 'self';connect-src 'self';media-src 'self' /        Content-Length: 77 /    X-Content-Type-Options: nosniff /       X-XSS-Protection: 1; mode=block /       X-Robots-Tag: none /    X-Frame-Options: SAMEORIGIN /   X-Download-Options: noopen /         X-Permitted-Cross-Domain-Policies: none /       Connection: close /     Content-Type: application/json; charset=utf-8 /
94.    wsd-00024-07 00:17:19.887567 [ prison_ws_0007 ] WOPI::CheckFileInfo returned: {"BaseFileName":"H\u00e1zip\u00e9nzt\u00e1r.xlsx","Size":30200,"Version":"0"}
95.    wsd-00024-07 00:17:19.888137 [ prison_ws_0007 ] Wopi requesting: /owncloud/index.php/apps/richdocuments/wopi/files/31698/contents?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi
96.    wsd-00024-10 00:17:20.000709 [ loolwsd ] Total memory used: 256120
97.    wsd-00024-07 00:17:25.619054 [ prison_ws_0007 ] WOPI::GetFile header for URI [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi]:
98.    Date: Wed, 14 Sep 2016 17:17:59 GMT /   Server: Apache/2.4.18 (Ubuntu) /        Strict-Transport-Security: max-age=15552000; preload /  Set-Cookie: nc_sameSiteCookiestrict=true; path=/owncloud; httponly;secure; expires=Fri, 31-Dec-2100 23:59:59 GMT; SameSite=strict /  Set-Cookie: nc_sameSiteCookielax=true; path=/owncloud; httponly;secure; expires=Fri, 31-Dec-2100 23:59:59 GMT; SameSite=lax /   Set-Cookie: oc_sessionPassphrase=ty5te9%2BNzTZpJ660Rf%2F4SAoC5ZcE8Fwix4aJ4nRXal%2F3%2BPKdpr3YWeDz8BsKOXKHcRLGnRtDOWDJSoDwZoe1dxiUW6GMQ7bzegNB8syrYlA2XETQAazElqgrv6gmAlij; path=/owncloud; secure; HttpOnly /        Set-Cookie: oc8krjxzwmfp=fhrtq3o62s9vvcnbniv88opci3; path=/owncloud; HttpOnly /         Expires: Thu, 19 Nov 1981 08:52:00 GMT /     Cache-Control: no-cache, must-revalidate /      Pragma: no-cache /      Content-Security-Policy: default-src 'none';script-src 'self' 'unsafe-eval';style-src 'self' 'unsafe-inline';img-src 'self' data: blob:;font-src 'self';connect-src 'self';media-src 'self' /        Content-Length: 30200 /         Vary: Accept-Encoding /         X-Content-Type-Options: nosniff /       X-XSS-Protection: 1; mode=block /       X-Robots-Tag: none / X-Frame-Options: SAMEORIGIN /   X-Download-Options: noopen /    X-Permitted-Cross-Domain-Policies: none /       Connection: close /     Content-Type: text/html; charset=UTF-8 /
99.    wsd-00024-07 00:17:25.685269 [ prison_ws_0007 ] WOPI::GetFile downloaded 30200 bytes from [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi] -> /opt/lool/child-roots/48/user/docs/48/Házipénztár.xlsx: 200 OK
100.    wsd-00024-07 00:17:25.685888 [ prison_ws_0007 ] TileCache ctor for uri [https://<my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698?access_token=bYa75aby7ladFBFvQz7F8hc40L5UgQVi] modifiedTime=1473873480 getLastModified()=0
101.    wsd-00024-07 00:17:25.686700 [ prison_ws_0007 ] MasterProcessSession ctor [ToPrisoner-0007].
102.    wsd-00024-07 00:17:25.686776 [ prison_ws_0007 ]  mapped 0x7fbed4012f10 jailId=48, id=0007 into _availableChildSessions, size=2
103.    wsd-00024-07 00:17:25.686813 [ prison_ws_0007 ] Adding doc <my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698 to Admin
104.    wsd-00024-07 00:17:25.686844 [ prison_ws_0007 ] Document <my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698 ctor.
105.    wsd-00024-07 00:17:25.686873 [ prison_ws_0007 ] Document <my.cloude.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/31698 dtor.
106.    kit-00048-00 00:17:25.577344 [ loolkit ] ChildProcessSession ctor [ToMaster-0007].
107.    kit-00048-00 00:17:25.577470 [ loolkit ] Connection ctor in child for 0007
108.    kit-00048-02 00:17:25.577495 [ kit_callback ] Thread started.
109.    kit-00048-00 00:17:25.577572 [ loolkit ] Connections: 1
110.    kit-00048-03 00:17:25.577613 [ kit_ws_0007 ] Thread started.
111.    kit-00048-03 00:17:25.577712 [ kit_ws_0007 ] SocketProcessor starting.
112.    kit-00048-04 00:17:25.577802 [ kit_queue_0007 ] Thread started.
113.    wsd-00024-07 00:17:25.695067 [ prison_ws_0007 ] Message to admin console: adddoc 48 H%C3%A1zip%C3%A9nzt%C3%A1r.xlsx 0007 85400
114.    wsd-00024-07 00:17:25.695258 [ prison_ws_0007 ] SocketProcessor starting.

After I kept trying open another or the same documet, and the results were the same. Sometimes it was opened, Sometimes got the error message. After a while it was comlete failure, and looked after in docker log again. In the 19. line it said “Maximum number of open documents reached.”

1.    wsd-00024-10 00:40:21.357638 [ loolwsd ] Total memory used: 1537520
2.    wsd-00024-23 00:40:23.533327 [ client_req_hdl ] Request from 172.17.0.1:38946: POST /loleaflet/1.8.2/loleaflet.html?WOPISrc=https%3A%2F%2F<my.cloud.domain.com>%2Fowncloud%2Findex.php%2Fapps%2Frichdocuments%2Fwopi%2Ffiles%2F39759&title=2016.xlsx&lang=hu-hu&closebutton=1&revisionhistory=1 HTTP/1.1 / Host: <my.office.domain.com> / Accept: text/html, application/xhtml+xml, image/jxr, */* / Accept-Language: hu,en-US;q=0.7,en;q=0.3 / User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 Safari/537.36 Edge/13.10586 / Content-Type: application/x-www-form-urlencoded / Accept-Encoding: gzip, deflate / Cache-Control: no-cache / X-Forwarded-For: 192.168.0.1 / X-Forwarded-Host: <my.office.domain.com> / X-Forwarded-Server: <my.office.domain.com> / Connection: Keep-Alive / Content-Length: 45
3.    wsd-00024-23 00:40:23.533678 [ client_req_hdl ] Preprocessing file: /usr/share/loolwsd//loleaflet/dist/loleaflet.html
4.    wsd-00024-04 00:40:24.069800 [ client_req_hdl ] Request from 172.17.0.1:38950: GET /lool/ws/https://<my.cloud.domain.com>/owncloud/index.php/apps/richdocuments/wopi/files/39759?access_token=bfDl03FJ3bo0Pu6acomkNeX3KCZD421O HTTP/1.1 / Host: <my.office.domain.com> / Origin: https://<my.office.domain.com> / Sec-WebSocket-Key: hpIf49fvYdjbKo1xvcvr7A== / Sec-WebSocket-Version: 13 / User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 Safari/537.36 Edge/13.10586 / Cache-Control: no-cache / X-Forwarded-For: 192.168.0.1 / X-Forwarded-Host: <my.office.domain.com> / X-Forwarded-Server: <my.office.domain.com> / Upgrade: WebSocket / Connection: Upgrade
5.    wsd-00024-04 00:40:24.069976 [ client_ws_001c ] Thread started.
6.    wsd-00024-04 00:40:24.070175 [ client_ws_001c ] Starting GET request handler for session [001c].
7.    wsd-00024-04 00:40:24.070213 [ client_ws_001c ] Sending to Client [statusindicator: find].
8.    wsd-00024-04 00:40:24.070343 [ client_ws_001c ] getNewChild: Have 1 children, forking 1
9.    wsd-00024-04 00:40:24.070385 [ client_ws_001c ] MasterToForKit: spawn 1
10.    wsd-00024-04 00:40:24.070417 [ client_ws_001c ] Writing to pipe. Data: [spawn 1].
11.    frk-00033-00 00:40:23.960905 [ loolforkit ] readFIFO for pipe: wsd_pipe_rd returned: 8
12.    frk-00033-00 00:40:23.960972 [ loolforkit ] Read line from pipe: wsd_pipe_rd, line: [spawn 1], data: [].
13.    frk-00033-00 00:40:23.961009 [ loolforkit ] ForKit command: [spawn 1].
14.    frk-00033-00 00:40:23.961050 [ loolforkit ] Spawning 1 child per request.
15.    frk-00033-00 00:40:23.961093 [ loolforkit ] Creating 1 new child.
16.    frk-00033-00 00:40:23.961180 [ loolforkit ] Forking a loolkit process.
17.    frk-00033-00 00:40:23.966292 [ loolforkit ] Forked kit [4480].
18.    wsd-00024-04 00:40:24.076279 [ client_ws_001c ] getNewChild: Returning new child [4286].
19.    wsd-00024-04 00:40:24.076354 [ client_ws_001c ] Maximum number of open documents reached.
20.    wsd-00024-04 00:40:24.076488 [ client_ws_001c ] ~ChildProcess dtor [4286].
21.    kit-04286-00 00:40:23.967029 [ loolkit ] Connection closed.
22.    kit-04286-00 00:40:23.967127 [ loolkit ] SocketProcessor finishing. TerminationFlag: 0, n: 2, payload size: 2, flags: 88
23.    kit-04286-00 00:40:23.967172 [ loolkit ] SocketProcessor finished.
24.    kit-04286-00 00:40:23.967217 [ loolkit ] Removing '/lo'
25.    mkit-04480-00 00:40:23.966913 [ loolforkit ] Initializing kit
26.    kit-04480-00 00:40:23.983985 [ loolforkit ] Log level is [8].

I’m rookie in the linux word, so please forgive me if it’s a trivial problem, but if someone could help me, please don’t hesitate.

Thx!
Zsolti

dev0 · September 16, 2016, 11:41am

I have the Issue with the No acceptable WOPI hosts found matching the target host too,
the Domain i am using has dashes (-) in it. I used the backslash and one time not,
I got in both variants:

wsd-00023-04 00:00:17.122585 [ client_ws_0001 ] WOPI host is not on the same host as the WOPI client: “x.x.x.x”. Connection is not allowed.
wsd-00023-04 00:00:17.122690 [ client_ws_0001 ] No acceptable WOPI hosts found matching the target host [cloud.dom-ain.at] in config.

Is there something specific to follow if you have dashes?

update: it works now fine, had the issue with the 3.xx kernel and the filesystem thing, after that a mistake in the docker run line. after that it works fine

Steven_Horner · September 16, 2016, 3:03pm

Unfortunately not, I still can’t get Collabora working. Grey box, an issue with iFrames and the URL I think.

tatdat171 · September 22, 2016, 8:25am

I’m using Ubuntu 16.04, Next cloud 10 and newest Collabora docker

I’m installed Collabora docker with guide in Collabora online - Nextcloud
After that i’m started Collabora with domain nextcloud (cloud.mydomain.com)

docker run -t -d -p 127.0.0.1:9980:9980 -e "domain=cloud\.mydomain\.com" --restart always --cap-add MKNOD collabora/code

And setup proxy in apache…

But when i start Collabora Onoine , i got error

Collabora Online unknown error: cURL error 56: Received HTTP code 504 from proxy after CONNECT
Please contact the "https://office.ho.fpt.vn" administrator.

Leon_Van_Zyl · September 29, 2016, 10:17pm

Using the CURRENT Docker Image was a total waste of time for me. I even copied out CODE from the docker image using this guide:

I would highly recommend building from source and using loolswsd 1.9.0, This guide can help if you’re struggling to follow the instructions in the readme files in the git repository:
https://gist.github.com/m-jowett/0f28bff952737f210574fc3b2efaa01a:

scroom · October 2, 2016, 1:21pm

Hi,
tried to get the docker image running but it doesn’t start. I’m getting the following error message:

docker: Error response from daemon: rpc error: code = 2 desc = "oci runtime error: exec format error".

**Edit:**Ok I’ve found that the docker image won’t work because it should run on my ARM-board (Odroid XU4) which seems not to work.

And aren’t there snap packages (I thought that the Nexcloud-Box comes with preinstalled Snap-Packages)?

Thanks in advance!

MikeLupe · October 2, 2016, 1:23pm

Thanks for your article. I’m on Deb Jesssie aswell for the container.

I did the entire kernel bpo upgrade (to 4.7 now) and docker remove/install by script (for aufs integration) etc etc pipapo - STILL the same error message (“unexpected connection error…”)!

I would really like to get some hints from the collabora devs, as I really am tired of spending hours and hours on trying to make collabora work with nextcloud. I’m losing my entire hair on this issue.

Or - and that would be totally legit - tell us we should wait for an official implementation. Or tell us it doesn’t flawlessly work on Debian.

Please - thank you.

mejo · October 3, 2016, 9:00pm

Hi Mike,

for me, properly escaping special characters in the domain argument to docker run was the key to success regarding the Error “unexpected connection”: When the VHost with Nextcloud is vhost-name.example.org, you’ll have to give -e “domain=vhost\-name\.example\.org” as commandline argument to docker run. Hope that it helps.

mejo · October 3, 2016, 10:05pm

Trying to run Collabora Online (Docker container) and the Nextcloud Richtdocuments App working on a Debian Stretch installation, I get the following error from dockerized Collabora Online when opening a (or creating a new) LO document from within Nextcloud:

[…]
kit-00037-04 00:13:15.142813 [ kit_queue_0002 ] Failed to load: file:///user/docs/37/About.odt, error: loadComponentFromURL returned an empty reference
kit-00037-04 00:13:15.142929 [ kit_queue_0002 ] Failed to get LoKitDocument instance.
kit-00037-04 00:13:15.143025 [ kit_queue_0002 ] ToMaster-0002 Send: error: cmd=load kind=faileddocloading
e[kit-00037-02 00:13:15.143214 [ kit_callback ] CallbackWorker::callback [ToMaster-0002]: STATUS_INDICATOR_START [(nil)].
kit-00037-02 00:13:15.143278 [ kit_callback ] ToMaster-0002 Send: statusindicatorstart:
37mwsd-00023-03 00:13:16.582532 [ prison_ws_0002 ] ToPrisoner-0002 Recv: error: cmd=load kind=faileddocloading
wsd-00023-03 00:13:16.583010 [ prison_ws_0002 ] ToPrisoner-0002: handling [error: cmd=load kind=faileddocloading].
wsd-00023-03 00:13:16.583054 [ prison_ws_0002 ] ToPrisoner-0002 → ToClient-0002: error: cmd=load kind=faileddocloading
wsd-00023-03 00:13:16.583095 [ prison_ws_0002 ] ToClient-0002 Send: 37 bytes
kit-00037-04 00:13:15.144277 [ kit_queue_0002 ] Socket handler flagged for finishing.
kit-00037-04 00:13:15.144329 [ kit_queue_0002 ] Thread finished.
[…]
kit-00037-00 00:13:15.179175 [ loolkit ] Termination flagged. Finishing.
kit-00037-00 00:13:15.179248 [ loolkit ] SocketProcessor finishing. TerminationFlag: 1, n: 83, payload size: 0, flags: 81
kit-00037-00 00:13:15.179285 [ loolkit ] SocketProcessor finished.
kit-00037-00 00:13:15.179322 [ loolkit ] Removing ‘/lo’
kit-00037-00 00:13:15.315182 [ loolkit ] Removing ‘/user/docs/’
wsd-00023-00 00:13:16.755676 [ prison_ws ] SocketProcessor: exception: Connection reset by peer
wsd-00023-00 00:13:16.755746 [ prison_ws ] SocketProcessor finished.

In the browser, I see the text modification tools on top but below it says “Connecting…”, the wheel symbol keeps spinning and no document is ever loaded.

In Comment #38, pupaxxo wrote that he had patched apps/richdocuments/controller/documentcontroller.php to remove ?encoding=text from $token, but contrary to Nemskiller that didn’t change anything for me.

I’m running Nextcloud 10.0.0 with updated Richdocuments app (1.1.6) and latest Collabora Online Docker image and followed the tutorial from Collabora Online in Nextcloud.

Any suggestions how to go on?

MikeLupe · October 4, 2016, 9:32am

Hi Mejo,

thanks for the suggestion. I already had escaped even in the form of -e “domain=www\.domain\.tld” and your hint made me think it was maybe too much, so I removed the “” escaping. But unfortunately still no go 1.1.6 app used.

I hope we’ll find a solution.

regards

mejo · October 4, 2016, 10:00am

Hi Mike, your escaping in the domain name were right. I didn’t check the result of my post, apparently backslashes need to be escaped when writing here Fixed my reply now.

Where exactly do you get your ‘unexpected connection error’? Is it a log from dockerized Collabora Online or do you see it in the Nextcloud webinterface? Did you check the Collabora logs? You can do so by running docker logs -f <container-id>. If the Nextcloud Richtdocuments App connects to your Collabora Online instance at all, you’ll see corresponding logs there. If no logs appear while trying to connect, then Nextcloud doesn’t access Collabora Online at all.

MikeLupe · October 4, 2016, 10:21am

Yeah @mejo , I know, I saw the missing escaping in my preview

I checked the logs again, and I again realize there must be something wrong with my Proxy settings for WS.

Log entries:
wsd-00024-04 00:00:52.801183 [ client_ws_0001 ] ClientRequestHandler::handleRequest: BadRequestException: Invalid URI or access denied.

wsd-00024-04 00:00:52.801237 [ client_ws_0001 ] Thread finished.

I really don’t know what I’m doing - I’m looking at my apache virtual host (NameVirtualHost) configuration for office.domain.tld:443 and intuitively don’t understand a single thing about those ProxyPass rules. Ports are correct, SSL Cert Let’s encryp activated etc.

Anyway - did you manage to solve the problem on your side?

edit: “Connection error try again” comes in the webui

mejo · October 4, 2016, 10:55am

Hi @MikeLupe, I’m still stuck with the issue described in comment comment #177. But at least it seems like I got further than you so far My VirtualHost configuration is basically the one from the official documentation. I have Nextcloud at vhost-name.example.org and Collabora Online at office.vhost-name.example.org. Maybe you should describe your setup and VirtualHost configuration somewhere in detail (e.g. in a pastebin) in order to make it more comprehensible. I then could compare it to my setup and tell you about the differences.

MikeLupe · October 4, 2016, 11:15am

@mejo I didn’t place the SSLCipherSuite in the .conf file, so maybe (almost for sure) there lies the problem.

Anyway, I got another problem now with my apache, so I’ll try to do some investigation. I hope to soon be able to catch up with you