KnowledgeTree DMS On An ISPConfig Server Within 10 Easy Steps
Author: <hans> [at] bb-hosting [dot] org>
Last edited 28/02/2007
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:
Extract the package:
tar -zxvf knowledgeTree*.tgz
Remove the .tgz files:
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:
mv * ../
Step 6 - Define the permissions:
chown -R www-data:www-data web/
Step 7 – Database setup:
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.
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:
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/