Page 1 of 1

Openoffice issue cannot preview MS doc, docx or txt

PostPosted:Fri Mar 11, 2011 3:35 pm
by plus8
Hi Guys,

I have recently downloaded the OpenKM and started deploying it on a fresh OS to test out the DMS. However i have problem previewing the .doc/docx/txt files. It shows "Document URL not provided or invalid".

I have started with a fresh OS, and done apt-get for java-jdk1.6, downloaded the latest full package of 3.3.0 from open office, installed swftools0.9.1.

I did a "#cat server.log | grep soff"--> nothing found
"#cat server.log | grep error"--> nothing found

What else do i need or did i miss any package or configuration?

Here are my configurations.
Code: Select all
OpenKM Version: 5.0.3 
OS: Ubuntu 10.10 server
OpenOffice version: 3.3.0
openkm.cfg
Code: Select all
system.openoffice.path=/opt/openoffice.org3
system.openoffice.tasks=5
system.openoffice.port=2100
system.img2pdf=/usr/bin/convert
system.pdf2swf=/usr/local/bin/pdf2swf

Re: Openoffice issue cannot preview MS doc, docx or txt

PostPosted:Sat Mar 12, 2011 10:51 am
by jllort
do some
Code: Select all
tail -f server.log
to see on live

do you have soffice started
Code: Select all
ps -ax | grep soffice

Re: Openoffice issue cannot preview MS doc, docx or txt

PostPosted:Sat Mar 12, 2011 2:11 pm
by plus8
jllort wrote:do some
Code: Select all
tail -f server.log
to see on live

do you have soffice started
Code: Select all
ps -ax | grep soffice

While tailing the logs i got this error when i click on preview and I cannot find any soffice running.
Code: Select all
2011-03-12 05:59:41,292 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/OpenKM].[OKMDownloadServlet]] Servlet.service() for servlet OKMDownloadServlet threw exception
java.lang.ClassNotFoundException: com.sun.star.io.IOException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
        at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(OfficeDocumentConverter.java:72)
        at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(OfficeDocumentConverter.java:66)
        at com.openkm.util.DocConverter.convert(DocConverter.java:169)
        at com.openkm.util.DocConverter.doc2pdf(DocConverter.java:190)
        at com.openkm.frontend.server.OKMDownloadServlet.service(OKMDownloadServlet.java:145)
        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:636)

Re: Openoffice issue cannot preview MS doc, docx or txt

PostPosted:Mon Mar 14, 2011 9:13 pm
by pavila
OpenKM 5.0.x has been succefully tested with OpenOffice 3.2.x but I can't say it works with OpenOffice 3.3.x because has not been tested. Maybe this is the problem. If you are on Ubuntu, I recommend to install OpenOffice from repository using the apt-get / aptitude tool. See http://wiki.openkm.com/index.php/OpenOffice.org for more info.

Re: Openoffice issue cannot preview MS doc, docx or txt

PostPosted:Tue Mar 15, 2011 7:37 am
by jllort
Seems some open office package is not installed. I recommend what says pavila, install with apt-get

Re: Openoffice issue cannot preview MS doc, docx or txt

PostPosted:Tue Mar 15, 2011 9:43 am
by plus8
jllort wrote:Seems some open office package is not installed. I recommend what says pavila, install with apt-get
pavila wrote:OpenKM 5.0.x has been succefully tested with OpenOffice 3.2.x but I can't say it works with OpenOffice 3.3.x because has not been tested. Maybe this is the problem. If you are on Ubuntu, I recommend to install OpenOffice from repository using the apt-get / aptitude tool. See http://wiki.openkm.com/index.php/OpenOffice.org for more info.
Hi Pavila and Jllort,

Before posting i have test 3.1, 3.2 and 3.3 I still have the same problem. In every version i ensured that openoffice.org-calc, openoffice.org-writer, openoffice.org-draw, and openoffice.org-math, where installed.

For the openoffice 3.2 i did the following to install.
Code: Select all
# sudo apt-get install openoffice.org openoffice.org-calc openoffice.org-writer openoffice.org-draw openoffice.org-math
I read somewhere about running headless mode, is this required for OpenKM 5.0.3? I believe that nothing is feeding to the DocConverter.java, that is why the files doesnt appear in the tmp or cache folder. Also i ensure that the whole Jboss folder is fully accessible.
Code: Select all
#sudo chmod -R 777 /opt/Jbos........../ 

Re: Openoffice issue cannot preview MS doc, docx or txt

PostPosted:Wed Mar 16, 2011 4:10 pm
by plus8
Hi All,

I tried removing 3.3.0 again downloading 3.2.1 to test but the result is still the same.

in OpenKM.cfg.. Should i put
Code: Select all
system.openoffice.path=/opt/openoffice.org3
or
Code: Select all
system.openoffice.path=/opt/openoffice.org3/program

Re: Openoffice issue cannot preview MS doc, docx or txt

PostPosted:Wed Mar 16, 2011 4:12 pm
by jllort
On ubuntu simply executing
Code: Select all
sudo aptitude openoffice.org 
You've got all packages you need to be installed

But open office will not be installed on /opt by deafult it'll be installed on /usr/lib/openoffice

After starting OpenKM soffice service is running ?