KnowledgeTree DMS On An ISPConfig Server Within 10 Easy Steps

KnowledgeTree DMS On An ISPConfig Server Within 10 Easy Steps 

Version 1.1
Author: <hans> [at] bb-hosting [dot] org>

Introduction:
KnowledgeTree is a commercial open source document management system (DMS).
A powerful tool that allows your organisation to secure, share, track and manage the document and records you depend on. With this howto, I guide you to setup the latest open source version of KnowledgeTree, which is version 3.4 at the moment.

After installation, you can access KnowledgeTree at http://dms.mywebsite.tld/

In this how to, I will use just as an example:
- KnowledgeTree open source version 3.1b
- Website: http://dms.yourwebsite.tld/
- MySQL database: web1_db1
- MySQL username: web1_u1
- MySQL password: mysqlpassword
- The used Linux distribution is Debian
Step 1 - Create a website:In ISPConfig, create a website via 「New site」 in the main menu.
On the tab called 「Basis」 use dms for the hostname and mywebsite.tld for the domain name.
Enable MySQL and PHP scripts for this website but disable PHP Safe Mode. Step 2 - Create a Administator user for the website:

In ISPConfig, create an Administrator user:
In the main menu select 「ISP Manager」, select your new website called dms.mywebsite.tld in the structure tree and press the tab 「User and Email」.
Press 「new」 and define a new user and its email address. Give this user administrator rights and press 「Save」.

Step 3 - Create a MySQL database for the website:

Click on the tab called 「Options」 and create a new database for the website.
ISPConfig will show you:
MySQL database: web_db1
MySQL username: web1_u1
MySQL password: mysqlpassword
Then you define a password for the database user and press 「Save」.

Step 4 - Download/extract the packages and remove the tar.gz files:

Download KnowledgeTree DMS:

wget http://downloads.sourceforge.net/kt-dms/knowledgeTree-src-UNSTABLE.3.4.2007-02-26-173332.tgz

Extract the package:

tar -zxvf knowledgeTree*.tgz

Remove the .tgz files:

rm *.tgz

Step 5 - Move the knowledgeTree contents and delete the empty directory:

Move the content of the knowledgeTree directory to your web root directory an remove the .htaccess files provided by KnowledgeTree:

cd knowledgeTree

mv * ../

cd ../

rmdir knowledgeTree

rm .htaccess

rm bin/.htaccess

rm config/.htaccess

rm docs/.htaccess

rm kthelp/.htaccess

rm lib/.htaccess

rm /sql/.htaccess

rm /tests/.htaccess

rm thirdparty/.htaccess

rm thirdparty/icon-theme/.htaccess

rm thirdparty/phpmailer/.htaccess

rm var/Documents/.htaccess

rm var/log/.htaccess

rm var/tmp/.htaccess

Step 6 - Define the permissions:

cd /var/www/web1/

chown -R www-data:www-data web/

Step 7 – Database setup:

cd web/sql/mysql/install/

Create the database:

mysqladmin -u root -p create web1_db1 (an error occurs, as we created th db within ISPConfig already)

Create the structure:

mysql -u root -p web1_db1 < structure.sql

Create the data:

mysql -u root -p web1_db1 < data.sql

Step  8 - Download some extra apps needed by KnowledgeTree:

apt-get install xpdf zip unzip catdoc pdftotext

If some apps are already installed, you will be informed.
Note: apt get is for Debian Linux, if you run a different Linux distro, this command might be different.

Step 9 – Make some settings in the KnowledgeTree configuration file:

Open the /web/config/config.ini file in your texteditor and change the database login details like this:

; Database login details
dbHost        = localhost
dbName        = web1_db1
dbUser        = web1_u1
dbPass        = mysqlpassword
dbPort        = default

Configure your e-mailserver :

emailServer = localhost
emailPort = default
emailAuthentication = false
emailUsername = administrator (mail)username as defined in step 2
emailPassword = administrator (mail)userpassword as defined in step 2

Define the indexer commands like this:

xls2csv = xls2csv
pdftotext = pdftotext
catppt = catdoc (this is for Debian, use catppt = catppt, if this package is not included within the catdoc package)
pstotext = pstotext
catdoc = catdoc
antiword = antiword.exe

Step 10 – Proceed with the KnowledgeTree setup program

You should now be able to verify setup successfully: http://dms.mywebsite.tld/setup (this checks for .htaccess and PHP/MySQL availability/compatibility) once that is ok, you should also click on "Post-installation checkup" at the bottom, which will verify the filesystem permissions and database connectivity.

Note:

The KnowledgeTree setup program will advise you with some settings which you have to make within your php.ini file.  On my Debian system this is the file: /etc/php4/apache2/php.ini
You can change some settings, but if you’ve changed your php.ini file,  do not forget to restart Apache2 with the command:

/etc/init.d/apache2 restart

That's it! logon at http://dms.mywebsite.tld (use username "admin" and password "admin") and enjoy a truly powerful document management system!

More information about KnowledgeTree: http://www.ktdms.com/