[SOLVED]Can't load SQLite client library
lazarus / 16-Databases

----------------------------------------------------------------------
bubu42 · 2022-08-25 13:39

Hello,
That's been quite a long time since I last used Lazarus (actually over
8 years, on Windows XP).
Now, I'm trying to build a new application, using SQLite3 on Ubuntu
(Linux). Things seem to quite different from Win XP !
I've installed SQLite3 on my machine, but when I try to Connect the
TSQLite component I get the error message : Cannot load SQLite3
library (libsqlite3.so). Check your installation.
I've copied the libsqlite3.so file from /usr/lib/i386-linuxgnu into my
application folder, but it doesn't seem to help.
What am I doing wrong ? Any advice welcome !
Thanks in advance.

----------------------------------------------------------------------
fpcoder · 2022-08-25 14:34

You just need to install the package libsqlite3-dev in Ubuntu.
Remove the .so file that you copied manually.

----------------------------------------------------------------------
MarkMLl · 2022-08-25 14:55

Quote from: kapibara on August 25, 2022, 04:34:53 pmYou just need to
install the package libsqlite3-dev in Ubuntu.
Remove the .so file that you copied manually.

Detail: the -dev package sets up a symlink that the normal package
omits.

I'm not sure, but https://wiki.freepascal.org/TSQLDBLibraryLoader
might be relevant as an alternative, but I've not done any heavyweight
database-related development since it was added (before that, I either
installed the -dev package where needed or did my own library search).

I must say that having to install a development package on an end-
user's system is a very unsatisfactory situation. However this is
fundamentally a Debian issue (inherited by Ubuntu), rather than a
Lazarus/LCL/FPC one.

MarkMLl

----------------------------------------------------------------------
Zvoni · 2022-08-25 14:57

Don't forget 32-Bit vs. 64-Bit
i see a "i386..." above

----------------------------------------------------------------------
MarkMLl · 2022-08-25 15:06

Quote from: Zvoni on August 25, 2022, 04:57:01 pmDon't forget 32-Bit
vs. 64-Bit
i see a "i386..." above

I saw that as well, but since he provided the entire source path and
didn't say that he'd moved it between systems decided to give him the
benefit of the doubt...

I've not got any significant SQLite stuff on the system in front of
me, but I do note

Code: Text  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i ~$ locate
libsqlite3.so/usr/lib/x86_64-linux-
gnu/libsqlite3.so.0/usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6 
For the purpose of comparison, the fairly complete PostgreSQL
installation (i.e. explicitly including the -dev package) has

Code: Text  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i ~$ locate
libpq.so/usr/lib/x86_64-linux-gnu/libpq.so ->
libpq.so.5.11/usr/lib/x86_64-linux-gnu/libpq.so.5 ->
libpq.so.5.11/usr/lib/x86_64-linux-gnu/libpq.so.5.11 
... and an app looking for either libpq.so or libpq.so.5 will be sent
to the actual library file libpq.so.5.11

MarkMLl

----------------------------------------------------------------------
bubu42 · 2022-08-25 17:28

Thanks a lot, folks ! That did it.
Actually, the 32/64 bits thing was the origin. I also checked the
symlink.