Libreoffice Integration OL7

Ask questions about your setup or get help installing ZCS server (ZD section below).
Andreas.Steinel
Posts: 3
Joined: Thu May 03, 2018 11:22 am

Libreoffice Integration OL7

Postby Andreas.Steinel » Thu May 03, 2018 11:46 am

Hi guys,

I'm currently testing the network edition with a trial license file with 8.8.8 on OL 7 (up-to-date) and we installed at first without libreoffice and libreoffice-headless. After testing, we decided to give it a try and at first installed the official libreoffice-files in /opt/libreoffice ... and tried the zmconfig-setting to give the path to soffice, which did not work. (Tutorial https://wiki.zimbra.com/wiki/High_Fidel ... nt_Preview)
After looking at this forum, I found out that there is an optional YUM repository from RHEL and also Oracle Linux that includes libreoffice, so I deinstalled the official rpms and installed libreoffice and libreoffice-headless (run into the same problem as described in Bug #107219).

In version 8.8.8, I cannot find the mentioned cos entries for the preview of mail attachments as described in https://wiki.zimbra.com/wiki/High_Fidel ... nt_Preview, has this been removed or do I have to enable this somehow?

We also use the ownCloud Integration zimlet from Berry, because Zimbra's Cloud plugin does a lot but simple things like attaching files by link and only at maximum file limit are total deal breakers, so we disabled this zimlet completely. Inside of the owncloud zimlet, files are automatically previewed, if they do not include any soffice conversion, if they do, I get a backtrace

Code: Select all

2018-05-03 13:21:38.336:WARN:oejs.HttpChannel:qtp998351292-182: https://zimbra.<FQDN>/service/extension/dav_download/?token=7e6bc648b39de32546f2333e978299be&name=Auswertung_Komprimierung.ods&contentType=application/vnd.oasis.opendocument.spreadsheet&inline=true
java.io.FileNotFoundException: /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.pdf (No such file or directory)
    at java.io.FileInputStream.open0(Native Method)
    at java.io.FileInputStream.open(FileInputStream.java:195)
    at java.io.FileInputStream.<init>(FileInputStream.java:138)
    at java.io.FileInputStream.<init>(FileInputStream.java:93)
    at com.zextras.dav.DownloadHandler.doGet(DownloadHandler.java:120)
    at org.openzal.zal.http.InternalHttpHandler.doGet(InternalHttpHandler.java:51)
    at com.zimbra.cs.extension.ExtensionDispatcherServlet.service(ExtensionDispatcherServlet.java:111)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:821)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1685)
    at com.zimbra.cs.servlet.CsrfFilter.doFilter(CsrfFilter.java:169)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at com.zimbra.cs.servlet.RequestStringFilter.doFilter(RequestStringFilter.java:54)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(SetHeaderFilter.java:59)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at com.zimbra.cs.servlet.ETagHeaderFilter.doFilter(ETagHeaderFilter.java:47)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at com.zimbra.cs.servlet.ContextPathBasedThreadPoolBalancerFilter.doFilter(ContextPathBasedThreadPoolBalancerFilter.java:107)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at com.zimbra.cs.servlet.ZimbraQoSFilter.doFilter(ZimbraQoSFilter.java:116)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at com.zimbra.cs.servlet.ZimbraInvalidLoginFilter.doFilter(ZimbraInvalidLoginFilter.java:117)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:473)
    at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:318)
    at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:288)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1158)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1090)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:119)
    at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:318)
    at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:437)
    at org.eclipse.jetty.server.handler.DebugHandler.handle(DebugHandler.java:84)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:119)
    at org.eclipse.jetty.server.Server.handle(Server.java:517)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:306)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:242)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:261)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
    at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:192)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:261)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
    at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:75)
    at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:213)
    at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:147)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572)
    at java.lang.Thread.run(Thread.java:748)


There are no related entries in convertd.log concerning this problem. I can see the input file /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.ods and can manually convert to pdf:

Code: Select all

zimbra@zimbra/tmp > ls -l /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.* 
-rw-r-----. 1 zimbra zimbra 45134 May  3 13:21 /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.ods

zimbra@zimbra /tmp > /usr/bin/libreoffice --headless --convert-to pdf docconvert082cec04-d626-4289-a417-13ea623e71d0.ods
convert /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.ods -> /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.pdf using filter : calc_pdf_Export

zimbra@zimbra/tmp > ls -l /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.*
-rw-r-----. 1 zimbra zimbra 45134 May  3 13:21 /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.ods
-rw-r-----. 1 zimbra zimbra 40386 May  3 13:38 /tmp/docconvert082cec04-d626-4289-a417-13ea623e71d0.pdf


So, something in between is not working properly. I've this setting:

Code: Select all

zimbra@zimbra/tmp > ls -l /usr/bin/libreoffice
-rwxr-xr-x. 1 root root 372 Apr 12 13:20 /usr/bin/libreoffice

zimbra@zimbra /tmp > zmlocalconfig oo_linux_install_path
oo_linux_install_path = /usr/bin/libreoffice


and version:

Code: Select all

zimbra@zimbra /tmp > zmcontrol -v
Release 8.8.8_GA_2009.RHEL7_64_20180322150747 RHEL7_64 NETWORK edition.


Now to recap my questions:
* How can I debug the conversion further to get an idea about the real, underlying problem?
* How can I enable attachment preview if the settings in admin -> cos -> <mycos> -> advanved -> attachments is not listed?


Andreas.Steinel
Posts: 3
Joined: Thu May 03, 2018 11:22 am

Re: Libreoffice Integration OL7

Postby Andreas.Steinel » Thu May 03, 2018 12:06 pm

The owncloud integration was an external problem and it is working right now after reinstalling the zimlet.

So the only question remains:

How can I use the mail attachment preview as described in https://wiki.zimbra.com/wiki/High_Fidel ... nt_Preview

Return to “Installation and Upgrade”

Who is online

Users browsing this forum: No registered users and 9 guests