MySQL driver detected but not loading on MacOS

Vince2480

@jsulm
19:18:00: Starting /Users/vinceieraci/Developer/build-VDB-Desktop_Qt_5_9_9_clang_64bit-Debug/VDB.app/Contents/MacOS/VDB ...
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqcocoa.dylib"
Found metadata in lib /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqcocoa.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"cocoa"
]
},
"className": "QCocoaIntegrationPlugin",
"debug": false,
"version": 329993
}

Got keys from plugin meta data ("cocoa")
QFactoryLoader::QFactoryLoader() looking at "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqminimal.dylib"
Found metadata in lib /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqminimal.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"minimal"
]
},
"className": "QMinimalIntegrationPlugin",
"debug": false,
"version": 329993
}

Got keys from plugin meta data ("minimal")
QFactoryLoader::QFactoryLoader() looking at "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqminimal_debug.dylib"
Found metadata in lib /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqminimal_debug.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"minimal"
]
},
"className": "QMinimalIntegrationPlugin",
"debug": true,
"version": 329993
}

Got keys from plugin meta data ("minimal")
QFactoryLoader::QFactoryLoader() looking at "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqoffscreen.dylib"
Found metadata in lib /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqoffscreen.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"offscreen"
]
},
"className": "QOffscreenIntegrationPlugin",
"debug": false,
"version": 329993
}

Got keys from plugin meta data ("offscreen")
QFactoryLoader::QFactoryLoader() looking at "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqoffscreen_debug.dylib"
Found metadata in lib /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqoffscreen_debug.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"offscreen"
]
},
"className": "QOffscreenIntegrationPlugin",
"debug": true,
"version": 329993
}

Got keys from plugin meta data ("offscreen")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Developer/build-VDB-Desktop_Qt_5_9_9_clang_64bit-Debug/VDB.app/Contents/MacOS/platforms" ...
loaded library "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqcocoa.dylib"
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Developer/build-VDB-Desktop_Qt_5_9_9_clang_64bit-Debug/VDB.app/Contents/MacOS/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/styles" ...
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Developer/build-VDB-Desktop_Qt_5_9_9_clang_64bit-Debug/VDB.app/Contents/MacOS/styles" ...
loaded library "/System/Library/Frameworks/Carbon.framework/Carbon"
Library path:
("/Users/vinceieraci/Qt/5.9.9/clang_64/plugins", "/Users/vinceieraci/Developer/build-VDB-Desktop_Qt_5_9_9_clang_64bit-Debug/VDB.app/Contents/MacOS")
Drivers:
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlite.dylib"
Found metadata in lib /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlite.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QSQLITE"
]
},
"className": "QSQLiteDriverPlugin",
"debug": false,
"version": 329993
}

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

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

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

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

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

Got keys from plugin meta data ("QPSQL7", "QPSQL")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Developer/build-VDB-Desktop_Qt_5_9_9_clang_64bit-Debug/VDB.app/Contents/MacOS/sqldrivers" ...
("QSQLITE", "QMYSQL", "QMYSQL3", "QPSQL", "QPSQL7")
Cannot load library /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib: (dlopen(/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib, 133): Library not loaded: /usr/local/mysql/lib/libmysqlclient.20.dylib
Referenced from: /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib
Reason: image not found)
QLibraryPrivate::loadPlugin failed on "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib" : "Cannot load library /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib: (dlopen(/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib, 133): Library not loaded: /usr/local/mysql/lib/libmysqlclient.20.dylib\n Referenced from: /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib\n Reason: image not found)"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
db.open() next...:
db.open() ok:
lasterr().type() 1 title "Connection Error 1" text "Driver not loaded Driver not loaded"
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/iconengines" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/iconengines/libqsvgicon.dylib"
Found metadata in lib /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/iconengines/libqsvgicon.dylib, metadata=
{
"IID": "org.qt-project.Qt.QIconEngineFactoryInterface",
"MetaData": {
"Keys": [
"svg",
"svgz",
"svg.gz"
]
},
"className": "QSvgIconPlugin",
"debug": false,
"version": 329993
}

Got keys from plugin meta data ("svg", "svgz", "svg.gz")
QFactoryLoader::QFactoryLoader() looking at "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/iconengines/libqsvgicon_debug.dylib"
Found metadata in lib /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/iconengines/libqsvgicon_debug.dylib, metadata=
{
"IID": "org.qt-project.Qt.QIconEngineFactoryInterface",
"MetaData": {
"Keys": [
"svg",
"svgz",
"svg.gz"
]
},
"className": "QSvgIconPlugin",
"debug": true,
"version": 329993
}

Got keys from plugin meta data ("svg", "svgz", "svg.gz")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/vinceieraci/Developer/build-VDB-Desktop_Qt_5_9_9_clang_64bit-Debug/VDB.app/Contents/MacOS/iconengines" ...
QLibraryPrivate::unload succeeded on "/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/platforms/libqcocoa.dylib"
QLibraryPrivate::unload succeeded on "/System/Library/Frameworks/Carbon.framework/Carbon"
19:18:04: /Users/vinceieraci/Developer/build-VDB-Desktop_Qt_5_9_9_clang_64bit-Debug/VDB.app/Contents/MacOS/VDB exited with code 1

jsulm

@Vince2480 You could try to set LD_LIBRARY_PATH to point to folder containing libmysqlclient.20.dylib

Vince2480

@jsulm libmysqlclient.20.dylib is not on my system so does that means I need to install MySQL? I didn't do that for Qt5.4, has something changed between then and now?

jsulm

@Vince2480 said in MySQL driver detected but not loading on MacOS:

install MySQL?

Not the server, only client.

"has something changed between then and now?" - yes, the MySQL license has changed (since Oracle owns MySQL). Because of that QtCompany does not include MySQL client lib anymore in the Qt builds it's providing.

Vince2480

@jsulm OK, I see.

I installed

brew install mysql-client

only libmysqlclient.21.dylib so I linked with libmysqlclient.20.dylib
but it's the wrong architecture.

Cannot load library /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib: (dlopen(/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib, 133): Library not loaded: /usr/local/mysql/lib/libmysqlclient.20.dylib
  Referenced from: /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib
  Reason: no suitable image found.  Did find:
	/opt/homebrew/Cellar/mysql-client/8.0.26/lib/libmysqlclient.20.dylib: mach-o, but wrong architecture
	/opt/homebrew/Cellar/mysql-client/8.0.26/lib/libmysqlclient.20.dylib: mach-o, but wrong architecture)

I downloaded mysql-connector-c++ but that doesn't look viable.
Where do I find the required files?

jsulm

@Vince2480 What does

file /opt/homebrew/Cellar/mysql-client/8.0.26/lib/libmysqlclient.20.dylib

and

file /Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib

output?

Vince2480

@jsulm Excuse my ignorance, I don't understand the question.

JonB

@Vince2480
From a command prompt/terminal/shell, copy & paste exactly each of the two lines @jsulm typed, and paste back here what response you get.

Vince2480

@JonB

/opt/homebrew/Cellar/mysql-client/8.0.26/lib/libmysqlclient.20.dylib: Mach-O 64-bit dynamically linked shared library

/Users/vinceieraci/Qt/5.9.9/clang_64/plugins/sqldrivers/libqsqlmysql.dylib: Mach-O 64-bit dynamically linked shared library x86_64

jsulm

@Vince2480 Both seems to be 64bit libs, except that libmysqlclient.20.dylib is missing x86_64.
Do you by any chance use a M1 Mac?

Vince2480

@jsulm Yes. M1 MacBook Pro.

SGaist

Hi,

Two solutions I can see here:

Build Qt yourself for the M1
Have a parallel install of brew which installs the x86_64 variants of the packages you need.

jsulm

@Vince2480 To add to @SGaist : QtCompany does not yet provide Apple Silicon Qt builds. That means you have x86_64 Qt build but MySQL client lib is ARM. This can't work, so you have to make sure both are same architecture (either ARM or x86_64), see @SGaist suggestion.

Vince2480

@jsulm I'll build Qt from sources as @SGaist has suggested, from the Qt5 git repository. I assume I don't need to build Qt Creator?

jsulm

@Vince2480 said in MySQL driver detected but not loading on MacOS:

I assume I don't need to build Qt Creator?

No.
Just add a new Kit with your self-built Qt.

SGaist

@Vince2480 said in MySQL driver detected but not loading on MacOS:

@jsulm I'll build Qt from sources as @SGaist has suggested, from the Qt5 git repository. I assume I don't need to build Qt Creator?

Do not forget to checkout the exact version you want. The default branch when cloning is dev so Qt 6.

Vince2480

@SGaist Ran into many problems trying to build the sources, fo

I don't think Qt6 has any MySQL plugins because they weren't in the pre-built version.

SGaist

That's wrong. The same rules apply for the MySQL plugin in Qt 6 than in Qt 5.

Qt has a lot more database plugins that what is provided in the pre-built binaries. Some of them require commercial dependencies that needs to be acquired by the developer/companies that wants to use them so they won't be part of the pre-built binaries either.

Vince2480

@SGaist I could not build Qt from sources, too many errors for me to understand, I'm only a hobby programmer. I read Qt company says 6.2 beta is M1 compliant. therefore I installed with Maintenance tool.

MySql plugins were present in Qt5.9.9 but definitely not in 6.

Now I'm trying to find the libmysql source files, all I can find are binaries Connector/C++ at dev.MySql.com

SGaist

@Vince2480 said in MySQL driver detected but not loading on MacOS:

MySql plugins were present in Qt5.9.9 but definitely not in 6.

And not in 5.14 and 5.15. Oracle has changed its licensing scheme and thus the Qt Company does not provide the pre-built plugin anymore. You can build it yourself for your Qt version if you get the x86_64 version of the connectior.