topic Re: OpenOffice connection works only when started manually in Alfresco Archive

OpenOffice connection works only when started manually

mike54 — Thu, 24 Sep 2009 11:33:12 GMT

Hi!My configuration:Centos 5.3 + Tomcat ALfresco 3.2OpenOffice 2.3When I run this command from terminal:/usr/lib/openoffice.org/program/soffice "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager""-env:Userinstallation=file://var/lib/alfresco/alf_data/oouser" -nologo -headless -no

Re: OpenOffice connection works only when started manually

mike54 — Thu, 01 Oct 2009 12:33:52 GMT

ok, I can see that nobody has any suggestions about it.
I know that many people have the same problem.
I'm not sure, but my guess for now is that "tomcat" user can't start this service for some reason.
When I run

sudo -u tomcat /usr/lib/openoffice.org/program/soffice "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager""-env:Userinstallation=file://var/lib/alfresco/alf_data/oouser" -nologo -headless -nofirststartwizard
‍‍

I will end up with:

Xlib: connection to ":1022.0" refused by server
Xlib: No protocol specified

/usr/lib/openoffice.org/program/soffice.bin X11 error: Can't open display: 
   Set DISPLAY environment variable, use -display option
   or check permissions of your X-Server
   (See "man X" resp. "man xhost" for details)‍‍‍‍‍‍‍

For now I have no idea how to fix this, is it actually only a security problem?

Regards,
Maciej

Re: OpenOffice connection works only when started manually

dward — Thu, 01 Oct 2009 12:36:47 GMT

No, it's because the DISPLAY environment variable isn't set to point to an X server.

This shouldn't be required because the -headless option has been specified to ask the server to run without a display.

But I suspect your Open Office version doesn't support the -headless option. Please upgrade to the latest version of OpenOffice.

Re: OpenOffice connection works only when started manually

mike54 — Thu, 01 Oct 2009 13:41:25 GMT

hi, thank you for your input.
I'm running OpenOffice 2.3 and I have read that OpenOffice 3.1 has even more problems with the headless option on Centos 5.3?
I will try to do that anyway…

One more thing. When I run soffice.bin directly (instead of soffice) I get this error:

[root@alfresco WEB-INF]# sudo -u tomcat /usr/lib/openoffice.org/program/soffice.bin "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager""-env:Userinstallation=file://var/lib/alfresco/alf_data/oouser" -nologo -headless -nofirststartwizard
creation of executable memory area failed: Permission denied
FATAL ERROR, could not mmap a file for executable memory either in home dir or in /tmp
Cannot continue, perhaps examine your mount options for those directories, or selinux
‍‍‍‍‍

When I run it as root - it works fine and Alfresco can display previews of ODT etc.

Re: OpenOffice connection works only when started manually

mike54 — Fri, 02 Oct 2009 07:57:48 GMT

UPDATE:
I have installed OpenOffice 3.1 from OO website.
The situation is actually the same - it works great when I start it manually as ROOT, and then restart Alfresco / Tomcat.
But it won't start on its own (with the bootstrap file)…

I think for now the only alternative for me is to use this approach:
http://forums.alfresco.com/en/viewtopic.php?f=9&t=15637

Re: OpenOffice connection works only when started manually

mike54 — Mon, 05 Oct 2009 09:54:34 GMT

Ok, I did give up the idea of starting OO by Alfresco.
To fix the problem I have created shell script and added OO as system service that starts automatically.
It is run under ROOT account with headless option.

Sometimes it is important to use "unset DISPLAY" before starting the service.
Now the connection works perfectly.