Problem connecting mysql to my qt application under linux

[Alfredy]

qt.sql.qsqldatabase: QSqlDatabase: QMYSQL driver not loaded

I'm having trouble connecting my application with my mysql database... I was on windows but I've decided to switch to Linux for good.
Can you help me? You can find above the error message on the sql driver I have.

[jsulm]

This is asked very often, you should use search function.
Set QT_DEBUG_PLUGINS env variable before starting your app and examine the output of your application and/or post it here.
See https://doc.qt.io/qt-6/debug.html

[Alfredy]

Okay, I'll try and get back to you.

[Alfredy]

Here is the message I received

t.sql.qsqldatabase: QSqlDatabase: QMYSQL driver not loaded
qt.sql.qsqldatabase: QSqlDatabase: available drivers: QMARIADB QMYSQL QSQLITE QODBC QPSQL QMIMER

[jsulm]

@Alfredy said in Problem connecting mysql to my qt application under linux:

Here is the message I received

There must be a lot more if you properly set QT_DEBUG_PLUGINS as I advised you.
Please do so and post the output, else we can only guess what the problem is...

[Alfredy]

Sorry I did it maybe I did it wrong. If you have a concrete orientation other than this link do not hesitate to provide it to me .. For the moment I'm thinking

[Alfredy]

Check this please :
qt.core.plugin.factoryloader: Got keys from plugin meta data QList("QPSQL")
qt.core.plugin.factoryloader: looking at "qsqlmysql.debug"
qt.core.plugin.factoryloader: "The shared library was not found."
not a plugin
qt.core.plugin.factoryloader: looking at "libqsqlmimer.so"
qt.core.plugin.loader: Found metadata in lib /home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmimer.so, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QMIMER"
]
},
"archlevel": 1,
"className": "QMimerSQLDriverPlugin",
"debug": false,
"version": 395264
}

qt.core.plugin.factoryloader: Got keys from plugin meta data QList("QMIMER")
qt.core.plugin.factoryloader: checking directory path "/home/.../P/MP/NN/App logiciel/gest_/gestion_d/build/Desktop-Release/sqldrivers" ...
qt.core.library: "/home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmysql.so" cannot load: Cannot load library /home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmysql.so: libmysqlclient.so.21: Ne peut ouvrir le fichier d'objet partagé: Aucun fichier ou dossier de ce type
qt.core.plugin.loader: QLibraryPrivate::loadPlugin failed on "/home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmysql.so" : "Cannot load library /home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmysql.so: libmysqlclient.so.21: Ne peut ouvrir le fichier d'objet partagé: Aucun fichier ou dossier de ce type"
qt.sql.qsqldatabase: QSqlDatabase: QMYSQL driver not loaded
qt.sql.qsqldatabase: QSqlDatabase: available drivers: QMARIADB QMYSQL QSQLITE QODBC QPSQL QMIMER
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqgif.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqicns.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqico.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqjpeg.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqpdf.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqsvg.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqtga.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqtiff.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqwbmp.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/imageformats/libqwebp.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/platforminputcontexts/libcomposeplatforminputcontextplugin.so" unloaded library
"/home/.../Qt/6.8.0/gcc_64/plugins/platforms/libqxcb.so" unloaded library

[jsulm]

@Alfredy said in Problem connecting mysql to my qt application under linux:

qt.core.library: "/home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmysql.so" cannot load: Cannot load library /home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmysql.so: libmysqlclient.so.21: Ne peut ouvrir le fichier d'objet partagé: Aucun fichier ou dossier de ce type
qt.core.plugin.loader: QLibraryPrivate::loadPlugin failed on "/home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmysql.so" : "Cannot load library /home/.../Qt/6.8.0/gcc_64/plugins/sqldrivers/libqsqlmysql.so: libmysqlclient.so.21: Ne peut ouvrir le fichier d'objet partagé: Aucun fichier ou dossier de ce type"

This is your problem. The MySQL client library is missing (libmysqlclient.so.21), download and install it.

[Alfredy]

How do I download this? Thanks

[jsulm]

@Alfredy said in Problem connecting mysql to my qt application under linux:

How do I download this?

If you search for "mysql client library" you will find https://dev.mysql.com/downloads/c-api/
But it looks like you're on Linux, in that case install the package containing MySQL client library (on Ubuntu it's libmysqlclient21).