Sqlite Driver not loaded

SRaD · wrote on 22 Dec 2017, 23:35

Here's the result.

$ ldd ./libqsqlite.so 
        linux-vdso.so.1 (0x00007ffc55fe0000)
        libsqlite3.so.0 => /usr/lib64/libsqlite3.so.0 (0x00007fa34c2b2000)
        libQt5Sql.so.5 => /usr/lib64/libQt5Sql.so.5 (0x00007fa34c26a000)
        libQt5Core.so.5 => /usr/lib64/libQt5Core.so.5 (0x00007fa34bdf0000)
        libstdc++.so.6 => /usr/lib/gcc/x86_64-pc-linux-gnu/5.4.0/libstdc++.so.6 (0x00007fa34b9bb000)
        libc.so.6 => /lib64/libc.so.6 (0x00007fa34b621000)
        libm.so.6 => /lib64/libm.so.6 (0x00007fa34b326000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007fa34b122000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fa34af05000)
        libicui18n.so.58 => /usr/lib64/libicui18n.so.58 (0x00007fa34aa8d000)
        libicuuc.so.58 => /usr/lib64/libicuuc.so.58 (0x00007fa34a6e3000)
        libz.so.1 => /lib64/libz.so.1 (0x00007fa34a4cb000)
        libpcre16.so.0 => /usr/lib64/libpcre16.so.0 (0x00007fa34a263000)
        libdouble-conversion.so.1 => /usr/lib64/libdouble-conversion.so.1 (0x00007fa34a052000)
        libglib-2.0.so.0 => /usr/lib64/libglib-2.0.so.0 (0x00007fa349d3d000)
        librt.so.1 => /lib64/librt.so.1 (0x00007fa349b35000)
        libgcc_s.so.1 => /usr/lib/gcc/x86_64-pc-linux-gnu/5.4.0/libgcc_s.so.1 (0x00007fa34991e000)
        /lib64/ld-linux-x86-64.so.2 (0x0000556d89e64000)
        libicudata.so.58 => /usr/lib64/libicudata.so.58 (0x00007fa347e1b000)
        libpcre.so.1 => /lib64/libpcre.so.1 (0x00007fa347ba9000)

SGaist · wrote on 22 Dec 2017, 23:56

@SRaD said in Sqlite Driver not loaded:

libqsqlite.so

Where is that on located ?

What do you have in /opt/rd5/bin/sqldrivers ?

SRaD · wrote on 23 Dec 2017, 00:50

libqsqlite.so is located in /usr/lib64/qt5/plugins/aqldrivers where my package manager installs it by default.

/opt/rd5/bin is my application location after being installed by autotools. I have nothing in /opt/rd5/bin/sqldrivers, but even when adding libqsqlite.so (I did read the deployment page), pretty much the results. Though I am curious if having it in the app directory is a must, and if so, why so as opposed to using the system wide install from the package manager.

hskoglund · wrote on 23 Dec 2017, 01:31

Hi, looking at your ldd for libqsqlite.so, that's one dll listed (the 2nd) that I think shouldn't be there:
/usr/lib64/libsqlite3.so.0

That dependency might be reason for the failure, perhaps try updating your SQlite.

SRaD · wrote on 23 Dec 2017, 02:16

I'm not (at this point) releasing my application, therefore not redistributing the SQL shared libs. Just using my system libraries while developing.

My driver name is ("QSQLITE") which according to the Supported Drivers page is SQLite version 3.

And this is what my package manager has put down in /usr/lib64/libsqlite3.so. So my sqlite version is at 3.19.3 which isn't too far from the latest (stable on my platform is at 3.20.1-r1), that should be fine.

And then there's the Qt driver in /usr/lib64/qt5/plugins/sqldrivers/libqsqlite.so, which I believe calls upon my /usr/lib64/libsqlite3.so.

Do I not have that correct?

hskoglund · wrote on 23 Dec 2017, 03:08

Ok (i"ve got Ubuntu and didn't see that .dll in ldd)
Could you do an ldd of libsqlite3.so.0 as well?

SRaD · wrote on 23 Dec 2017, 03:15

Sure, here's what I've got for that.

$ ldd /usr/lib64/libsqlite3.so.0
        linux-vdso.so.1 (0x00007fffbe7bc000)
        libm.so.6 => /lib64/libm.so.6 (0x00007fbf388fd000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007fbf386f8000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fbf384dc000)
        libicui18n.so.58 (0x00007fbf38064000)
        libicuuc.so.58 (0x00007fbf37cb9000)
        libc.so.6 => /lib64/libc.so.6 (0x00007fbf37920000)
        /lib64/ld-linux-x86-64.so.2 (0x0000560144638000)
        libstdc++.so.6 => /usr/lib/gcc/x86_64-pc-linux-gnu/5.4.0/libstdc++.so.6 (0x00007fbf37526000)
        libgcc_s.so.1 => /usr/lib/gcc/x86_64-pc-linux-gnu/5.4.0/libgcc_s.so.1 (0x00007fbf3730e000)
        libicudata.so.58 (0x00007fbf3580c000)

SGaist · 24 Dec 2017, 19:39

Where are the libicu related libraries ?

hskoglund · wrote on 24 Dec 2017, 10:23

Yes, nice catch @SGaist, in the first ldd they're in /usr/lib64/ but not in this ldd, hmmm...

SRaD · S SGaist 23 Dec 2017, 22:37

@SGaist said in Sqlite Driver not loaded:

Where are the libicu related libraries ?

I should have commanded ldd from another directory other than /usr/lib64. Apparently the path changes pending if you command it from within the directory of the file, or from another location. Here it is again.

$ ldd /usr/lib64/libsqlite3.so.0
        linux-vdso.so.1 (0x00007fff2b2a5000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f12f073f000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f12f053a000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f12f031e000)
        libicui18n.so.58 => /usr/lib64/libicui18n.so.58 (0x00007f12efea6000)
        libicuuc.so.58 => /usr/lib64/libicuuc.so.58 (0x00007f12efafb000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f12ef762000)
        /lib64/ld-linux-x86-64.so.2 (0x0000563a1341e000)
        libstdc++.so.6 => /usr/lib/gcc/x86_64-pc-linux-gnu/5.4.0/libstdc++.so.6 (0x00007f12ef368000)
        libgcc_s.so.1 => /usr/lib/gcc/x86_64-pc-linux-gnu/5.4.0/libgcc_s.so.1 (0x00007f12ef150000)
        libicudata.so.58 => /usr/lib64/libicudata.so.58 (0x00007f12ed64e000)

SGaist · wrote on 24 Dec 2017, 21:36

Are you modifying the LD_LIBRARY_PATH environment variable at some point ?

Note that 5.7.1 is a bit outdated, you should consider updating to a more recent version since the current LTS is 5.9.3 and the current Qt version is 5.10.