Debian 3.1 Installation Instructions

From KnowledgeTree Community

Here are the steps required to install KnowledgeTree on a machine running Debian GNU/Linux 3.1 (aka sarge):

Check that you satisfy the pre-requisites for installation. As specified in the installation document (KnowledgeTree_3.0_Quick_Start_for_Administrators_v1.0.pdf), the Generic Platform Manual Installation requires Apache 1.3 or above, MySQL 4.0 or above and PHP 4.3.0 or above (but not PHP 5.0 or above)

Login as root and simply execute the following commands:

move to the src folder (i usually keep my zip/tgz bundles here)

1. > cd /usr/local/src

get the knowledgeTree bundle: (note: your mirror maybe different)

1. > wget http://umn.dl.sourceforge.net/sourceforge/kt-dms/knowledgeTree-3.0.1.tgz

extract the bundle:

1. > tar -zxvf knowledgeTree-3.0.1.tgz

move the extracted folder to the server root (mine is /var/www)

1. > mv knowledgeTree/ /var/www/

i will refer to this location as SERVER_ROOT

change to the server root:

1. > cd SERVER_ROOT

change the ownership to the user that runs apache - mine is www-data (at a minimum the var folder must be server writable - you can further restrict other folders)

1. > chown -R www-data:www-data knowledgeTree/

let's get the db ready:

1. > cd knowledgeTree/sql/mysql/install/

create the database:

1. > mysqladmin -u root -p create dms

create the structure:

1. > mysql -u root -p dms < structure.sql

create the data:

1. > mysql -u root -p dms < data.sql

create the default users (you might want to change the default user names and passwords in the user.sql file under SERVER_ROOT/knowledgeTree/sql/mysql/install/):

1. > mysql -u root -p dms < user.sql

open the config.ini file (to ensure proper values - this is the prime location for errors that would affect db connectivity, so take care here)

1. > vi SERVER_ROOT/knowledgeTree/config/config.ini

check the values of the 4 lines:

Database login details

dbHost = localhost/SERVER_IP ( you can try localhost or 127.0.0.1; the latter works for me) dbName = DMS_DATABASE_NAME ( i used the default "dms", but if it is different in your case, change it here) dbUser = DMS_USERNAME dbPass = DMS_PASSWORD

another important point to remember: if you used the user.sql script above or the "grant" statement to give access to the dms databse to the dms admin user, then chances are that MySQL created a "new style" password and you might not be able to login even if you use the right credentials.

so it is always ok to run the following command:

1. > mysql -u root -p

Enter password: (enter your password) mysql> update mysql.user set password = old_password('DMS_PASSWORD') where user='DMS_USERNAME'; mysql> commit; mysql> quit

this will convert the password to the "old style" password and you should not have any more problems with the db.

you also need certain software packages that KnowledgeTree uses to manipulate documents or extract/compress them:

debian makes this a breeze! (if you already have some of these packages, relax - no harm will come to your robust debian!)

1. > apt-get install xpdf zip unzip catdoc

you should now be able to verify setup successfully: http://localhost/knowledgeTree/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.

that's it! logon at http://localhost/knowledgeTree/ (use username "admin" and password "admin") and enjoy a truly powerful document management system!