Collabora "connecting" delay for 20 seconds

If you guys want, i created a repo for this setup. We could work together to make this work? If you want to help please post in the issue i made and then i’ll add you as owner/maintainer.
https://github.com/ezraholm50/collabora-auto-build

Maybe to start with, the people who have compiled it successfully (hopefully without too much trouble), which OS were you running:

  • Debian 7
  • Debian 8
  • Ubuntu 14.04
  • Ubuntu 16.04

Or anything else?

Stepan,
Get latest libre office, and make it

cd /usr/local/src
git clone git://anongit.freedesktop.org/libreoffice/core
sudo apt-get build-dep libreoffice
./autogen.sh
make
sudo make install

Let me know, it WILL take some time XD

I successfully built libreoffice, loolwsd and lolfleat. I copied the missing css libraries from the docker container. I am also able to access docs and tables from the browser on localhost.
But when I am trying to access the files through nextcloud I only get a blank page … so not entirly blank but the main window is blanc. At the moment I am running loolwsd in the non-deamon mode with the debug output in the command line. And there is no output when I am trying to access through nextclouds richdocuments app. I also tried loolwsd on a seperate subdomain … also no success.

I would appreciate some help. THX.

If I start answering here it will become a flooded thread, I will reply to you personally, but here’s what you need to pay attention to: https://github.com/LibreOffice/online/tree/master/loolwsd/debian

there are loolwsd.postinst and loolwsd.service that answer a lot of questions. You need to use these as a reference and not blindly do it on your build.

I tried it and when doing the make install it fails:

: *****************************************************************
: ERROR: ERROR: Missing files at /usr/local/src/core/solenv/bin/modules/installer/scriptitems.pm line 1197.
: *****************************************************************
Fri Aug 12 10:14:28 2016 (00:12 min.)
Failed to install:  at /usr/local/src/core/solenv/bin/ooinstall line 92.
Makefile:308: recipe for target 'install' failed
make: *** [install] Error 255

I can’t know why it happens, there maybe many reasons. I think this is a question to LibreOffice forum not here. I had no problem building it on debian-like systems. Maybe these links will be helpful:
https://wiki.documentfoundation.org/Development/BuildingOnLinux
https://wiki.documentfoundation.org/Development/Linux_Build_Dependencies

Hi,

I’m using CODE from the docker image (5.1-1) and NEXTCLOUD (9.52) on a powerful Ubuntu 16.04 server. Everything works fine but I observe also the delay when loading documents.

Since the installation via DOCKER is very comfortable I’m interested in knowing whether the DOCKER or CODE experts have ideas to improve the loading performance. If it helps I can provide more details and logs.

Thanks for the great work!

Maarten

1 Like

Perhaps the issue is solved but not with the official docker image… Here on debian 8.5, apache.

Also have this latence to load the document.
Save and use of the document work fine.

I have a Virtual Private Server at OVH, arm 1 core 2,4Ghz 2GO RAM SSD 10Go
Ubuntu 16.04.1 with Apache2 PHP7 MariaDB10.1

It’s a better idea to do this than to use Docker.

I started to compile it but, it’s really long.
You need to compile first loolwsd and then loleaflet;

But when i want to compule loolwsd, i have to compile libreoffice beforce (1GB just the source)

I’m sure it worth it, i cross fingers.

I have also compiled everything for the last version, but now we have the next version and i am to lazy to do it again. So i copied collabora online out of the container, and it works:

Create user lool, group lool

copy with: sudo docker cp container-name:path path

collaboraoffice
/opt/collaboraoffice5.1

Libreoffice online
/usr/bin/loolforkit
/usr/bin/loolmap
/usr/bin/loolmount
/usr/bin/looltool
/usr/bin/loolwsd
/usr/bin/loolwsd-systemplate-setup
/etc/loolwsd/
/usr/share/loolwsd/
/usr/share/loolwsd/loleaflet/

poco
/usr/lib/libPocoCrypto.so.42
/usr/lib/libPocoFoundation.so.42
/usr/lib/libPocoJSON.so.42
/usr/lib/libPocoNet.so.42
/usr/lib/libPocoNetSSL.so.42
/usr/lib/libPocoUtil.so.42
/usr/lib/libPocoXML.so.42

set cap:
sudo setcap cap_fowner,cap_mknod,cap_sys_chroot=ep /usr/bin/loolforkit
sudo setcap cap_sys_admin=ep /usr/bin/loolmount

create new (mkdir, chown -R lool:lool…)
/var/cache/loolwsd/
/opt/lool/child-roots/

create: sudo /usr/bin/loolwsd-systemplate-setup /opt/lool/systemplate /opt/lool/collaboraoffice5.1
/opt/lool/systemplate/
sudo chown -R /opt/lool/systemplate

Install your certificates to /etc/loolwsd/
adapt configuration to your certificates /etc/loolwsd/loolwsd.xml

run: sudo -u lool /usr/bin/loolwsd --o:sys_template_path=/opt/lool/systemplate --o:lo_template_path=/opt/collaboraoffice5.1 --o:child_root_path=/opt/lool/child-roots --o:file_server_root_path=/usr/share/loolwsd

1 Like

hello,

Here is my log when i try this command sudo /usr/bin/loolwsd-systemplate-setup /opt/lool/systemplate /opt/lool/collaboraoffice5.1 :

find: ‘lib/ld-’: No such file or directory
find: ‘lib64/libcap
’: No such file or directory
find: ‘lib/libattr*’: No such file or directory
find: ‘lib/libnss_’: No such file or directory
find: ‘lib64/libnss_
’: No such file or directory
find: ‘var/cache/fontconfig’: No such file or directory
find: ‘usr/lib/locale/en_US.utf8’: No such file or directory
find: ‘usr/lib/locale/locale_archive’: No such file or directory
find: ‘usr/lib/libpng*’: No such file or directory
find: ‘usr/lib64/libpng*’: No such file or directory
find: ‘lib/ld-’: No such file or directory
find: ‘lib/libnss_
’: No such file or directory
find: ‘lib64/libnss_’: No such file or directory
find: ‘lib64/libcap
’: No such file or directory
find: ‘lib/libattr*’: No such file or directory
find: ‘usr/lib/libpng*’: No such file or directory
find: ‘usr/lib64/libpng*’: No such file or directory
find: ‘/usr/lib64’: No such file or directory
cpio: /opt/lool/systemplate/lib/x86_64-linux-gnu/libc.so.6 not created: newer or same age version exists
cpio: /opt/lool/systemplate/lib/x86_64-linux-gnu/libdl.so.2 not created: newer or same age version exists
cpio: /opt/lool/systemplate/lib/x86_64-linux-gnu/libgcc_s.so.1 not created: newer or same age version exists
cpio: /opt/lool/systemplate/lib/x86_64-linux-gnu/libm.so.6 not created: newer or same age version exists
cpio: /opt/lool/systemplate/lib/x86_64-linux-gnu/libpthread.so.0 not created: newer or same age version exists
cpio: /opt/lool/systemplate/lib/x86_64-linux-gnu/librt.so.1 not created: newer or same age version exists
cpio: /opt/lool/systemplate/usr/lib/x86_64-linux-gnu/libstdc++.so.6 not created: newer or same age version exists

I got the same messages, but the systemplate folder was filled with content. So it was no problem for me.

OKay, so something is missing :
/usr/bin/lool doesn’t exist…

How this file is created ? does something’s missing in your HOW TO ?

Sorry, i have typed the wrong name in my description, you have to run /usr/bin/loolwsd

Thanks.

Now i’m missing Poco library for lunching Lool. Should i install it with apt-get or from source ?

Install it from source. And you do need the full Version.

http://pocoproject.org/releases/poco-1.7.4/poco-1.7.4-all.tar.gz

Most comfortable is to configure it with an install path and then do make install. Cause the library location shouldnt change.

https://raw.githubusercontent.com/pocoproject/poco/poco-1.7.4/README

These are the bulding instructions for poco.

I would also suggest to proceed the same way with loolwsd. Install path /usr. When I am back at home I will Upload the content of my loolwsd.xml file and the service file for systemd.

I have added the poco files to the copy description

poco
/usr/lib/libPocoCrypto.so.42
/usr/lib/libPocoFoundation.so.42
/usr/lib/libPocoJSON.so.42
/usr/lib/libPocoNet.so.42
/usr/lib/libPocoNetSSL.so.42
/usr/lib/libPocoUtil.so.42
/usr/lib/libPocoXML.so.42

Alright some news :

I ve got made the cp for Poco Library

Now i stop the lool docker and start the lool server.

After changing the server name in the admin panel, and putting the good cert from letsencrypt here is the error when i try to open a file :

[ client_req_hdl ] Preprocessing file: /usr//loleaflet/dist/loleaflet.html
[client_req_hdl ] FileServerR
equestHandler: File not found: /usr//loleaflet/dist/loleafl
et.html

There is an error in the file path : /usr//loleaflet
It should be /usr/share/loolwsd/loleaflet ?

Where is the file i have to modify ?
Is it in loolwsd.xml ?

Thank you for your help

EDIT :
So just open loolwsd.xml
Search for the line about loleaflet folder and configure it at follow : /usr/share/loolwsd (do not put / after loolwsd)

And then it works !!!
No 20 seconds to wait, UTF8 working no problems with é à etc…

Great.