OpenOffice not starting

[boneill]

Hi All,

I am running version 2.2 alfresco on  a windows server 2003 standard edition.  I set the alfresco install to auto download and install OpenOffice.  Openoffice is not starting when I start up Alfresco.  I get the following error message:

[org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.

Does anyone know how to fix this problem.

[boneill]

Come on, somebody must have had problems getting OpenOffice to run.  I have installed alfresco a number of times now on windows and OpenOffice never works.  Is there s step you need to do to get it to work.  How do I debug what is happening with it.  Any help really appreciated.

[dinger]

Have you configured alfresco to point to the correct path to find open office?

Rob

[boneill]

I am not sure where you are meant to configure the OpenOffice path.  I did a search through the forums for this and found the following post:

I had Open office already installed. On startup I was receiveing an error when the server tried to start openoffice. I removed the following from the openofficeStartupCommand secion in tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml

"-env:UserInstallation=file://C:/Alfresco/openoffice"

Following this advice seeded to fix the problem on startup.  It does not make much sense to me though as C:/Alfresco/openoffice is where openoffice is installed.  However, I noted in the startup window that on startup it cant find openoffice initially and then OpenOfficeConnectionDetector reports that "The OpenOffice connection was re-established" a few seconds later after the server has started.  Puzzling!

[infodon]

make sure you have 3 /// after file:

like this >>>      -env:UserInstallation=file:///C:/Alfresco/openoffice"

[braulio_moura]

Hi guys!!

As boneill  said, I think  somebody must have had problems getting OpenOffice to run …

I'd be glad if someone can help me!!!

I'm running Alfresco Community 2.1 and Was told that for my PPt files to get indexed, I must have OpenOffice running on the server.

So, accordingly to http://wiki.alfresco.com/wiki/Setting_up_OpenOffice_for_Alfresco, I've dowloaded it, and installed step-by-step as the tutorial explains.

The problm is that, after starting up Alfresco server, when it tries to connect to OpenOffice it gets the following error message:

14:48:00,814 ERROR [openoffice.connection.SocketOpenOfficeConnection] disconnected unexpectedly
14:48:00,861 ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConnectionTester' defined in class path resource [alfresco/content-services-context.xml]: Invocation of init method failed; nested exception is net.sf.jooreports.openoffice.connection.OpenOfficeException: connection failed: socket,host=localhost,port=8100,tcpNoDelay=1; com.sun.star.lang.DisposedException: com.sun.star.io.IOException: java.net.SocketException: Socket closed
Caused by:
net.sf.jooreports.openoffice.connection.OpenOfficeException: connection failed: socket,host=localhost,port=8100,tcpNoDelay=1; com.sun.star.lang.DisposedException: com.sun.star.io.IOException: java.net.SocketException: Socket closed
   at net.sf.jooreports.openoffice.connection.AbstractOpenOfficeConnection.connect(AbstractOpenOfficeConnection.java:77)
   at org.alfresco.util.OpenOfficeConnectionTester.checkConnection(OpenOfficeConnectionTester.java:94)
   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:585)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1160)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1122)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:448)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
   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:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)


Am I missing something? Is there anything that I would know to make things work?

Please, help me!!!!!

[olivergardiner]

I am not sure where you are meant to configure the OpenOffice path.  I did a search through the forums for this and found the following post:

I had Open office already installed. On startup I was receiveing an error when the server tried to start openoffice. I removed the following from the openofficeStartupCommand secion in tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml

"-env:UserInstallation=file://C:/Alfresco/openoffice"

Following this advice seeded to fix the problem on startup.  It does not make much sense to me though as C:/Alfresco/openoffice is where openoffice is installed.  However, I noted in the startup window that on startup it cant find openoffice initially and then OpenOfficeConnectionDetector reports that "The OpenOffice connection was re-established" a few seconds later after the server has started.  Puzzling!

Note that if you have a default install of Open Office it will be in the "Program Files" directory, i.e. there will be spaces in the path. The "-env:UserInstallation" parameter is a URL and requires encoding. The Alfresco installer doesn't fix this so you will need to manually edit to replace spaces in the URL with %20.