{"id":6063,"date":"2017-08-17T20:04:26","date_gmt":"2017-08-17T19:04:26","guid":{"rendered":"https:\/\/home.apeconsulting.co.uk\/adrian\/?p=6063"},"modified":"2017-08-17T20:21:13","modified_gmt":"2017-08-17T19:21:13","slug":"onlyoffice","status":"publish","type":"post","link":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/","title":{"rendered":"ONLYOFFICE"},"content":{"rendered":"

\"ONLYOFFICE<\/p>\n

 <\/p>\n

What is ONLYOFFICE<\/a> I hear you ask? \u00a0Well, it’s a very good question and one I wouldn’t have known the answer to until today! \u00a0<\/p>\n

I only found out myself today as I decided to upgrade my ownCloud\u00a0server from 9.1.5 to 10.0.2. \u00a0ownCloud 10 (or X<\/a> as some have been referring to it) has been out for a good few months, but as it sounded like a fairly major upgrade and my ownCloud server was running quite happily on one of the last 9 instances, I thought I’d stay clear for a while and wait for a few point releases before upgrading. \u00a0I received an e-mail this morning saying the beta for 10.0.3 had been released, so thought it might be time to take a look.<\/p>\n

As with any service update running on my FreeNAS server, the first step was to snapshot the relevant datasets so it could be easily recovered. \u00a0For ownCloud, that’s the jail and both database and file locations. \u00a0Updating ownCloud has always been a little bit of a manual process, as the built-in\u00a0updater very rarely works, but it’s pretty straight forward with just the following steps:<\/p>\n

mv \/usr\/local\/www\/owncloud \/usr\/local\/www\/owncloud-915<\/em>
\nfetch “http:\/\/download.owncloud.org\/community\/owncloud-10.0.2.tar.bz2<\/em>
\ntar jxf owncloud-10.0.2.tar.bz2 -C \/usr\/local\/www<\/em>
\nrm owncloud-10.0.2.tar.bz2<\/em>
\ncp \/usr\/local\/www\/owncloud-915\/config\/config.php \/usr\/local\/www\/owncloud\/config<\/em>
\nchown -R www:www \/usr\/local\/www\/owncloud<\/em>
\nchsh -s \/bin\/sh www<\/em>
\nsu www<\/em>
\nphp \/usr\/local\/www\/owncloud\/occ upgrade<\/em><\/p>\n

Well, it wasn’t quite as straight forward this time as it threw an error about one of the apps being incompatible, so I copied things back and then opened ownCloud to take a look. \u00a0I don’t have many apps running, but use the Calendar, Contacts, Documents, Gallery and 2FA apps so though it just easier to disable them all. \u00a0At the 2nd attempt, everything worked fine, and ownCloud 10.0.2 was up and running.<\/p>\n

It doesn’t look that different, although the user and admin settings have been combined, and there’s a whole new way to install Apps, through a new Marketplace like feature. \u00a0Adding Calendar, Contacts, Gallery and 2FA back wasn’t a problem, but where had the Documents app gone? \u00a0Well, I soon discovered that it was incompatible with the 10 branch, and had effectively been dropped from further development. \u00a0While it wasn’t the greatest software in the world and was pretty slow with limited functionality, it did allow me to collaborate on Microsoft documents with other people in real-time. \u00a0Now I know I can do that using Office 365 (which I have a subscription for) or Google Apps (which I don’t) but I liked the ability to do it using my own technology and file storage solution.<\/p>\n

So what was in the Marketplace to replace it? \u00a0Well, a couple of things as it happens. \u00a0The first one was\u00a0Collabora Online<\/a>\u00a0which I’d heard about before but requires you to set-up another server running Collabora. \u00a0The second one was ONLYOFFICE, which at first glance looked like it connected to an online service for opening and editing documents. \u00a0So off I went and created a trial account, but it turns out this can’t be used in the way I wanted, and this can only be achieved using the open source ONLYOFFICE Document Server, which like Collabora requires another server running.<\/p>\n

Ok, so I had some time to play so first checked Freshports to see if either were available as packages in FreeBSD. \u00a0I wasn’t surprised to find they weren’t, so after a little Googling decided I’d have a go at setting up ONLYOFFICE in a Ubuntu Server running as in FreeNAS using a VirtualBox VM. \u00a0Sounds complicated, and for the next 4 hours it pretty much was, although most of that was down to the way my FreeNAS server is configured, and precisely how I manage my SSL certificates which I’ve posted about a few times before (like here<\/a> and here<\/a> and here)<\/a> and still haven’t reached a perfect solution!<\/p>\n

Getting ONLYOFFICE up and running in the Ubuntu VM wasn’t that difficult, and the help documentation<\/a> is pretty good. \u00a0Creating the VM, installing the dependencies and packages probably only took about an hour. \u00a0But ONLYOFFICE will only work with ownCloud using the same HTTP protocol, and as I use SSL for my ownCloud server, I needed to get an SSL certificate working for ONLYOFFICE. \u00a0I won’t go into all the details of that here, as this is already longer than I’d expected, but I eventually got a Letsencrypt certificate working through my reverse-proxy server, and everything seems to be working well together. \u00a0From first impressions, it’s a much better solution than the old Documents app in ownCloud 9, and maybe I’ll use it a little more given the effort involved.<\/p>\n

As ever, it’s always a useful learning experience and something I enjoy attempting when I have some free time. \u00a0Even better when it all works at the end of it!<\/p>\n

Now if only I could simplify my SSL process. \u00a0Hopefully, wildcard certificates from Letsencrypt in 2018<\/a> will help….<\/p>\n","protected":false},"excerpt":{"rendered":"

  What is ONLYOFFICE I hear you ask? \u00a0Well, it’s a very good question and one I wouldn’t have known the answer to until today! \u00a0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,2,9,10],"tags":[21],"class_list":["post-6063","post","type-post","status-publish","format-standard","hentry","category-freenas","category-it","category-server","category-software","tag-spellchecked"],"yoast_head":"\nONLYOFFICE - Adrian's Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ONLYOFFICE - Adrian's Blog\" \/>\n<meta property=\"og:description\" content=\"  What is ONLYOFFICE I hear you ask? \u00a0Well, it’s a very good question and one I wouldn’t have known the answer to until today! \u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/\" \/>\n<meta property=\"og:site_name\" content=\"Adrian's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-17T19:04:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-17T19:21:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-content\/uploads\/sites\/2\/2017\/08\/1426033-150x150.jpg\" \/>\n<meta name=\"author\" content=\"Adrian\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adrian\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/\"},\"author\":{\"name\":\"Adrian\",\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/#\\\/schema\\\/person\\\/f63f15ff50bb8f956afdd86a816c5d2a\"},\"headline\":\"ONLYOFFICE\",\"datePublished\":\"2017-08-17T19:04:26+00:00\",\"dateModified\":\"2017-08-17T19:21:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/\"},\"wordCount\":869,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/#\\\/schema\\\/person\\\/f63f15ff50bb8f956afdd86a816c5d2a\"},\"image\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2017\\\/08\\\/1426033-150x150.jpg\",\"keywords\":[\"Checked\"],\"articleSection\":[\"FreeNAS\",\"IT\",\"Server\",\"Software\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/\",\"url\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/\",\"name\":\"ONLYOFFICE - Adrian's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2017\\\/08\\\/1426033-150x150.jpg\",\"datePublished\":\"2017-08-17T19:04:26+00:00\",\"dateModified\":\"2017-08-17T19:21:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/#primaryimage\",\"url\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2017\\\/08\\\/1426033.jpg\",\"contentUrl\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2017\\\/08\\\/1426033.jpg\",\"width\":250,\"height\":250},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/onlyoffice\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ONLYOFFICE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/#website\",\"url\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/\",\"name\":\"Adrian's Blog\",\"description\":\"Ramblings of an IT Geek\",\"publisher\":{\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/#\\\/schema\\\/person\\\/f63f15ff50bb8f956afdd86a816c5d2a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/home.apeconsulting.co.uk\\\/adrian\\\/#\\\/schema\\\/person\\\/f63f15ff50bb8f956afdd86a816c5d2a\",\"name\":\"Adrian\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2e5d9012573aedee25fd68deb071781d974af50ae74bf73aeb0e70433f7390c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2e5d9012573aedee25fd68deb071781d974af50ae74bf73aeb0e70433f7390c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2e5d9012573aedee25fd68deb071781d974af50ae74bf73aeb0e70433f7390c?s=96&d=mm&r=g\",\"caption\":\"Adrian\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2e5d9012573aedee25fd68deb071781d974af50ae74bf73aeb0e70433f7390c?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ONLYOFFICE - Adrian's Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/","og_locale":"en_GB","og_type":"article","og_title":"ONLYOFFICE - Adrian's Blog","og_description":"  What is ONLYOFFICE I hear you ask? \u00a0Well, it’s a very good question and one I wouldn’t have known the answer to until today! \u00a0","og_url":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/","og_site_name":"Adrian's Blog","article_published_time":"2017-08-17T19:04:26+00:00","article_modified_time":"2017-08-17T19:21:13+00:00","og_image":[{"url":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-content\/uploads\/sites\/2\/2017\/08\/1426033-150x150.jpg","type":"","width":"","height":""}],"author":"Adrian","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Adrian","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/#article","isPartOf":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/"},"author":{"name":"Adrian","@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/#\/schema\/person\/f63f15ff50bb8f956afdd86a816c5d2a"},"headline":"ONLYOFFICE","datePublished":"2017-08-17T19:04:26+00:00","dateModified":"2017-08-17T19:21:13+00:00","mainEntityOfPage":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/"},"wordCount":869,"commentCount":4,"publisher":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/#\/schema\/person\/f63f15ff50bb8f956afdd86a816c5d2a"},"image":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/#primaryimage"},"thumbnailUrl":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-content\/uploads\/sites\/2\/2017\/08\/1426033-150x150.jpg","keywords":["Checked"],"articleSection":["FreeNAS","IT","Server","Software"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/","url":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/","name":"ONLYOFFICE - Adrian's Blog","isPartOf":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/#website"},"primaryImageOfPage":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/#primaryimage"},"image":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/#primaryimage"},"thumbnailUrl":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-content\/uploads\/sites\/2\/2017\/08\/1426033-150x150.jpg","datePublished":"2017-08-17T19:04:26+00:00","dateModified":"2017-08-17T19:21:13+00:00","breadcrumb":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/#primaryimage","url":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-content\/uploads\/sites\/2\/2017\/08\/1426033.jpg","contentUrl":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-content\/uploads\/sites\/2\/2017\/08\/1426033.jpg","width":250,"height":250},{"@type":"BreadcrumbList","@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/onlyoffice\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/home.apeconsulting.co.uk\/adrian\/"},{"@type":"ListItem","position":2,"name":"ONLYOFFICE"}]},{"@type":"WebSite","@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/#website","url":"https:\/\/home.apeconsulting.co.uk\/adrian\/","name":"Adrian's Blog","description":"Ramblings of an IT Geek","publisher":{"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/#\/schema\/person\/f63f15ff50bb8f956afdd86a816c5d2a"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/home.apeconsulting.co.uk\/adrian\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/home.apeconsulting.co.uk\/adrian\/#\/schema\/person\/f63f15ff50bb8f956afdd86a816c5d2a","name":"Adrian","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/c2e5d9012573aedee25fd68deb071781d974af50ae74bf73aeb0e70433f7390c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c2e5d9012573aedee25fd68deb071781d974af50ae74bf73aeb0e70433f7390c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c2e5d9012573aedee25fd68deb071781d974af50ae74bf73aeb0e70433f7390c?s=96&d=mm&r=g","caption":"Adrian"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/c2e5d9012573aedee25fd68deb071781d974af50ae74bf73aeb0e70433f7390c?s=96&d=mm&r=g"}}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p90DI4-1zN","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/posts\/6063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/comments?post=6063"}],"version-history":[{"count":6,"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/posts\/6063\/revisions"}],"predecessor-version":[{"id":6151,"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/posts\/6063\/revisions\/6151"}],"wp:attachment":[{"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/media?parent=6063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/categories?post=6063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/home.apeconsulting.co.uk\/adrian\/wp-json\/wp\/v2\/tags?post=6063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}