Mac --> QSqlDatabase: QMYSQL driver not loaded

[NicoKino]

I add
@QT_DEBUG_PLUGINS = 1@
in QtProject
and I have the same error.

[SGaist]

It's not supposed to make it work but to give your more information about what happens when plugins are getting loaded.

How did you set that environment variable ?

[NicoKino]

I set your code line like this :
@QT += core
QT += sql

QT -= gui$

QT_DEBUG_PLUGINS = 1

TARGET = sans_titre2
CONFIG += console
CONFIG -= app_bundle

TEMPLATE = app

SOURCES += main.cpp
@
in the Qproject

[SGaist]

Sorry, I mislead you, it must be set as environment variable when you run your application. Go to Projects, select the run panel, Run environment, and add that variable there

[NicoKino]

I place my variable and I have a lot of stuff :
@Found metadata in lib /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlite.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QSQLITE"
]
},
"className": "QSQLiteDriverPlugin",
"debug": false,
"version": 328448
}

Got keys from plugin meta data ("QSQLITE")
QFactoryLoader::QFactoryLoader() looking at "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlite_debug.dylib"
Found metadata in lib /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlite_debug.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QSQLITE"
]
},
"className": "QSQLiteDriverPlugin",
"debug": true,
"version": 328448
}

Got keys from plugin meta data ("QSQLITE")
QFactoryLoader::QFactoryLoader() looking at "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql.dylib"
Found metadata in lib /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QMYSQL3",
"QMYSQL"
]
},
"className": "QMYSQLDriverPlugin",
"debug": false,
"version": 328448
}

Got keys from plugin meta data ("QMYSQL3", "QMYSQL")
QFactoryLoader::QFactoryLoader() looking at "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql_debug.dylib"
Found metadata in lib /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql_debug.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QMYSQL3",
"QMYSQL"
]
},
"className": "QMYSQLDriverPlugin",
"debug": true,
"version": 328448
}

Got keys from plugin meta data ("QMYSQL3", "QMYSQL")
QFactoryLoader::QFactoryLoader() looking at "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlodbc.dylib"
Found metadata in lib /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlodbc.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QODBC3",
"QODBC"
]
},
"className": "QODBCDriverPlugin",
"debug": false,
"version": 328448
}

Got keys from plugin meta data ("QODBC3", "QODBC")
QFactoryLoader::QFactoryLoader() looking at "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlodbc_debug.dylib"
Found metadata in lib /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlodbc_debug.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QODBC3",
"QODBC"
]
},
"className": "QODBCDriverPlugin",
"debug": true,
"version": 328448
}

Got keys from plugin meta data ("QODBC3", "QODBC")
QFactoryLoader::QFactoryLoader() looking at "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlpsql.dylib"
Found metadata in lib /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlpsql.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QPSQL7",
"QPSQL"
]
},
"className": "QPSQLDriverPlugin",
"debug": false,
"version": 328448
}

Got keys from plugin meta data ("QPSQL7", "QPSQL")
QFactoryLoader::QFactoryLoader() looking at "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlpsql_debug.dylib"
Found metadata in lib /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlpsql_debug.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QPSQL7",
"QPSQL"
]
},
"className": "QPSQLDriverPlugin",
"debug": true,
"version": 328448
}

Got keys from plugin meta data ("QPSQL7", "QPSQL")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/nicolaspeyvel/build-sans_titre2-Desktop_Qt_5_3_0_clang_64bit-Debug/sqldrivers" ...
loaded library "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql.dylib"
QLibraryPrivate::loadPlugin failed on "/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql.dylib" : "Cannot load library /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql.dylib: (dlopen(/Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql.dylib, 5): Library not loaded: /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib
Referenced from: /Users/nicolaspeyvel/Qt/5.3/clang_64/plugins/sqldrivers/libqsqlmysql.dylib
Reason: image not found)"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7

QSqlError("", "Driver not loaded", "Driver not loaded")
@

[SGaist]

Can you run

@file /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib@

?

[NicoKino]

sorry but I don't have file like you, so I don't know where this lib is:
@bash-3.2$ cd opt/X11/lib
bash-3.2$ ls
X11 libXmuu.1.dylib libxcb-event.1.dylib
libAppleWM.7.dylib libXmuu.dylib libxcb-ewmh.2.dylib
libAppleWM.dylib libXp.6.dylib libxcb-ewmh.dylib
libFS.6.dylib libXp.dylib libxcb-glx.0.dylib
libFS.dylib libXplugin.1.dylib libxcb-glx.dylib
libGL.1.dylib libXplugin.dylib libxcb-icccm.4.dylib
libGL.dylib libXpm.4.dylib libxcb-icccm.dylib
libGLU.1.dylib libXpm.dylib libxcb-image.0.dylib
libGLU.dylib libXrandr.2.dylib libxcb-image.dylib
libICE.6.dylib libXrandr.dylib libxcb-keysyms.1.dylib
libICE.dylib libXrender.1.dylib libxcb-keysyms.dylib
libOSMesa.8.dylib libXrender.dylib libxcb-present.0.dylib
libOSMesa.dylib libXss.1.dylib libxcb-present.dylib
libOpenVG.1.dylib libXss.dylib libxcb-randr.0.dylib
libOpenVG.dylib libXt.6.dylib libxcb-randr.dylib
libSM.6.dylib libXt.dylib libxcb-record.0.dylib
libSM.dylib libXtst.6.dylib libxcb-record.dylib
libX11-xcb.1.dylib libXtst.dylib libxcb-render-util.0.dylib
libX11-xcb.dylib libXv.1.dylib libxcb-render-util.dylib
libX11.6.dylib libXv.dylib libxcb-render.0.dylib
libX11.dylib libXvMC.1.dylib libxcb-render.dylib
libXRes.1.dylib libXvMC.dylib libxcb-res.0.dylib
libXRes.dylib libXvMCW.1.dylib libxcb-res.dylib
libXTrap.6.dylib libXvMCW.dylib libxcb-screensaver.0.dylib
libXTrap.dylib libXxf86misc.1.dylib libxcb-screensaver.dylib
libXau.6.dylib libXxf86misc.dylib libxcb-shape.0.dylib
libXau.dylib libXxf86vm.1.dylib libxcb-shape.dylib
libXaw.6.dylib libXxf86vm.dylib libxcb-shm.0.dylib
libXaw.7.dylib libcairo-script-interpreter.2.dylib libxcb-shm.dylib
libXaw.8.dylib libcairo-script-interpreter.dylib libxcb-sync.1.dylib
libXaw.dylib libcairo.2.dylib libxcb-sync.dylib
libXaw3d.8.dylib libcairo.dylib libxcb-util.0.dylib
libXaw3d.dylib libdmx.1.dylib libxcb-util.1.dylib
libXaw6.6.dylib libdmx.dylib libxcb-util.dylib
libXaw6.dylib libfontconfig.1.dylib libxcb-xevie.0.dylib
libXaw7.7.dylib libfontconfig.dylib libxcb-xevie.dylib
libXaw7.dylib libfontenc.1.dylib libxcb-xf86dri.0.dylib
libXaw8.8.dylib libfontenc.dylib libxcb-xf86dri.dylib
libXaw8.dylib libfreetype.6.dylib libxcb-xfixes.0.dylib
libXcomposite.1.dylib libfreetype.dylib libxcb-xfixes.dylib
libXcomposite.dylib libglut.3.dylib libxcb-xinerama.0.dylib
libXcursor.1.dylib libglut.dylib libxcb-xinerama.dylib
libXcursor.dylib libpixman-1.0.dylib libxcb-xkb.1.dylib
libXdamage.1.dylib libpixman-1.dylib libxcb-xkb.dylib
libXdamage.dylib libpng.3.dylib libxcb-xprint.0.dylib
libXdmcp.6.dylib libpng.dylib libxcb-xprint.dylib
libXdmcp.dylib libpng12.0.dylib libxcb-xtest.0.dylib
libXevie.1.dylib libpng14.14.dylib libxcb-xtest.dylib
libXevie.dylib libpng15.15.dylib libxcb-xv.0.dylib
libXext.6.dylib libpng15.dylib libxcb-xv.dylib
libXext.dylib libqsqlmysql.dylib libxcb-xvmc.0.dylib
libXfixes.3.dylib libxcb-atom.1.dylib libxcb-xvmc.dylib
libXfixes.dylib libxcb-aux.0.dylib libxcb.1.dylib
libXfont.1.dylib libxcb-composite.0.dylib libxcb.dylib
libXfont.dylib libxcb-composite.dylib libxkbfile.1.dylib
libXfontcache.1.dylib libxcb-cursor.0.dylib libxkbfile.dylib
libXfontcache.dylib libxcb-cursor.dylib libxkbui.1.dylib
libXft.2.dylib libxcb-damage.0.dylib libxkbui.dylib
libXft.dylib libxcb-damage.dylib libxshmfence.1.dylib
libXi.6.dylib libxcb-dpms.0.dylib libxshmfence.dylib
libXi.dylib libxcb-dpms.dylib pkgconfig
libXinerama.1.dylib libxcb-dri2.0.dylib python2.6
libXinerama.dylib libxcb-dri2.dylib sqldrivers
libXmu.6.dylib libxcb-dri3.0.dylib xorg
libXmu.dylib libxcb-dri3.dylib
@

In sqldrivers I have
@bash-3.2$ cd sqldrivers/
bash-3.2$ ls
libqsqlite.dylib libqsqlmysql.dylib libqsqlodbc.dylib libqsqlpsql.dylib
libqsqlite_debug.dylib libqsqlmysql_debug.dylib libqsqlodbc_debug.dylib libqsqlpsql_debug.dylib@

[SGaist]

Then how did you install MySQL ?

[NicoKino]

I used the installer.
To test my databases I use MAMP

[SGaist]

Ok, so where on your system can you find a library named libmysqlclient.dylib ?

[NicoKino]

I found it here :
@bash-3.2$ sudo find / -name "libmysqlclient.dylib"
find: /dev/fd/3: Not a directory
find: /dev/fd/4: Not a directory
/usr/local/mysql-5.6.19-osx10.6-x86/lib/libmysqlclient.dylib@

[SGaist]

Ok ! Here we have it now. Please use install_name_tool to update the QtSql library in the framework

[NicoKino]

In my folder I have theses files :
@bash-3.2$ cd usr/local/mysql-5.6.19-osx10.6-x86//lib/
bash-3.2$ ls
libmysqlclient.18.dylib libmysqlclient_r.dylib
libmysqlclient.a libmysqld-debug.a
libmysqlclient.dylib libmysqld.a
libmysqlclient_r.18.dylib libmysqlservices.a
libmysqlclient_r.a plugin@

What will I do ?

[SGaist]

using install_name_tool, correct the path /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib in libqsqlmysql.dylib with /usr/local/mysql-5.6.19-osx10.6-x86//lib/libmysqlclient.18.dylib

[NicoKino]

When I'm in the correct directory, what lines I must insert in the terminal ?

[SGaist]

install_name_tool -change old_path new_path libqsqlmysql.dylib

[warcomeb]

Hello SGaist,
I have tried your solution, with this instruction:
install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /Applications/mampstack-5.4.26-0/mysql/lib/libmysqlclient.dylib libqsqlmysql.dylib

but during debug I receive this message:
@
QFactoryLoader::QFactoryLoader() checking directory path "/Users/warcomeb/Projects/build-LabOrToolGui-Desktop_Qt_5_2_1_clang_64bit/Debug/LabOrTool.app/Contents/MacOS/sqldrivers" ...
loaded library "/Users/warcomeb/Qt5.2.1/5.2.1/clang_64/plugins/sqldrivers/libqsqlmysql.dylib"
QSqlError(-1, "", "")
Database non connected!
QSqlError(2005, "QMYSQL: Unable to connect", "Unknown MySQL server host 'localhost:3306' (2)") @

I have followed all step that you wrote previously!
Can you help me?

[SGaist]

Is your server running ?

Also, if it was deployed correctly, you should need to correct the path by hand. The client library should be already copied in your bundle

[warcomeb]

Yes, the server is running!
I have added setPort to my database configuration and now it work!

Thanks!
Marco

[NicoKino]

It's not work for my :'(

@install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /Applications/mampstack-5.4.26-0/mysql/lib/libmysqlclient.dylib libqsqlmysql.dylib
error: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/install_name_tool: can't open file: libqsqlmysql.dylib (No such file or directory)
@

what I must to do ? I'm on Yosemite now.