Can't connect to FB database

[terry6]

Running lazarus IDE v1.6+dfsg-1  amd64

using Firebird SS 2.5.6  amd64

Flamerobin works good with fdb database and table.

when I set connection on ibconnection to True i get an error:

Can not load default Firebird Clients ("LIBFbClient.so.2.5.1" or "LibGDS.so" or "LibFEmbed.so.2.5") Check your installation.

libgds.so and libfbclient.so.2.5.6 are both located in /usr/lib64

It says it is looking for 2.5.1 and I have 2.5.6 of the libfbclient but it still should should find the libgds.

I am running lubuntu. Ubuntu 16.04 LTS  xenial

[Ñuño_Martínez]

The problem seems to be at the "LIBFbClient.so.2.5.1" file.  Did you tryed to install Firebird 2.5.1?  It is possible on Ubuntu.  If it works then you have your answer.

[rvk]

Confirmed. This is a really nasty one.

First of all the libfbclient.2.5.1 is an old one. So the source needs to be adjusted to also take 2.5.6.

Second... the libgds.so should have been loaded but isn't.

I found out the libraries in /usr/lib64 are NOT used.
If you create a symlink in /usr/lib it DOES work

Code: [Select]

ln -s /opt/firebird/lib/libfbclient.so.2.5.6 /usr/lib/libfbclient.so.2.5.1(this creates a symlink named libfbclient.so.2.5.1 which fpc still uses to the new libfbclient.so.2.5.6)

[terry6]

I don't want to know why but:

putting the libclient2.5.6 into /usr/lib as libclient2.5.1 works so I am happy.

Maybe someday the code can be straightened out but for now this seems to work.

Also: I had to put sudo on the start of the command line for the permissions to let it work.

[Ñuño_Martínez]

(...)

Second... the libgds.so should have been loaded but isn't.

I found out the libraries in /usr/lib64 are NOT used.
If you create a symlink in /usr/lib it DOES work

Code: [Select]

ln -s /opt/firebird/lib/libfbclient.so.2.5.6 /usr/lib/libfbclient.so.2.5.1(this creates a symlink named libfbclient.so.2.5.1 which fpc still uses to the new libfbclient.so.2.5.6)

That's not a good idea:  You're mixing 64bit and 32bit stuff.  That's not good.  And it should not work, unless libfbclient wasn't installed correctly.

[edit]
I've read again and I've realized that you are not mixing 64bit and 32bit:  the problem is that the Firebird client isn't installed correctly.  It should be at /usr/lib/, not at /opt/firebird/lib/.  Actually I don't know why it is at /opt ???

I didn't try Firebird in Ubuntu yet, but when I used it with Fedora it installed correctly.

[rvk]

(...)

Code: [Select]

ln -s /opt/firebird/lib/libfbclient.so.2.5.6 /usr/lib/libfbclient.so.2.5.1(this creates a symlink named libfbclient.so.2.5.1 which fpc still uses to the new libfbclient.so.2.5.6)

That's not a good idea:  You're mixing 64bit and 32bit stuff.  That's not good.  And it should not work, unless libfbclient wasn't installed correctly.

Well, it does work, perfectly.
And somehow the libraries in /usr/lib64 are not found. The default Firebird installations installs them there so I guess they are installed correctly.

But... I thought the /usr/lib IS for 64bit libraries on a 64bit OS !!
https://bbs.archlinux.org/viewtopic.php?pid=815764#p815764

Although I agree it would be better to separate 32bit and 64bit libraries it seems this is not always done and the /usr/lib is also used for 64bit libraries.


Edit: I though the libraries are always in /opt/firebird/lib/ and Firebird symlinked them to /usr/lib. (but in this case it was to /usr/lib64 for some reason)
PS. I used the tarball and used the install.sh because I was on Mint. Maybe that's the difference.