cancel
Showing results for 
Search instead for 
Did you mean: 

OpenOffice on RHEL 5

samuel_penn
Champ in-the-making
Champ in-the-making
Hi all,

I'm trying to get OpenOffice integration working against Alfresco 2.2 on RHEL 5, and I'm running into some issues. It just seems to work on our Gentoo setup, so I don't know whether it's something to do with the RedHat open office package, or something else.

Firstly, having installed the headless version of openoffice, I still need to add a "-display :0" parameter to the openoffice startup. My script to start openoffice looks like this:

/usr/lib/openoffice.org/program/soffice "-accept=socket,host=0.0.0.0,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file:///opt/alfresco/oouser" -nologo -headless -nofirststartwizard -display :0 &‍‍‍

If I don't include a display parameter, then it complains that DISPLAY isn't set. I've also set the custom-content-services-context.xml to talk to 127.0.0.1, otherwise Alfresco seems to try to resolve localhost to an IPv6 address, and fails to find OpenOffice at all.

Alfresco starts, and seems to pick up OpenOffice. If I try to transform a file from MS-Word to PDF, then it gives me an error as follows:

11:59:17,548 ERROR [org.alfresco.web.ui.common.Utils] Failed to run Actions due to error: Content conversion failed:   reader: ContentAccessor[ contentUrl=store://2008/7/28/15/29/891dc837-5cb1-11dd-8b28-c119e2c1bf70.bin, mimetype=application/msword, size=94208, encoding=UTF-8, locale=en_US]   writer: ContentAccessor[ contentUrl=store://2008/8/1/11/59/e2bde68d-5fb8-11dd-b0fc-519e6bbd05cf.bin, mimetype=application/pdf, size=0, encoding=UTF-8, locale=en_US]   options: {}org.alfresco.service.cmr.repository.ContentIOException: Content conversion failed:   reader: ContentAccessor[ contentUrl=store://2008/7/28/15/29/891dc837-5cb1-11dd-8b28-c119e2c1bf70.bin, mimetype=application/msword, size=94208, encoding=UTF-8, locale=en_US]   writer: ContentAccessor[ contentUrl=store://2008/8/1/11/59/e2bde68d-5fb8-11dd-b0fc-519e6bbd05cf.bin, mimetype=application/pdf, size=0, encoding=UTF-8, locale=en_US]   options: {}        at org.alfresco.repo.content.transform.AbstractContentTransformer.transform(AbstractContentTransformer.java:255)        at org.alfresco.repo.content.transform.AbstractContentTransformer.transform(AbstractContentTransformer.java:210)        at org.alfresco.repo.content.RoutingContentService.transform(RoutingContentService.java:468)        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:281)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:131)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:245)        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)        at $Proxy27.transform(Unknown Source)        at org.alfresco.repo.action.executer.TransformActionExecuter.doTransform(TransformActionExecuter.java:309)        at org.alfresco.repo.action.executer.TransformActionExecuter.executeImpl(TransformActionExecuter.java:284)        at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:120)        at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:537)        at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:472)        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:399)        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:387)        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:545)        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:281)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:245)        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)        at $Proxy18.executeAction(Unknown Source)        at org.alfresco.web.bean.actions.RunActionWizard.finishImpl(RunActionWizard.java:101)        at org.alfresco.web.bean.dialog.BaseDialogBean$1.execute(BaseDialogBean.java:122)        at org.alfresco.web.bean.dialog.BaseDialogBean$1.execute(BaseDialogBean.java:119)        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:241)        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:171)        at org.alfresco.web.bean.dialog.BaseDialogBean.finish(BaseDialogBean.java:128)        at org.alfresco.web.bean.wizard.WizardManager.finish(WizardManager.java:540)        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.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)        at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)        at javax.faces.component.UICommand.broadcast(UICommand.java:109)        at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)        at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)        at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)        at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)        at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)        at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)        at java.lang.Thread.run(Thread.java:619)Caused by: org.alfresco.service.cmr.repository.ContentIOException: OpenOffice server conversion failed:   reader: ContentAccessor[ contentUrl=store://2008/7/28/15/29/891dc837-5cb1-11dd-8b28-c119e2c1bf70.bin, mimetype=application/msword, size=94208, encoding=UTF-8, locale=en_US]   writer: ContentAccessor[ contentUrl=store://2008/8/1/11/59/e2bde68d-5fb8-11dd-b0fc-519e6bbd05cf.bin, mimetype=application/pdf, size=0, encoding=UTF-8, locale=en_US]   from file: /opt/alfresco/tomcat/temp/Alfresco/OpenOfficeContentTransformer-source-56669.doc   to file: /opt/alfresco/tomcat/temp/Alfresco/OpenOfficeContentTransformer-target-56670.pdf        at org.alfresco.repo.content.transform.OpenOfficeContentTransformer.transformInternal(OpenOfficeContentTransformer.java:225)        at org.alfresco.repo.content.transform.AbstractContentTransformer.transform(AbstractContentTransformer.java:246)        … 85 moreCaused by: net.sf.jooreports.openoffice.connection.OpenOfficeException: conversion failed; com.sun.star.lang.IllegalArgumentException: URL seems to be an unsupported one.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I've inserted some blank lines just before the last part of the log where it seems to have useful information. Looking in the tomcat temp directory, the doc file referenced above exists, and there is an empty pdf file. I'm guessing that the important error is "URL seems to be an unsupported one". Alfresco and OpenOffice are both running as root.

Any help greatly appreciated, thanks.

Sam.
4 REPLIES 4

samuel_penn
Champ in-the-making
Champ in-the-making
I'm still having issues with this. Some similar forum posts I've found have suggested checking directory permissions, but I've set everything I can to be world writable, and openoffice and Alfresco are both running as root. I've also disabled the firewall and SE to remove these as possible sources of problems.

Given that the Gentoo openoffice package just works, I've also tried installing the RPMs that Gentoo uses, but these give exactly the same error as the standard RH packages.

Thanks,
Sam.

cwho80
Champ in-the-making
Champ in-the-making
I am facing a similar issue. If you have solved this, do let us know how you did so. Thanks!

samuel_penn
Champ in-the-making
Champ in-the-making
Basically, the version of OpenOffice shipped with RHEL5 is broken. After discussions we Alfresco support, we tried to get some third party tools to talk to the OpenOffice server and these failed to work as well, so it's not an Alfresco problem.

The solution was to remove the RHEL supplied version of OpenOffice, and install the RPMs available on the OpenOffice site. These worked without a problem, and also worked correctly in headless mode (when the RHEL ones didn't).

Sam.

chaibi
Champ in-the-making
Champ in-the-making
Hi Sam,
I have the same problem with Alfresco labs 3 stable and i don't know how to install openoffice headless for Centos 5 without graphical mode. I installed openoofice.org3 using RPM but it doesn't work.

Think you for any help.
Welcome to the new Hyland Connect. Get started or submit feedback.