Page 1 of 1

OpenOffice / LibreOffice on Windows

PostPosted:Tue Dec 09, 2014 12:36 pm
by Catscratch
He there,

a short question. I configured system.openoffice.path to point to the office folder (where inside is the program\soffice.exe ).

But OpenKM always appends "program\soffice.bin". <--- BIN !
In a Windows environment.

How to get rid of this? If I try to point directly to the soffice.exe file, OpenKM also appends, so that it looks like: OpenOffice4\program\soffice.exe\program\soffice.bin.

Did you hard coded the "program\soffice.bin" suffix in the code? Or where does it come from?

Regards.

Re: OpenOffice / LibreOffice on Windows

PostPosted:Wed Dec 10, 2014 5:50 pm
by jllort
soffice.bin indicates the soffice service is started, that is correct do not worry about it. Really openoffice path points to folder what contains subfolder program, from this path openkm start soffice as service.

Re: OpenOffice / LibreOffice on Windows

PostPosted:Thu Dec 11, 2014 7:51 am
by Catscratch
Hm, that's strage. Because when I try to use the office service (download ODP file as PDF) I get:
Code: Select all
2014-12-11 08:50:32,104 [http-nio-0.0.0.0-8080-exec-5] ERROR com.openkm.servlet.frontend.ConverterServlet- Error in application/vnd.oasis.opendocument.text to PDF conversion
com.openkm.core.ConversionException: Error in application/vnd.oasis.opendocument.text to PDF conversion
	at com.openkm.util.DocConverter.doc2pdf(DocConverter.java:330)
	at com.openkm.servlet.frontend.ConverterServlet.toPDF(ConverterServlet.java:246)
	at com.openkm.servlet.frontend.ConverterServlet.service(ConverterServlet.java:134)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
	at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: this OfficeManager is currently stopped
	at org.artofsolving.jodconverter.office.ProcessPoolOfficeManager.execute(ProcessPoolOfficeManager.java:70)
	at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(OfficeDocumentConverter.java:78)
	at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(OfficeDocumentConverter.java:69)
	at com.openkm.util.DocConverter.convert(DocConverter.java:273)
	at com.openkm.util.DocConverter.doc2pdf(DocConverter.java:327)
	... 48 more

Re: OpenOffice / LibreOffice on Windows

PostPosted:Fri Dec 12, 2014 5:49 pm
by jllort
error is clear "java.lang.IllegalStateException: this OfficeManager is currently stopped" seems your soffice service not starts correctly. Go to computer process and see if soffice starts ( if you see catalina.log at end start up you'll see if goes right or not ). In Administration / configuration parameters, at top right, you got and icon to check this configuration section

Re: OpenOffice / LibreOffice on Windows

PostPosted:Mon Dec 15, 2014 11:42 am
by Catscratch
jllort wrote:error is clear "java.lang.IllegalStateException: this OfficeManager is currently stopped" seems your soffice service not starts correctly. Go to computer process and see if soffice starts ( if you see catalina.log at end start up you'll see if goes right or not ). In Administration / configuration parameters, at top right, you got and icon to check this configuration section
In Administration panel the configuration check shows everything green.

And yes. The office process currently stopped at startup. I don't know why, but I would suggest, that OpenKM tries to start the soffice.bin, which does not work on windows. But I found no way to configure the office path to use the EXE instead of the bin.

Re: OpenOffice / LibreOffice on Windows

PostPosted:Wed Dec 17, 2014 10:25 am
by jllort
I suggest you try with openoffice not with libreoffice ( I found some problems on libre office with windows ). And soffice.bin must start without problems on windows, sure.

Re: OpenOffice / LibreOffice on Windows

PostPosted:Wed Dec 17, 2014 10:58 am
by Catscratch
Ok, I'm using open office. Don't know whats going wrong. :-/

Re: OpenOffice / LibreOffice on Windows

PostPosted:Thu Dec 18, 2014 5:29 pm
by jllort
You're on Windows or on Debian ? because on your signature you put "My OpenKM installation: - OpenKM Community 6.3.0 (build: 19782) on Tomcat 8.0.9, Debian 7.6 x64, 2GB RAM, 500GB HDD, MySQL, Active Directory, Only https"

If you're on windows be sure none openoffice application be running ( sometimes there're some helper openoffice daemond etc... stop it, be sure nothing is running ). Which is your OS version? This server has a lot of programs configured, my suggestion is always try on a clean computer, because there're a lot of thing what can going wrong on a multi-purpose computer ( a lot of hands installing software means problems on future ).

Re: OpenOffice / LibreOffice on Windows

PostPosted:Fri Dec 19, 2014 11:55 am
by Catscratch
Ok, I found it. On Windows you need to manually extend the PATH variable to find sigar libraries.

I throught LD_LIBRARY_PATH would work, but it don't.

So I extended PATH in setenv.bat. And not sigar libraries are working.

Re: OpenOffice / LibreOffice on Windows

PostPosted:Sat Dec 20, 2014 12:25 pm
by jllort
At the bottom of this page is shown http://wiki.openkm.com/index.php/Config ... ce_windows