Collabora Online: Cannot open any documents

ℹ️ Support 📄 Collabora
1

Hi there !!

I try to make Collabora working in my Nextcloud environment.

When i try to open a document, i get this (message in french ^^: Could not connect your document, please retry).

Pasted image1754Ă—460 15.4 KB

Container logs:

office version details: { “ProductName”: “Collabora Office”, “ProductVersion”: “5.1”, “ProductExtension”: “.10.12”, “BuildId”: “653cc4c38dd2c05aecbee156aef460f5a361e579” }
wsd-00026-0028 0:03:17.813084 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/node_modules/jquery-ui/themes/ui-lightness/images/ui-bg_highlight-soft_100_eeeeee_1x100.png
wsd-00026-0029 0:04:02.689258 [ client_ws_0003 ] ERR WOPI::CheckFileInfo is missing JSON payload
wsd-00026-0029 0:04:02.740580 [ client_ws_0003 ] ERR ToClient-0003: Bad socket while sending [wopi: {“HideExportOption”:false,“HidePrintOption”:false,“HideSaveOption”:false}].| LOOLSession.cpp:83
wsd-00026-0029 0:04:02.749352 [ client_ws_0003 ] ERR Invalid fileinfo for URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Oi3ddWEAlFyqcWIoaew1sMHlH3E9Xqql&permission=edit].| DocumentBroker.cpp:281
wsd-00026-0029 0:04:02.749406 [ client_ws_0003 ] ERR Failed to load document with URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Oi3ddWEAlFyqcWIoaew1sMHlH3E9Xqql&permission=edit].| DocumentBroker.cpp:493
wsd-00026-0029 0:04:02.749535 [ client_ws_0003 ] ERR Error in client request handler: Failed to load document with URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Oi3ddWEAlFyqcWIoaew1sMHlH3E9Xqql&permission=edit].| LOOLWSD.cpp:966
wsd-00026-0027 0:04:02.749760 [ client_ws_0004 ] ERR Error in client request handler: I/O error| LOOLWSD.cpp:966
wsd-00026-0030 0:04:02.749798 [ client_ws_0005 ] ERR Error in client request handler: I/O error| LOOLWSD.cpp:966
wsd-00026-0030 0:04:02.770841 [ client_ws_0005 ] ERR ClientRequestHandler::handleClientRequest: SSL Exception: error:1409F07F:SSL routines:SSL3_WRITE_PENDING:bad write retry| LOOLWSD.cpp:1161
wsd-00026-0027 0:04:02.770842 [ client_ws_0004 ] ERR ClientRequestHandler::handleClientRequest: SSL Exception: error:1409F07F:SSL routines:SSL3_WRITE_PENDING:bad write retry| LOOLWSD.cpp:1161
wsd-00026-0029 0:04:02.771247 [ client_ws_0003 ] ERR ClientRequestHandler::handleClientRequest: I/O error: Broken pipe| LOOLWSD.cpp:1161

My setup with 2 separate hosts:

Nextcloud Server 10.0.1 on Centos 7
PHP 5.4.16
Server version: Apache/2.4.6 (CentOS)
Collabora Online App 1.1.13 configured with this url: https://office.mydomain.com
Address: cloud.mydomain.com

Collabora Online Docker Container installed on Ubuntu 16.04.1
Docker version 1.12.1, build 23cf638
Kernel: 4.4.0-47-generic
Address: office.mydomain.com
Image of collabora is up to date:

Using default tag: latest
latest: Pulling from collabora/code
Digest: sha256:12a10f5978ede9b54f6c9f19747f208fe8505acd65845670b47d792ecd6dabc9
Status: Image is up to date for collabora/code:latest

Any help?

Thanks :slight_smile:

1 Like
2

Hello @ZrL
have you created a user for docker?

3

Hi @Darksoul_Machine.

I don’t have any user for docker.
All commands were launched with my actual user account with sudo.

Any suggestions?

4

look here: https://www.collaboraoffice.com/tag/code
and here: http://askubuntu.com/questions/477551/how-can-i-use-docker-without-sudo

5

Thanks !

I have add my user to the docker group, and follow instructions in the first link.
I can access now to the Collabora admin panel.

Pasted image1698Ă—448 27.1 KB

But i still cannot open any documents from Nextcloud :slight_frown:

office version details: { “ProductName”: “Collabora Office”, “ProductVersion”: “5.1”, “ProductExtension”: “.10.12”, “BuildId”: “653cc4c38dd2c05aecbee156aef460f5a361e579” }
wsd-00025-0026 0:02:23.622865 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/node_modules/jquery-ui/themes/ui-lightness/images/ui-bg_highlight-soft_100_eeeeee_1x100.png
wsd-00025-0028 0:02:46.586009 [ admin_ws_2 ] WRN Connection closed.| IoUtil.cpp:115
wsd-00025-0026 0:02:46.799309 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/admin/l10n/ui-fr.json
wsd-00025-0028 0:02:49.377529 [ admin_ws_4 ] WRN Connection closed.| IoUtil.cpp:115
wsd-00025-0026 0:02:49.497101 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/admin/l10n/ui-fr.json
wsd-00025-0027 0:04:23.775118 [ client_ws_0003 ] ERR WOPI::CheckFileInfo is missing JSON payload
wsd-00025-0027 0:04:23.775741 [ client_ws_0003 ] ERR ToClient-0003: Bad socket while sending [wopi: {“HideExportOption”:false,“HidePrintOption”:false,“HideSaveOption”:false}].| LOOLSession.cpp:83
wsd-00025-0027 0:04:23.775927 [ client_ws_0003 ] ERR Invalid fileinfo for URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Q7dEW8FnOk3zoXeHQbfNMwyyaWJadP8D&permission=edit].| DocumentBroker.cpp:281
wsd-00025-0027 0:04:23.776074 [ client_ws_0003 ] ERR Failed to load document with URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Q7dEW8FnOk3zoXeHQbfNMwyyaWJadP8D&permission=edit].| DocumentBroker.cpp:493
wsd-00025-0030 0:04:23.776370 [ client_ws_0006 ] ERR Error in client request handler: I/O error| LOOLWSD.cpp:966
wsd-00025-0026 0:04:23.776466 [ client_ws_0007 ] ERR Error in client request handler: I/O error| LOOLWSD.cpp:966
wsd-00025-0030 0:04:23.776519 [ client_ws_0006 ] ERR ClientRequestHandler::handleClientRequest: SSL Exception: error:1409F07F:SSL routines:SSL3_WRITE_PENDING:bad write retry| LOOLWSD.cpp:1161
wsd-00025-0026 0:04:23.776648 [ client_ws_0007 ] ERR ClientRequestHandler::handleClientRequest: SSL Exception: error:1409F07F:SSL routines:SSL3_WRITE_PENDING:bad write retry| LOOLWSD.cpp:1161
wsd-00025-0027 0:04:23.776780 [ client_ws_0003 ] ERR Error in client request handler: Failed to load document with URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Q7dEW8FnOk3zoXeHQbfNMwyyaWJadP8D&permission=edit].| LOOLWSD.cpp:966
wsd-00025-0027 0:04:23.777061 [ client_ws_0003 ] ERR ClientRequestHandler::handleClientRequest: I/O error: Broken pipe| LOOLWSD.cpp:1161
wsd-00025-0027 0:04:45.814027 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/node_modules/jquery-ui/themes/ui-lightness/images/ui-bg_highlight-soft_100_eeeeee_1x100.png
wsd-00025-0026 0:06:24.688475 [ client_ws_0008 ] ERR WOPI::CheckFileInfo is missing JSON payload
wsd-00025-0026 0:06:24.688759 [ client_ws_0008 ] ERR ToClient-0008: Bad socket while sending [wopi: {“HideExportOption”:false,“HidePrintOption”:false,“HideSaveOption”:false}].| LOOLSession.cpp:83
wsd-00025-0026 0:06:24.688905 [ client_ws_0008 ] ERR Invalid fileinfo for URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Q7dEW8FnOk3zoXeHQbfNMwyyaWJadP8D&permission=edit].| DocumentBroker.cpp:281
wsd-00025-0026 0:06:24.688977 [ client_ws_0008 ] ERR Failed to load document with URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Q7dEW8FnOk3zoXeHQbfNMwyyaWJadP8D&permission=edit].| DocumentBroker.cpp:493
wsd-00025-0026 0:06:24.689124 [ client_ws_0008 ] ERR Error in client request handler: Failed to load document with URI [https://cloud.mydomain.com/index.php/apps/richdocuments/wopi/files/36462?access_token=Q7dEW8FnOk3zoXeHQbfNMwyyaWJadP8D&permission=edit].| LOOLWSD.cpp:966
wsd-00025-0026 0:06:24.689414 [ client_ws_0008 ] ERR ClientRequestHandler::handleClientRequest: I/O error: Broken pipe| LOOLWSD.cpp:1161

What’s wrong?

6

have you created the right SSL certificate for the hostname of collabora?

7

Yes,

In fact, i have a HAPROXY server in front of these.
SSL Offloading is configured with the right certificate in my frontend.
Here is the admin panel of Collabora Online:

Pasted image1917Ă—369 52.1 KB

If you see the last logs:

SSL Exception: error:1409F07F:SSL routines:SSL3_WRITE_PENDING:bad write retry| LOOLWSD.cpp:1161

By default, all my frontend in HAPROXY don’t let pass any SSLv3 negociation.
Is SSL3 in the log is related to the SSLv3 protocol or something like this?

Thanks for your precious help ^^.

8

You need two certificates, one for your _nextcloud _IP and one for your _office.nextcloud _IP

9

use Let´s Encrypt!!!

10

I have the same IP address for cloud.mydomain.com and office.mydomain.com
But i have 2 differents frontend and 2 differents certificates for each one.
Certs were delivred by Let’s Encrypt ;).

To be sure that the problem is coming from HAProxy config or something like that, i will get an additional IP address, and i will NAT this one directly to my Collabora server.

I will report my experience soon.

Thanks for your help again :slight_smile:

11

It works !

With an additionnal IP address and a NAT, everything is OK.
So i have a problem with my HAProxy configuration…

I’ll make some test again with HAproxy and i will update this post ASAP.

Thanks again for your help @Darksoul_Machine

1 Like
12

Hello, I have same config as you one haproxy frontend (1public IP) with two certificates for nextcloud and for collabora.
But I don understand your hint with NAT and second IP address. Can you explain it ?
With haproxy config.
Thanx

1 Like
15

Now I have working nextcloud + code.
I done it without any NAT.
three servers in DMZ (cloud app and code docker app (without nginx or apache as reverse)) and one haproxy server with 1public IP.
All DNS record are pointing to this public dns.

16

can you explain your action .?

"It works !

With an additionnal IP address and a NAT, everything is OK.
"

17

Hello! I tried make my own haproxy cfg for nextcloud and collabora, but it doesn’t work. Can you show your haproxy cfg to me? Thank you!

18

hi i am also stuck. Would you be willing to share your haproxy cfg?