Configure Tomcat service windows

Running as a Windows Service

Configure OpenKM in windows as service need some extra work because are several tomcat versions depending your hardware architecture.

We recommend before starting with installation have some good test editor application like Geany] because will be needed modify some xml files.

Step 1 - Download OpenKM Bundle

Download from [| sourceforge.net] the latest OpenKM bundle, name will be something like openkm-X.X.X-community-tomcat-bundle.zip.

Uncompress zip file at c:\. It will create a c:\tomcat-7.0.27 folder. Rename c:\tomcat-7.0.27 folder to c:\openkm

At the moment we have writting documentation the latest version is openkm-6.2.3-community-tomcat-bundle.zip

Step 2 - Select your tomcat

• http://archive.apache.org/dist/tomcat/tomcat-7/v7.0.27/bin/apache-tomcat-7.0.27-windows-x86.zip
• http://archive.apache.org/dist/tomcat/tomcat-7/v7.0.27/bin/apache-tomcat-7.0.27-windows-x64.zip
• http://archive.apache.org/dist/tomcat/tomcat-7/v7.0.27/bin/apache-tomcat-7.0.27-windows-i64.zip

Uncompress zip file at c:\. It will create a c:\tomcat-7.0.27 folder

At this point we got two folders c:\openkm which contains OpenKM bundle and tomcat-7.0.27 which contains tomcat in correspondence with your hardware architecture

Step 3 - Modify context.xml files

Modify file c:\tomcat-7.0.27\conf\context.xml.

After line:

<WatchedResource>WEB-INF/web.xml</WatchedResource>

Add lines:

<ResourceLink global="jdbc/OpenKMDS" name="jdbc/OpenKMDS" type="javax.sql.DataSource"/>
<ResourceLink global="mail/OpenKM" name="mail/OpenKM" type="javax.mail.Session"/>

Step 4 - Modify server.xml files

Modify file c:\tomcat-7.0.27\conf\server.xml.

After line:

<Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" />

Add lines:

<Resource auth="Container" driverClassName="org.hsqldb.jdbcDriver" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/OpenKMDS" password="" type="javax.sql.DataSource" url="jdbc:hsqldb:${catalina.base}/repository/okmdb" username="sa" validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"/> 
  
<Resource name="mail/OpenKM" auth="Container" type="javax.mail.Session"
            mail.smtp.host="localhost" mail.from="testing@openkm.com"/>

Donwload and install 32-bit/64-bit Windows Service Installer from http://archive.apache.org/dist/tomcat/tomcat-7/v7.0.27/bin/

Simply uncompress and overwrite openkm tomcat bundle into exiting tomcat folder.

Do not overwritten tomcat openkm bundle with tomcat windows service intaller !!!

Known issue

If you got openoffice or libreoffice configured will get some error when OpenKM try start as service, to solve it edit your general environment variable PATH and add your tomcat\lib\sigar\ folder, for example like PATH=...;C:\Program Files\OpenKM-6.2.1\tomcat\lib\sigar

Caused by: java.lang.UnsatisfiedLinkError: org.hyperic.sigar.Sigar.getSigNum(Ljava/lang/String;)I
	at org.hyperic.sigar.Sigar.getSigNum(Native Method)
	at org.hyperic.sigar.Sigar.kill(Sigar.java:275)