Roll Your Own Google Docs with Collabora On ownCloud

#ownCloud #Debian #Self-Hosted

Full steps can be found at https://i12bretro.github.io/tutorials/0169.html

Prerequisites

• A XCA PKI database https://youtu.be/ezzj3x207lQ

Installing Collabora Office

1. Log into the Linux device
2. Run the following commands in a terminal:

# install signing key
sudo apt‐key adv ‐‐keyserver keyserver.ubuntu.com ‐‐recv‐keys 0C54D189F4BA284D
# add software repository
sudo echo 'deb https://www.collaboraoffice.com/repos/CollaboraOnline/CODE‐debian10 ./' >> sudo /etc/apt/sources.list
# update software repositories
sudo apt update
# install loolwsd and code‐brand
sudo apt install loolwsd code‐brand
# enable required Apache modules
sudo a2enmod proxy proxy_wstunnel proxy_http ssl

Creating SSL Certificates

1. Launch XCA
2. Open the PKI database if it is not already (File > Open DataBase), enter password
3. Click on the Certificates tab, right click on your Intermediate CA certificate
4. Select New
5. On the Source tab, make sure Use this Certificate for signing is selected
6. Verify your Intermediate CA certificate is selected from the drop down
7. Click the Subject tab
8. Complete the Distinguished Name section

internalName: nettools.i12bretro.local
countryName: US
stateOrProvinceName: Virginia
localityName: Northern
organizationName: i12bretro
organizationUnitName: i12bretro Certificate Authority
commonName: nettools.i12bretro.local

9. Click the Generate a New Key button
10. Enter a name and set the key size to at least 2048
11. Click Create
12. Click on the Extensions tab
13. Select End Entity from the type list
14. Click Edit next to Subject Alternative Name
15. Add any DNS or IP addresses that the certificate will identify
16. Update the validity dates to fit your needs
17. Click the Key Usage tab
18. Under Key Usage select Digital Signature, Key Encipherment
19. Under Extended Key Usage select Web Server and Web Client Authentication
20. Click the Netscape tab
21. Select SSL Server
22. Click OK to create the certificate

Exporting Required Files

1. In XCA, click on the Certificates tab
2. Right click the Intermediate CA certificate > Export > File
3. Set the file name CA.pem and verify the export format is PEM chain (*.pem)
4. Click OK
5. Right click the SSL certificate > Export > File
6. Set the file name with a .crt extension and verify the export format is PEM (*.crt)
7. Click OK
8. Click the Private Keys tab
9. Right click the private key generated for the SSL certificate > Export > File
10. Set the file name with a .key extension and verify the export format is PEM private (*.pem)
11. Click OK

Applying the Certificates

1. Download WinSCP Download
2. Extract WinSCP and run the executable
3. Connect to the Collabora Online server via WinSCP
4. Copy the created .crt, .key and .pem files to ~/
5. On the Collabora Online server, run the following command in a terminal

sudo cp ~/nettools.i12bretro.local.crt /etc/ssl/certs/
sudo cp ~/nettools.i12bretro.local.key /etc/ssl/certs/
sudo cp ~/CA.pem /etc/ssl/certs/
# edit the configuration file
sudo nano /etc/loolwsd/loolwsd.xml

6. Edit the loolwsd.xml file, find the SSL block and update the cert_file_path, key_file_path and ca_file_path values

<cert_file_path desc="Path to the cert file" relative="false">/etc/ssl/certs/nettools.i12bretro.local.crt</cert_file_path>
<key_file_path desc="Path to the key file" relative="false">/etc/ssl/certs/nettools.i12bretro.local.key</key_file_path>
<ca_file_path desc="Path to the ca file" relative="false">/etc/ssl/certs/CA.pem</ca_file_path>

7. Press CTRL+W and search for <wopi<wopi< li=""></wopi<>
8. Add a new host for the DNS name of the ownCloud server

<host allow=true">nettools.i12bretro.local</host>

9. Press CTRL+O, Enter, CTRL+X
10. Continue the configuration by running the following commands in terminal:

# create CODE proxy configuration file
sudo nano /etc/apache2/conf‐available/code.conf

....Full steps can be found on GitHub [link at the top]

### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro
...
https://www.youtube.com/watch?v=05rkZyiI4_4