topic 4.0a Linux : Preview OpenOffice not working in Alfresco Archive

4.0a Linux : Preview OpenOffice not working

dranakan — Thu, 20 Oct 2011 13:02:13 GMT

Hello,I get problem to show the preview from docx with Alfresco 4.0a /Rhel 5.6 64 bits / Mysql 5.0.77. The preview with PDF is working.When I upload a document.docx the preview does not work… alfresco-global.propertiesooo.exe=/opt/alfresco-4.0.a/openoffice/program/soffice.binooo.enabled=trueooo.port

Re: 4.0a Linux : Preview OpenOffice not working

michaelk — Sat, 22 Oct 2011 14:23:30 GMT

I do not get errors (in alfresco.log) when uploading .doc files (in Linux environment) but I do not get a preview either. The document must be being processed because I can search for terms in the uploaded document and oo is used to parse the document to extract the text for the solr engine. I'm not sure how (or even if) previews are generated for MS office documents. I presume for PDFs, ghostscript is used. Perhaps it's oo->pdf->gs.

Re: 4.0a Linux : Preview OpenOffice not working

michaelk — Sat, 22 Oct 2011 18:05:31 GMT

*** Note this is with alfresco-4.0a on X64 Linux ****

After looking around I found the problem.

The startup script (alfresco.sh) looks for the openoffice script as…

OPENOFFICE_SCRIPT=$INSTALLDIR/openoffice/scripts/ctl.sh‍

but this does not exist… it is actually called openoffice_ctl.sh
so this needs to change to …

OPENOFFICE_SCRIPT=$INSTALLDIR/openoffice/scripts/openoffice_ctl.sh‍

however (at least in my case) when I executed ….

alfresco-4.0.a/openoffice/program/soffice -nofirststartwizard -nologo -headless -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager‍

OO complained that I was missing libXext.so.6

I got a compiled library for this and placed it in the openoffice/program directory and then it complained about missing libX11.so.6 and then libxcb.so.1. I likewise obtained these libraries and bingo it works and I now get previews of .doc and .xls

I am running alfreco on an external server vi the shell without X, so perhaps this missing library problem is not encountered if you have an instillation with X

Re: 4.0a Linux : Preview OpenOffice not working

dranakan — Mon, 24 Oct 2011 06:02:39 GMT

Thank you michaelk.

OO complained that I was missing libXext.so.6

Did you find this in catalina.out ?
I have changed the alfresco.sh but I still get problems… This is the error after uploading (via Share) a docx :

2011-10-24 08:00:15,121  ERROR [repo.action.AsynchronousActionExecutionQueueImpl] [defaultAsyncAction3] Failed to execute asynchronous action: Action[ id=7431a8f3-7fe6-4dfb-99dd-8e77caf39982, node=null ]
 org.alfresco.error.AlfrescoRuntimeException: 09240011 Creation of thumbnail 'doclib' failed
        at org.alfresco.repo.thumbnail.CreateThumbnailActionExecuter.executeImpl(CreateThumbnailActionExecuter.java:133)
        at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:196)
        at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:780)
        at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:700)
        at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1$1.execute(AsynchronousActionExecutionQueueImpl.java:403)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
        at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1.doWork(AsynchronousActionExecutionQueueImpl.java:412)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
        at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:415)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 09240010 Content conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/24/8/0/271f7890-9bf1-4b1b-8794-880484f40ad1.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store://2011/10/24/8/0/a6ec3ef4-b80d-43e8-bbb2-1336e08c900e.bin, mimetype=image/png, size=0, encoding=UTF-8, locale=en_US]
   options: ImageTransformationOptions[ commandOptions=, resizeOptions=org.alfresco.repo.content.transform.magick.ImageResizeOptions@6d3fb627]
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:177)
        at org.alfresco.repo.content.ContentServiceImpl.transform(ContentServiceImpl.java:569)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:125)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy51.transform(Unknown Source)
        at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine.render(AbstractTransformationRenderingEngine.java:71)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeRenditionImpl(AbstractRenderingEngine.java:494)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine$1.doWork(AbstractRenderingEngine.java:426)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine$1.doWork(AbstractRenderingEngine.java:406)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeImpl(AbstractRenderingEngine.java:405)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeImpl(AbstractRenderingEngine.java:369)
        at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:196)
        at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:780)
        at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:700)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:538)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy37.executeAction(Unknown Source)
        at org.alfresco.repo.rendition.RenditionServiceImpl.executeRenditionAction(RenditionServiceImpl.java:281)
        at org.alfresco.repo.rendition.RenditionServiceImpl.render(RenditionServiceImpl.java:183)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnailNode(ThumbnailServiceImpl.java:592)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.access$000(ThumbnailServiceImpl.java:67)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl$1.doWork(ThumbnailServiceImpl.java:248)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl$1.doWork(ThumbnailServiceImpl.java:245)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnail(ThumbnailServiceImpl.java:243)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy122.createThumbnail(Unknown Source)
        at org.alfresco.repo.thumbnail.CreateThumbnailActionExecuter.executeImpl(CreateThumbnailActionExecuter.java:124)
        … 12 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 09240009 Content conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/24/8/0/271f7890-9bf1-4b1b-8794-880484f40ad1.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store:///opt/alfresco-4.0.a/tomcat/temp/Alfresco/ComplextTransformer_intermediate_docx_5853181242243135218.pdf, mimetype=application/pdf, size=0, encoding=UTF-8, locale=en_US]
   options: ImageTransformationOptions[ commandOptions=, resizeOptions=org.alfresco.repo.content.transform.magick.ImageResizeOptions@6d3fb627]
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:177)
        at org.alfresco.repo.content.transform.ComplexContentTransformer.transformInternal(ComplexContentTransformer.java:247)
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:161)
        … 86 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 09240008 OpenOffice server conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/24/8/0/271f7890-9bf1-4b1b-8794-880484f40ad1.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store:///opt/alfresco-4.0.a/tomcat/temp/Alfresco/ComplextTransformer_intermediate_docx_5853181242243135218.pdf, mimetype=application/pdf, size=0, encoding=UTF-8, locale=en_US]
   from file: /opt/alfresco-4.0.a/tomcat/temp/Alfresco/OpenOfficeContentTransformer-source-7537520202277468096.docx
   to file: /opt/alfresco-4.0.a/tomcat/temp/Alfresco/OpenOfficeContentTransformer-target-7990716797799954993.pdf
        at org.alfresco.repo.content.transform.OpenOfficeContentTransformerWorker.transform(OpenOfficeContentTransformerWorker.java:249)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:65)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy11.transform(Unknown Source)
        at org.alfresco.repo.content.transform.ProxyContentTransformer.transformInternal(ProxyContentTransformer.java:68)
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:161)
        … 88 more
Caused by: net.sf.jooreports.openoffice.connection.OpenOfficeException: conversion failed; com.sun.star.lang.DisposedException: java.io.IOException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,tcpNoDelay=1,localHost=localhost.localdomain,localPort=35990,peerHost=localhost,peerPort=8100
        at net.sf.jooreports.openoffice.converter.OpenOfficeDocumentConverter.convertInternal(OpenOfficeDocumentConverter.java:114)
        at net.sf.jooreports.openoffice.converter.AbstractOpenOfficeDocumentConverter.convert(AbstractOpenOfficeDocumentConverter.java:75)
        at org.alfresco.repo.content.transform.OpenOfficeContentTransformerWorker.transform(OpenOfficeContentTransformerWorker.java:244)
        … 98 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: 4.0a Linux : Preview OpenOffice not working

dranakan — Mon, 24 Oct 2011 12:48:10 GMT

The bug of the preview appears only with 1 file (the one that I have used to test…). This bug also appears with Alfresco 3.4d -> https://issues.alfresco.com/jira/browse/ALF-10993

Re: 4.0a Linux : Preview OpenOffice not working

michaelk — Mon, 24 Oct 2011 20:52:19 GMT

Did you find this in catalina.out ?

I extracted the libraries from the Linux distribution RPMs.
Apparently, even though it's operating 'headless' it needs some X libraries to work.

Was the issue with the one file or the one file type (docx). Do you have success with other 'docx' (office 2007) files ?

Re: 4.0a Linux : Preview OpenOffice not working

dranakan — Tue, 25 Oct 2011 05:52:12 GMT

Was the issue with the one file or the one file type (docx). Do you have success with other 'docx' (office 2007) files ?

Yes. To test Alfresco 4.0a I used a file that I was actually editing for customers… The file seems to be an exception… I have removed all sensitive information inside and post on JIRA… you can try it : https://issues.alfresco.com/jira/secure/attachment/25764/CrashOpenOffice.docx

Re: 4.0a Linux : Preview OpenOffice not working

dhornford — Thu, 27 Oct 2011 19:04:34 GMT

We have the same problem with .docx, .xlxs & .pptx
New documents are created in Office 2010 (Windows 7) and Office 2011 (Mac)

Running 4.0a with the Linux community installer using the included OO, Postgres & Tomcat
Linux is CentOS 6

Will happily troubleshoot if someone will point where to look.

Dave

Re: 4.0a Linux : Preview OpenOffice not working

johngouf — Thu, 08 Dec 2011 16:08:40 GMT

I think it doesn't work properly on 4.0b either.
michaelk, the error I get is about libXext.so.6 missing. Any idea where can I get them for Ubuntu 64bit?

Re: 4.0a Linux : Preview OpenOffice not working

nickbsd — Wed, 14 Mar 2012 23:38:26 GMT

I've recently installed the Linux Alfresco version (4.0.d) on a new CentOS server using the wizard.

.DOC/.PDF files preview and open fine but .DOCX files fail to preview.

I get similiar error messages that have been posted to this forum posting.

Re: 4.0a Linux : Preview OpenOffice not working

nickbsd — Thu, 15 Mar 2012 23:09:00 GMT

For all of you who are unable to get the new Microsoft Office 2010 documents to open in Alfresco/Share you'll need to upgrade your Open Office to version 3.3.0.

I was able to do the following which resolved my problem:

OS: CentOS 64bit
Linux ALF 2.6.32-220.7.1.el6.x86_64 #1 SM

Install OpenOffice via console:

yum install openoffice.org-writer
yum install openoffice.org-calc
yum install openoffice.org-draw openoffice.org-impress

Rename the old soffice.bin file.

mv /opt/alfresco/openoffice/program/soffice.bin /opt/alfresco/openoffice/program/soffice.bin.old

Locate the newly compiled/installed soffice.bin; in my case it was located at: /usr/lib64/openoffice.org3/program/soffice.bin
To find your soffice.bin use the following command: "find / -name soffice.bin"

Once found, copy it to the Alfresco OpenOffice program folder:
cp /usr/lib64/openoffice.org3/program/soffice.bin /opt/alfresco/openoffice/program/soffice.bin

Restart Alfresco

./opt/alfresco/alfresco.sh restart

Re: 4.0a Linux : Preview OpenOffice not working

smelis — Wed, 22 Aug 2012 11:51:13 GMT

To anyone trying this. I had to do some extra work to get the above fix to work.

Intall libre office as per the above (yum install openoffice.org-writer etc.)
AND do "yum install openoffice.org-headless" (or your distros equivelant)

Edit the ctl.sh script in /opt/alfresco/openoffice/scripts (where /opt/alfresco is your alfresco install dir)
Change the line at the top that says "SOFFICE="$SOFFICEBIN […]" to

SOFFICE="$SOFFICEBIN –nofirststartwizard –nologo –headless –accept=\"socket,host=localhost,port=$SOFFICE_PORT;urp;StarOffice.ServiceManager\""

Also, it did not work for me to make symbolic link to the soffice.bin executable. Instead I had to make a symbolic link to the libreoffice directory.
So I did "mv /opt/alfresco/openoffice/program /opt/alfresco/openoffice/program.old" and then "ln /usr/lib64/libreoffice/program /opt/alfresco/openoffice/program"

For me the latest libre office works much better than the (alfres)co-installed openoffice.

Re: 4.0a Linux : Preview OpenOffice not working

cbernardi — Mon, 03 Sep 2012 09:27:17 GMT

I'm working on alfresco 4.0.d community with alfresco installer (Centos 64bit) so I prefered to "pack" the new version of openoffice/libreoffice within Alfresco installation folder.
That worked for me:

1) Install 3.2.+ version of libreoffice: (yum install openoffice.org-writer openoffice.org-calc openoffice.org-draw openoffice.org-impress openoffice.org-headless)
2) Locate path of installed version of libreoffice (for me /usr/lib64/libreoffice)
3) Copy libreoffice installation folder into alfresco folder (cp -r /usr/lib64/libreoffice <alfresco_home>)
4) Copy script folder from old installation of openoffice to libreoffice folder (cp -r <alfresco_home>/openoffice/scripts <alfresco_home>/libreoffice)
5) Edit <alfresco_home>/libreoffice/scripts/ctl.sh:
from

SOFFICE_PATH="<alfresco_home>/openoffice/program"
   SOFFICE_PORT="8100"
   SOFFICEBIN=<alfresco_home>/openoffice/program/soffice.bin‍‍‍

SOFFICE_PATH="<alfresco_home>/libreoffice/program"
   SOFFICE_PORT="8100"
   SOFFICEBIN=<alfresco_home>/libreoffice/program/soffice.bin‍‍‍

6) Rename old openoffice installation folder (mv <alfresco_home>/openoffice <alfresco_home>/openofficeOLD)
7) Create a symbolic link to libreoffice folder named openoffice (ln -s <alfresco_home>/libreoffice/ <alfresco_home>/openoffice)

Hope this helps

Re: 4.0a Linux : Preview OpenOffice not working

dranakan — Tue, 18 Sep 2012 13:42:54 GMT

Thank you for your help. LibreOffice 3.6.1 is working for me.

I try to install from last version :

 
#http://www.libreoffice.org/download/
tar -xvf LibO_3.6.1_Linux_x86-64_install-rpm_en-US.tar.gz
cd LibO_3.6.1.4_Linux_x86-64_install-rpm_en-US/RPMS
rpm -Uvh *.rpm
# Errors with  dict-en, dict-fr… continue…
cp -r /opt/libreoffice3.6 /opt/Alfresco/libreoffice
cp -r /opt/Alfresco/openoffice/scripts /opt/Alfresco/libreoffice/
‍‍‍‍‍‍‍‍‍

I don't know how openoffice is started out of box… If I check in alfresco.sh, the path is not good… (.app) :

OPENOFFICE_SCRIPT=$INSTALLDIR/openoffice.app/scripts/ctl.sh‍

So, to start libreoffice, I change it and adapt the ctl.sh

OPENOFFICE_SCRIPT=$INSTALLDIR/libreoffice/scripts/ctl.sh‍

libreoffice/ctl.sh

# Open Office
SOFFICE_PATH="/opt/Alfresco/libreoffice/program"
SOFFICE_PORT="8100"
SOFFICEBIN=/opt/Alfresco/libreoffice/program/soffice.bin
#SOFFICE="$SOFFICEBIN -nofirststartwizard -nologo -headless -accept=socket,host=localhost,port=$SOFFICE_PORT;urp;StarOffice.ServiceManager"
SOFFICE="$SOFFICEBIN –nofirststartwizard –nologo –headless –accept=socket,host=localhost,port=$SOFFICE_PORT;urp;StarOffice.ServiceManager"‍‍‍‍‍‍

and alfresco-global.properties :

   #ooo.exe=/opt/Alfresco/openoffice/program/soffice.bin
   ooo.exe=/opt/Alfresco/libreoffice/program/soffice.bin‍‍

Re: 4.0a Linux : Preview OpenOffice not working

cbernardi — Wed, 19 Sep 2012 14:12:44 GMT

Yes, I faced this too…
Infact as I wrote in my post, instead of modify the launch script I renamed the old OpenOffice folder and made a symbolic link to the new one… so the scripts continued to work with the old paths!

Re: 4.0a Linux : Preview OpenOffice not working

aweber1nj — Thu, 04 Oct 2012 16:38:32 GMT

Thank you all for this good work.

I am testing 4.0e, and it appears that the path in the alfresco.sh script is wrong (again). In the script, as delivered it is:

OPENOFFICE_SCRIPT=$INSTALLDIR/openoffice.app/scripts/ctl.sh
‍‍

I am almost certain this should be without the .app extension like:

OPENOFFICE_SCRIPT=$INSTALLDIR/openoffice/scripts/ctl.sh
‍‍

-AJ

Re: 4.0a Linux : Preview OpenOffice not working

digihorse — Thu, 04 Oct 2012 16:47:35 GMT

Many use macs for development at Alfresco. That would be a mac OS X path….. Alter to fit your environment.

Re: 4.0a Linux : Preview OpenOffice not working

csmith — Thu, 11 Oct 2012 20:05:00 GMT

This was my fix as well. Thank you.

Re: 4.0a Linux : Preview OpenOffice not working

mkmahmoud — Sat, 21 Jan 2017 05:44:18 GMT

When I click in .docx or any other office type document I got message "cant preview PDF contents". Logically, alfresco will use standard format to display the contents of files. Converting to PDF is more than one process i,e it need to read document, create the uniform format and convert to PDF. when I was installed alfresco I got warning message "RAM and CPU is Not enough". Most probably, it related to max document size and the specification of the HW which is less than minimum requirements. I think you need to install open office or libre office with ooo.exe=/path to/soffice.bin no matter where you install it. installing libre office directly with alfresco installing process is the easiest way to have smooth document viewing and over all system stability. But if you want to install libre office manually without GUI environment you need to install libre office core only. most probably full libre office installing will try to install python 3.x and the GUI contents which is not applicable will cause sever problem.