OpenOffice not working 3.0 Stable

[boden]

Openoffice.org conversions aren't working for me on 3.0 Stable.  I used the tomcat bundle for linux to install.

I've verified that OpenOffice.org is indeed installed.  I get no errors on Alfresco startup, and I have verified that soffice.bin is running and listening on 8100 after Alfresco starts up.  Any ideas?

Caused by: org.alfresco.service.cmr.repository.ContentIOException: OpenOffice server conversion failed:
   reader: ContentAccessor[ contentUrl=store://2009/1/23/15/48/56e25306-2a79-4264-a03b-1c3127236d34.bin, mimetype=application/msword, size=20992, encoding=UTF-8, locale=en_US]
   writer: ContentAccessor[ contentUrl=store://2009/1/23/15/48/33e9d5e7-d5e4-445a-90e9-2b6417c4083c.bin, mimetype=application/pdf, size=0, encoding=UTF-8, locale=en_US]
   from file: /opt/alfresco/tomcat/temp/Alfresco/OpenOfficeContentTransformer-source-23496.doc
   to file: /opt/alfresco/tomcat/temp/Alfresco/OpenOfficeContentTransformer-target-23497.pdf
        at org.alfresco.repo.content.transform.OpenOfficeContentTransformer.transformInternal(OpenOfficeContentTransformer.java:249)
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:216)
        … 39 more
Caused by: net.sf.jooreports.openoffice.connection.OpenOfficeException: conversion failed; com.sun.star.lang.IllegalArgumentException: URL seems to be an unsupported one.
        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.OpenOfficeContentTransformer.transformInternal(OpenOfficeContentTransformer.java:244)
        … 40 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

openoffice-startup-context.xml

 <property name="commandsAndArguments">
          <map>
              <entry key=".*">
                  <list>
                        <value>/usr/lib/openoffice/program/soffice.bin</value>
                     <!– <value>${ooo.exe}</value> –>
                      <value>-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager</value>
                        <value>-env:UserInstallation=file:////usr/lib/openoffice</value>
                      <!– <value>-env:UserInstallation=file:///${ooo.user}</value> –>
                      <value>-nologo</value>
                      <value>-headless</value>
                      <value>-nofirststartwizard</value>
                      <value>-nocrashrep</value>
                      <value>-norestore</value>
                  </list>
              </entry>
          </map>
      </property>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[jan]

Hi,

I have the same problem!!! I'm using openoffice 2.3 on ubuntu 8.04.
Soffice.bin is running and listening on 8100.

* I have added a start_oo.sh (starting open office) script and adapted the alfresco.sh to load this script.
* Tried a lot of changes for the 'openoffice-startup-context.xml',
but do not succeed in solving the problem.

Thanks for any help.

[mikeh]

Check there's no firewall blocking access to port 8100 from the user account running Alfresco. Can you telnet in?

Mike

[jan]

Hi,

I don't know if boden has the same setup but I guess we are struggling with the same problem.

Everything is on one server, there is no firewall blocking the access.

Error message in the catalina log during Alfresco startup:

11:02:40,743 Userystem ERROR [util.exec.RuntimeExecBootstrapBean] Bootstrap command failed:
Execution result:
   os:         Linux
   command:    [/usr/lib/openoffice/program/soffice.bin "-accept=socket, host=localhost, port=8100;urp;StarOffice.ServiceManager -env:UserInstallation=file:////opt/Alfresco" -nologo -headless -nofirststartwizard -nocrashrep -norestore]
   succeeded:  false
   exit code:  2
   out:
   err:        Cannot run program "/usr/lib/openoffice/program/soffice.bin "-accept=socket": java.io.IOException: error=2, No such file or directory

Tried a lot of setting for the openoffice-startup-context.xml command.
My current line is <value><!CDATA[/usr/lib … command in error log above ]]</value>.

Please note that the command runs fine directly from the Linux command prompt. Did chmod 777 the whole openoffice directory to counter access problems.

[mikeh]

It looks like there might be a stray " in there - what's the exact contents of openoffice-startup-context.xml?

Mike

[jan]

Well,

I have been trying with all sorts of statements.

Both myself and boden, the original poster (feel like I'm hijacking his question, but guess it's the same problem) changed the commandsAndArguments section of openoffice-startup-context.xml. This because the initial setup didn't work.


Tried many versions, but my current version is:

     <property name="commandsAndArguments">
          <map>
              <entry key=".*">
                      <value><![CDATA[/usr/lib/openoffice/program/soffice.bin "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager -env:UserInstallation=file:////opt/Alfresco" -nologo -headless -nofirststarststartwizard -nocrashrep -norestore]]></value>
              </entry>
          </map>

[boden]

I tried the same configuration as jan which has been posted in a few places, no luck.

Everything is on the same server for me as well.  This isn't live so everything is running as root.

The key phrase in the error seems to be "URL seems to be an unsupported one."  From what I can find online it appears as though this message comes back from OOo itself.

[jan]

I do not know if it's relevant, but the function changed from 3c to 3d (labs stable release)

In 3c this function was called : propertyname=commandMap, now it's called propertyname=commandsAndArguments. Also the default statement in the file changed. Maybe it also expects a different type of statement?

[boden]

Hi jan, looks like we're alone on this one.  Have you had any luck?  I've pretty much exhausted everything I can think to do….

[alberto]

Same problem here. But I have no idea on how to aproach it.