Roll Your Own Google Docs with Collabora On ownCloud
1#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
01. Log into the Linux device
02. 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
01. Launch XCA
02. Open the PKI database if it is not already (File ≫ Open DataBase), enter password
03. Click on the Certificates tab, right click on your Intermediate CA certificate
04. Select New
05. On the Source tab, make sure Use this Certificate for signing is selected
06. Verify your Intermediate CA certificate is selected from the drop down
07. Click the Subject tab
08. 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
09. 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
01. In XCA, click on the Certificates tab
02. Right click the Intermediate CA certificate ≫ Export ≫ File
03. Set the file name CA.pem and verify the export format is PEM chain (*.pem)
04. Click OK
05. Right click the SSL certificate ≫ Export ≫ File
06. Set the file name with a .crt extension and verify the export format is PEM (*.crt)
07. Click OK
08. Click the Private Keys tab
09. 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
01. Download WinSCP https://winscp.net/eng/downloads.php
02. Extract WinSCP and run the executable
03. Connect to the Collabora Online server via WinSCP
04. Copy the created .crt, .key and .pem files to ~/
05. 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
06. 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≫
07. Press CTRL+W and search for ≪wopi
08. Add a new host for the DNS name of the ownCloud server
≪host allow=true"≫nettools.i12bretro.local≪/host≫
09. 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
11. Paste the following into code.conf
Options -Indexes
#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
....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