Almost there!

[laidback01]

So, I've installed openkm 6.2.3. Inside of a FreeBSD jail

I'm trying to get it to use either libreoffice or openoffice. I've got both installed, but neither works at the moment. I think it's got something to do with being in a jail, but that's not a for sure. Anyway, there's a way to set which port that the soffice.bin listener will attache to, is there a way to set the IP?

right now, I've attempted to use both libreaoffice and apache openoffice with identical results:

Code: Select all

2013-06-04 19:37:16,836 [localhost-startStop-1] INFO  com.openkm.util.DocConverter - *** Build Office Manager ***
2013-06-04 19:37:16,836 [localhost-startStop-1] INFO  com.openkm.util.DocConverter - system.openoffice.path=/usr/local/openoffice-3.4.1/openoffice.org3/
2013-06-04 19:37:16,837 [localhost-startStop-1] INFO  com.openkm.util.DocConverter - system.openoffice.tasks=200
2013-06-04 19:37:16,837 [localhost-startStop-1] INFO  com.openkm.util.DocConverter - system.openoffice.port=9000
2013-06-04 19:37:16,877 [localhost-startStop-1] INFO  org.artofsolving.jodconverter.office.ProcessPoolOfficeManager - ProcessManager implementation is SigarProcessManager
2013-06-04 19:37:16,903 [localhost-startStop-1] 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:64)
	at org.artofsolving.jodconverter.office.PooledOfficeManager.start(PooledOfficeManager.java:101)
	at org.artofsolving.jodconverter.office.ProcessPoolOfficeManager.start(ProcessPoolOfficeManager.java:62)
	at com.openkm.util.DocConverter.start(DocConverter.java:149)
	at com.openkm.servlet.RepositoryStartupServlet.start(RepositoryStartupServlet.java:285)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:127)
	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5123)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5407)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1114)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1672)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:722)
Caused by: java.util.concurrent.ExecutionException: java.lang.UnsatisfiedLinkError: org.hyperic.sigar.ptql.SigarProcessQuery.create(Ljava/lang/String;)V
	at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)
	at java.util.concurrent.FutureTask.get(FutureTask.java:111)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:62)
	... 23 more
Caused by: java.lang.UnsatisfiedLinkError: org.hyperic.sigar.ptql.SigarProcessQuery.create(Ljava/lang/String;)V
	at org.hyperic.sigar.ptql.SigarProcessQuery.create(Native Method)
	at org.hyperic.sigar.ptql.ProcessQueryFactory.getQuery(ProcessQueryFactory.java:66)
	at org.hyperic.sigar.ptql.ProcessFinder.find(ProcessFinder.java:68)
	at org.hyperic.sigar.ptql.ProcessFinder.find(ProcessFinder.java:56)
	at org.artofsolving.jodconverter.process.SigarProcessManager.findPid(SigarProcessManager.java:42)
	at org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:65)
	at org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:60)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:119)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.access$000(ManagedOfficeProcess.java:31)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess$1.run(ManagedOfficeProcess.java:58)
	... 6 more

I know others have fired it up standalone on freebsd, but since it seems to want to attach to 127.0.0.1, and the jail will redirect that to the jail ip, this might be the issue. Any help?


Another Question:
I just got PDF Text extraction to work (yay, my search engine is indexing now!). So... I've already loaded about a hundred or so PDFs into this, so has my wife. Now... how do I re-run the Text Extractor across the existing PDFs? is this a marker set in the database somewhere?

thanks!

[laidback01]

Okay, so I couldn't sort out what button to push to reattempt the TextExtract... but after rooting around a while, I chose to run this and was rewarded with good results:

Code: Select all

update okm_node_document 
      set ndc_text_extracted='F'
 where ndc_text is null

anyway, that worked. Please let me know if there would be any side effects to doing that.

thanks

[jllort]

Please do not merge several question on same post, that will create confusion to other users, and me. About reindexing is correct what you have done. About soffice service, change port etc... normally should not be necessary is extrange you need doing it. Confirm to me :

1- Into /usr/local/openoffice-3.4.1/openoffice.org3/ there's a folder called program ?
2- How did you install libreoffice / openoffice from repository or by hand ?

[wthie]

Hi

after some googling I found the missing link
The system tries to start LibreOffice but stumbles over

Code: Select all

java.lang.UnsatisfiedLinkError: org.hyperic.sigar.ptql.SigarProcessQuery.create(Ljava/lang/String;)V

So, where is the hyperic.sigar library, a quick search shows libraries for

Code: Select all

/usr/local/openkm-6.2.5-community-tomcat-bundle/lib/sigar
/usr/local/openkm-6.2.5-community-tomcat-bundle/lib/sigar/libsigar-amd64-linux.so
/usr/local/openkm-6.2.5-community-tomcat-bundle/lib/sigar/libsigar-x86-linux.so
/usr/local/openkm-6.2.5-community-tomcat-bundle/lib/sigar/sigar-x86-winnt.dll
/usr/local/openkm-6.2.5-community-tomcat-bundle/lib/sigar/sigar-amd64-winnt.dll

but not for FreeBSD!

The port for the libsigar exists in

Code: Select all

/usr/ports/sysutils/hyperic-sigar

but doing a make install shows, that the port is marked broken for quite some time and nobody is working on it

HTH, Werner

[jllort]

TEll us if you get it running in FreeBSD and we will share this information with other community users in our wiki

[laidback01]

I never got the emails for this or I'd have replied to it. I've had OpenKM running now for the past year or so with good success. most of it works well enough, and it's extremely useful to me.

New server in place, version 10.1.0 of FreeBSD, using poudriere - will post configs and necessary steps to make OpenKM work in a FreeBSD jail.

[laidback01]

Because this is FreeBSD, the sigar tools just don't work - I'm not a java guy, or I'd try to sort it out... so the FreeBSD environment is hampered by not getting previews in the OpenKM application for anything other than PDF. However, to be clear, it seems text extraction works fine, as my files do come up in the search when looked for. If there is other functionality provided by having libreoffice listen on a port, I cannot say - I've apparently not noticed.

okay, to get OpenKM to work in FreeBSD:
Install these:
archivers/unzip
archivers/zip
devel/git
editors/vim
editors/libreoffice
graphics/ImageMagick
graphics/poppler
graphics/swftools
java/openjdk8
shells/bash
shells/fish
sysutils/tmux
ports-mgmt/dialog4ports
ports-mgmt/pkg
print/pdflib
www/tomcat7
x11/xauth

You can see I installed Libre Office regardless - it does listen on a port if you as it to run headless, however, because the SigarProcessManager is not available, it cannot be used.
As for how to load these, it's your preference on FreeBSD - I used Poudriere, however, I'm sure using pkg alone will be just fine. Since you can't use Libre/Open office currently, you can probably save some 500-1000mb of installed packages if you skip that! Not to mention agonizing compile times.

I used the community-war zip file, and just extracted this into the tomcat dir - as you would any other war; my url ends up as http://openkm.my.house:8080/OpenKM/frontend/index.jsp and it works just fine.

It is extremely fast, thank you for the excellent software, if I can sort out a solution, I will, but it's not likely given my skillset.

thanks,
Jack

[jllort]

Other solution is got openoffice started as service in other server ( use it only for conversion, that is good idea in huge repositories ), but I'm not totally sure if 6.3 community comes with this configuration feature.