Koozali.org: home of the SME Server

Obsolete Releases => SME 8.x Contribs => Topic started by: Bud on August 06, 2014, 05:17:13 AM

Title: ownCloud and LibreOffice
Post by: Bud 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

Title: Re: ownCloud and LibreOffice
Post by: DanB35 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.

Title: Re: ownCloud and LibreOffice
Post by: stephdl on August 06, 2014, 11:05:11 PM

I would suggest that you save your post in the wiki, thanks in advance.

Title: Re: ownCloud and LibreOffice
Post by: DanB35 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:

• Clean install of SME 8.1 in a VM.  Install all updates.
• Upgrade PHP to 5.3.28 as directed here: http://wiki.contribs.org/Talk:OwnCloud#Mmccarn_.28talk.29_17:55.2C_30_December_2013_.28MST.29
• Install Owncloud 7.0.1 following http://wiki.contribs.org/OwnCloud
• Download RPM tarball from http://download.documentfoundation.org/libreoffice/stable/4.3.0/rpm/, extract, change into the RPMS directory, and yum localinstall *.rpm
• yum install java.  Java isn't identified as a dependency for any of the LibreOffice RPMs, but Owncloud errors if it isn't installed (not sure if this is a LibreOffice or an Owncloud requirement).
• Edit owncloud's config.php as stated earlier
• Log in to owncloud as admin, go to the admin page, and hit "Apply and Test" under the Documents section.

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.

Title: Re: ownCloud and LibreOffice
Post by: Bud 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:

Title: Re: ownCloud and LibreOffice
Post by: mmccarn 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.

Title: Re: ownCloud and LibreOffice
Post by: Bud 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  :-)

Title: Re: ownCloud and LibreOffice
Post by: guest22 on October 15, 2014, 09:56:44 AM

I see a similarity over here http://wiki.contribs.org/index.php?title=Pydio&oldid=24518#Office_file_preview_and_indexation (http://wiki.contribs.org/index.php?title=Pydio&oldid=24518#Office_file_preview_and_indexation)

but I could be wrong.

Title: Re: ownCloud and LibreOffice
Post by: Bud 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  :-)

Title: Re: ownCloud and LibreOffice
Post by: guest22 on October 16, 2014, 05:09:59 PM

@Bud,


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


guest

Title: Re: ownCloud and LibreOffice
Post by: mmccarn on October 17, 2014, 01:06:23 PM

Quote from: Bud on October 15, 2014, 05:54:25 AM

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.