Collabora Online / CODE (LibreOffice Online) with ownCloud

anon30676603 · August 11, 2016, 7:42am

The Collabora Project is targeting to bring LibreOffice into your browser. There are currently two integration possibilities with ownCloud:

The “CODE” VM shipping a complete ownCloud and Collabora Online Setup

This VM is available for download at the following page:

https://www.collaboraoffice.com/code/

Further setup instructions are available here: https://www.collaboraoffice.com/code-vm-setup-instructions/
Integration into an existing ownCloud installation via the “Collabora Online connector” app

Unfortunately there are install instructions missing for Collabora Online / LibreOffice Online ( How do I install this? · Issue #6 · owncloud/richdocuments · GitHub ). However for easy setup a docker image is provided which can be used to integrate Collabora Online into ownCloud:

https://www.collaboraoffice.com/code/

To setup this docker image the following tutorials are available:

Nextcloud Office - Self-hosted online office suite For Apache
Icewind.nl For nginx

Afterwards the “Collabora Online connector” app from Marketplace can be installed.

Where to report bugs / issues

Issues / Bugs within the “Collabora Online connector” should be reported to GitHub · Where software is built
Issues with LibreOffice Online / CODE or the CODE docker image should be reported to Bug List

anon30676603 · August 12, 2016, 6:05pm

Some issues i was facing when trying to get this to run on my Debian Jessie (Got a “We are sorry, this is an unexpected connection error. Please try again” error).

You need the Linux Image from Debian Jessie Backports (currently 4.6+74~bpo8+1), probably for the same reason why the docker container is not supported on Ubuntu 14.04
It might be needed that you start your docker container with the --dns parameters like:
docker run -t -d -p 127.0.0.1:9980:9980 -e "domain=cloud\.example.\.com" --dns 8.8.8.8 --dns 8.8.4.4 --restart always --cap-add MKNOD collabora/code
If you’re running an iptables script / firewall make sure that you’re starting docker afterwards as it will add some additional NAT rules to your iptables

When using the documents app you also need to disable that app before you’re able to set the server name in your admin backend. Afterwards you can enable the documents app again:

anon30676603 · September 30, 2016, 7:23pm

Seems some one has now write down the needed steps how to install that app and build LibreOffice Online from source here:

gist.github.com

https://gist.github.com/m-jowett/0f28bff952737f210574fc3b2efaa01a

log.md

# Setup LibreOffice Online (Log/Guide) [WIP]

## About

This guide/log is based off my experience attempting to build and install
LibreOffice Online and it's dependencies on my system.

The end goal is to get LibreOffice Online integrated with [Karoshi Server](https://github.com/the-linux-schools-project/karoshi-server).

LibreOffice Online is still in development (17/06/16).

This file has been truncated. show original

anon30676603 · October 1, 2016, 12:04pm

There is also an issue with the app itself if you’re restricting it to a specific group:

github.com/owncloud/richdocuments

documents won't open if app is restricted to user group

opened 10:03PM - 23 Aug 16 UTC

nextgen-networks

bug

Found an issue by restricting Collabora Online connector 1.1.4 to an specific ow…nCloud/nextcloud user-group. ![image](https://cloud.githubusercontent.com/assets/21206978/17911429/c7f9cec2-698d-11e6-9427-e02458a80f56.png) Maybe this happens only when using collabora online within an docker container on an other server than ownCloud/nextcloud is hosted. If configured as mentioned above the document file can be clicked but won't be opened by collabora online. "unexpected error" message appears. It seems collabora cant communicate with the ownCloud/nextcloud app. ![image](https://cloud.githubusercontent.com/assets/21206978/17911460/e34bd148-698d-11e6-866a-878f941bc535.png) Further information about the setup can be found here (german only by now - sorry): https://www.2good4you.net/blog/19-web-stuff/6-collabora-online-unter-debian-8

It currently also won’t work if encryption is in use:

github.com/owncloud/richdocuments

richdocuments not working with encryption

opened 06:20PM - 30 Jul 16 UTC

closed 01:25PM - 06 Jun 17 UTC

SpiGAndromeda

bug help wanted

Hi, I also posted this issue in the nextcloud support forum but they suggested …to post this issue here: [https://help.nextcloud.com/t/collabora-not-working-with-encryption/1913](url) I am using Collabora via the docker container. OS is Ubuntu 14.04. Before you ask ... CONFIG_AUFS_XATTR=y is activated in the kernel. The Nextcloud configuration: "system": { "instanceid": "oc42b8zohyfj", "passwordsalt": "**_REMOVED SENSITIVE VALUE**_", "secret": "**_REMOVED SENSITIVE VALUE**_", "trusted_domains": [ "localhost", "**_REMOVED SENSITIVE VALUE**_" ], "datadirectory": "**_REMOVED SENSITIVE VALUE**_", "overwrite.cli.url": "http:\/\/localhost\/owncloud", "dbtype": "mysql", "version": "9.0.52.0", "dbname": "nextcloud_database", "dbhost": "localhost", "dbtableprefix": "nc_", "dbuser": "**_REMOVED SENSITIVE VALUE**_", "dbpassword": "**_REMOVED SENSITIVE VALUE**_", "logtimezone": "UTC", "installed": true, "mail_smtpmode": "php", "mail_smtpsecure": "tls", "mail_smtpport": "587", "mail_smtphost": "smtp.gmail.com", "mail_from_address": "**_REMOVED SENSITIVE VALUE**_", "mail_domain": "gmail.com", "mail_smtpauth": 1, "mail_smtpname": "**_REMOVED SENSITIVE VALUE**_", "mail_smtppassword": "**_REMOVED SENSITIVE VALUE**_", "memcache.local": "\OC\Memcache\APCu", "theme": "fancy", "loglevel": 3, "maintenance": false, "singleuser": false, "htaccess.RewriteBase": "\/owncloud", "integrity.check.disabled": true, "mail_smtpauthtype": "LOGIN", "default_language": "de", "defaultapp": "files", "enable_previews": true, "preview_max_scale_factor": 10, "preview_max_filesize_image": 5, "forcessl": true, "forceSSLforSubdomains": true } "apps": { "richdocuments": { "enabled": "yes", "installed_version": "1.1.3", "ocsid": "174727", "types": "", "wopi_url": "https:\/\/owncloud.spigomaniac.de" } } So i get the following error if I try to open any document with richdocuments: ![screenshot 2016-07-25 14 11 20](https://cloud.githubusercontent.com/assets/15141351/17272211/d444ab9e-5690-11e6-93f2-a56e2800e9d7.png) I guess the key error message is: Private Key missing for user: please try to log-out and log-in again. Fristly I already confirmed the encryption as the reason, because with a test user and temporairily disabled encryption it is fully working. Secondly I used the CODE VM for testing. I upgraded owncloud to the latest version of nextcloud, enabled encryption and it's working! Under the assumption that this richdocuments app is just an updeted version of the app used in the CODE VM some updates between this versions seems to have broken the encryption support. Another issue that could be connected to this one is the file loading delay (20s - 30s): ![screenshot 2016-07-30 20 19 16](https://cloud.githubusercontent.com/assets/15141351/17272293/061c65ba-5693-11e6-84d7-0c0840f504cf.png)

and also not if you have shared a folder on an external storage to other users: Unable to open files stored in an external storage · Issue #83 · owncloud/richdocuments · GitHub

anon30676603 · November 11, 2016, 11:54am

With a recent update of the CODE docker image you can now specify the username/password combination in the docker startup like:

-e 'username=admin' -e 'password=123456'

Afterwards you can access the admin backend accessible at:

https://office.example.com/loleaflet/dist/admin/admin.html (example)