Collabora Online setup


#1

Hi, I need help to setup Collabora Onlilne on DigitalOcean Ubunut 16 server. I will pay, please contact me with offer ?

Regards
Neso


#3

I have got it working on 16.04 Ubuntu, glad to give you a demo, let me know if you need help. Took me three weeks to get it working out of docker but at last a stable platform I have


#4

How much would you ask to setup this for me on DigitalOcean, Ubuntu 16 and docker (I did try this myself but I am lost after I need to setup apache and SSL) this VPS will be only used for Collabora Online, and my NC setups will be on diffrent server ?

I did try to fallow this: https://nextcloud.com/collaboraonline/

Regards
Neso


#5

Hi Nesso,

Add me on skype
faisalna and I would be able to help you and show you my working platform
as well

Regards
Faisal


#6

It show me 4 users with same faisalna as username on skype ?

My username is: - Zorro -


#7

What did you have to do to get it working? Im running it behind an NGINX reverse proxy and half the time the documents just time out and wont load. Any advice?


#8

Please paster your nginx configuration file here.

Also hosts file


#9

I managed to install it but when I enter my Collabora server URL and start new document I get this error:

Unauthorized WOPI host. Please try again later and report to your administrator if the issue persists.

My NextCloud is on one server and Collabora is on another server


#10

I resolved WOPI host error, but now I can not use/write anything, it just load document but it is not possible to write text or use any option:

I am getting this in error log:

=============================
{“log”:"\u001b[1m\u001b[31mwsd-00022-0025 0:08:05.472310 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/help-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:05:57.309981552Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0025 0:08:05.652446 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/ui-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:05:57.489518646Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0025 0:08:06.312334 [ 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\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:05:58.149495188Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0026 0:08:34.539320 [ client_ws_0003 ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:06:26.377280881Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0042 0:08:34.553534 [ prsnr_req_hdl ] ERR SocketProcessor: exception: Connection reset by peer\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:06:26.390728925Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0024 0:08:39.230534 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/help-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:06:31.068126751Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0024 0:08:39.381191 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/ui-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:06:31.218257379Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0024 0:08:39.711415 [ 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\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:06:31.548557626Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0025 0:13:59.782759 [ client_ws_0006 ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:11:51.620496602Z”}
{“log”:"\u001b[1m\u001b[33mkit-00432-0432 0:13:59.711673 [ loolkit ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:11:51.622187817Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0439 0:13:59.794598 [ prsnr_req_hdl ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:11:51.631762222Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:14:05.109931 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/help-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:11:56.947103703Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:14:05.256363 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/ui-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:11:57.093391106Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:14:05.548546 [ 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\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:11:57.38561068Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0486 0:17:42.286907 [ client_ws_000c ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:15:34.125146022Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0023 0:18:49.830540 [ client_ws_000d ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:16:41.668081435Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0023 0:18:52.635920 [ client_ws_000e ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:16:44.473114692Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0026 0:19:26.170820 [ client_ws_0010 ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:17:18.008102967Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0024 0:19:30.528424 [ client_ws_000a ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:17:22.365603052Z”}
{“log”:"\u001b[1m\u001b[33mkit-00479-0479 0:19:30.459348 [ loolkit ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:17:22.389664702Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0487 0:19:30.566463 [ prsnr_req_hdl ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:17:22.410630919Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:20:01.510198 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/help-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:17:53.347406325Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:20:01.655243 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/ui-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:17:53.492222316Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:20:02.069011 [ 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\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:17:53.905990547Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0025 0:21:59.299397 [ client_ws_0012 ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:19:51.138136073Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0895 0:21:59.317559 [ prsnr_req_hdl ] ERR SocketProcessor: exception: Connection reset by peer\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:19:51.15471373Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:30:15.156815 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/help-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:28:06.994362079Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:30:15.310060 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/ui-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:28:07.147235844Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0023 0:30:15.605587 [ 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\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:28:07.44263877Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0024 0:31:44.301842 [ client_ws_0014 ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:29:36.144827781Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-1331 0:31:44.317148 [ prsnr_req_hdl ] ERR SocketProcessor: exception: Connection reset by peer\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T19:29:36.154350285Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0026 1:10:41.472167 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/help-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:08:33.309870322Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0026 1:10:41.641033 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/ui-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:08:33.478022393Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0026 1:10:41.967785 [ 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\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:08:33.805088252Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-3853 1:13:51.281164 [ client_ws_0017 ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:11:43.121311837Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-1880 1:13:51.305808 [ prsnr_req_hdl ] ERR SocketProcessor: exception: Connection reset by peer\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:11:43.143244271Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0024 1:14:01.890282 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/help-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:11:53.727312985Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0024 1:14:02.032592 [ client_req_hdl ] ERR FileServerRequestHandler: File not found: /usr/share/loolwsd//loleaflet/dist/l10n/ui-sr.json\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:11:53.869592424Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-0024 1:14:02.327914 [ 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\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:11:54.165132349Z”}
{“log”:"\u001b[1m\u001b[33mwsd-00022-0026 1:14:11.679171 [ client_ws_001a ] WRN Connection closed.\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:12:03.517293868Z”}
{“log”:"\u001b[1m\u001b[31mwsd-00022-3868 1:14:11.700800 [ prsnr_req_hdl ] ERR SocketProcessor: exception: Connection reset by peer\u001b[0m\r\n",“stream”:“stdout”,“time”:“2016-11-16T20:12:03.538062059Z”}


Collabora app doesn appear in nextcloud
#11

i have solved all my Problems. I Wrote an Guide in German… Sorry but the blog post is not available . I write an new one https://larsmueller.net/collaboracode-mit-nextcloud-verbinden/


#12

Hi, how much would you ask to setup server for me on DigitakOcean ?


#13

Hello Neso, could you please tell us more about how you resolved the UNAUTHORIZED WOPI HOST problem? I am kinda stuck now. I have compiled libreoffice and all the other tools myself (no docker image) and I can open any file through web browser (test page on https://office.mydomain.com:9980/loleaflet/dist/loleaflet.html?file_path=file:///opt/loolwsd/test/data/hello-world.odt) and I can open in two browsers, all changes are represented on both devices immediately.

In my nextCloud I have the Collabora online connector and URL set to https://office.mydomain.com:9980 (without the port it goes straight to “Well this is embarrasing” error).

Thanks in advance.


#14

So I have found the solution for UNAUTHORIZED WOPI HOST, it was in the loolwsd.xml.in and loolwsd.xml settings. I did not include nextcloud.mydomain.com in there (with escaped dots, ie. nextcloud.mydomian.com, with the docker image, make sure you start the image with domain=nextcloud\.mydomain\.com, as it need to be escaped twice).

But I still cannot open a file through nextcloud, it only opens if I go straight to the direct URL in the browser. In loolwsd.log it ends with ERR Error in client request handler: Timeout| wsd/LOOLWSD.cpp1013

Any ideas?


#15

I am adding hosts like this:

docker ps
then
docker kill CONTAINER ID (you get this CONTAINER ID from docker ps command)
and then execute this:

docker run -t -d -p 127.0.0.1:9980:9980 -e ‘domain=subdomain\.domain\.com|subdomain2\.domain\.com’ --restart always --cap-add MKNOD collabora/code

Every time I execute that when wish to add new allowed host.


#16

Thanks. I have solved it in loolwsd.xml directly because I have compiled it myself. But I have two test VMs and one with docker and one with compiled libreoffice manually. Both are having same error: It starts the user interface with edit buttons when opening a document, but then the loader turns and turns and after a while it write “Well its embarrassing” and docker logs and loolwsd logs write the same - ERR Error in client request handler: Timeout| wsd/LOOLWSD.cpp.