LiveCode Forums.

Posted: **Sun May 08, 2011 12:06 am**

I have a debian 5 (64, amd_64) with LiveCode Server.

It's working fine.

I've added a MySQL DB. The DB is working, through external client.

However, within my irev file, I got the error message : "revdberr,invalid database type"

I did a ldd on the file dbmysql.so (in /extensions)

libstdc++.so.6 => /usr/lib32/libstdc++.so.6 (0xb760d000)
libmysqlclient.so.15 => not found
libc.so.6 => /lib32/libc.so.6 (0xb74bb000)
libm.so.6 => /lib32/libm.so.6 (0xb7497000)
/lib/ld-linux.so.2 (0xb770f000)
libgcc_s.so.1 => /usr/lib32/libgcc_s.so.1 (0xb7489000)

Again... another lib missing. It drives me nuts.

How could I install this lib in /usr/lib32 ?

Posted: **Sun May 08, 2011 2:01 am**

No personal experience, but you might look at this:

http://forum.teamspeak.com/showthread.p ... queeze-Way

Posted: **Sun May 08, 2011 9:42 am**

wsamples wrote:No personal experience, but you might look at this:

Thanks. I've tried this method.

But I got another error message :
"The architecture of the package(i386) is not equal to the architecture of the system (amd64)."

Posted: **Sun May 08, 2011 9:53 am**

Great ! Thank you.

I was able to trace the error message. And I found this : dpkg -i --force-architecture *deb

So I summarize the differents steps :

on a debian, 64, AMD, in order to install libmysqlclient15, needed by LiveCode Server (for the file dbmyslq.so)

Code: Select all

wget http://ftp.nl.debian.org/debian/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.51a-24+lenny5_i386.deb

sudo dpkg -i libmysqlclient15off_5.0.51a-24+lenny5_i386.deb

dpkg -i --force-architecture  libmysqlclient15off_5.0.51a-24+lenny5_i386.deb

Bingo, the file dbmysql.so has now all libraries.

[after some checks]
.... But unfortunatly... now the apache service fails !

/var/log/apache2# sudo /etc/init.d/apache2 start
Starting web server: apache2/usr/sbin/apache2: error while loading shared libraries: libmysqlclient_r.so.15: wrong ELF class: ELFCLASS32

So back to square one...

I'm making progress. I've managed to create a symbolic link to this damned library in /usr/lib32

Now, my irev script tells me :

Code: Select all

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

Solution :

Code: Select all

ln -s /var/run/mysqld/mysqld.sock /var/lib/mysql/mysql.sock

It's working !

The irev script is able to pull out data from the local MySQL DB...
At last...

I found a lot of information here :

http://support.caligare.com/kb/entry/55/

LiveCode Forums.

How to install libmysqlclient.so.15 ?

How to install libmysqlclient.so.15 ?

Re: How to install libmysqlclient.so.15 ?

Re: How to install libmysqlclient.so.15 ?

Re: How to install libmysqlclient.so.15 ?