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

[rays]

I'm working on the same installation as Paolo.

While we now have indexing working for OOo if files are uploaded via the share/alfresco web interfaces, or if we upload using ftp, OOo files uploaded using WebDAV are not indexed! Yet doc files uploaded via WebDAV are indexed normally. These results confirmed over a number of trials using different documents.

Anyone else here able to either 1) confirm our findings so we can file a bug or 2) point us in the direction of a solution to this problem?

<edit> I'd be particularly interested to hear from Alberto whether he can confirm or not this behaviour on his installation as he has now installed the OOo deb direct from OpenOffice.org site. thanks.</edit>

[alberto]

It seems to be working.
These are the tests I've run. First I created a file with a few words in openoffice. I then save it as .doc .sxw (openoffice 1) and .odt. I uploaded it through the web interface. If I try the small info icon I can see the beginning of the file in text. Then I tried a search on some of the words on the file. The three versions of the file are found. So first stage OK.
I then deleted those files. I checked that I search could not find the key words that I used. I uploaded those files using CIFS on windows. Repeated the testing and it worked.
I deleted the files again and uploaded them using CIFS on linux. Success too.
Again, deleted the files and uploaded them using webdav on linux (mounted drive on Ubuntu 8.10), result success.
Finally deleted the files and uploaded them using webdav on windows (XP). It worked.
I was also checking the logs as I was doing the test and I got no errors.
Conclusion, so far I have not found a problem. I have not tested spreadsheets but I'm assuming that if it works for one kind of file it should not be a problem.
For your information I felt like testing and installed openoffice 3 instead of the recommended 2.x. I should also tell you that since most of our files are in spanish i installed the spanish version of openoffice. I fail to see how that could make a difference but I wanted to give it a try.
Now If I could only get CIFS to work robustly   :?
If there is something you need to know from my install that you think can help you let me know.

[arnekaiser]

I had the same issue with openoffice 2.4.1 from Ubuntu 8.0.4 repository. I found somewhere the notice that this particular OOo version ignores the nofirststartwizard option.
I updated to OOo 3.0.1 from these repository:

deb http://ppa.launchpad.net/openoffice-pkgs/ppa/ubuntu hardy main

Then everything worked fine for me.

Good luck

Arne

[alberto]

I can confirm that it works installing openoffice 3 from the repositories on Ubuntu 8.04 as mentioned in the previous post. Thanks a lot guys 

[jan]

Same here. Works with openoffice 3! 

[jmcooper]

Hi Arne, Jan, Alberto … anyone

Could you please clarify how to get Open-Office headless v3 installed? I am experiencing all the same problems. I tried to install OOo version 3 from the link you referenced (http://ppa.launchpad.net/openoffice-pkgs/ppa/ubuntu), and went through a great deal of trouble with apt-get keys, etc. In the end it said my version was up to date … but it's still v2.4.1.

Any help on the details of getting the version 3 of OOo (Ubuntu 8.04) installed would be a great help.

Thanks!!!

John

[alberto]

Hi John,
What I did, and it would be my recommendation, was to completely uninstall openoffice 2.4 first. I mean, with purge and all. If I remember correctly there is no headless package in openoffice 3 (I'm talking from the top of my head here, I would have to check). So the procedure involves installing openoffice core and any dependencies that it indicates after you have added the mentioned repository.
Hope this helps.