Collabora Online¶

4.3 Enterprise Edition

Collabora Online offers real-time collaboration with office documents in your browser. As soon as you open a file from SeaTable, Collabora opens in a new browser tab and allows real time collaboration. As soon as the last user exits the document by closing his browser window, the document is saved back to the SeaTable base.

This article is about the how to install the CODE version of collabora online.

This manual assumes that SeaTable Enterprise Edition is installed and is running.

Installation¶

1. Change the .env file¶

To install OnlyOffice, include collabora.yml in the COMPOSE_FILE variable within your .env file. This instructs Docker to download the required images for OnlyOffice.

Simply copy and paste () the following code into your command line:

sed -i "s/COMPOSE_FILE='\(.*\)'/COMPOSE_FILE='\1,collabora.yml'/" /opt/seatable-compose/.env

Modify dtable_web_setings.py¶

Now execute the follwogin command to add the required configuration to dtable_web_settings.py. You don't have to replace ${SEATABLE_SERVER_HOSTNAME}. It will replaced automatically.

source /opt/seatable-compose/.env
echo -e "\n# collabora online" >> /opt/seatable-server/seatable/conf/dtable_web_settings.py
echo "ENABLE_COLLABORA = True" >> /opt/seatable-server/seatable/conf/dtable_web_settings.py
echo "COLLABORA_DISCOVERY_URL = 'https://${SEATABLE_SERVER_HOSTNAME}:6232/hosting/discovery'" >> /opt/seatable-server/seatable/conf/dtable_web_settings.py

Download collabora and restart¶

One more step is necessary to download the Collabora container and restart the SeaTable service.

cd /opt/seatable-compose
docker compose down
docker compose up -d

Check if installation is complete¶

Wait for some seconds and then open https://<your-seatable-url>:6232 and you should see simple an OK. This confirms that Collabora Online is up and running. Office documents that you double click in your base should be opened with Collabora Online in a new browser tab.

Advanced: Custom settings¶

Admin interface¶

Collabora Online provides an admin interface, which is disabled by default. Add the following parameters to your .env file to activate it and adapt it to your needs.

COLLABORA_ADMIN=username
COLLABORA_PW=password
COLLABORA_ENABLE_ADMIN_CONSOLE=true

After restarting the Collabora container you can access the admin interface at https://<your-seatable-url>:6232/browser/dist/admin/admin.html.

Activate File Logging¶

To activate File logging of Collabora Online you have to add the following parameter to your .env file:

COLLABORA_ENABLE_FILE_LOGGING=true

After a restart of the container the logs are written to /opt/cool/logs/coolwsd.log. To access this log file at the host system you have to create a folder and change the permission to 777.

mkdir /opt/collabora
chmod 777 /opt/collabora

Now make a copy of the collabora.yml and uncomment the volumes definition in your custom-collabora.yml.

Advanced: Collabora on a separate host and URL¶

Install Collabora¶

Use the predefined yml files to install Collabora on a separate host. Your .env might look like

COMPOSE_FILE='caddy.yml,collabora.yml'
COMPOSE_PATH_SEPARATOR=','

SEATABLE_SERVER_HOSTNAME=<your-collabora-url>
COLLABORA_PORT=443

Have a look at collabora.yml and uncommend and update the value of aliasgroup1.

Configuration of SeaTable server¶

Now update the dtable_web_settings.py on your SeaTable Server.

In addition you have to extend the caddy security headers. Add the URL of your Collabora host to the variables form-action and frame-src in your custom-seatable-server.yml. Don't forget to restart all containers.