MySQL driver detected but not loading on MacOS

[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.

[Vince2480]

Ok, I need help building MySql.
Just to be sure what I'm doing is right,
Attempting to build the x86-64 version drivers
I Downloaded the MySql source package with

git clone https://github.com/mysql/mysql-connector-cpp.git
git checkout 8.0

Next I ran cmake

cmake cmakelists.txt

-- The C compiler identification is AppleClang 12.0.5.12050022
-- The CXX compiler identification is AppleClang 12.0.5.12050022
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working C compiler: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/cc - skipped
-- Detecting C compile features
-- Detecting C compile features - done
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Check for working CXX compiler: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/c++ - skipped
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- BIG_ENDIAN: 0
Building version 8.0.26
Building on system: Darwin-20.6.0 (arm64)
Using cmake generator: Unix Makefiles
Using toolset: 
Building 64bit code
Building shared connector library
Configuring CDK as part of MySQL_CONCPP project
-- Looking for SSL library.
CMake Error at cdk/cmake/DepFindSSL.cmake:79 (message):
  Cannot find appropriate system libraries for SSL.  Make sure you've
  specified a supported SSL version.  Consult the documentation for WITH_SSL
  alternatives
Call Stack (most recent call first):
  cdk/cmake/DepFindSSL.cmake:354 (main)
  cdk/cmake/dependency.cmake:42 (include)
  cdk/CMakeLists.txt:96 (find_dependency)

% which openssl                                                   
/opt/homebrew/cellar/openssl@1.1/1.1.1k/bin/openssl

Is it possible OpenSSL isn't M1 compliant?