Set-up MariaDB library file location programmatically?
-
Found this post:
https://forum.qt.io/topic/90065/how-to-create-the-plugin-of-mariadb-for-qt5/19
And have adapted the qmake command to match my system:
qmake -- MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.4.6_1/include/mysql "MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.6_1/lib" MYSQL_LIBS="-llibmariadb"I'm not sure if libmariadb is correct, the paths are correct.
Kind Regards,
Sy -
Found this post:
https://forum.qt.io/topic/90065/how-to-create-the-plugin-of-mariadb-for-qt5/19
And have adapted the qmake command to match my system:
qmake -- MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.4.6_1/include/mysql "MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.6_1/lib" MYSQL_LIBS="-llibmariadb"I'm not sure if libmariadb is correct, the paths are correct.
@SPlatten said in Set-up MariaDB library file location programmatically?:
MYSQL_LIBS="-llibmariadb"
This should be
MYSQL_LIBS="-lmariadb" -
@jsulm, Thank you, it still looks like its only set-up for SQLite:
simonplatten@Simons-iMac sqldrivers % $QTDIRBIN/qmake -- MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.4.6_1/include/mysql "MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.6_1/lib" MYSQL_LIBS="-lmariadb" Running configuration tests... Done running configuration tests. Configure summary: Qt Sql Drivers: DB2 (IBM) .............................. no InterBase .............................. no MySql .................................. no OCI (Oracle) ........................... no ODBC ................................... no PostgreSQL ............................. no SQLite2 ................................ no SQLite ................................. yes Using system provided SQLite ......... no TDS (Sybase) ........................... no Qt is now configured for building. Just run 'make'. Once everything is built, you must run 'make install'. Qt will be installed into '/Users/simonplatten/Qt/5.14.2/clang_64'. Prior to reconfiguration, make sure you remove any leftovers from the previous build.Kind Regards,
Sy -
@jsulm, Thank you, it still looks like its only set-up for SQLite:
simonplatten@Simons-iMac sqldrivers % $QTDIRBIN/qmake -- MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.4.6_1/include/mysql "MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.6_1/lib" MYSQL_LIBS="-lmariadb" Running configuration tests... Done running configuration tests. Configure summary: Qt Sql Drivers: DB2 (IBM) .............................. no InterBase .............................. no MySql .................................. no OCI (Oracle) ........................... no ODBC ................................... no PostgreSQL ............................. no SQLite2 ................................ no SQLite ................................. yes Using system provided SQLite ......... no TDS (Sybase) ........................... no Qt is now configured for building. Just run 'make'. Once everything is built, you must run 'make install'. Qt will be installed into '/Users/simonplatten/Qt/5.14.2/clang_64'. Prior to reconfiguration, make sure you remove any leftovers from the previous build. -
As before I don't see a configure.log, but there is a config.log:
simonplatten@Simons-iMac sqldrivers % cat config.log Command line: MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.4.6_1/include/mysql MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.6_1/lib MYSQL_LIBS=-lmariadb Global lib dirs: [] [/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk/usr/lib] Global inc dirs: [/usr/local/opt/openssl/include] [/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/include/c++/v1 /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/lib/clang/11.0.3/include /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk/usr/include /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/include] loaded result for library config.sqldrivers.libraries.db2 Trying source 0 (type inline) of library db2 ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library db2 ... sqlcli.h not found in [] and global paths. sqlcli1.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.db2 FAILED loaded result for library config.sqldrivers.libraries.ibase Trying source 0 (type inline) of library ibase ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library ibase ... ibase.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.ibase FAILED loaded result for library config.sqldrivers.libraries.mysql Trying source 0 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs_r > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql > Info: creating stash file /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/.qmake.stash + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib > Undefined symbols for architecture x86_64: > "_mysql_get_client_version", referenced from: > _main in main.o > ld: symbol(s) not found for architecture x86_64 > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 1 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib > Undefined symbols for architecture x86_64: > "_mysql_get_client_version", referenced from: > _main in main.o > ld: symbol(s) not found for architecture x86_64 > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 2 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs_r > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto > ld: library not found for -lssl > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 3 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto > ld: library not found for -lssl > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 4 (type inline) of library mysql ... mysql.h not found in [/usr/local/include] and global paths. => source produced no result. Trying source 5 (type inline) of library mysql ... => source failed condition 'config.win32'. Trying source 6 (type inline) of library mysql ... mysql.h not found in [/usr/local/include] and global paths. => source produced no result. test config.sqldrivers.libraries.mysql FAILED loaded result for library config.sqldrivers.libraries.oci Trying source 0 (type inline) of library oci ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library oci ... oci.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.oci FAILED loaded result for library config.sqldrivers.libraries.odbc Trying source 0 (type inline) of library odbc ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library odbc ... sql.h not found in [] and global paths. sqlext.h not found in [] and global paths. => source produced no result. Trying source 2 (type inline) of library odbc ... => source failed condition '!config.win32 && !config.darwin'. test config.sqldrivers.libraries.odbc FAILED loaded result for library config.sqldrivers.libraries.psql Trying source 0 (type pkgConfig) of library psql ... pkg-config use disabled globally. => source produced no result. Trying source 1 (type psqlConfig) of library psql ... pg_config not found. => source produced no result. Trying source 2 (type psqlEnv) of library psql ... => source failed condition 'config.win32'. Trying source 3 (type psqlEnv) of library psql ... libpq-fe.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.psql FAILED loaded result for library config.sqldrivers.libraries.sqlite2 Trying source 0 (type inline) of library sqlite2 ... sqlite.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.sqlite2 FAILED loaded result for library config.sqldrivers.libraries.tds Trying source 0 (type sybaseEnv) of library tds ... => source failed condition 'config.win32'. Trying source 1 (type sybaseEnv) of library tds ... + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += tds' 'QMAKE_LIBS_TDS = -lsybdb' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && MAKEFLAGS= make > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > main.cpp:2:10: fatal error: 'sybfront.h' file not found > #include <sybfront.h> > ^~~~~~~~~~~~ > 1 error generated. > make: *** [main.o] Error 1 => source failed verification. test config.sqldrivers.libraries.tds FAILED -
brew install openssl Updating Homebrew... ==> Auto-updated Homebrew! Updated 1 tap (homebrew/core). ==> New Formulae k9s ==> Updated Formulae agedu broot elvish gmt kustomize pgrouting serve swiftgen vulkan-headers artifactory catch2 erlang grap libmicrohttpd pnpm snapcraft tnftp benthos duplicity fluent-bit heimdal mdcat quickjs sphinx-doc unnethack bit dwarfutils git-town helmfile mpg123 rsync sratoolkit vttest Error: openssl@1.1 1.1.1d is already installed To upgrade to 1.1.1g, run `brew upgrade openssl@1.1` simonplatten@Simons-iMac sqldrivers % -
Hi, I just tried the same, i.e. brew install mariadb and it worked 1st try:
~/Qt/5.15.0/clang_64/bin/qmake -- MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.4.13/include/mysql "MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.13/lib" MYSQL_LIBS="-lmariadb" Info: creating stash file /Users/henry/Downloads/qt-everywhere-src-5.15.0/qtbase/src/plugins/sqldrivers/.qmake.stash Running configuration tests... Checking for DB2 (IBM)... no Checking for InterBase... no Checking for MySQL... yes Checking for OCI (Oracle)... no Checking for ODBC... no Checking for PostgreSQL... no Checking for SQLite (version 2)... no Checking for TDS (Sybase)... no Done running configuration tests. Configure summary: Qt Sql Drivers: DB2 (IBM) .............................. no InterBase .............................. no MySql .................................. yes OCI (Oracle) ........................... no ODBC ................................... no PostgreSQL ............................. no SQLite2 ................................ no SQLite ................................. yes Using system provided SQLite ......... no TDS (Sybase) ........................... no Qt is now configured for building. Just run 'make'. Once everything is built, you must run 'make install'. Qt will be installed into '/Users/henry/Qt/5.15.0/clang_64'. Prior to reconfiguration, make sure you remove any leftovers from the previous build.and the config.log file: (just the interesting/good part):
... ... Trying source 4 (type inline) of library mysql ... + cd /Users/henry/Downloads/qt-everywhere-src-5.15.0/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/henry/Qt/5.15.0/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.13/lib -lmariadb' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.13/include/mysql' /Users/henry/Downloads/qt-everywhere-src-5.15.0/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/henry/Downloads/qt-everywhere-src-5.15.0/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.13/include/mysql -I/Users/henry/Qt/5.15.0/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.13/lib -lmariadb => source accepted. test config.sqldrivers.libraries.mysql succeeded ... ...The only difference I can see, is that I got mariadb version 10.4.13 but you have 10.4.6._1 maybe you can upgrade?
Edit: added the good parts of the log :-)
-
Thank you:
simonplatten@Simons-iMac bin % brew install unixodbc ==> Downloading https://homebrew.bintray.com/bottles/libtool-2.4.6_2.catalina.bottle.tar.gz ==> Downloading from https://d29vzk4ow07wi7.cloudfront.net/af317b35d0a394b7ef55fba4950735b0392d9f31bececebf9c412261c23a01 ######################################################################## 100.0% ==> Downloading https://homebrew.bintray.com/bottles/unixodbc-2.3.7.catalina.bottle.1.tar.gz ==> Downloading from https://akamai.bintray.com/03/03ba378d971af98d07652f978548ffacb4c155ba11dd36af9d46af36e2d5674b?__gda ######################################################################## 100.0% ==> Installing dependencies for unixodbc: libtool ==> Installing unixodbc dependency: libtool ==> Pouring libtool-2.4.6_2.catalina.bottle.tar.gz ==> Caveats In order to prevent conflicts with Apple's own libtool we have prepended a "g" so, you have instead: glibtool and glibtoolize. ==> Summary 🍺 /usr/local/Cellar/libtool/2.4.6_2: 71 files, 3.7MB ==> Installing unixodbc ==> Pouring unixodbc-2.3.7.catalina.bottle.1.tar.gz 🍺 /usr/local/Cellar/unixodbc/2.3.7: 46 files, 1.9MB ==> `brew cleanup` has not been run in 30 days, running now... Removing: /Users/simonplatten/Library/Caches/Homebrew/gettext--0.20.1.mojave.bottle.tar.gz... (8.4MB) Removing: /Users/simonplatten/Library/Caches/Homebrew/git--2.23.0_1.mojave.bottle.tar.gz... (17.1MB) Removing: /usr/local/Cellar/libtool/2.4.6_1... (70 files, 3.7MB) Removing: /Users/simonplatten/Library/Caches/Homebrew/mariadb--10.4.6_1.mojave.bottle.tar.gz... (48.6MB) Removing: /Users/simonplatten/Library/Caches/Homebrew/openssl@1.1--1.1.1d.mojave.bottle.tar.gz... (5.2MB) Removing: /Users/simonplatten/Library/Caches/Homebrew/pcre2--10.33.mojave.bottle.tar.gz... (1.9MB) Removing: /Users/simonplatten/Library/Logs/Homebrew/mariadb... (64B) Removing: /Users/simonplatten/Library/Logs/Homebrew/gettext... (64B) Removing: /Users/simonplatten/Library/Logs/Homebrew/pcre2... (64B) Removing: /Users/simonplatten/Library/Logs/Homebrew/openssl@1.1... (64B) Removing: /Users/simonplatten/Library/Logs/Homebrew/git... (64B) Pruned 0 symbolic links and 4 directories from /usr/local ==> Caveats ==> libtool In order to prevent conflicts with Apple's own libtool we have prepended a "g" so, you have instead: glibtool and glibtoolize. -
After all that:
simonplatten@Simons-iMac bin % cd $QTDIR/Src/qtbase/src/plugins/sqldrivers simonplatten@Simons-iMac sqldrivers % $QTDIRBIN/qmake -- MYSQL_INCDIR="/usr/local/Cellar/mariadb/10.4.6_1/include/mysql" "MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.6_1/lib" MYSQL_LIBS="-lmariadb" Running configuration tests... Done running configuration tests. Configure summary: Qt Sql Drivers: DB2 (IBM) .............................. no InterBase .............................. no MySql .................................. no OCI (Oracle) ........................... no ODBC ................................... no PostgreSQL ............................. no SQLite2 ................................ no SQLite ................................. yes Using system provided SQLite ......... no TDS (Sybase) ........................... no Qt is now configured for building. Just run 'make'. Once everything is built, you must run 'make install'. Qt will be installed into '/Users/simonplatten/Qt/5.14.2/clang_64'. Prior to reconfiguration, make sure you remove any leftovers from the previous build. -
simonplatten@Simons-iMac sqldrivers % cat config.log Command line: MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.4.6_1/include/mysql MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.6_1/lib MYSQL_LIBS=-lmariadb Global lib dirs: [] [/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk/usr/lib] Global inc dirs: [/usr/local/opt/openssl/include] [/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/include/c++/v1 /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/lib/clang/11.0.3/include /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk/usr/include /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/include] loaded result for library config.sqldrivers.libraries.db2 Trying source 0 (type inline) of library db2 ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library db2 ... sqlcli.h not found in [] and global paths. sqlcli1.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.db2 FAILED loaded result for library config.sqldrivers.libraries.ibase Trying source 0 (type inline) of library ibase ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library ibase ... ibase.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.ibase FAILED loaded result for library config.sqldrivers.libraries.mysql Trying source 0 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs_r > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql > Info: creating stash file /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/.qmake.stash + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib > Undefined symbols for architecture x86_64: > "_mysql_get_client_version", referenced from: > _main in main.o > ld: symbol(s) not found for architecture x86_64 > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 1 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib > Undefined symbols for architecture x86_64: > "_mysql_get_client_version", referenced from: > _main in main.o > ld: symbol(s) not found for architecture x86_64 > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 2 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs_r > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto > ld: library not found for -lssl > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 3 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto > ld: library not found for -lssl > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 4 (type inline) of library mysql ... mysql.h not found in [/usr/local/include] and global paths. => source produced no result. Trying source 5 (type inline) of library mysql ... => source failed condition 'config.win32'. Trying source 6 (type inline) of library mysql ... mysql.h not found in [/usr/local/include] and global paths. => source produced no result. test config.sqldrivers.libraries.mysql FAILED loaded result for library config.sqldrivers.libraries.oci Trying source 0 (type inline) of library oci ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library oci ... oci.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.oci FAILED loaded result for library config.sqldrivers.libraries.odbc Trying source 0 (type inline) of library odbc ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library odbc ... sql.h not found in [] and global paths. sqlext.h not found in [] and global paths. => source produced no result. Trying source 2 (type inline) of library odbc ... => source failed condition '!config.win32 && !config.darwin'. test config.sqldrivers.libraries.odbc FAILED loaded result for library config.sqldrivers.libraries.psql Trying source 0 (type pkgConfig) of library psql ... pkg-config use disabled globally. => source produced no result. Trying source 1 (type psqlConfig) of library psql ... pg_config not found. => source produced no result. Trying source 2 (type psqlEnv) of library psql ... => source failed condition 'config.win32'. Trying source 3 (type psqlEnv) of library psql ... libpq-fe.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.psql FAILED loaded result for library config.sqldrivers.libraries.sqlite2 Trying source 0 (type inline) of library sqlite2 ... sqlite.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.sqlite2 FAILED loaded result for library config.sqldrivers.libraries.tds Trying source 0 (type sybaseEnv) of library tds ... => source failed condition 'config.win32'. Trying source 1 (type sybaseEnv) of library tds ... + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += tds' 'QMAKE_LIBS_TDS = -lsybdb' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && MAKEFLAGS= make > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > main.cpp:2:10: fatal error: 'sybfront.h' file not found > #include <sybfront.h> > ^~~~~~~~~~~~ > 1 error generated. > make: *** [main.o] Error 1 => source failed verification. test config.sqldrivers.libraries.tds FAILED -
Almost there, one more: freetds
brew install freetdsEdit: check that have you all the .h files needed:
ls -la /usr/local/include/mysql*
I got:
lrwxr-xr-x 1 henry admin 39 Jul 6 09:16 /usr/local/include/mysql -> ../Cellar/mariadb/10.4.13/include/mysqlAlso check:
ls -la /usr/local/include/sqllrwxr-xr-x 1 henry admin 38 Mar 24 22:12 /usr/local/include/sql.h -> ../Cellar/unixodbc/2.3.7/include/sql.h
lrwxr-xr-x 1 henry admin 40 Mar 24 22:12 /usr/local/include/sqldb.h -> ../Cellar/freetds/1.1.24/include/sqldb.h
lrwxr-xr-x 1 henry admin 41 Mar 24 22:12 /usr/local/include/sqlext.h -> ../Cellar/unixodbc/2.3.7/include/sqlext.h
lrwxr-xr-x 1 henry admin 43 Mar 24 22:12 /usr/local/include/sqlfront.h -> ../Cellar/freetds/1.1.24/include/sqlfront.h
lrwxr-xr-x 1 henry admin 41 Mar 24 22:12 /usr/local/include/sqlspi.h -> ../Cellar/unixodbc/2.3.7/include/sqlspi.h
lrwxr-xr-x 1 henry admin 43 Mar 24 22:12 /usr/local/include/sqltypes.h -> ../Cellar/unixodbc/2.3.7/include/sqltypes.h
lrwxr-xr-x 1 henry admin 43 Mar 24 22:12 /usr/local/include/sqlucode.h -> ../Cellar/unixodbc/2.3.7/include/sqlucode.h -
Done that, still after quake only see SQLite with yes by it, and MySql with no, output from config.log:
Command line: MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.4.6_1/include/mysql MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.4.6_1/lib MYSQL_LIBS=-lmariadb Global lib dirs: [] [/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk/usr/lib] Global inc dirs: [/usr/local/opt/openssl/include] [/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/include/c++/v1 /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/lib/clang/11.0.3/include /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk/usr/include /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/include] loaded result for library config.sqldrivers.libraries.db2 Trying source 0 (type inline) of library db2 ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library db2 ... sqlcli.h not found in [] and global paths. sqlcli1.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.db2 FAILED loaded result for library config.sqldrivers.libraries.ibase Trying source 0 (type inline) of library ibase ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library ibase ... ibase.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.ibase FAILED loaded result for library config.sqldrivers.libraries.mysql Trying source 0 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs_r > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql > Info: creating stash file /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/.qmake.stash + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib > Undefined symbols for architecture x86_64: > "_mysql_get_client_version", referenced from: > _main in main.o > ld: symbol(s) not found for architecture x86_64 > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 1 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib > Undefined symbols for architecture x86_64: > "_mysql_get_client_version", referenced from: > _main in main.o > ld: symbol(s) not found for architecture x86_64 > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 2 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs_r > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto > ld: library not found for -lssl > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 3 (type mysqlConfig) of library mysql ... + /usr/local/bin/mysql_config --version > 10.4.6 + /usr/local/bin/mysql_config --libs > -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto + /usr/local/bin/mysql_config --include > -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql/.. + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += mysql' 'QMAKE_LIBS_MYSQL = -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.4.6_1/include/mysql /usr/local/Cellar/mariadb/10.4.6_1/include' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && MAKEFLAGS= make clean && MAKEFLAGS= make > rm -f main.o > rm -f *~ core *.core > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.4.6_1/include/mysql -I/usr/local/Cellar/mariadb/10.4.6_1/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -stdlib=libc++ -headerpad_max_install_names -arch x86_64 -Wl,-syslibroot,/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o -L/usr/local/Cellar/mariadb/10.4.6_1/lib -lmariadb -lz -liconv -lssl -lcrypto > ld: library not found for -lssl > clang: error: linker command failed with exit code 1 (use -v to see invocation) > make: *** [mysql] Error 1 => source failed verification. Trying source 4 (type inline) of library mysql ... mysql.h not found in [/usr/local/include] and global paths. => source produced no result. Trying source 5 (type inline) of library mysql ... => source failed condition 'config.win32'. Trying source 6 (type inline) of library mysql ... mysql.h not found in [/usr/local/include] and global paths. => source produced no result. test config.sqldrivers.libraries.mysql FAILED loaded result for library config.sqldrivers.libraries.oci Trying source 0 (type inline) of library oci ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library oci ... oci.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.oci FAILED loaded result for library config.sqldrivers.libraries.odbc Trying source 0 (type inline) of library odbc ... => source failed condition 'config.win32'. Trying source 1 (type inline) of library odbc ... sql.h not found in [] and global paths. sqlext.h not found in [] and global paths. => source produced no result. Trying source 2 (type inline) of library odbc ... => source failed condition '!config.win32 && !config.darwin'. test config.sqldrivers.libraries.odbc FAILED loaded result for library config.sqldrivers.libraries.psql Trying source 0 (type pkgConfig) of library psql ... pkg-config use disabled globally. => source produced no result. Trying source 1 (type psqlConfig) of library psql ... pg_config not found. => source produced no result. Trying source 2 (type psqlEnv) of library psql ... => source failed condition 'config.win32'. Trying source 3 (type psqlEnv) of library psql ... libpq-fe.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.psql FAILED loaded result for library config.sqldrivers.libraries.sqlite2 Trying source 0 (type inline) of library sqlite2 ... sqlite.h not found in [] and global paths. => source produced no result. test config.sqldrivers.libraries.sqlite2 FAILED loaded result for library config.sqldrivers.libraries.tds Trying source 0 (type sybaseEnv) of library tds ... => source failed condition 'config.win32'. Trying source 1 (type sybaseEnv) of library tds ... + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && /Users/simonplatten/Qt/5.14.2/clang_64/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'INCLUDEPATH += /usr/local/opt/openssl/include' 'QMAKE_USE += tds' 'QMAKE_LIBS_TDS = -lsybdb' /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds + cd /Users/simonplatten/Qt/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && MAKEFLAGS= make > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/opt/openssl/include -I/Users/simonplatten/Qt/5.14.2/clang_64/mkspecs/macx-clang -o main.o main.cpp > main.cpp:2:10: fatal error: 'sybfront.h' file not found > #include <sybfront.h> > ^~~~~~~~~~~~ > 1 error generated. > make: *** [main.o] Error 1 => source failed verification. test config.sqldrivers.libraries.tds FAILED -
The culprit I think for you is in step #4:
Trying source 4 (type inline) of library mysql ... mysql.h not found in [/usr/local/include] and global paths. => source produced no result.(because my step #4 succeeded)
What does
ls -la /usr/local/include/mysql*say?
Mine says:lrwxr-xr-x 1 henry admin 39 Jul 6 09:16 /usr/local/include/mysql -> ../Cellar/mariadb/10.4.13/include/mysql -
simonplatten@Simons-iMac sqldrivers % ls -la /usr/local/include/mysql/* -rw-r--r-- 1 simonplatten staff 3877 17 Jun 2019 /usr/local/include/mysql/errmsg.h -rw-r--r-- 1 simonplatten staff 1607 17 Jun 2019 /usr/local/include/mysql/ma_list.h -rw-r--r-- 1 simonplatten staff 4325 17 Jun 2019 /usr/local/include/mysql/ma_pvio.h -rw-r--r-- 1 simonplatten staff 4256 17 Jun 2019 /usr/local/include/mysql/ma_tls.h -rw-r--r-- 1 simonplatten staff 17284 17 Jun 2019 /usr/local/include/mysql/mariadb_com.h -rw-r--r-- 1 simonplatten staff 2593 17 Jun 2019 /usr/local/include/mysql/mariadb_ctype.h -rw-r--r-- 1 simonplatten staff 8196 17 Jun 2019 /usr/local/include/mysql/mariadb_dyncol.h -rw-r--r-- 1 simonplatten staff 7894 17 Jun 2019 /usr/local/include/mysql/mariadb_rpl.h -rw-r--r-- 1 simonplatten staff 11702 17 Jun 2019 /usr/local/include/mysql/mariadb_stmt.h -rw-r--r-- 1 simonplatten staff 1127 28 Sep 2019 /usr/local/include/mysql/mariadb_version.h -rw-r--r-- 1 simonplatten staff 148 17 Jun 2019 /usr/local/include/mysql/my_config.h -rw-r--r-- 1 simonplatten staff 148 17 Jun 2019 /usr/local/include/mysql/my_global.h -rw-r--r-- 1 simonplatten staff 148 17 Jun 2019 /usr/local/include/mysql/my_sys.h -rw-r--r-- 1 simonplatten staff 40580 17 Jun 2019 /usr/local/include/mysql/mysql.h -rw-r--r-- 1 simonplatten staff 174 17 Jun 2019 /usr/local/include/mysql/mysql_com.h -rw-r--r-- 1 simonplatten staff 230 17 Jun 2019 /usr/local/include/mysql/mysql_version.h -rw-r--r-- 1 simonplatten staff 46992 17 Jun 2019 /usr/local/include/mysql/mysqld_error.h /usr/local/include/mysql/mariadb: total 8 drwxr-xr-x 3 simonplatten staff 96 17 Jun 2019 . drwxr-xr-x 22 simonplatten staff 704 28 Sep 2019 .. -rw-r--r-- 1 simonplatten staff 1622 17 Jun 2019 ma_io.h /usr/local/include/mysql/mysql: total 40 drwxr-xr-x 5 simonplatten staff 160 17 Jun 2019 . drwxr-xr-x 22 simonplatten staff 704 28 Sep 2019 .. -rw-r--r-- 1 simonplatten staff 8625 17 Jun 2019 client_plugin.h -rw-r--r-- 1 simonplatten staff 3793 17 Jun 2019 plugin_auth.h -rw-r--r-- 1 simonplatten staff 3873 17 Jun 2019 plugin_auth_common.h /usr/local/include/mysql/server: total 1288 drwxr-xr-x 49 simonplatten staff 1568 28 Sep 2019 . drwxr-xr-x 22 simonplatten staff 704 28 Sep 2019 .. -rw-r--r-- 1 simonplatten staff 4505 17 Jun 2019 big_endian.h -rw-r--r-- 1 simonplatten staff 5194 17 Jun 2019 byte_order_generic.h -rw-r--r-- 1 simonplatten staff 4237 17 Jun 2019 byte_order_generic_x86.h -rw-r--r-- 1 simonplatten staff 4087 17 Jun 2019 byte_order_generic_x86_64.h -rw-r--r-- 1 simonplatten staff 4667 17 Jun 2019 decimal.h -rw-r--r-- 1 simonplatten staff 4363 17 Jun 2019 errmsg.h -rw-r--r-- 1 simonplatten staff 4443 17 Jun 2019 handler_ername.h -rw-r--r-- 1 simonplatten staff 758 17 Jun 2019 handler_state.h -rw-r--r-- 1 simonplatten staff 13619 17 Jun 2019 json_lib.h -rw-r--r-- 1 simonplatten staff 8827 17 Jun 2019 keycache.h -rw-r--r-- 1 simonplatten staff 3572 17 Jun 2019 little_endian.h -rw-r--r-- 1 simonplatten staff 46703 17 Jun 2019 m_ctype.h -rw-r--r-- 1 simonplatten staff 7545 17 Jun 2019 m_string.h -rw-r--r-- 1 simonplatten staff 8042 17 Jun 2019 ma_dyncol.h -rw-r--r-- 1 simonplatten staff 1986 17 Jun 2019 my_alloc.h -rw-r--r-- 1 simonplatten staff 2249 17 Jun 2019 my_attribute.h -rw-r--r-- 1 simonplatten staff 1980 17 Jun 2019 my_byteorder.h -rw-r--r-- 1 simonplatten staff 5036 17 Jun 2019 my_compiler.h -rw-r--r-- 1 simonplatten staff 14852 28 Sep 2019 my_config.h -rw-r--r-- 1 simonplatten staff 9454 17 Jun 2019 my_dbug.h -rw-r--r-- 1 simonplatten staff 2075 17 Jun 2019 my_decimal_limits.h -rw-r--r-- 1 simonplatten staff 3886 17 Jun 2019 my_dir.h -rw-r--r-- 1 simonplatten staff 5603 17 Jun 2019 my_getopt.h -rw-r--r-- 1 simonplatten staff 33753 17 Jun 2019 my_global.h -rw-r--r-- 1 simonplatten staff 1506 17 Jun 2019 my_list.h -rw-r--r-- 1 simonplatten staff 2031 17 Jun 2019 my_net.h -rw-r--r-- 1 simonplatten staff 28292 17 Jun 2019 my_pthread.h -rw-r--r-- 1 simonplatten staff 43095 17 Jun 2019 my_sys.h -rw-r--r-- 1 simonplatten staff 2544 17 Jun 2019 my_valgrind.h -rw-r--r-- 1 simonplatten staff 2832 17 Jun 2019 my_xml.h drwxr-xr-x 35 simonplatten staff 1120 17 Jun 2019 mysql -rw-r--r-- 1 simonplatten staff 39621 17 Jun 2019 mysql.h -rw-r--r-- 1 simonplatten staff 29909 17 Jun 2019 mysql_com.h -rw-r--r-- 1 simonplatten staff 1313 17 Jun 2019 mysql_com_server.h -rw-r--r-- 1 simonplatten staff 1124 17 Jun 2019 mysql_embed.h -rw-r--r-- 1 simonplatten staff 2420 17 Jun 2019 mysql_time.h -rw-r--r-- 1 simonplatten staff 1076 17 Jun 2019 mysql_version.h -rw-r--r-- 1 simonplatten staff 125194 17 Jun 2019 mysqld_ername.h -rw-r--r-- 1 simonplatten staff 46992 17 Jun 2019 mysqld_error.h -rw-r--r-- 1 simonplatten staff 1105 17 Jun 2019 pack.h drwxr-xr-x 294 simonplatten staff 9408 28 Sep 2019 private -rw-r--r-- 1 simonplatten staff 5499 17 Jun 2019 sql_common.h -rw-r--r-- 1 simonplatten staff 14897 17 Jun 2019 sql_state.h -rw-r--r-- 1 simonplatten staff 1357 17 Jun 2019 sslopt-case.h -rw-r--r-- 1 simonplatten staff 2707 17 Jun 2019 sslopt-longopts.h -rw-r--r-- 1 simonplatten staff 1405 17 Jun 2019 sslopt-vars.h -rw-r--r-- 1 simonplatten staff 2350 17 Jun 2019 typelib.h -
Yes I'm sure I did, but it was quite a long time ago:
simonplatten@Simons-iMac sqldrivers % ls -l /usr/local total 0 drwxrwxr-x 48 simonplatten admin 1536 6 Jul 08:50 Cellar drwxrwxr-x 4 simonplatten admin 128 6 Jul 08:41 Frameworks drwxrwxr-x 20 simonplatten admin 640 6 Jul 08:49 Homebrew drwxrwxr-x 384 simonplatten admin 12288 6 Jul 08:50 bin drwxrwxr-x 20 simonplatten admin 640 6 Jul 08:50 etc drwxrwxr-x 73 simonplatten staff 2336 6 Jul 08:50 include drwxrwxr-x 191 simonplatten admin 6112 6 Jul 08:50 lib drwxr-xr-x 3 root wheel 96 1 Oct 2018 n drwxrwxr-x 62 simonplatten admin 1984 6 Jul 08:50 opt drwxr-xr-x 3 root wheel 96 1 Oct 2018 remotedesktop drwxrwxr-x 44 simonplatten admin 1408 6 Jul 08:41 share drwxrwxr-x 5 simonplatten admin 160 1 Oct 2018 var
