topic Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh in Alfresco Archive

Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

billydekid — Wed, 09 Jul 2014 00:33:02 GMT

Hi,I just want to share how to fix the problem of document preview which sometimes not fully functional on loading some of certain files.I use Alfresco 5.0.a on Ubuntu 14.04.One of the problem occurred when opening .docx files.Document preview just showing a thumbnail image instead of full frame of

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

caolem — Tue, 05 Aug 2014 23:14:00 GMT

I'm using alfresco 5.0.a with debian, in order to fix the office documents preview I did several steps.

1. check if libreoffice is running
/opt/alfresco-5.0.a/libreoffice/scripts/libreoffice_ctl.sh status

2. edit the file /opt/alfresco-5.0.a/alfresco.sh
modify the line LIBREOFFICE_SCRIPT with the correct script path
LIBREOFFICE_SCRIPT=$INSTALLDIR/libreoffice/scripts/libreoffice_ctl.sh

3. test for missing libraries
/opt/alfresco-5.0.a/libreoffice/program/soffice.bin –nofirststartwizard –nologo –headless –accept=socket,host=localhost,port=8100

4. install missing libraries (I had missing libxinerama1 and libdbus-glib-1-2)
apt-get install libxinerama1
apt-get install libdbus-glib-1-2

5. try to start opeoffice using the script
/opt/alfresco-5.0.a/libreoffice/scripts/libreoffice_ctl.sh start

6. restart alfresco
/etc/init.d/alfresco restart

7. you must see the line
/opt/alfresco-5.0.a/libreoffice/scripts/libreoffice_ctl.sh : libreoffice started at port 8100

Now previews work perfectly 😉

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

d_hoang — Wed, 24 Sep 2014 09:31:10 GMT

Thank You caolem. It was exactly my problem. Prevviews work fine now.

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

mkpelletier — Mon, 27 Oct 2014 10:31:42 GMT

Hello all! Thanks for the info here. It has helped me some.

I followed your instructions, @caolem, and made some progress from the default install, however I now get:


12:28:45,009 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] [http-bio-8443-exec-4] Exception from executeScript - redirecting to status template error: connection failed: socket,host=127.0.0.1,port=8100,tcpNoDelay=1; com.sun.star.lang.IllegalArgumentException
net.sf.jooreports.openoffice.connection.OpenOfficeException: connection failed: socket,host=127.0.0.1,port=8100,tcpNoDelay=1; com.sun.star.lang.IllegalArgumentException
   at net.sf.jooreports.openoffice.connection.AbstractOpenOfficeConnection.connect(AbstractOpenOfficeConnection.java:77)
   at org.alfresco.util.OpenOfficeConnectionTester.testAndConnect(OpenOfficeConnectionTester.java:183)
   at org.alfresco.util.OpenOfficeConnectionTester.checkConnection(OpenOfficeConnectionTester.java:129)
   at org.alfresco.util.OpenOfficeConnectionTester.onBootstrap(OpenOfficeConnectionTester.java:101)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:96)
   at org.alfresco.repo.management.subsystems.ChildApplicationContextFactory$ChildApplicationContext.publishEvent(ChildApplicationContextFactory.java:554)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
   at org.alfresco.repo.management.subsystems.ChildApplicationContextFactory$ApplicationContextState.start(ChildApplicationContextFactory.java:809)
   at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.start(AbstractPropertyBackedBean.java:991)
   at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.onApplicationEvent(AbstractPropertyBackedBean.java:530)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
   at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
   at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
   at java.util.concurrent.FutureTask.run(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This seems to only happen when using MySQL rather than the default postgresql.

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

loruam — Mon, 22 Dec 2014 17:37:30 GMT

Great Billythekid!!! It´s a week that i can't resolv this issue. Your solition work fine! Tks

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

arannasousa — Wed, 24 Dec 2014 12:10:31 GMT

In alfresco 5.0.c, was having connection problems between the alfresco and libreoffice.

In the file:


<alfresco> /libreoffice/scripts/libreoffice_ctl.sh
‍‍‍

before:


Soffice="$SOFFICEWRAPPER –nofirststartwizard –nologo –headless –accept=socket,host=localhost,port=$
SOFFICE_PORT\;urp\;StarOffice.ServiceManager"
‍‍‍‍

After (remove "\"):


Soffice="$SOFFICEWRAPPER –nofirststartwizard –nologo –headless –accept=socket,host=localhost,port=$SOFFICE_PORT;urp;StarOffice.ServiceManager"
‍‍‍

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

pknight — Fri, 29 May 2015 23:16:00 GMT

Does anyone know how to resolve this problem with Alfresco running on Windows server?

I can preview pdf's without issue but office docs won't display

Thanks

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

danyfortier — Wed, 15 Jul 2015 01:43:00 GMT

PKnight, have you resolve the problem ?

I have exactly the same problem here. I am running with Alfreso 5.0.d

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

danyfortier — Wed, 15 Jul 2015 01:54:28 GMT

ok i got it working by restarting tomcat service for now. But still investigating

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

voula_11 — Fri, 07 Aug 2015 21:09:19 GMT

I have the same problem on 5.0.d.

I changed alfresco.sh to point to the correct script, I changed libreoffice_ctl.sh to have the correct paths. Still not working.

When I test for missing libraries as suggested by caolem, I get this:

error while loading shared libraries: libdbus-glib-1.so.2: cannot open shared object file: No such file or directory‍

So I did a "yum install libdbus-glib-1.so.2" and I got this:

Package dbus-glib-0.86-6.10.amzn1.i686 already installed and latest version‍

So I guess this means that the package is installed in the wrong directory?
I tried removing it and re-installing it, but it still can't be located.

I really don't know what to do to fix this.

Can anyone help please?

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

yoyo46 — Thu, 20 Aug 2015 13:21:01 GMT

how about in windows? same also?

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

wags — Thu, 29 Oct 2015 07:31:22 GMT

Thanks for that. Where is alfresco.sh located under ubuntu 14.04? I installed using

https://github.com/loftuxab/alfresco-ubuntu-install

Thanks

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

fwegener — Thu, 25 Feb 2016 12:59:35 GMT

Hello,

i'm got the problem that libreoffice isent't running, too. The Problem occurs both with Debian 8 and Ubuntu 14.04. Also i tested with 5.0d and 5.1.

In Share i got only thumbnails with doc-files and a option for downloading file and no preview with docx-files.

i try to test based on your instructions with following result:

1. check if libreoffice is running
/opt/alfresco-5.0.a/libreoffice/scripts/libreoffice_ctl.sh status

–> libreoffice dont run and can't be started

2. edit the file /opt/alfresco-5.0.a/alfresco.sh
modify the line LIBREOFFICE_SCRIPT with the correct script path
LIBREOFFICE_SCRIPT=$INSTALLDIR/libreoffice/scripts/libreoffice_ctl.sh

–> i fixed the file but if i restart alfresco, libreoffice can't be started

3. test for missing libraries
/opt/alfresco-5.0.a/libreoffice/program/soffice.bin –nofirststartwizard –nologo –headless –accept=socket,host=localhost,port=8100

–> libGl.so1 is missing. Unfortunately it isn't possible to install manually

root@ubuntu:/opt/alfresco-community/libreoffice/scripts# apt-get install libGl.so.1
Reading package lists… Done
Building dependency tree
Reading state information… Done
E: Unable to locate package libGl.so.1
E: Couldn't find any package by regex 'libGl.so.1'

furthermore the linux-version has no gui.

4. install missing libraries (I had missing libxinerama1 and libdbus-glib-1-2)
apt-get install libxinerama1
apt-get install libdbus-glib-1-2

–>not possible. look at 3

5. try to start opeoffice using the script
/opt/alfresco-5.0.a/libreoffice/scripts/libreoffice_ctl.sh start

–> libreoffice wont start because i am not able to fix 3 & 4

6. restart alfresco
/etc/init.d/alfresco restart

7. you must see the line
/opt/alfresco-5.0.a/libreoffice/scripts/libreoffice_ctl.sh : libreoffice started at port 8100

Sry for my bad english guys Hope anyone can help me.

Thanks a lot

Florian

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

boiss007 — Sat, 02 Apr 2016 14:05:56 GMT

just fyi, instead of blindly using ,


#apt-get install libGl.so.1
‍‍‍

first use a sudo enabled user, not root (best practice), then do :

sudo apt-get update
apt-cache search libgl‍‍

and you will find the necessary libraries to install.

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

anon26949 — Thu, 18 May 2017 10:40:57 GMT

Thank you for sharing your experience!.. The same problem in Alfresco 5.1 CE.

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

billydekid — Thu, 18 May 2017 11:14:30 GMT

Hi ‌,

Frankly speaking, this problem is never appear again in 5.1 and 5.2 CE so far, on my environment.

Thanks,

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

anon26949 — Fri, 19 May 2017 06:15:30 GMT

Hi, Bayu Widyasanyata!

It seems that this script is not needed at all... LibreOffice managed by JODConverter.

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

billydekid — Sun, 21 May 2017 03:18:51 GMT

Hi ‌,

Thank you for issue's link! Then we can "close" this issue for 4.2+ version 🙂

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

douglascrp — Mon, 29 May 2017 15:51:13 GMT

Out of the box, LibreOffice managed by JODConverter is an Enterprise only feature.

If you need it for Community edition, then you will have to use an addon, in this case, this is what you are looking for xenit / alfresco-remote-jodconverter — Bitbucket

Re: Document preview problem was fixed by changing libreoffice's ctl.sh to libreoffice_ctl.sh

luceros — Wed, 05 Jul 2017 12:05:38 GMT

Hi, I resolve this problem changing the path of libreoffice installation on alfresco-global.properties.

From:

ooo.exe=/opt/alfresco-community/libreoffice/program/soffice.bin

ooo.exe=/usr/bin/soffice

then I restart alfresco service et voilà.
You must find soffice file on your sistem (this works on linux).

Bye, bye.