Nethserver-collabora CODE testing and discussion

mark_nl · September 16, 2018, 8:13pm

I think its truncated here.

mrmarkuz · September 16, 2018, 8:16pm

OMG, putty nano copy paste error…will be fixed soon.

loolconfig set admin_console.secure_password pbkdf2.sha512.10000.84de78d224a447158478da8b9717c3b66ac842e7217ac6b79bf864cf2cbc2d0be5b76818dd397502286295f8d31742564e0b31efac46fb6dffb6bd10ac9aacd1861af5c3311c749bc046608ee47d86f2978eedf78819bbde26e620d886eed4192234517ff1585c93dc6fde0166ba714268c89f7c41eefd77ada783ad86266dd7.1e2ecb9a387f3f5d48d167cde908f72f115c131307e556eb9c30227ffdfcf4843e3cea4fa80c4bfb830c2c1ab64c920a1902785e06c02f9365778cfd863a6fc0736db0b708a11231e2ecd47a5210b55bef7f7b0ce2f84c820b144313567845a5fa4e5b18c10d021dac5d99fb6e44876f6d39763b341a2b1533355c2485f6e248

EDIT: fixed

EDIT2:

Thanks, I added the service restart in form of signal-event nethserver-collabora-update to the wiki entry.

mark_nl · September 16, 2018, 9:18pm

or restart it by default on a nethserver-collabora-update event, again just a suggestion:
https://github.com/mrmarkuz/nethserver-collabora/pull/1/commits/bbc100d8711c910d9e12a12ad9e4c292aa80deb2

mrmarkuz · September 16, 2018, 9:20pm

Thx, I thought I entered the restart already…

EDIT:

I managed to change to http, it was easy, seems loolwsd uses port 9981 when running http.

EDIT2:

No, seems not so easy, collabora not working, only admin interface

mark_nl · September 16, 2018, 9:49pm

Very nice! EDIT oke work to be done…

BTW I have dificuties finding documentation, and man loolconfig does not give much too.
Did you find any, or (also) trial and error?

mrmarkuz · September 16, 2018, 9:53pm

Me too, I am afraid there’s not much documentation.
I am going with trial/error method too

EDIT:

BTW, for additional custom config you may have look at the links by @dnutan :

mark_nl · September 16, 2018, 9:56pm

Respect for the achievement to get it up and running so good!

mrmarkuz · September 16, 2018, 9:59pm

Thanks for your support and code commit, really appreciate it.

mark_nl · September 24, 2018, 10:52am

Found some info, seems you need a key file even if ssl is disabled i.e HTTP is used:

github.com

LibreOffice/online/blob/master/wsd/README#L185


      
          
              openssl req -sha256 -new -key key.pem -out csr.pem
          
              # change "unique_subject = yes" to "unique_subject = no" in demoCA/index.txt.attr
              # otherwise you'll get the following error:
              #   failed to update database
              #   TXT_DB error number 2
          
              openssl ca -keyfile private/ca.key.pem -cert ca.cert.pem -extensions usr_cert -notext -md sha256 -in csr.pem -out cert.pem
          
          HTTPS is the default. HTTP-only mode can be enabled with --disable-ssl
          configure option.
          
          If you plan to hack on loolwsd, you probably want to familiarize
          yourself with loolwsd's --o:num_prespawn_children switch, and the 'connect'
          test program.
          
          For interactive testing, you can use the 'connect' program. It accepts
          "commands" from the protocol on standard input.

Also managed to build loolwsd from source but it’s not working yet, curl pit seems to be setting up the jail chroot in a proper way. This is done quite unconventional by running loolwsd-systemplate-setup script at install (%post):

github.com

LibreOffice/online/blob/3.3.1-final/loolwsd-systemplate-setup

#!/bin/bash

test $# -eq 2 || { echo "Usage: $0 <chroot template directory for system libs to create> <LO installation directory>"; exit 1; }

# No provision for spaces or other weird characters in pathnames. So sue me.

CHROOT=$1
INSTDIR=$2

test -d "$INSTDIR" || { echo "No such directory: $INSTDIR"; exit 1; }

mkdir -p $CHROOT || exit 1

CHROOT=`cd $CHROOT && /bin/pwd`
INSTDIR=`cd $INSTDIR && /bin/pwd`

cd / || exit 1

(
# Produce a list of file names, one per line, that will be copied

This file has been truncated. show original

Need to figure out what it does…

pagaille · December 20, 2018, 8:52pm

Hey @mrmarkuz, did I say thank for that module ?

I successfully installed it using the manual installation following your first post but recently upgraded to NC 15, which broke the installation. Now I get a white page when I create or open a document.

I tried to install your nethserver-collabora module but same result.

The admin page leads to NC’s usual file page, like if there is a redirect.

In Apache’s access_log I see 500 errors when acceding to the richdocumentsapp (when opening a document file).

Do you observe this behaviour as well ?
Matt

mrmarkuz · December 20, 2018, 11:47pm

First, thanks for testing!

I think I could reproduce it. Fresh install worked but updating is a problem.
After updating CODE from 3.4 to 4.0 the updated /etc/loolwsd/loolwsd.xml (including the new paths to collabora 6 instead of 5.3) is saved as loolwsd.xml.rpmnew but loolwsd continues working with the old loolwsd.xml and that leads to the white screen.

Workaround until I can provide an updated module, I’ll update the wiki too.

mv /etc/loolwsd/loolwsd.xml /etc/loolwsd/loolwsd.xml.old
mv /etc/loolwsd/loolwsd.xml.rpmnew /etc/loolwsd/loolwsd.xml`
signal-event nethserver-collabora-update

As you use a new default config file, you have to set the password again, see the wiki

I couldn’t reproduce this one, do you use a vhost for nextcloud?

pagaille · December 21, 2018, 4:04am

Everything working, THANKS

Indeed. Using the “real” server name worked.

danb35 · January 12, 2019, 11:51am

Curious if this is currently installing CODE 4.0–document editing using the mobile client apps would be a big win.

mrmarkuz · January 12, 2019, 11:54am

Yes, it should use the newest one from collabora repo.

danb35 · January 12, 2019, 1:50pm

Cool, once 7.6 hits the subscription repo I’ll give it a try.

Why does the wiki call for yum install nethserver-nextcloud as a separate step? Seems it’d be simpler to just have it as a Requires: for nethserver-collabora.

mrmarkuz · January 12, 2019, 2:18pm

You are right, it’s the same with onlyoffice.
The intention was to be extra flexible and have the possibility to have them on separate machines.

danb35 · January 12, 2019, 2:22pm

Ah, that does make some sense too–hadn’t thought about that scenario.

dnutan · January 12, 2019, 2:24pm

Or if other applications supporting Collabora CODE are integrated in the future.

giacomo · January 14, 2019, 9:33am

We have a testing machine running collabora integrated with Nextcloud.
It’s not rock solid, but it works for simple documents.

An alpha release it’s in my agenda since long time, let’s see if now it is stable enough

I hope also webtop will use it. Ehi @webtop_team any news on it?

pagaille · January 14, 2019, 11:47am

That’s also my experience : ok for small documents but even integrating a picture or two leads to annoying display and functional bugs. Much better than nothing though.

I wish a full HTML5 editor even with less features (except collaborative editing which is a must) exists.