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>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[mikeh]

Out of interest, where are you guys getting OpenOffice from?

Does the information in this thread help? http://forums.alfresco.com/en/viewtopic.php?f=8&t=13572

Thanks,
Mike

[alberto]

my case I'm using the version installed with ubuntu 8.04.1 which I believe is version 2.4.1. It did not give me any problem running headless as the other thread mentioned. However, I have no idea how to check if it is broken as it is mentioned. I would like to use that version to help with updates and so on.
thanks

[boden]

I'm using OOo from the Ubuntu 8 repo.  Jan mentioned also using Ubuntu 8.04.

I suppose that could have something to do with it.  Ubuntu package managers just love messing with stuff to make it "better."

I'll try grabbing it directly from openoffice.org when I have some time.

[loftux]

I just tested with

ooo.exe=/usr/bin/soffice
ooo.user=/home/petl/.openoffice.org2/user
‍‍‍‍

I'm running Ubuntu 8.10 and OOo from the ubuntu package. Works without any problem.
Do the user running Alfresco have write access to -env:UserInstallation=file:////usr/lib/openoffice?
Is that where you actually want to store ooo user data?

[alberto]

Openoffice data is actually being stored in ooo.user. Alfresco can write in it.
The strange thing is that the installation seems to be able to convert doc files. The problem is limited to oppenoffice ones.
I have done a small test on indexing and it also seems to work for doc files while it does not for openoffices ones.

[loftux]

Works both with .doc and .odf file, indexing, thumbnails, preview.
I know me saying this may not help you, but I have installed pretty much "as is", just configuring mysql access and openoffice, imagemagick, pdf2swf binaries paths.

[alberto]

Thanks anyway.
That is pretty much the same thing I've done. I have a machine running 8.10 at home. I'll give it a try there.

[jan]

I guess it definitely has to do with the openoffice version on Ubuntu 8.04. Installing a different version should solve the problems.

[paolo]

With ubuntu 8.04 server and Alfresco Labs 3.0 if I run this command:

# xvfb-run -a /usr/lib/openoffice/program/soffice.bin -headless -accept="socket,port=8100;urp;" &‍

I'm able to index correctly all my odt documents.
Please note that this will work only with the new documents uploaded after this command.

[alberto]

Maybe the X server (xvfb right?) is needed with the official ubuntu package? I have installed openoffice from the .debs on the openoffice.org and now it works with the default alfresco configuration. It seems weird to me that it could index .doc with ubuntu's openoffice though. I guess figuring out why is out of my league. I have not tried Paolo's suggestion but it seems to me that the difference comes from the way openoffice is launched.
It's working now, thank you very much guys!!