Qt plugins MySQL in Raspbian

SGaist

No you can't, they are not from the same architecture. You have to compile the plugin with the Qt you are using for your RPi.

Nisix

@SGaist Ok, i do it and not work at all...
with the same error in Qt ...

QSQLDatabase QMYSQL driver not loaded
& QSQLDatabase : available drivers : QSQLITE

SGaist

Did you check that the plugin was properly installed in your device ?

Nisix

@SGaist Yep he did. Should i copy/paste on my debug folder ?

SGaist

He did ? Who's that ?

What do you mean by copy/past on my debug folder ?

Nisix

@SGaist @SGaist Sorry for my english :]
I mean yeah i got the good drivers.
And my question is : should i copy / paste the lib on my projet folder (in debug / release) or something else ?

SGaist

No, they should be in Qt's installation folder under plugins/sqldrivers/

Nisix

@SGaist Yeah, they are in the folder sqldrivers as you said. I really don't know how to help you with some indications... :/

SGaist

What do you get if your run ldd libqsqlmysql.so on your RPi ?

Nisix

@SGaist I got this :

pi@raspberrypi:/usr/lib/arm-linux-gnueabihf/qt5/plugins/sqldrivers $ ldd libqsqlmysql.so
linux-vdso.so.1 (0x7ec39000)
/usr/lib/arm-linux-gnueabihf/libarmmem.so (0x76f42000)
libmysqlclient.so.18 => /usr/lib/arm-linux-gnueabihf/libmysqlclient.so.18 (0x76c1a000)
libQt5Sql.so.5 => /usr/lib/arm-linux-gnueabihf/libQt5Sql.so.5 (0x76bd4000)
libQt5Core.so.5 => /usr/lib/arm-linux-gnueabihf/libQt5Core.so.5 (0x7674f000)
libstdc++.so.6 => /usr/lib/arm-linux-gnueabihf/libstdc++.so.6 (0x76673000)
libc.so.6 => /lib/arm-linux-gnueabihf/libc.so.6 (0x76532000)
/lib/ld-linux-armhf.so.3 (0x54b8f000)
libpthread.so.0 => /lib/arm-linux-gnueabihf/libpthread.so.0 (0x76509000)
libz.so.1 => /lib/arm-linux-gnueabihf/libz.so.1 (0x764e2000)
libdl.so.2 => /lib/arm-linux-gnueabihf/libdl.so.2 (0x764cf000)
libm.so.6 => /lib/arm-linux-gnueabihf/libm.so.6 (0x76454000)
libgcc_s.so.1 => /lib/arm-linux-gnueabihf/libgcc_s.so.1 (0x76427000)
libicui18n.so.52 => /usr/lib/arm-linux-gnueabihf/libicui18n.so.52 (0x76266000)
libicuuc.so.52 => /usr/lib/arm-linux-gnueabihf/libicuuc.so.52 (0x7611e000)
libglib-2.0.so.0 => /lib/arm-linux-gnueabihf/libglib-2.0.so.0 (0x7601b000)
librt.so.1 => /lib/arm-linux-gnueabihf/librt.so.1 (0x76004000)
libicudata.so.52 => /usr/lib/arm-linux-gnueabihf/libicudata.so.52 (0x74987000)
libpcre.so.3 => /lib/arm-linux-gnueabihf/libpcre.so.3 (0x74913000)

SGaist

Looks fine… Can you start your application with QT_DEBUG_PLUGINS=1 ? To see what happens when your application loads the plugins.

Nisix

@SGaist I go this about Qt plugins for mysql :

Got keys from plugin meta data ("QSQLITE")
QFactoryLoader::QFactoryLoader() looking at "/usr/lib/arm-linux-gnueabihf/qt5/plugins/sqldrivers/libqsqlmysql.so"
Found metadata in lib /usr/lib/arm-linux-gnueabihf/qt5/plugins/sqldrivers/libqsqlmysql.so, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QMYSQL3",
            "QMYSQL"
        ]
    },
    "className": "QMYSQLDriverPlugin",
    "debug": false,
    "version": 328450
}


Got keys from plugin meta data ("QMYSQL3", "QMYSQL")
QFactoryLoader::QFactoryLoader() looking at "/usr/lib/arm-linux-gnueabihf/qt5/plugins/sqldrivers/libqsqlpsql.so"
Found metadata in lib /usr/lib/arm-linux-gnueabihf/qt5/plugins/sqldrivers/libqsqlpsql.so, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QPSQL7",
            "QPSQL"
        ]
    },
    "className": "QPSQLDriverPlugin",
    "debug": false,
    "version": 328960
}


In /usr/lib/arm-linux-gnueabihf/qt5/plugins/sqldrivers/libqsqlpsql.so:
  Plugin uses incompatible Qt library (5.5.0) [release]
"Le plugin '/usr/lib/arm-linux-gnueabihf/qt5/plugins/sqldrivers/libqsqlpsql.so' utilise une bibliothèque Qt incompatible. (5.5.0) [release]"
         not a plugin
QFactoryLoader::QFactoryLoader() checking directory path "/usr/bin/sqldrivers" ...
loaded library "/usr/lib/arm-linux-gnueabihf/qt5/plugins/sqldrivers/libqsqlite.so"

SGaist

Looks like you either have two different version of Qt installed or you build your plugin with a different version of Qt than the one you originally built.

Nisix

@SGaist Ok, i will try a new install of Qt with this tutorial https://wiki.qt.io/RaspberryPi2EGLFS
Then a new install of MySql header & lib files. I will inform you about progress of this. I hate Qt on raspbian (joke ofc) :D

Norbert M

Hello,

I know this thread is old but I came here with the same problem and managed to solve it.

By installing libqt5sql5-mysql with $ apt-get install libqt5sql5-mysql

Happy coding ! :)