0ct0pu5
/
tutorials


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266
							    <!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,HowTo,Tutorial,i12bretro,Web Based Tools,Collabora,Google Docs,Alternative">
        <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">
								  <script type="text/javascript" src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
				        <script type="text/javascript">
          $(function(){
            $('textarea').each(function(i,e){
              theTextarea = $(this);
              theTextarea.height((theTextarea[0].scrollHeight-5) +'px');
            });

            $('li').each(function(i,e){
							if(!$(this).hasClass('noCheckbox')){
								var uuid = 'li_' + Math.floor(Math.random() * Math.floor(1000000)).toString() + '_' + i.toString();
								$(this).contents().wrap('<span id="'+ uuid +'"><label for="cb_'+ uuid +'"></label></span>');
								$(this).prepend('<input type="checkbox" class="completeBox" id="cb_' + uuid +'" rel="'+ uuid +'" />')
							}
            });

            $('code,div.codeBlock,textarea.codeBlock').each(function(i,e){
              theElement = $(this);
              var lines = theElement.html().split("\n");
              theElement.empty();
              for(l=0;l<lines.length;l++){
                if($.trim(lines[l]) != '' && $.trim(lines[l]).substr(0,1) != '#' && $.trim(lines[l]).indexOf(' #') == -1 && lines[l].substr(0, 4).toUpperCase() != 'REM '){
									                  theElement.append('<input type="image" src="images/clipboard.png" value="" class="copy-text" rel="copy_'+ i +'_'+ l +'" data-clipboard-text="'+ $.trim(lines[l].replace(/"/g, '&quot;')) +'" /><span id="copy_'+ i +'_'+ l +'">'+ lines[l] +'</span>');
									                } else {
                  theElement.append(lines[l]);
                }
              }
            });

            $(document).on('click','input.copy-text',function(){
              theButton = $(this);
														$('input.copy-text').attr('src','images/clipboard.png');
							              $('span.copy-animation,span.copy-animation-ps').removeClass('copy-animation copy-animation-ps');
              try {
                if($('#'+ theButton.attr('rel')).parent('div').hasClass('PS')){
                  $('#'+ theButton.attr('rel')).addClass('copy-animation-ps');
								} else if($('#'+ theButton.attr('rel')).parent('div').hasClass('CMD')){
									$('#'+ theButton.attr('rel')).addClass('copy-animation-cmd');
                } else {
                  $('#'+ theButton.attr('rel')).addClass('copy-animation');
                }
                navigator.clipboard.writeText(theButton.data('clipboard-text').replace(/<[^>]*>?/gm, ''));
																theButton.attr('src','images/clipboard_active.png');
								              } catch(err) {
              }
              return false;
            });

            $(document).on('click','input.completeBox',function(){
              theBox = $(this);
              $('#'+ theBox.attr('rel')).addClass('strikethrough');
              theBox.prop('disabled',true);
              theBox.parent('li').prevAll().each(function(i,e){
                theLI = $(this);
                if(theLI.find('input[type=checkbox]').not(':checked')){
                  $('#'+ theLI.find('input[type=checkbox]').attr('rel')).addClass('strikethrough');
                  theLI.find('input[type=checkbox]').prop('checked',true).prop('disabled',true);
                }
              });
            });

            if(window.self !== window.top){
															window.parent.$('iframe.stepsFrame').height((this['scrollingElement']['scrollHeight']+20) +'px');
							            }
          });
        </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>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 Enchiperment</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</li>
	<li>Add a new host for the DNS name of the ownCloud server<br />
	<host allow="true">nettools.i12bretro.local</host></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</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 /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>