Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

openoffice is not work.

https://forum.openkm.com/viewtopic.php?t=5631

Page 1 of 2

openoffice is not work.

PostPosted:Tue Jan 10, 2012 2:10 am
by grainsong
I am new to this software.I find openoffice is not work for the openkm.When I uninstall openoffice,the error is same.How can I configurate openoffice.Would you give a guide,thank you!
on: win2003 jdk1.6 openkm5.1.8
in administraotor tab,I write
system.openoffice.path:c:\program files\openoffice.org 3\
.....swftools:c:\swftools\

the error log :
Code: Select all
08:54:07,733 ERROR [ConverterServlet] Error in application/msword to PDF conversion
com.openkm.core.ConversionException: Error in application/msword to PDF conversion
        at com.openkm.util.DocConverter.doc2pdf(DocConverter.java:311)
        at com.openkm.servlet.frontend.ConverterServlet.toPDF(ConverterServlet.java:188)
        at com.openkm.servlet.frontend.ConverterServlet.toSWF(ConverterServlet.java:225)
        at com.openkm.servlet.frontend.ConverterServlet.service(ConverterServlet.java:106)
        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:524)
        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)
Caused by: java.lang.IllegalStateException: this OfficeManager is currently stopped
        at org.artofsolving.jodconverter.office.ProcessPoolOfficeManager.execute(ProcessPoolOfficeManager.java:67)
        at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(OfficeDocumentConverter.java:75)
        at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(OfficeDocumentConverter.java:66)
        at com.openkm.util.DocConverter.convert(DocConverter.java:251)
        at com.openkm.util.DocConverter.doc2pdf(DocConverter.java:308)
        ... 23 more

Re: openoffice is not work.

PostPosted:Tue Jan 10, 2012 5:02 am
by okmuser
I have the same issue, no preview on office documents (doc, xls, odt ...)

I am not sure whether there is any change in libreoffice update, which I did recently.

Already converted documents have no issues in the preview.

OpenKM: 5.1.9 (nightly build)

ADDED LOG:
Code: Select all
2012-01-10 16:21:28,080 INFO  [org.artofsolving.jodconverter.office.ProcessPoolOfficeManager] ProcessManager implementation is UnixProcessManager
2012-01-10 16:21:28,158 WARN  [org.artofsolving.jodconverter.office.OfficeProcess] profile dir '/tmp/.jodconverter_socket_host-127.0.0.1_port-2002' already exists; deleting
2012-01-10 16:21:28,199 INFO  [org.artofsolving.jodconverter.office.OfficeProcess] starting process with acceptString 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1' and profileDir '/tmp/.jodconverter_socket_host-127.0.0.1_port-2002'
2012-01-10 16:21:28,278 INFO  [org.artofsolving.jodconverter.office.OfficeProcess] started process; pid = 18975
2012-01-10 16:21:58,503 WARN  [com.openkm.servlet.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)
Code: Select all
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)
	... 143 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=2002,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=2002,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
2012-01-10 16:21:58,851 WARN  [net.xeoh.plugins.base.impl.classpath.loader.FileLoader] Supplied path does not exist. Unable to add plugins from there.
Cheers,

Re: openoffice is not work.

PostPosted:Tue Jan 10, 2012 8:34 am
by pavila
OpenKM start an OpenOffice / LibreOffice instance on its initialization process. This message says that can't find any OpenOffice / LibreOffice running instances: this OfficeManager is currently stopped

Maybe you did start OpenOffice / LibreOffice manually and closed it? Which OpenOffice or LibreOffice version are you running?

Re: openoffice is not work.

PostPosted:Tue Jan 10, 2012 9:10 am
by okmuser
Hi Pavila,

I even rebooted the server but still didn't work.

When I start soffice manually before starting OpenKM, the conversion works without problems.

I believe soffice is not starting automatically by OpenKM.

EDITED:
Sorry for hijacking the thread.. I think your previous question is for the first user. But I had the the same issues.

Cheers,

Re: openoffice is not work.

PostPosted:Wed Jan 11, 2012 6:37 am
by pavila
Let's do this:

- Stop JBoss
- Delete $JBOSS_HOME/server/default/log directory
- Start JBoss again
- Once JBoss has started, attach the $JBOSS_HOME/server/default/log/server.log file to this forum thread (zipped to reduce weight, please)

Re: openoffice is not work.

PostPosted:Fri Jan 20, 2012 1:56 pm
by minhhai_cd
i have installed

Openoffice 3.2.0( because i fail with Openoffice 3.3 before)

OpenKM version 5.1.9

My "OpenKM.cfg"
Code: Select all
system.openoffice=on
system.openoffice.tasks=5
system.openoffice.port=8100
system.webdav.server=on
system.openoffice.path=G:/Program Files/OpenOffice.org 3
system.img2pdf=G:/Program Files/ImageMagick-6.7.4-Q16/convert.exe
system.convert=G:/Program Files/ImageMagick-6.7.4-Q16/convert.exe
system.swftools.pdf2swf=G:\\Program Files\\SWFTools\\pdf2swf.exe
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.hbm2ddl=none
application.url=http://localhost:8080/OpenKM/frontend/index.jsp
I also config in like 1.png

Add make openoffice like http://artofsolving.com/node/11

--> It is ok-->

My Database: MySQL
Installed: ImageMagick-6.7.4-Q16, pdf2swf.exe,

I run run.bat for jboss-4.2.3.GA

and then i check:
cmd netstat -anp tcp
TCP 127.0.0.1:8100 0.0.0.0:0 ESTABLISHED

But result like server.log And word, excel, pdf, image also like 2.png can not preview for all

Please help, tks u

Re: openoffice is not work.

PostPosted:Fri Jan 20, 2012 2:57 pm
by minhhai_cd
I send you more ...

Please advise

Re: openoffice is not work.

PostPosted:Sat Jan 21, 2012 3:12 am
by okmuser
I don't know how to set the paths in windows, but by the look of it the path for pdf2swf and other programs (such as openoffice) paths does not seems similar.

Are you sure that you use two backslashes (G:\....) for pdf2swf and one forward slash (G:/......) for openoffice and others?

Cheers,

Re: openoffice is not work.

PostPosted:Sat Jan 21, 2012 4:13 am
by minhhai_cd
Last time i only use 1 backslashes \\ or / for all but also fail...like what you see: i use different backslashes to test error, do you think use not unit backslashes is bug?

\\ or / is same correct case in OS window, last time i set system.swftools.pdf2swf=G:/Program Files/SWFTools/pdf2swf.exe and got same bug..

Please guide, tks :?:

Re: openoffice is not work.

PostPosted:Sat Jan 21, 2012 12:20 pm
by okmuser
These are my settings on a Debian Wheezy Server;

I would suggest you to try ONLY the below settings with windows path format (eg. system.openoffice.path=C:\\Program Files\\OpenOffice.org 3)
Code: Select all
system.imagemagick.convert	String 	/usr/bin/convert
system.keyword.lowercase  	Boolean
system.login.lowercase	        Boolean
system.maintenance	                Boolean
system.ocr	                        String
system.openoffice.dictionary	String
system.openoffice.path	        String 	/usr/lib/libreoffice
system.openoffice.port	        Integer 	2002
system.openoffice.server	        String
system.openoffice.tasks	        Integer 	200
system.pdf.force.ocr	                Boolean 	
system.previewer	                String 	zviewer
system.readonly	                Boolean 	
system.swftools.pdf2swf	        String 	/usr/local/bin/pdf2swf
cheers,

Re: openoffice is not work.

PostPosted:Sun Jan 22, 2012 5:17 am
by minhhai_cd
Tks

I can not fix it like your config, please help ..

Br

Re: openoffice is not work.

PostPosted:Sun Jan 22, 2012 9:40 am
by okmuser
If your PDF files too have problem in preview then I think the issue is in the pdf2swf.exe path or program.

Can you recheck the path and the files in the path on pdf2swf.exe

and also try one conversion on command line and see whether the program is working properly.

with this path

G:/Program Files/SWFTools/pdf2swf.exe

Cheers,

Re: openoffice is not work.

PostPosted:Tue Jan 24, 2012 6:28 am
by minhhai_cd
Hello

I ran cmd already, it ran well and got output good result before, but still not work at openKM, maybe window OS not support at all?

Please help ?

Re: openoffice is not work.

PostPosted:Tue Jan 24, 2012 12:34 pm
by pavila
Please, attach the portion of the JBoss log file which contains the error. The log file is located at $JBOSS_HOME/server/default/log/server.log (Please, ZIP it before attach).

Re: openoffice is not work.

PostPosted:Tue Jan 24, 2012 4:03 pm
by minhhai_cd
I attached above message like server.zip(server.log) or you can download at here: http://forum.openkm.com/download/file.php?id=415

Please wiew and guide me, tks u
All times are UTC
Page 1 of 2
Powered by phpBB® Forum Software © phpBB Limited