My personal notes on all things technical and factual....

Clayton's Tech Bits

Search this site:

Custom Search

Wed, 09 Sep 2009

/SW/business/KnowledgeTree: Installing a New KnowledgeTree instance

If this is a first install on a new server, this guide[1] is a must read. Some of the highlights:

apt-get install apache2 php5 php5-curl php5-mysql mysql-server mysql-client xpdf zip unzip catdoc pstotext

apt-get install python-reportlab python-imaging python-uno antiword sun-java5-jre sun-java5-bin lynx openoffice.org-java

And do not forget to bump memory_limit up to at least 64 in /etc/php5/apache2/php.ini.

Get the latest source tarball from here[2][3].

In your desired web root, make a copy of knowledgetree for this instance, then sim link a simpler name, ie.

tar -xvf ktdms-src-oss-3.5.4a.tgz 
mv kt-dms-oss/ kt-dms-oss-3.5.4a
ln -s kt-dms-oss-3.5.4a/ knowledgetree

Give ownership to the web server process:

chown -R www-data:www-data kt-dms-oss-3.5.4a

Create a new MySQL database for the new instance:

#  mysql -u root -p
Enter password: mr4gvc7s
mysql> create database apps_kt;
mysql> grant all on apps_kt.* to 'apps_kt'@'%' identified by 'password';
flush privileges;

Edit config/config.ini to agree:

dbName           = apps_kt
dbUser           = apps_kt
dbPass           = password
dbAdminUser      = apps_kt
dbAdminPass      = password

Now import the database from sql/mysql/install:

mysql -u root -p apps_kt < structure.sql
mysql -u root -p apps_kt < data.sql

Separate out the configuration and the data:

mv knowledgetree/var/ kt-var
mv knowledgetree/config/config.ini kt-config.ini
cd knowledgetree
ln -s ../kt-var/ var
cd config/
ln -s ../../kt-config.ini config.ini

Now login to the new KnowledgeTree instance with the default:

user: admin
password: admin

and change the admin password.

Anticipated path for upgrading to a new version of Knowledgetree:

create a copy of the code of the new version
check for changes between the old config.ini and the new one
symlink (ln -s) var and config/config.ini in the new code to the old location in the top-level directory
run the upgrade script: knowledgetree/setup/upgrade.php
move the symlink for the short name (ie. knowledgetree) to the new copy of the code
test the new code
if the new code is broken, move the short name symlink back to the old code, and hopefully it should still work and down-time should have been just minutes.

[1] http://wiki.knowledgetree.com/Debian_4_Installation_Instructions#Grab_a_few_more_packages
[2] http://www.knowledgetree.com/try-now/knowledgetree_open_source_download
[3] http://www.knowledgetree.com/products/opensource/downloadopensource

posted at: 12:46 | path: /SW/business/KnowledgeTree | permanent link to this entry

Home

Contact

Resumé / C.V.

Links

Categories:

Archives:

Subscribe XML RSS Feed

Wed, 09 Sep 2009