Monday, November 14, 2011

Connect Omnis Studio to MySQL on Ubuntu

The environment is a 32-bit single CPU machine running Ubuntu 10.04.3 LTS. I will be using Omnis Studio 5.1.1.

The first step is to download and install the software. Nothing special is needed for this step.

Omnis Studio will crash when libc6-i686 is installed because it's not compatible with tls (thread local storage).

The second step is to get the MySQL DAM working.
The issue with the DAM is that the SSL symbols in the so file can't be resolved. You can see this by using "ld -M xcomp/dammysql.so > /dev/null"
The fix for this is to modify the omnisI386 script and add the following lines:
LD_PRELOAD=/lib/libssl.so.0.9.8
export LD_PRELOAD

Now the MySQL DAM should work!