28/8/2019 Can't connect to FB database
Lazarus Home Help Search Login Register
Lazarus » Forum » Installation » Linux » Can't connect to FB database
« previous next »
Pages: [1] PRINT
Author Topic: Can't connect to FB database (Read 4064 times)
terry6 Can't connect to FB database
« on: July 12, 2016, 03:21:31 pm »
New member
Running lazarus IDE v1.6+dfsg-1 amd64
Posts: 6
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
« Last Edit: July 13, 2016, 03:01:41 am by terry6 » Logged
Ñuño_Martínez Re: Can't connect to FB database
« Reply #1 on: July 13, 2016, 12:54:37 pm »
Hero Member
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.
Logged
Are you interested in game programming? Join the Pascal Game Development community!
Posts: 908
Also visit the Game Development Portal
https://forum.lazarus.freepascal.org/index.php?topic=33333.0 1/6
28/8/2019 Can't connect to FB database
rvk Re: Can't connect to FB database
« Reply #2 on: July 13, 2016, 01:45:43 pm »
Hero Member
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.
Posts: 3789 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)
Logged
terry6 Re: Can't connect to FB database
« Reply #3 on: July 13, 2016, 05:17:27 pm »
New member
I don't want to know why but:
Posts: 6
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.
« Last Edit: July 13, 2016, 05:27:19 pm by terry6 » Logged
Ñuño_Martínez Re: Can't connect to FB database
« Reply #4 on: July 13, 2016, 06:56:21 pm »
Hero Member
Quote from: rvk on July 13, 2016, 01:45:43 pm
(...)
Second... the libgds.so should have been loaded but isn't.
Posts: 908 I found out the libraries in /usr/lib64 are NOT used.
https://forum.lazarus.freepascal.org/index.php?topic=33333.0 2/6
28/8/2019 Can't connect to FB database
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.
« Last Edit: July 13, 2016, 07:00:33 pm by Ñuño_Martínez » Logged
Are you interested in game programming? Join the Pascal Game Development community!
Also visit the Game Development Portal
rvk Re: Can't connect to FB database
« Reply #5 on: July 13, 2016, 07:17:56 pm »
Hero Member
Quote from: Ñuño_Martínez on July 13, 2016, 06:56:21 pm
Quote from: rvk on July 13, 2016, 01:45:43 pm
(...)
Posts: 3789 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.
https://forum.lazarus.freepascal.org/index.php?topic=33333.0 3/6
28/8/2019 Can't connect to FB database
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.
« Last Edit: July 13, 2016, 07:21:39 pm by rvk » Logged
Pages: [1] PRINT
« previous next »
Lazarus » Forum » Installation » Linux » Can't connect to FB database
Jump to: => Linux go
Recent
Thread vs Application.Pro... by Munair
[Today at 05:49:13 pm]
[Closed] Poll: Usage of D... by Thaddy
[Today at 05:38:56 pm]
Free Pascal
Website All Things SynFacilSyn by pixelink
[Today at 05:37:11 pm]
Downloads
Wiki
How to know if the mouse ... by ASerge
Bugtracker
[Today at 05:35:56 pm]
Mailing List
Lazarus Tutorial: Install Lazarus... by Linkat
Website [Today at 05:12:09 pm]
Downloads (Laz+FPC)
Packages (OPM) Read out File Attribute H... by LazProgger
FAQ [Today at 04:45:15 pm]
Wiki
Bugtracker Activity Indicator - Led ... by 440bx
IRC channel [Today at 04:24:11 pm]
Developer Blog
Follow us on Twitter to detect the default/sta... by winni
[Today at 03:07:11 pm]
Latest SVN
Mailing List
fphttpClient - problem in... by dbannon
Other languages
[Today at 02:18:45 pm]
Foundation
https://forum.lazarus.freepascal.org/index.php?topic=33333.0 4/6
28/8/2019 Can't connect to FB database
Website Strange Issue with LazPai... by winni
Useful Wiki Links [Today at 02:05:42 pm]
Project Roadmap
Getting the Source
Screenshots
Donate €
Donate $
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
(preview only)
Search
Search
Advanced search
SMF 2.0.15 | SMF © 2017, Simple Machines
Privacy Policy
TinyPortal © 2005-2018
XHTML RSS WAP2
https://forum.lazarus.freepascal.org/index.php?topic=33333.0 5/6
28/8/2019 Can't connect to FB database
https://forum.lazarus.freepascal.org/index.php?topic=33333.0 6/6