MySQL driver detected but not loading on MacOS

jsulm

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

/usr/local/mysql/lib

Can you post whole output?

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