When installing or migrating from KnowledgeTree (Document Management System) version 3.0.6 to 3.0.7.2 on CentOS using the KnowledgeTree universal installer one might run into the following issue:

None of the Scheduler's tasks get executed correctly. 

All the tasks exit with the following errorcode:

[db_error: message="DB Error: extension not found" code=-25 mode=return level=notice prefix="" info="Array"] 

You can test this manually:

# /usr/local/zend/bin/php /usr/share/knowledgetree-ce/search2/bin/cronDocumentProcessor.php
[db_error: message="DB Error: extension not found" code=-25 mode=return level=notice prefix="" info="Array"]

The problem here is that the variable LD_LIBRARY_PATH is not set correctly, causing the zend php binary not being able to find the correct database module.
Let's try setting this variable manually:

# export LD_LIBRARY_PATH=/usr/local/zend/lib/
# /usr/local/zend/bin/php /usr/share/knowledgetree-ce/search2/bin/cronDocumentProcessor.php
#

Fixed! Now, this only fixes the problem in our current shell, how do we make this fix persistent system wide? By creating a file in /etc/profile.d/ setting the variable system wide:

# vi /etc/profile.d/kt.sh

With the contents:

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/local/zend/lib/

Now, lets make this file executable:

# chmod +x /etc/profile.d/kt.sh

Now, all that's left to do is restart KnowledgeTree so that it reads the new content of the LD_LIBRARY_PATH variable and our problem is solved.

Bug reported to KnowledgeTree: http://issues.knowledgetree.com/browse/KTS-4576

Here are some steps I always perform when installing a new server...
Some of these steps apply for every new server I install, some are CentOS specific, but believe me, these steps will help you!

1. Install 'screen'

Screen is a kind of console based window manager. It allows you to run several virtual shells within one ssh connection. It also allows you to detach a session enabling you to log out of the server without losing any running jobs and reattach to the session later when you log back in to the server.

For more information on screen: http://en.wikipedia.org/wiki/GNU_Screen

On debian:

apt-get install screen

On Centos:

yum install screen

2. [centos-only] Add dag's repositories!

Dag's repositories provide you with a lot of addon software for your RHEL/CentOS based server. These are the steps to install them on a RHEL5 / Centos5 system.

wget http://apt.sw.be/redhat/el5/en/i386/RPMS.dag/rpmforge-release-0.3.6-1.el...
rpm --import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt
rpm --import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt

3. [centos-only] Install apt-get!

Apt-get on CentOS exists! And works! And is faster then yum! And nice to work with... Please! Try it out :x

yum check-update
yum install apt

vi /etc/apt/sources.list.d/os.list

Edit this file to include the needed repositories

apt-get update

4. Enable bash-completion

Who can live without?

Install bash-completion (skip this on a standard debian-system)

apt-get/yum install bash-completion

Edit the file /etc/bashrc or /etc/bash.bashrc to include the following:

# enable programmable completion features (you don't need to enable
# this, if it's already enabled in /etc/bash.bashrc and /etc/profile
# sources /etc/bash.bashrc).
if [ -f /etc/bash_completion ]; then
    . /etc/bash_completion
fi

Today I was trying to dump an oracle database into a mysql dumpfile, and no mather what I tried (using the mysql migration toolkit on windows) it always failed…

The first try gave me some import errors telling me that there was an invalid value ‘x0′ in the field lists, google didn’t help me :(

The second try gave me no import errors but I ended up with a really weird mysql database changing the row count from a specific table on each query (without modifying the database in between).

All the other tries gave me headache.

So I decided to install the mysql migration toolkit on a linux system, I chose CentOs since installing an rpm should be faster (and more easy, at least I hoped so), well BAD LUCK to myself as the only version available here at the office was a CentOs 4.4 and I didn’t want to download a newer one.

When trying to install the migration toolkit on this CentOs operating system I ran into some dependancy errors:

libjvm.so is needed by mysql-gui-tools-5.0r11-1rhel4.i386
libjvm.so(SUNWprivate_1.1) is needed by mysql-gui-tools-5.0r11-1rhel4.i386

Well, I ended my day today by fixing the dependancies, but altough everything is fine, the mysql migration toolkit rpm contains a bug telling me that the dependancies are NOT met :-(