Koozali.org: home of the SME Server

ownCloud and LibreOffice

Offline Bud

  • *
  • 487
  • +0/-0
ownCloud and LibreOffice
« on: August 06, 2014, 05:17:13 AM »
hope you guys can help

i have successfully installed ownCloud 7 on a SME 8.1 Server however for the ownCloud system to "edit" documents/html files it requires Libreoffice as the old "ckeditor addon" does not work with ownCloud 7
has anybody been able to install Libreoffice on a SME 8.1 Server and configured it to be used with any version of ownCloud?
can it be done?

any help greatly appreciated  :P

Offline DanB35

  • ****
  • 764
  • +0/-0
    • http://www.familybrown.org
Re: ownCloud and LibreOffice
« Reply #1 on: August 06, 2014, 10:37:13 PM »
I'm running SME 9.0, not 8.1 any more, but am also interested in using Owncloud in this way.  A bit of web searching found this, although it's not 100% current:
http://www.tecmint.com/install-libreoffice-on-rhel-entos-6-3-5-8-and-fedora-17-16/

The current release RPM tarballs can be found at:
http://download.documentfoundation.org/libreoffice/stable/4.3.0/rpm/

The process from tecmint.com says to download the RPM tarball appropriate to your architecture, untar it, and yum localinstall *.rpm.  That completed successfully on my machine.  Next, I had to add the following line to owncloud's config.php file, before the closing ); :
Code: [Select]
  'preview_libreoffice_path' => '/usr/bin/libreoffice4.3',
On brief testing, it seems to work for me--I can open, edit, and save .doc files in my owncloud folder.  No guarantee at all that it'll work on 8.1, but it might be worth a try.
......

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: ownCloud and LibreOffice
« Reply #2 on: August 06, 2014, 11:05:11 PM »
I would suggest that you save your post in the wiki, thanks in advance.
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline DanB35

  • ****
  • 764
  • +0/-0
    • http://www.familybrown.org
Re: ownCloud and LibreOffice
« Reply #3 on: August 07, 2014, 06:37:34 PM »
While I'm waiting for Wiki access, I decided I'd test this on SME 8.1.  It isn't working yet, though it seems like it's close.  Here's what I did, in brief:


The result looks like a permissions problem; I get this error in Owncloud's log:
Code: [Select]
Conversion failed. Raw output::1: parser error : Document is empty 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAOwADAP7/CQAGAAAAAAAAAAAAAAABAAAAKQAAAAAAAAAAEAAA ^ mkstemp("//.execoooAE8LgB") failed: Permission denied
I'll probably work more on this later, but this should at least get folks started.
......

Offline Bud

  • *
  • 487
  • +0/-0
Re: ownCloud and LibreOffice
« Reply #4 on: August 08, 2014, 12:41:39 PM »
DanB35 thanks for helping

after installing i get the same error using SME 8.1 64Bit and ownClound 7.0 as you did.

awaiting with abated breath for a solution

thanks again  :smile:


Offline mmccarn

  • *
  • 2,627
  • +10/-0
Re: ownCloud and LibreOffice
« Reply #5 on: August 09, 2014, 02:27:14 PM »
* SME 8.1
* Owncloud 7.0.1
* LibreOffice 4.2.5.2

Instead of modifying  owncloud's config.php to set preview_libreoffice_path, I created a symlink for 'libreoffice' to the installed executable:
Code: [Select]
cd /usr/bin
ln -s libreoffice4.2 libreoffice

After which the 'Apply and Test' button in the Owncloud admin screen succeeds.

Following the same steps using LibreOffice 4.3 does *not* succeed.

[edit]
After installing OpenJDK from the Centos 'updates' repo using yum install java-1.7.0-openjdk, LibreOffice 4.3 still does not succeed.

LibreOffice4.3 gives a 'permission denied' error in owncloud.log
LibreOffice4.2 succeeds.
« Last Edit: August 09, 2014, 02:47:13 PM by mmccarn »

Offline Bud

  • *
  • 487
  • +0/-0
Re: ownCloud and LibreOffice
« Reply #6 on: October 15, 2014, 05:54:25 AM »
mmccarn thanks for your support

sorry for the noob question but i am trying to understand what you are saying:

I have created the symlink but what must i now place in the owncloud config.php file?

i do not seem to be able to edit any file.docx documents or any file.html documents and am desperate

any help greatly appreciated  :-)


guest22

Re: ownCloud and LibreOffice
« Reply #7 on: October 15, 2014, 09:56:44 AM »

Offline Bud

  • *
  • 487
  • +0/-0
Re: ownCloud and LibreOffice
« Reply #8 on: October 16, 2014, 03:48:13 PM »
RequestedDeletion thanks for your input

what i am trying to find out and do, is use owncloud and get libreoffice to view and edit the office files in owncloud

do you think this will do it as i am using sme server 8.1, owncloud 7 and libreoffice 4.2

how will i know if libreoffice is working on the sme 8.1 server?

soffy for the noob questions guys i really need to get this working  :-)

guest22

Re: ownCloud and LibreOffice
« Reply #9 on: October 16, 2014, 05:09:59 PM »
@Bud,


I really don't know, I simply saw the similarity and indicated that.


guest


Offline mmccarn

  • *
  • 2,627
  • +10/-0
Re: ownCloud and LibreOffice
« Reply #10 on: October 17, 2014, 01:06:23 PM »
i do not seem to be able to edit any file.docx documents or any file.html documents and am desperate

I can edit documents if I select the 'Documents' app in the top left - but not if I browse to a file in the 'files' app.