• openkm and Libreoffice

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #9567  by STB2010
 
Hi!

I just updated my opensuse to version 11.4 and they switched to libreoffice. Is openkm able to work with libreoffice?
At the moment I do not get any preview for openoffice/libreoffice documents.

Best regards,

Stephan
 #9607  by jllort
 
It might run without problem with libreoffice, but I've not tested. In openoffice installation there's soffice service running. Which is your configuration parameters at OpenKM.cfg and take a look at starting server.log file if there's some error on starting up service. To ensure service is right installed then try converting some document to pdf, are button enabled ?
 #9708  by STB2010
 
I get this message when trying to preview an openoffice-document:

Document URL not provided or invalid.

My OpenKM.cfg looks like this:
Code: Select all
hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=none
system.ocr=/usr/local/bin/tesseract
system.img2pf=/usr/bin/convert
system.convert=/usr/bin/convert
repository.home=/home/openkm/datastore
default.lang=de-DE
system.login.username.lowercase=on
system.pdf2swf=/usr/bin/pdf2swf
system.openoffice.path=/usr/lib64/libreoffice
system.openoffice.tasks=5
system.openoffice.port=2222

# mail
subscription.message.subject=OpenKM - {0} - {1};
subscription.message.body=Document: <a href=\"{0}\">{1}</a>
notify.message.subject=OpenKM - NOTIFICATION - {0}
notify.message.body=Document: <a href=\"{0}\">{1}</a>
schedule.mail.importer=10
The binary from libreoffice is in /usr/lib64/libreoffice/program.

Error-Message from logfile:
Code: Select all
 Servlet.service() for servlet OKMDownloadServlet threw exception
com.openkm.frontend.client.OKMException: Error in application/vnd.oasis.opendocument.spreadsheet to PDF conversion
        at com.openkm.frontend.server.OKMDownloadServlet.service(OKMDownloadServlet.java:193)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
        at java.lang.Thread.run(Thread.java:662)
 #9762  by jllort
 
Seems there's some problem on starting libreoffice service. We might investigate it. Meanwhile we suggest using open office on server, really it's only for conversion files, nothing else.
 #9777  by joako
 
Yes but for example some (many?) Linux distributions are switching to LibreOffice instead of OpenOffice.

Does LibreOffice have "soffice" binary, or has the name changed? If you are 100% certain your config is correct file a bug report against openSUSE. They claim it's just a change to the name.
 #9793  by jllort
 
We must debug application is this configuration, I can not says anything before doing it. In fact libreoffice and openoffice might be the same ( except some conversion are not available on libreoffice ), but seems there's something more changed.
 #9964  by pavila
 
I've tested OpenKM 5.0.3 with LibreOffice 3.3.2 in Ubuntu 10.10 and works pretty well, but it has not been roughly tested as OpenOffice 3.2.1. In other operating system should also work.
 #11140  by flekschas
 
We've been forced to use lirbreoffice (v3.3.2) as well because there aren't any openoffice repos any longer for opensuse11.4
unfortunately the conversion doesn't work and during the startup we have the following errors:
Code: Select all
2011-05-26 20:38:35,554 ERROR [STDERR] 26.05.2011 20:38:35 org.artofsolving.jodconverter.office.ProcessPoolOfficeManager <init>
INFO: ProcessManager implementation is UnixProcessManager
2011-05-26 20:38:35,611 ERROR [STDERR] 26.05.2011 20:38:35 org.artofsolving.jodconverter.office.OfficeProcess start
INFO: starting process with acceptString 'socket,host=127.0.0.1,port=2222,tcpNoDelay=1' and profileDir '/tmp/.jodconverter_socket_host-127.0.0.1_port-2222'
2011-05-26 20:38:35,656 ERROR [STDERR] 26.05.2011 20:38:35 org.artofsolving.jodconverter.office.OfficeProcess start
INFO: started process; pid = 19594
2011-05-26 20:39:05,761 WARN  [com.openkm.sersvlet.RepositoryStartupServlet] failed to start and connect
org.artofsolving.jodconverter.office.OfficeException: failed to start and connect
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:61)
	at org.artofsolving.jodconverter.office.PooledOfficeManager.start(PooledOfficeManager.java:102)
	at org.artofsolving.jodconverter.office.ProcessPoolOfficeManager.start(ProcessPoolOfficeManager.java:59)
	at com.openkm.util.DocConverter.start(DocConverter.java:116)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:212)
	at javax.servlet.GenericServlet.init(GenericServlet.java:212)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4071)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4375)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
	at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
	at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)
	at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)
	at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)
	at org.jboss.web.WebModule.startModule(WebModule.java:83)
	at org.jboss.web.WebModule.startService(WebModule.java:61)
	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
	at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
	at $Proxy0.start(Unknown Source)
	at org.jboss.system.ServiceController.start(ServiceController.java:417)
	at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy44.start(Unknown Source)
	at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
	at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
	at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
	at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)
	at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
	at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy45.start(Unknown Source)
	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
	at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy9.deploy(Unknown Source)
	at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
	at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
	at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
	at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
	at $Proxy0.start(Unknown Source)
	at org.jboss.system.ServiceController.start(ServiceController.java:417)
	at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy4.start(Unknown Source)
	at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy5.deploy(Unknown Source)
	at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
	at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
	at org.jboss.Main.boot(Main.java:200)
	at org.jboss.Main$1.run(Main.java:508)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.util.concurrent.ExecutionException: org.artofsolving.jodconverter.office.OfficeException: could not establish connection
	at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
	at java.util.concurrent.FutureTask.get(FutureTask.java:83)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:59)
	... 142 more
Caused by: org.artofsolving.jodconverter.office.OfficeException: could not establish connection
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:123)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.access$000(ManagedOfficeProcess.java:31)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess$1.run(ManagedOfficeProcess.java:55)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	... 1 more
Caused by: org.artofsolving.jodconverter.office.RetryTimeoutException: java.net.ConnectException: connection failed: 'socket,host=127.0.0.1,port=2222,tcpNoDelay=1'; java.net.ConnectException: Connection refused
	at org.artofsolving.jodconverter.office.Retryable.execute(Retryable.java:48)
	at org.artofsolving.jodconverter.office.Retryable.execute(Retryable.java:31)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:113)
	... 8 more
Caused by: java.net.ConnectException: connection failed: 'socket,host=127.0.0.1,port=2222,tcpNoDelay=1'; java.net.ConnectException: Connection refused
	at org.artofsolving.jodconverter.office.OfficeConnection.connect(OfficeConnection.java:101)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess$6.attempt(ManagedOfficeProcess.java:116)
	at org.artofsolving.jodconverter.office.Retryable.execute(Retryable.java:41)
	... 10 more
Do u have any ideas how to solve this? Thanks!
 #11142  by joako
 
I'm involved in the openSUSE community. I don't make any guarantee anything will be done, but I'll try to test on openSUSE 11.4 and see what happens. If I see there's something wrong I'll submit a bug report.
 #11156  by jllort
 
I've tested with libre office 3.3.2 without problems
 #11204  by aaugusto
 
Hi all,

I'm testing in one machine under opensuse 11.3, with libreoffice 3.3.1.2-2.4.2.x86_64 and got no luck to make the LibreOffice server up. :cry:

I've tested with 5.0.4, 5.1.3, 5.1.4 and 5.1.5 (just to see if this makes any difference). But also no luck with any of them, so the problem is on LO side.

Then I have another machine with opensuse 11.4, with libreoffice 3.3.1.2-1.2.2.x86_64 (not so new version), with OpenKM 5.0.4 and it works like a charm. So I believe that there is something "missing" in the new libreoffice version.

I will try to downgrade the libreoffice, just to say if this is OK or NOT.

All the best,

Prof. Andrés Augusto Nogueiras Meléndez
Electronic Technology Department, University of Vigo, Spain
 #11219  by jllort
 
take a look about all packages installed between both servers, could be someone missing that in one version is installed by default but not in other. Or some package that must be installed on latest version that's not needed in previous ( althought it seems strange and the problem could be in other place ).
 #11234  by aaugusto
 
Hi again

Running under openSuSE 11.3, I just removed the LibreOffice package (the one in the repository), and installed (downgraded) to OpenOffice (also the one in the repository. This is the package list:
Code: Select all
OpenOffice_org-3.2.1.4-1.2.x86_64
OpenOffice_org-base-3.2.1.4-1.6.x86_64
OpenOffice_org-branding-openSUSE-3.2.1-2.2.noarch
OpenOffice_org-calc-3.2.1.4-1.5.x86_64
OpenOffice_org-components-3.2.1.4-1.8.x86_64
OpenOffice_org-draw-3.2.1.4-2.1.1.x86_64
OpenOffice_org-filters-3.2.1.4-1.8.x86_64
OpenOffice_org-filters-optional-3.2.1.4-1.8.x86_64
OpenOffice_org-help-en-US-3.2.1.4-1.8.noarch
OpenOffice_org-help-es-3.2.1.4-1.8.noarch
OpenOffice_org-hyphen-20080929-42.1.noarch
OpenOffice_org-icon-theme-industrial-3.2.1.4-1.2.noarch
OpenOffice_org-impress-3.2.1.4-2.1.1.x86_64
OpenOffice_org-l10n-es-3.2.1.4-1.5.noarch
OpenOffice_org-l10n-extras-3.2.1.4-1.8.noarch
OpenOffice_org-libs-core-3.2.1.4-1.6.x86_64
OpenOffice_org-libs-extern-3.2.1.4-1.8.x86_64
OpenOffice_org-libs-gui-3.2.1.4-2.1.1.x86_64
OpenOffice_org-mailmerge-3.2.1.4-1.6.x86_64
OpenOffice_org-math-3.2.1.4-1.5.x86_64
OpenOffice_org-pyuno-3.2.1.4-1.9.x86_64
OpenOffice_org-templates-en-3.0-5.1.noarch
OpenOffice_org-templates-labels-a4-1.0-9.1.noarch
OpenOffice_org-templates-labels-letter-1.0-9.1.noarch
OpenOffice_org-templates-presentation-layouts-3.0-5.1.noarch
OpenOffice_org-thesaurus-en-US-20060111-11.1.noarch
OpenOffice_org-thesaurus-es-20050720-11.1.noarch
OpenOffice_org-ure-3.2.1.4-1.9.x86_64
OpenOffice_org-writer-3.2.1.4-1.5.x86_64
As the machine has plenty of disk, I just tried four versions of OpenKM:

* 5.0.4
* 5.1.3
* 5.1.4
* 5.1.5

Every set up is located in a different directory. Starting and testing one at each time. And no problem appear. The office server started in all of them and, when uploading doc or odt files, we have previsualization and indexed taxonomy.

So, once again the problem seems to be on the LibreOffice side (as far as all the clues point to this direction). Will try again to remove the OpenOffice and install the LibreOffice, and also will start the server and keep the log in a file, as maybe it gives me more clues.

Prof. Andrés A. Nogueiras Melendez
Electronic Technology Department, University of Vigo, Spain
Last edited by aaugusto on Tue Jun 07, 2011 3:41 pm, edited 1 time in total.
 #11243  by aaugusto
 
Hi again, this is a continuation of the previous post

Running under openSuSE 11.3, I now removed the OpenOffice packages from the machine (all of them, for sure) and installed the minimal ammount of LibreOffice packages This is the new package list:
Code: Select all
libreoffice-3.3.1.2-2.4.2.x86_64
libreoffice-branding-upstream-3.3.1.2-2.2.1.noarch
libreoffice-calc-3.3.1.2-2.2.3.x86_64
libreoffice-calc-extensions-3.3.1.2-2.2.3.x86_64
libreoffice-components-3.3.1.2-2.2.3.x86_64
libreoffice-draw-3.3.1.2-2.2.3.x86_64
libreoffice-draw-extensions-3.3.1.2-2.2.3.x86_64
libreoffice-filters-3.3.1.2-2.2.3.x86_64
libreoffice-filters-optional-3.3.1.2-2.2.3.x86_64
libreoffice-icon-theme-crystal-3.3.1.2-2.2.3.noarch
libreoffice-impress-3.3.1.2-2.2.3.x86_64
libreoffice-impress-extensions-3.3.1.2-2.2.3.x86_64
libreoffice-l10n-extras-3.3.1.2-2.2.3.noarch
libreoffice-libs-core-3.3.1.2-2.2.3.x86_64
libreoffice-libs-extern-3.3.1.2-2.2.3.x86_64
libreoffice-libs-gui-3.3.1.2-2.2.3.x86_64
libreoffice-math-3.3.1.2-2.2.3.x86_64
libreoffice-pyuno-3.3.1.2-2.2.3.x86_64
libreoffice-ure-3.3.1.2-2.2.3.x86_64
libreoffice-writer-3.3.1.2-2.2.3.x86_64
libreoffice-writer-extensions-3.3.1.2-2.2.3.x86_64
I just tried the most advanced version of OpenKM -> 5.1.5. The others will be tested if I found a solution :-)

Just move the directory with the previous setup to another one, unziped the tar.gz file. Then edited the OpenKM.org file to be
Code: Select all
#system.ocr=/usr/bin/cuneiform
system.ocr=/usr/bin/tesseract
system.openoffice.path=/usr/lib64/libreoffice 
system.imagemagick.convert=/usr/bin/convert
#system.swftools.pdf2swf=/usr/bin/pdf2swf
system.swftools.pdf2swf=/usr/local/bin/pdf2swf
system.antivir=/usr/bin/clamscan
hibernate.dialect=org.hibernate.dialect.HSQLDialect
#hibernate.hbm2ddl=create
hibernate.hbm2ddl=none
#application.url=http://localhost:8080/OpenKM/com.openkm.frontend.Main/index.jsp
The first time hibernate was create, then changed to none.

I started the application with
Code: Select all
~#  cd /srv/openkm-5.1.5
~#  date >> log1.txt & ./bin/run.sh -b 0.0.0.0 >> log1.txt 2>> log2.txt &
and the log file has the warning
Code: Select all
16:25:10,059 WARN  [RepositoryStartupServlet] officeHome must exist and be a directory
java.lang.IllegalArgumentException: officeHome must exist and be a directory
        at org.artofsolving.jodconverter.office.DefaultOfficeManagerConfiguration.checkArgument(DefaultOfficeManagerConfiguration.java:160)
        at org.artofsolving.jodconverter.office.DefaultOfficeManagerConfiguration.setOfficeHome(DefaultOfficeManagerConfiguration.java:50)
But the officeHome is set up as /usr/lib64/libreoffice, and inside this path (folder) the /program/soffice.bin exists.

Now I'm not so sure about LibreOffice, but maybe it is the JVM (or not) in the opensuse 11.3 machine. The opensuse 11.4 machine that works fine also uses this JVM.
Code: Select all
~# java -version
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.7) (suse-1.2.1-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
But just a so simple code of checking an existing folder or file doesn't seems to me the reason for this...

Any ideas are welcome!

Prof. Andrés A. Nogueiras Melendez
Electronic Technology Department, University of Vigo, Spain
 #11247  by aaugusto
 
Just more debug information:

As suggested by jllort, a few post above, I check if there are any significant package differences. I check the java and the office. And no difference at all.

Testing with
Code: Select all
Java Packages

java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.7) (suse-1.2.1-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)

java-1_6_0-openjdk-1.6.0.0_b20.1.9.7-1.2.1.x86_64
java-1_6_0-openjdk-plugin-1.6.0.0_b20.1.9.7-1.2.1.x86_64
java-ca-certificates-1-5.3.noarch
timezone-java-2011g-0.2.1.noarch
and later with the sun Oracle java version
Code: Select all
java version "1.6.0_25"
Java(TM) SE Runtime Environment (build 1.6.0_25-b06)
Java HotSpot(TM) 64-Bit Server VM (build 20.0-b11, mixed mode)

java-1_6_0-sun-1.6.0.u25-0.2.1.x86_64
java-1_6_0-sun-plugin-1.6.0.u25-0.2.1.x86_64
java-ca-certificates-1-5.3.noarch
timezone-java-2011g-0.2.1.noarch
but no luck.

Errors on console (log file too) are similar to the ones reported in post above

During the start of the OpenKM application, during a very brief time, the soffice.bin program gets started and, then it dies. I just don't have a clue on how to debug this start and stop of the service. Well, let me get stuck to OpenOffice...

Prof. Andrés A. Nogueiras Melendez
Electronic Technology Department, University of Vigo, Spain

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.