topic Re: libreoffice extension not working in Alfresco Archive

libreoffice extension not working

mkpelletier — Fri, 24 Oct 2014 10:46:16 GMT

I have scoured the forums and the internet looking for a solution to this, but have found none. I am running the latest Alfresco 5.0b, on Debian Wheezy. Interestingly, out of the "box" the script to start libreoffice is specified incorrectly in alfresco.sh: LIBREOFFICE_SCRIPT=$INSTALLDIR/libreoffi

Re: libreoffice extension not working

go4alfresco — Fri, 12 Dec 2014 20:47:50 GMT

I'm having the same problem on debian with alfresco 5.0.b and standard installation with postgresql.

Checked that libreoffice is up an running
/opt/alfresco-5.0.b$ sudo ./libreoffice/scripts/libreoffice_ctl.sh status
libreoffice already running

but when trying to get preview or upload new document alfreco logs
Caused by: net.sf.jooreports.openoffice.connection.OpenOfficeException: connection failed: socket,host=localhost,port=8100,tcpNoDelay=1; com.sun.star.lang.IllegalArgumentException
at net.sf.jooreports.openoffice.connection.AbstractOpenOfficeConnection.connect(AbstractOpenOfficeConnection.java:77)

I checked required libraries already but everything seems to be OK on libreoffice side.

Does anybody have an idea?

/M

Re: libreoffice extension not working

mkpelletier — Sat, 13 Dec 2014 06:43:12 GMT

I figured this one out, but forgot to repost the solution. There is a problem in the way the script specifies the parameters passed to the binary. This portion of the command needs to be passed WITH the double quotes: "–accept=socket,host=127.0.0.1,port=8100,tcpNoDelay=1;urp;". The result should look like this:

{alfresco home}/libreoffice/program/soffice.bin –headless –nologo –nofirststartwizard –nodefault –norestore "–accept=socket,host=127.0.0.1,port=8100,tcpNoDelay=1;urp;"‍

You can confirm the above by killing the libreoffice process: {alrescohome}/libreoffice/scripts/ctl.sh –stop
Then restart the process using the above.

I hope that helps!

Re: libreoffice extension not working

axel_baudin — Mon, 09 Feb 2015 17:00:00 GMT

Hi,
I've got the same problem in my alfresco install.
Can you paste the line from libreoffice\cripts\ctl.sh ?

in the original script there are 2 backslashes <cite>SOFFICE="$SOFFICEWRAPPER –nofirststartwizard –nologo –headless –accept=socket,host=localhost,port=$SOFFICE_PORT\;urp\;StarOffice.ServiceManager"</cite>, are they removed ?

Thanks

Re: libreoffice extension not working

mkpelletier — Mon, 16 Feb 2015 06:20:41 GMT

The escape character is not needed when the command includes the quotes. I believe this problem is fixed in 5.0c. In any case, I had trouble getting the command options specified in the variable to pass to the command, due to the way /bin/sh parses single and double quotes. There is probably a better way to do this, but I finally just put the command options in line 58 of /$ALFRESCO_HOME/libreoffice/scripts/ctl.sh directly rather than using the variable:

$SOFFICEWRAPPER –headless –nologo –nofirststartwizard –nodefault –norestore "–accept=socket,host=127.0.0.1,port=8100,tcpNoDelay=1;urp;"& >/dev/null 2>&1

I hope that helps!

Re: libreoffice extension not working

gasp72 — Mon, 16 Feb 2015 09:58:00 GMT

Hi,
This configuration file works for my setup.
I have created a symoblic link with
ln -s /array/alfresco/libreoffice/scripts/libreoffice_ctl.sh /array/alfresco/libreoffice/scripts/ctl.sh

And modified the configuration file with

# Libre Office
SOFFICE_PATH="/array/alfresco/libreoffice/program"
SOFFICE_PORT="8100"
SOFFICEBIN=/array/alfresco/libreoffice/program/.soffice.bin
SOFFICEWRAPPER=/array/alfresco/libreoffice/program/soffice.bin
SOFFICE="$SOFFICEWRAPPER –nofirststartwizard –nologo –headless "–accept=socket,host=localhost,port=$SOFFICE_PORT\;urp\;StarOffice.ServiceManager""
SOFFICE_STATUS=""

Re: libreoffice extension not working

me678 — Tue, 22 Sep 2015 15:56:32 GMT

Thanks for the reply! THis worked perfectly for me with your method. I am running Alfresco Community 5.0.d.