First I am not an expert, but want to share my experience and hope you all can get shorter to your KM goal. So please forgive me if any stupid thing did here and mistakes found...
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
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;
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
# vi /etc/tomcat7/context.xml
find the follwing line WEB-INF/web.xml
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 maxActive="100" maxIdle="30" maxWait="10000" validationQuery="select 1" username="openkm" password="okmtest123" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/okmdb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"/>
Recently, I am searching a software with Captive Portal Service. After surfing the web, I got the Zeroshell. Very surprising, it comes with tones of features that I want to implement on a network with better management. Like Lan2Lan VPN, Bandwidth Control and Balancing, QoS, Human readable logging... All are great. If you are facing plenty daily problem originated from Network management, take a look here. http://www.zeroshell.org/.
I used Lotus Client 8.5 beta at Ubuntu 8.0.4 fine. However, I cannot open attachment with Lotus Client 8.5 at Ubuntu 9.0.4. And got the following messages.
<span style="font-weight: bold;">/opt/ibm/lotus/notes/framework/../openwith: error while loading shared libraries: libgnome-desktop-2.so.2: cannot open shared object file: No such file or directory</span>
The Solution is very simple: Make a symbolic link to lead it find the library file
If you found that the displaying fonts and window sizes are strange using Lotus Notes Client 8.5 on Ubuntu 9.0.4, try to install the following packing. It works, at least, for me.
