After studying the OpenKM for a couple weeks, I have successfully to setup the OpenKM on a total new installed Ubuntu Server only using the OpenKM's configuration files and the WAR.
My Target:
1. Deploy OpenKM with only a WAR file on New Installed Ubuntu/Tomcat
2. Implement MySQL instead of HSQL
3. Implement all preview functions for PDFs/Office Documents/Image/Videos...
4. Implement the anti-virus function
Detail Setup Guide:
Step 1 - OS Setup
Step 2 - OS Network Configuration
Step 3 - SSH Client with Putty
Step 4 - OpenKM Setup (NOTE: typing mistakes in video MySQL5InnoDBDialect during setup OpenKM.cfg)
Step 5 - OpenKM Testing
Finished!!!
(you can get the following notes for the videos, with it you can copy/paste commands simply for your personal trial. Of course, remember to change my name to your name... haha..., Enjoy it.!!!)
Notes for OpenKM Installation on Ubuntu
Step 1 - OS Setup
Follow the wizard and remember to Select install “OpenSSH” only
Step 2 - OS Network Configuration
$ sudo bash
# vi /etc/network/interfaces
iface eth0 inet static
address 188.4.72.198
network 255.255.255.0
gateway 188.4.72.231
# /etc/resolvconf/resolv.conf.d/base
nameserver 188.4.72.16
nameserver 188.4.72.7
# resolvconf -u
Step 3 - OpenKM Setup
Installing MySQL Server
# apt-get install mysql-server
after that it will prompt you to input the Master password for MYSQL server (input and REMEMBER IT……)
Installing Tomcat7 Server
# apt-get install libtcnative-1 libtomcat7-java tomcat7 tomcat7-admin tomcat7-common tomcat7-docs tomcat7-examples tomcat7-user
# apt-get install unzip
# wget http://liquidtelecom.dl.sourceforge.net/project/openkm/6.3/openkm-6.3.0-community-tomcat-bundle.zip
# unzip openkm-6.3.0-community-tomcat-bundle.zip
Configuration MySQL Server (Optional)
# vi /etc/mysql/my.cnf and
under [mysqld] section in your ini file, add:
default-storage-engine = innodb
Check if your MySQL installation has InnoDB engine enabled:
# service mysql restart
# mysql -h localhost -u root -p
mysql> show engines;
and continue create OpenKM db in mysql tool (remember to change your password)
CREATE DATABASE okmdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
CREATE USER openkm@localhost IDENTIFIED BY 'okmtest123';
GRANT ALL ON okmdb.* TO openkm@localhost WITH GRANT OPTION;
Build some Links
# ln -s /var/lib/tomcat7/common /usr/share/tomcat7/common
# ln -s /var/lib/tomcat7/server /usr/share/tomcat7/server
# ln -s /var/log/tomcat7 /usr/share/tomcat7/logs
# ln -s /var/lib/tomcat7/repository /usr/share/tomcat7/repository
# ln -s /etc/tomcat7 /usr/share/tomcat7/conf
Preparing OpenKM.cfg
# cp /home/kevinchui/tomcat/OpenKM.cfg /usr/share/tomcat7
modify the line in file /usr/share/tomcat7/OpenKM.cfg (note that in the video, it was wrongly typed as "i" which should be capitalized in MySQL5InnoDBDialect)
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.hbm2ddl=create
Preparing OpenKM.xml, PropertyGroups
# cp /home/kevinchui/tomcat/OpenKM.xml /usr/share/tomcat7
# cp /home/kevinchui/tomcat/PropertyGroups.xml /usr/share/tomcat7
Preparing setenv.sh (Environment Setting)
# cp /home/kevinchui/tomcat/bin/setenv.sh /usr/share/tomcat7/bin
Remark the line in file /usr/share/tomcat7/bin/setenv.sh
#CATALINA_PID=$CATALINA_HOME/catalina.pid
Preparing lib for OpenKM
# cp /home/kevinchui/tomcat/lib/javassist-*.jar /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/jstl-1.2.jar /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/jta-1.1.jar /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/log4j-1.2.17.jar /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/log4j-initializer.jar /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/mail-1.*.jar /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/mysql-connector-java-5.1.12-bin.jar /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/tomcat-juli-adapters.jar /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/unicode.ttf /usr/share/tomcat7/lib
# cp /home/kevinchui/tomcat/lib/sigar /usr/share/tomcat7/lib/sigar -R
# cp /home/kevinchui/tomcat/lib/hsqldb.jar /usr/share/tomcat7/lib/
Preparing log4j configuration
# cp /home/kevinchui/tomcat/conf/log4j.properties /etc/tomcat7
Configurating context.xml
# vi /etc/tomcat7/context.xml
find the follwing line
and add the following lines after it
Configurating server.xml
# vi /etc/tomcat7/server.xml
find the follwing line
and add the following lines after it
then find the follwing line
and add the following 7 lines after it
username="openkm" password="okmtest123" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/okmdb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"/>
then find and Modify the line
FROM:
TO:
Set directories privileges
# chown tomcat7.tomcat7 /usr/share/tomcat7 /var/lib/tomcat7 /etc/tomcat7/* -R
Deploying OpenKM.war
# service tomcat7 stop
# cp /home/kevinchui/tomcat/webapps/OpenKM.war /var/lib/tomcat7/webapps/
Implement the rest
# apt-get install libreoffice imagemagick clamav clamav-daemon
Update the Virus Definitions
# freshclam
Prepareing SWFTOOLS
# cp /home/kevinchui/tomcat/bin/pdf2swf /usr/bin
Start TOMCAT server
# service tomcat7 start
OpenKM additional Configurations for Preview/Antivirus
Login OpenKM -> Administration -> Configuration and set the followings.
system.openoffice.path
/usr/lib/libreoffice
system.imagemagick.convert
/usr/bin/convert
system.swftools.pdf2swf
/usr/bin/pdf2swf -f -T 9 -t -s storeallcharacters ${fileIn} -o ${fileOut}
system.webdav.fix
true
system.webdav.server
true
system.ghostscript.ps2pdf
/usr/bin/pdf2swf
system.antivir
/usr/bin/clamscan
application.url
http://188.4.72.198:8080/OpenKM/index.jsp
The last step: Logout OpenKM and restart tomcat server
# service tomcat7 restart
