Collabora - LibreOffice als Cloud

Hintergrund: Eigene Online-Office Suite als reine Web-Anwendung, OpenSource, basierend auf LibreOffice
Installation erfolgt auf einer Test-Maschine die als Ubuntu16.04 (Server) neu aufgesetzt wurde.

Voraussetzung:

Collabora arbeitet nicht "allein", sondern benötigt eine Sync&Share-Anwendung, die sich als Basis eignet. In diesem Beispiel wird eine Nextcloud-Installation verwendet. Collabora wird von dieser Installation aus als WOBI-URL eingebunden

1. Installation Von Nextcloud

1.1 Benötigte Ubuntu-Pakete installieren:

apt-get install apache2 mariadb-server libapache2-mod-php7.0 apt-transport-https
apt-get install php7.0-gd php7.0-json php7.0-mysql php7.0-curl php7.0-mbstring
apt-get install php7.0-intl php7.0-mcrypt php-imagick php7.0-xml php7.0-zip
apt-get install php7.0-ldap

1.2 Download von Netxcloud

Der Download erfolgt über diese Adresse:
https://download.nextcloud.com/server/releases/nextcloud-12.0.0.zip
Entpacken nach:
/var/www/html/netxcloud

1.3 Anlegen einer Site-Configuration im Apache mit der Datei /etc/apache2/sites-avaliable/netxtcloud.conf:
Alias /nextcloud "/var/www/html/nextcloud/"

<Directory /var/www/html/nextcloud/>
  Options +FollowSymlinks
  AllowOverride All

 <IfModule mod_dav.c>
  Dav off
 </IfModule>

 SetEnv HOME /var/www/html/nextcloud
 SetEnv HTTP_HOME /var/www/html/nextcloud

</Directory>

Anschließend aktivieren mitb "a2ensite nextcloud"

1.4 Einrichten einer Mariadb-Datenbank:

create database nextcloud character set utf8 collate utf8_bin;
grant select,insert,update,delete,create,drop,alter,index on nextcloud.* to 'nextcloud'@'localhost' identified by '<passwd>';

1.5 Erst-Konfiguration Nextcloud

  Im Browser aufrufen:
    https://<meinserver.<meinedomain>.de/nextcloud/index.php
        • Administrator: admin <adminpasswd>
        • Datenbank: localhost, User nextcloud, Passwort <passwd>

Optional: Anbindung an einen AD-Controller
    • LDAP-Authentifikation (AD)
        • Modul LDAP aktivieren (Einstellungen-> AddOns)
        • Administraton -> LDAP/AD Integration
            - Host: <AD-Domäne>
            - User-DN: AD-User
            - Base-DN: <Domänen-Basis>
            - Filter:(&(objectCategory=Person)(sAMAccountName=*)(!(UserAccountControl:1.2.840.113556.1.4.803:=2)))

2. Collabora-Installations-Beschreibung für Ubuntu 16.04:

Beschreibung unter
https://www.collaboraoffice.com/code/ und
https://www.collaboraoffice.com/code/#packages_for_linux_x86_64_platform
Falls ein Proxy verwendet werden muss, wird dieser in der apt-Konfiguration angegeben::

/etc/apt/apt.conf.d/00proxy
Acquire::http::Proxy "http://proxy.example.de:80";
Acquire::https::Proxy "http://proxy.example.de:80";


2.1 Hinzufügen der Repositories für Collabora


# import the signing key
apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 0C54D189F4BA284D

# add the repository URL to /etc/apt/sources.list
echo 'deb https://collaboraoffice.com/repos/CollaboraOnline/CODE ./' >> /etc/apt/sources.list

2.2 Installation der collabora-Pakete
# perform the installation
apt-get update && apt-get install loolwsd code-brand


2.3 Anpassen der Konfiguration für den "Libre Office Online Websocket Daemon" (loolwsd) unter  /etc/loolwsd/loolwsd.xml Diese ist ein zentraler Punkt und muss etwas genauer vorgestellt werden. Hier ist eine Beispiel-Konfiguration abgebildet, zu verändernde Parameter sind fett hervorgehoben:

<config>

    <!-- Note: 'default' attributes are used to document a setting's default value as well as to use as fallback. -->
    <!-- Note: When adding a new entry, a default must be set in WSD in case the entry is missing upon deployment. -->

    <allowed_languages desc="List of supported languages on this instance." default="de_DE en_GB en_US es_ES fr_FR it nl pt_BR pt_PT ru">de_DE en_GB en_US es_ES fr_FR it nl pt_BR pt_PT ru</allowed_languages>

    <tile_cache_path desc="Path to a directory where to keep the tile cache." type="path" relative="false" default="/var/cache/loolwsd"></tile_cache_path>
    <sys_template_path desc="Path to a template tree with shared libraries etc to be used as source for chroot jails for child processes." type="path" relative="true" default="systemplate"></sys_template_path>
    <lo_template_path desc="Path to a LibreOffice installation tree to be copied (linked) into the jails for child processes. Should be on the same file system as systemplate." type="path" relative="false" default="/opt/collaboraoffice5.3"></lo_template_path>
    <child_root_path desc="Path to the directory under which the chroot jails for the child processes will be created. Should be on the same file system as systemplate and lotemplate. Must be an empty directory." type="path" relative="true" default="jails"></child_root_path>

    <server_name desc="Hostname:port of the server running loolwsd. If empty, it's derived from the request." type="string" default=""></server_name>
    <file_server_root_path desc="Path to the directory that should be considered root for the file server. This should be the directory containing loleaflet." type="path" relative="true" default="loleaflet/../"></file_server_root_path>

    <memproportion desc="The maximum percentage of system memory consumed by all of the LibreOffice Online, after which we start cleaning up idle documents" type="double" default="80.0"></memproportion>
    <num_prespawn_children desc="Number of child processes to keep started in advance and waiting for new clients." type="uint" default="1">4</num_prespawn_children>
    <per_document desc="Document-specific settings, including LO Core settings.">
        <max_concurrency desc="The maximum number of threads to use while processing a document." type="uint" default="4">4</max_concurrency>
        <idle_timeout_secs desc="The maximum number of seconds before unloading an idle document. Defaults to 1 hour." type="uint" default="3600">3600</idle_timeout_secs>
        <!-- Idle save and auto save are checked every 30 seconds -->
        <idlesave_duration_secs desc="The number of idle seconds after which document, if modified, should be saved. Defaults to 30 seconds." type="uint" default="30">30</idlesave_duration_secs>
        <autosave_duration_secs desc="The number of seconds after which document, if modified, should be saved. Defaults to 5 minutes." type="uint" default="300">300</autosave_duration_secs>
        <limit_virt_mem_kb desc="The maximum virtual memory allowed to each document process. 0 for unlimited, 1700 min." type="uint">0</limit_virt_mem_kb>
        <limit_data_mem_kb desc="The maximum memory data segment allowed to each document process. 0 for unlimited." type="uint">0</limit_data_mem_kb>
        <limit_stack_mem_kb desc="The maximum stack size allowed to each document process. 0 for unlimited." type="uint">8000</limit_stack_mem_kb>
        <limit_file_size_mb desc="The maximum file size allowed to each document process to write. 0 for unlimited." type="uint">200</limit_file_size_mb>
        <limit_num_open_files desc="The maximum number of files allowed to each document process to open. 0 for unlimited." type="uint">0</limit_num_open_files>
    </per_document>

    <per_view desc="View-specific settings.">
        <out_of_focus_timeout_secs desc="The maximum number of seconds before dimming and stopping updates when the browser tab is no longer in focus. Defaults to 60 seconds." type="uint" default="60">60</out_of_focus_timeout_secs>
        <idle_timeout_secs desc="The maximum number of seconds before dimming and stopping updates when the user is no longer active (even if the browser is in focus). Defaults to 15 minutes." type="uint" default="900">900</idle_timeout_secs>
    </per_view>

    <loleaflet_html desc="Allows UI customization by replacing the single endpoint of loleaflet.html" type="string" default="loleaflet.html">loleaflet.html</loleaflet_html>

    <logging>
        <color type="bool">true</color>
        <level type="string" desc="Can be 0-8, or none (turns off logging), fatal, critical, error, warning, notice, information, debug, trace" default="warning">warning</level>
        <file enable="false">
            <property name="path" desc="Log file path.">/var/log/loolwsd.log</property>
            <property name="rotation" desc="Log file rotation strategy. See Poco FileChannel.">never</property>
            <property name="archive" desc="Append either timestamp or number to the archived log filename.">timestamp</property>
            <property name="compress" desc="Enable/disable log file compression.">true</property>
            <property name="purgeAge" desc="The maximum age of log files to preserve. See Poco FileChannel.">10 days</property>
            <property name="purgeCount" desc="The maximum number of log archives to preserve. Use 'none' to disable purging. See Poco FileChannel.">10</property>
            <property name="rotateOnOpen" desc="Enable/disable log file rotation on opening.">true</property>
            <property name="flush" desc="Enable/disable flushing after logging each line. May harm performance. Note that without flushing after each line, the log lines from the different processes will not appear in chronological order.">false</property>
        </file>
    </logging>

    <loleaflet_logging desc="Logging in the browser console" default="false">false</loleaflet_logging>

    <trace desc="Dump commands and notifications for replay. When 'snapshot' is true, the source file is copied to the path first." enable="false">
        <path desc="Output path to hold trace file and docs. Use '%' for timestamp to avoid overwriting. For example: /some/path/to/looltrace-%.gz" compress="true" snapshot="false">/tmp/looltrace-%.gz</path>
        <filter>
            <message desc="Regex pattern of messages to exclude"></message>
        </filter>
        <outgoing>
            <record desc="Whether or not to record outgoing messages" default="false">false</record>
        </outgoing>
    </trace>

    <net desc="Network settings">
      <proto type="string" default="all" desc="Protocol to use IPv4, IPv6 or all for both">IPv4</proto>
    </net>

    <ssl desc="SSL settings">
        <enable type="bool" default="true">true</enable>
        <termination desc="Connection via proxy where loolwsd acts as working via https, but actually uses http." type="bool" default="true">false</termination>
        <cert_file_path desc="Path to the cert file" relative="false">/etc/loolwsd/cert.pem</cert_file_path>
        <key_file_path desc="Path to the key file" relative="false">/etc/loolwsd/key.pem</key_file_path>
        <ca_file_path desc="Path to the ca file" relative="false"></ca_file_path>
        <cipher_list desc="List of OpenSSL ciphers to accept" default="ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH"></cipher_list>
        <hpkp desc="Enable HTTP Public key pinning" enable="false" report_only="false">
            <max_age desc="HPKP's max-age directive - time in seconds browser should remember the pins" enable="true">1000</max_age>
            <report_uri desc="HPKP's report-uri directive - pin validation failure are reported at this URL" enable="false"></report_uri>
            <pins desc="Base64 encoded SPKI fingerprints of keys to be pinned">
            <pin></pin>
            </pins>
        </hpkp>
    </ssl>

    <security desc="Altering these defaults potentially opens you to significant risk">
      <seccomp desc="Should we use the seccomp system call filtering." type="bool" default="true">false</seccomp>
      <capabilities desc="Should we require capabilities to isolate processes into chroot jails" type="bool" default="true">true</capabilities>
    </security>

    <storage desc="Backend storage">
        <filesystem allow="false" />
        <wopi desc="Allow/deny wopi storage. Mutually exclusive with webdav." allow="true">
            <host desc="Regex pattern of hostname to allow or deny." allow="true">localhost</host>
            <host desc="Regex pattern of hostname to allow or deny." allow="true">nextcloudserver.example.com</host>
            <host desc="Regex pattern of hostname to allow or deny." allow="true">::1</host>
            <max_file_size desc="Maximum document size in bytes to load. 0 for unlimited." type="uint">0</max_file_size>
        </wopi>
        <webdav desc="Allow/deny webdav storage. Mutually exclusive with wopi." allow="false">
            <host desc="Hostname to allow" allow="false">localhost</host>
        </webdav>
    </storage>

    <tile_cache_persistent desc="Should the tiles persist between two editing sessions of the given document?" type="bool" default="true">true</tile_cache_persistent>

    <admin_console desc="Web admin console settings.">
        <enable desc="Enable the admin console functionality" type="bool" default="true">true</enable>
        <enable_pam desc="Enable admin user authentication with PAM" type="bool" default="false">false</enable_pam>
        <username desc="The username of the admin console. Ignored if PAM is enabled."></username>
        <password desc="The password of the admin console. Deprecated on most platforms. Instead, use PAM or loolconfig to set up a secure password."></password>
    </admin_console>

    <monitors desc="Addresses of servers we connect to on start for monitoring">
    </monitors>

</config>

Wichting sind hierdiese Abschnitte

  1. "net": Sollte die Verbindung zwischen Nextcloud und loolwsd nicht zustange kommt, sollt als IP-Protokoll die Version 4 (=IPv4) verwendet werden.
  2. "ssl": Die Kommunikation zwischen dem Browser und dem loolwsd läuft SSL-Verschlüsselt. eine Änderung auf unverschlüsselte Kommunikation durch den Parameter "termination" und Anpassung der Apache-Konfig war in meiner Konfiguration nicht hilfreich. Hier kann aber der SSK-Key nebst Zertifikat aus dem Apache-Store verwendet werden, aber er muss an den angegeben Ort kopiert werden, weil der User lool nicht den Provate Key aus dem Apache-Store einshen darf und eine Öffnung der Rechte nicht sinnvoll wäre.
  3. "security" Sollte eine Virtualisierungsumgebung verwendet werden, die das kernel-Mudul "seccomp" nicht verwendet wie z.B. "Virtuozzo", kann dieses mit dem Parameter "seccomp" auf "alse" ausgeschaltet werden. Vorsicht: der Parameter "capabilities" muss aber auf "true" bleiben, weil anderenfalls lool die benötigte Datei nicht findet und mit der Fehlermeldung, der Dateityp könne nicht ermittelt werden, seine Arbeit verweigert.
  4. "storage": Alle Server bzw. Adressen, die den lool nutzen sollen, müssen hier jeweils als separate zeile

 

2.4 Starten der Collabora Software

 systemctl start loolwsd.service

2.5 Anpassen der Apache Config

Anlegen einer Site-Konfig für Apache unter /etc/apache2/sites-avaliable/lool.conf

<VirtualHost *:443>
  ServerName collabora.example.com:443

  # SSL configuration, you may want to take the easy route instead and use Lets Encrypt!
  SSLEngine on
  SSLCertificateFile /path/to/signed_certificate
  SSLCertificateChainFile /path/to/intermediate_certificate
  SSLCertificateKeyFile /path/to/private/key
  SSLProtocol             all -SSLv2 -SSLv3
  SSLCipherSuite ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS
  SSLHonorCipherOrder     on

  # Encoded slashes need to be allowed
  AllowEncodedSlashes NoDecode

  # Container uses a unique non-signed certificate
  SSLProxyEngine On
  SSLProxyVerify None
  SSLProxyCheckPeerCN Off
  SSLProxyCheckPeerName Off

  # keep the host
  ProxyPreserveHost On

  # static html, js, images, etc. served from loolwsd
  # loleaflet is the client part of LibreOffice Online
  ProxyPass           /loleaflet https://127.0.0.1:9980/loleaflet retry=0
  ProxyPassReverse    /loleaflet https://127.0.0.1:9980/loleaflet

  # WOPI discovery URL
  ProxyPass           /hosting/discovery https://127.0.0.1:9980/hosting/discovery retry=0
  ProxyPassReverse    /hosting/discovery https://127.0.0.1:9980/hosting/discovery

  # Main websocket
  ProxyPassMatch "/lool/(.*)/ws$" wss://127.0.0.1:9980/lool/$1/ws nocanon

  # Admin Console websocket
  ProxyPass   /lool/adminws wss://127.0.0.1:9980/lool/adminws

  # Download as, Fullscreen presentation and Image upload operations
  ProxyPass           /lool https://127.0.0.1:9980/lool
  ProxyPassReverse    /lool https://127.0.0.1:9980/lool
</VirtualHost>

Anschließend aktivieren mit a2ensite lool

3. Einbinden in Nextcloud:

3.1 Vorbereitung

Das Plugin für Collabora muss in Nextcloud aus dem Repository von Nextcloud eingebunden werden. Falls der Server die Verbindung nur über einen Proxy aufbauen kann, muss die folgende Einstellung vorgenommen werden:

    Ergänzen in der /var/www/html/nextcloud/config/config.php
'proxy' => 'http://proxy.hs-owl.de:80',

Achtung: Diese Einstellung wird nur für Aktivierung des Collabora-Plugins benötigt. Zur weiteren Konfiguration muss sie wieder entfernt werden, weil sonst der interne Socket nach localhost nicht gefunden wird!!!

Falls für die lool-Umgebung Self Signed Certs verwendt werden, müssen diese im PHP noch übernommen werden:
    #sudo -u www-data php /var/www/nextcloud/occ security:certificates:import /etc/ssl/certs/ssl-cert-snakeoil.pem

Sicherheitstechnisch besser ist jedoch, auch hier offizielle Zertifikate zu verwenden.
    

3.2 Konfiguraton in Nextcloud

Im Web-Portal von Nextcloud als admin-User anmelden und dort unter "Einstellungen" -> "Apps" -> "Büro&Text" ->"Collabora Online" aktivieren
 Dann unter Einstellungen->Administration->Collabora Online die neue URL einstellen:
        https://<collabora-server>

Fertig!

 

Nun können ODT- und Word-Dateien direkt im Portal bearbeitet werden, ohne sie herunter zu laden oder Browser-Plugins zu benutzen. Auch Versionen und gemeinsame Bearbeitung ist hier möglich!