topic OpenOffice not working 3.0 Stable in Alfresco Archive

OpenOffice not working 3.0 Stable

boden — Fri, 23 Jan 2009 22:59:45 GMT

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.

Re: OpenOffice not working 3.0 Stable

jan — Sun, 25 Jan 2009 13:00:22 GMT

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.

Re: OpenOffice not working 3.0 Stable

mikeh — Sun, 25 Jan 2009 13:08:32 GMT

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

Mike

Re: OpenOffice not working 3.0 Stable

jan — Mon, 26 Jan 2009 12:43:10 GMT

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.

Re: OpenOffice not working 3.0 Stable

mikeh — Mon, 26 Jan 2009 12:56:49 GMT

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

Mike

Re: OpenOffice not working 3.0 Stable

jan — Mon, 26 Jan 2009 15:52:35 GMT

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>

Re: OpenOffice not working 3.0 Stable

boden — Mon, 26 Jan 2009 18:49:18 GMT

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.

Re: OpenOffice not working 3.0 Stable

jan — Mon, 26 Jan 2009 19:07:19 GMT

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?

Re: OpenOffice not working 3.0 Stable

boden — Tue, 27 Jan 2009 16:17:12 GMT

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….

Re: OpenOffice not working 3.0 Stable

alberto — Tue, 27 Jan 2009 22:35:55 GMT

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

Re: OpenOffice not working 3.0 Stable

mikeh — Tue, 27 Jan 2009 23:12:09 GMT

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

Re: OpenOffice not working 3.0 Stable

alberto — Wed, 28 Jan 2009 08:50:37 GMT

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

Re: OpenOffice not working 3.0 Stable

boden — Wed, 28 Jan 2009 16:24:07 GMT

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.

Re: OpenOffice not working 3.0 Stable

loftux — Wed, 28 Jan 2009 17:01:34 GMT

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?

Re: OpenOffice not working 3.0 Stable

alberto — Wed, 28 Jan 2009 18:26:59 GMT

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.

Re: OpenOffice not working 3.0 Stable

loftux — Wed, 28 Jan 2009 18:58:31 GMT

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.

Re: OpenOffice not working 3.0 Stable

alberto — Wed, 28 Jan 2009 19:01:58 GMT

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.

Re: OpenOffice not working 3.0 Stable

jan — Thu, 29 Jan 2009 12:52:20 GMT

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

Re: OpenOffice not working 3.0 Stable

paolo — Thu, 29 Jan 2009 14:33:30 GMT

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.

Re: OpenOffice not working 3.0 Stable

alberto — Thu, 29 Jan 2009 20:01:05 GMT

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