0ct0pu5
/
tutorials


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210
							    <!DOCTYPE html>
    <html lang="en" xmlns="http://www.w3.org/1999/xhtml">
      <head>
        <title>Roll Your Own Google Docs with Collabora On ownCloud</title>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <meta charset="UTF-8">
        <meta name="keywords" content="Linux,OwnCloud,PHP,Apache,Self-Hosted,Cloud Solution,Web Based Tools,Collabora,Google Docs,Alternative,PHP Software,Apache HTTPD,Browser Based,Home Lab,Home Lab Ideas,Install Guide,Web Based,Debian,Free Software,Freeware,MariaDB,MySQL,LAMP,System Administration,System Administrator,Web Server,PHP Application,HTTPD,Google Docs Alternative,Self-Hosted Google Docs Alternative,How To,Tutorial,i12bretro">
        <meta name="author" content="i12bretro">
        <meta name="description" content="Roll Your Own Google Docs with Collabora On ownCloud">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="revised" content="10/24/2022 10:35:16 AM" />
				          <link rel="icon" type="image/x-icon" href="includes/favicon.ico">
				  <script type="text/javascript" src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
				        <script type="text/javascript" src="includes/js/steps.js"></script>
        <link href="css/steps.css" rel="stylesheet" type="text/css" />
      </head>
      <body>
        <div id="gridContainer">
          <div class="topMargin"></div>
          <div id="listName" class="topMargin">
            <h1>Roll Your Own Google Docs with Collabora On ownCloud</h1>
          </div>
          <div></div>
          <div id="content">
          <h2>Prerequisites</h2>

<ul>
	<li class="noCheckbox">A XCA PKI database <a href="https://youtu.be/ezzj3x207lQ" target="_blank">https://youtu.be/ezzj3x207lQ</a></li>
</ul>

<h2>Installing Collabora Office</h2>

<ol>
	<li>Log into the Linux device</li>
	<li>Run the following commands in a terminal:
	<div class="codeBlock"># install signing key<br />
	sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 0C54D189F4BA284D<br />
	# add software repository<br />
	sudo echo &#39;deb https://www.collaboraoffice.com/repos/CollaboraOnline/CODE-debian10 ./&#39; &gt;&gt; sudo /etc/apt/sources.list<br />
	# update software repositories<br />
	sudo apt update<br />
	# install loolwsd and code-brand<br />
	sudo apt install loolwsd code-brand<br />
	# enable required Apache modules<br />
	sudo a2enmod proxy proxy_wstunnel proxy_http ssl</div>
	</li>
</ol>

<h2>Creating SSL Certificates</h2>

<ol>
	<li>Launch XCA</li>
	<li>Open the PKI database if it is not already (File &gt; Open DataBase), enter password</li>
	<li>Click on the Certificates tab, right click on your Intermediate CA certificate</li>
	<li>Select New</li>
	<li>On the Source tab, make sure Use this Certificate for signing is selected</li>
	<li>Verify your Intermediate CA certificate is selected from the drop down</li>
	<li>Click the Subject tab</li>
	<li>Complete the Distinguished Name section
	<p>internalName: nettools.i12bretro.local<br />
	countryName: US<br />
	stateOrProvinceName: Virginia<br />
	localityName: Northern<br />
	organizationName: i12bretro<br />
	organizationUnitName: i12bretro Certificate Authority<br />
	commonName: nettools.i12bretro.local</p>
	</li>
	<li>Click the Generate a New Key button</li>
	<li>Enter a name and set the key size to at least 2048</li>
	<li>Click Create</li>
	<li>Click on the Extensions tab</li>
	<li>Select End Entity from the type list</li>
	<li>Click Edit next to Subject Alternative Name</li>
	<li>Add any DNS or IP addresses that the certificate will identify</li>
	<li>Update the validity dates to fit your needs</li>
	<li>Click the Key Usage tab</li>
	<li>Under Key Usage select Digital Signature, Key Encipherment</li>
	<li>Under Extended Key Usage select Web Server and Web Client Authentication</li>
	<li>Click the Netscape tab</li>
	<li>Select SSL Server</li>
	<li>Click OK to create the certificate</li>
</ol>

<h2>Exporting Required Files</h2>

<ol>
	<li>In XCA, click on the Certificates tab</li>
	<li>Right click the Intermediate CA certificate &gt; Export &gt; File</li>
	<li>Set the file name CA.pem and verify the export format is PEM chain (*.pem)</li>
	<li>Click OK</li>
	<li>Right click the SSL certificate &gt; Export &gt; File</li>
	<li>Set the file name with a .crt extension and verify the export format is PEM (*.crt)</li>
	<li>Click OK</li>
	<li>Click the Private Keys tab</li>
	<li>Right click the private key generated for the SSL certificate &gt; Export &gt; File</li>
	<li>Set the file name with a .key extension and verify the export format is PEM private (*.pem)</li>
	<li>Click OK</li>
</ol>

<h2>Applying the Certificates</h2>

<ol>
	<li>Download WinSCP <a href="https://winscp.net/eng/downloads.php" target="_blank">Download</a></li>
	<li>Extract WinSCP and run the executable</li>
	<li>Connect to the Collabora Online server via WinSCP</li>
	<li>Copy the created .crt, .key and .pem files to ~/</li>
	<li>On the Collabora Online server, run the following command in a terminal
	<div class="codeBlock">sudo cp ~/nettools.i12bretro.local.crt /etc/ssl/certs/<br />
	sudo cp ~/nettools.i12bretro.local.key /etc/ssl/certs/<br />
	sudo cp ~/CA.pem /etc/ssl/certs/<br />
	# edit the configuration file<br />
	sudo nano /etc/loolwsd/loolwsd.xml</div>
	</li>
	<li>Edit the loolwsd.xml file, find the SSL block and update the cert_file_path, key_file_path and ca_file_path values
	<p>&lt;cert_file_path desc=&quot;Path to the cert file&quot; relative=&quot;false&quot;&gt;/etc/ssl/certs/nettools.i12bretro.local.crt&lt;/cert_file_path&gt;<br />
	&lt;key_file_path desc=&quot;Path to the key file&quot; relative=&quot;false&quot;&gt;/etc/ssl/certs/nettools.i12bretro.local.key&lt;/key_file_path&gt;<br />
	&lt;ca_file_path desc=&quot;Path to the ca file&quot; relative=&quot;false&quot;&gt;/etc/ssl/certs/CA.pem&lt;/ca_file_path&gt;</p>
	</li>
	<li>Press CTRL+W and search for &lt;wopi<wopi< li=""></wopi<></li>
	<li>Add a new host for the DNS name of the ownCloud server
	<p>&lt;host allow=true&quot;&gt;nettools.i12bretro.local&lt;/host&gt;</p>
	</li>
	<li>Press CTRL+O, Enter, CTRL+X</li>
	<li>Continue the configuration by running the following commands in terminal:
	<div class="codeBlock"># create CODE proxy configuration file<br />
	sudo nano /etc/apache2/conf-available/code.conf</div>
	</li>
	<li>Paste the following into code.conf
	<p>Options -Indexes</p>

	<p>#Encoded slashes need to be allowed<br />
	AllowEncodedSlashes NoDecode</p>

	<p># Container uses a unique non-signed certificate<br />
	SSLProxyEngine On<br />
	SSLProxyVerify None<br />
	SSLProxyCheckPeerCN Off<br />
	SSLProxyCheckPeerName Off</p>

	<p># keep the host<br />
	ProxyPreserveHost On</p>

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

	<p># WOPI discovery URL<br />
	ProxyPass           /hosting/discovery https://127.0.0.1:9980/hosting/discovery retry=0<br />
	ProxyPassReverse    /hosting/discovery https://127.0.0.1:9980/hosting/discovery</p>

	<p># Capabilities<br />
	ProxyPass           /hosting/capabilities https://127.0.0.1:9980/hosting/capabilities retry=0<br />
	ProxyPassReverse    /hosting/capabilities https://127.0.0.1:9980/hosting/capabilities</p>

	<p># Main websocket<br />
	ProxyPassMatch &quot;/lool/(.*)/ws$&quot; wss://127.0.0.1:9980/lool/$1/ws nocanon</p>

	<p># Admin Console websocket<br />
	ProxyPass   /lool/adminws wss://127.0.0.1:9980/lool/adminws</p>

	<p># Download as, Fullscreen presentation and Image upload operations<br />
	ProxyPass           /lool https://127.0.0.1:9980/lool<br />
	ProxyPassReverse    /lool https://127.0.0.1:9980/lool</p>
	</li>
	<li>Press CTRL+O, Enter, CTRL+X to save the changes and exit nano</li>
	<li>Continue the configuration by running the following commands in terminal:
	<div class="codeBlock"># edit default SSL configuration file<br />
	sudo nano /etc/apache2/sites-available/default-ssl.conf</div>
	</li>
	<li>Add the following line just above the &lt;/VirtualHost tag
	<p>Include /etc/apache2/conf-available/code.conf</p>
	</li>
	<li>Press CTRL+O, Enter, CTRL+X</li>
	<li>Continue the configuration by running the following commands in terminal:
	<div class="codeBlock"># edit ownCloud configuration file<br />
	sudo nano /var/www/owncloud/config/config.php</div>
	</li>
	<li>Find the trusted_domains array and add the DNS used for the SSL certificate</li>
	<li>Press CTRL+O, Enter, CTRL+X</li>
	<li>Continue with the following commands to restart loolwsd and apache2 to apply the changes:
	<div class="codeBlock">sudo systemctl restart loolwsd apache2</div>
	</li>
	<li>Open a web browser and navigate to https://DNS:9980</li>
	<li>If everything is working as expected the message OK should be shown</li>
</ol>

<h2>Adding Collabora Office to ownCloud</h2>

<ol>
	<li>Log into ownCloud with an administrative user</li>
	<li>Click the hamburger menu in the top left corner &gt; Market</li>
	<li>Click Integration under the Categories heading</li>
	<li>Find and click on Collabora Online</li>
	<li>Click the Install button</li>
	<li>Once the installation completes, click the username dropdown &gt; Settings</li>
	<li>Select Admin &gt; Additional from the left navigation menu</li>
	<li>Enter the DNS name for the Collabora Online server URL</li>
	<li>Click Apply</li>
	<li>If the above option does not appear, you can complete the same terminal by running:
	<div class="codeBlock">cd /var/www/owncloud<br />
	sudo -u www-data php occ config:app:set --value https://nettools.i12bretro.local:9980 richdocuments wopi_url</div>
	</li>
</ol>

<p>Source: <a href="https://www.collaboraoffice.com/code/linux-packages/" target="_blank">https://www.collaboraoffice.com/code/linux-packages/</a></p>          </div>
        </div>
      </body>
    </html>