openoffice is not work.

[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

[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,

[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?

[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,

[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)

[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

[minhhai_cd]

I send you more ...

Please advise

[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,

[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

[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,

[minhhai_cd]

Tks

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

Br

[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,

[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 ?

[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).

[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