Set-up MariaDB library file location programmatically?

jsulm

@SPlatten said in Set-up MariaDB library file location programmatically?:

sybfront.h

Google says that header file is part of freetds-dev package (on Ubuntu).

SPlatten

@jsulm , I'll see what I can find.

After some googling:

brew upgrade freetds

Still getting same result tho.

SPlatten

Can anyone offer a solution?

SGaist

Since you want to build the MariaDB backend, what does the checks related to that backend say ?

SPlatten

@SGaist , can you explain what you mean please? This is the content of the config.log:

Command line: MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.5.7/include/mysql MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.5.7/lib MYSQL_LIBS=-lmariadb
Global lib dirs: [] [/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX11.1.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/12.0.0/include /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX11.1.sdk/usr/include /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/include]
looking for library 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
looking for library 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.

I've no idea why there is mention of win32, I'm on an iMAC running:

macOS Big Sur
Version 11.1

SGaist

If you take the time to read what you just posted, you'll see that it's for the Db2 database.

The logs contain all the tests that are done, concentrate on the one that are pertinent to MariaDB.

SPlatten

@SGaist , that's the problem isn't it? MySQL isn't mentioned.

SGaist

Did you grep through the complete logs ?
Until now you extracted information for two unrelated database backend.

SPlatten

@SGaist , sorry, I'm am idiot:

Command line: MYSQL_INCDIR=/usr/local/Cellar/mariadb/10.5.7/include/mysql MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.5.7/lib MYSQL_LIBS=-lmariadb
Global lib dirs: [] [/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX11.1.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/12.0.0/include /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX11.1.sdk/usr/include /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/include]
looking for library 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
looking for library 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
looking for library mysql
Trying source 0 (type mysqlConfig) of library mysql ...
+ /usr/local/bin/mysql_config --version
> 10.5.8
+ /usr/local/bin/mysql_config --libs_r
> -L/usr/local/Cellar/mariadb/10.5.8/lib  -lmariadb -lssl -lcrypto
+ /usr/local/bin/mysql_config --include
> -I/usr/local/Cellar/mariadb/10.5.8/include/mysql -I/usr/local/Cellar/mariadb/10.5.8/include/mysql/..
+ cd /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/sy/Qt/5.15.1/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.5.8/lib' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.5.8/include/mysql /usr/local/Cellar/mariadb/10.5.8/include' /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
> Project WARNING: Qt has only been tested with version 10.15 of the platform SDK, you're using 11.1.
> Project WARNING: This is an unsupported configuration. You may experience build issues, and by using
> Project WARNING: the 11.1 SDK you are opting in to new features that Qt has not been prepared for.
> Project WARNING: Please downgrade the SDK you use to build your app to version 10.15, or configure
> Project WARNING: with CONFIG+=sdk_no_version_check when running qmake to silence this warning.
+ cd /Users/sy/Qt/5.15.1/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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -w -fPIC  -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.5.8/include/mysql -I/usr/local/Cellar/mariadb/10.5.8/include -I/Users/sy/Qt/5.15.1/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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o   -L/usr/local/Cellar/mariadb/10.5.8/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.5.8
+ /usr/local/bin/mysql_config --libs
> -L/usr/local/Cellar/mariadb/10.5.8/lib  -lmariadb -lssl -lcrypto
+ /usr/local/bin/mysql_config --include
> -I/usr/local/Cellar/mariadb/10.5.8/include/mysql -I/usr/local/Cellar/mariadb/10.5.8/include/mysql/..
+ cd /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/sy/Qt/5.15.1/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.5.8/lib' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.5.8/include/mysql /usr/local/Cellar/mariadb/10.5.8/include' /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
> Project WARNING: Qt has only been tested with version 10.15 of the platform SDK, you're using 11.1.
> Project WARNING: This is an unsupported configuration. You may experience build issues, and by using
> Project WARNING: the 11.1 SDK you are opting in to new features that Qt has not been prepared for.
> Project WARNING: Please downgrade the SDK you use to build your app to version 10.15, or configure
> Project WARNING: with CONFIG+=sdk_no_version_check when running qmake to silence this warning.
+ cd /Users/sy/Qt/5.15.1/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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -w -fPIC  -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.5.8/include/mysql -I/usr/local/Cellar/mariadb/10.5.8/include -I/Users/sy/Qt/5.15.1/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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o   -L/usr/local/Cellar/mariadb/10.5.8/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.5.8
+ /usr/local/bin/mysql_config --libs_r
> -L/usr/local/Cellar/mariadb/10.5.8/lib  -lmariadb -lssl -lcrypto
+ /usr/local/bin/mysql_config --include
> -I/usr/local/Cellar/mariadb/10.5.8/include/mysql -I/usr/local/Cellar/mariadb/10.5.8/include/mysql/..
+ cd /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/sy/Qt/5.15.1/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.5.8/lib -lmariadb -lssl -lcrypto' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.5.8/include/mysql /usr/local/Cellar/mariadb/10.5.8/include' /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
> Project WARNING: Qt has only been tested with version 10.15 of the platform SDK, you're using 11.1.
> Project WARNING: This is an unsupported configuration. You may experience build issues, and by using
> Project WARNING: the 11.1 SDK you are opting in to new features that Qt has not been prepared for.
> Project WARNING: Please downgrade the SDK you use to build your app to version 10.15, or configure
> Project WARNING: with CONFIG+=sdk_no_version_check when running qmake to silence this warning.
+ cd /Users/sy/Qt/5.15.1/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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -w -fPIC  -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.5.8/include/mysql -I/usr/local/Cellar/mariadb/10.5.8/include -I/Users/sy/Qt/5.15.1/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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o   -L/usr/local/Cellar/mariadb/10.5.8/lib -lmariadb -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.5.8
+ /usr/local/bin/mysql_config --libs
> -L/usr/local/Cellar/mariadb/10.5.8/lib  -lmariadb -lssl -lcrypto
+ /usr/local/bin/mysql_config --include
> -I/usr/local/Cellar/mariadb/10.5.8/include/mysql -I/usr/local/Cellar/mariadb/10.5.8/include/mysql/..
+ cd /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql && /Users/sy/Qt/5.15.1/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.5.8/lib -lmariadb -lssl -lcrypto' 'QMAKE_INCDIR_MYSQL = /usr/local/Cellar/mariadb/10.5.8/include/mysql /usr/local/Cellar/mariadb/10.5.8/include' /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
> Project WARNING: Qt has only been tested with version 10.15 of the platform SDK, you're using 11.1.
> Project WARNING: This is an unsupported configuration. You may experience build issues, and by using
> Project WARNING: the 11.1 SDK you are opting in to new features that Qt has not been prepared for.
> Project WARNING: Please downgrade the SDK you use to build your app to version 10.15, or configure
> Project WARNING: with CONFIG+=sdk_no_version_check when running qmake to silence this warning.
+ cd /Users/sy/Qt/5.15.1/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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -w -fPIC  -I. -I/usr/local/opt/openssl/include -I/usr/local/Cellar/mariadb/10.5.8/include/mysql -I/usr/local/Cellar/mariadb/10.5.8/include -I/Users/sy/Qt/5.15.1/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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -Wl,-rpath,@executable_path/../Frameworks -o mysql main.o   -L/usr/local/Cellar/mariadb/10.5.8/lib -lmariadb -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 ...
Include path /usr/local/Cellar/mariadb/10.5.7/include/mysql is invalid.
mysql.h not found in [/usr/local/Cellar/mariadb/10.5.7/include/mysql] 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 ...
  => source failed condition 'config.win32'.
Trying source 7 (type inline) of library mysql ...
Include path /usr/local/Cellar/mariadb/10.5.7/include/mysql is invalid.
mysql.h not found in [/usr/local/Cellar/mariadb/10.5.7/include/mysql] and global paths.
  => source produced no result.
Trying source 8 (type inline) of library mysql ...
Include path /usr/local/Cellar/mariadb/10.5.7/include/mysql is invalid.
mysql.h not found in [/usr/local/Cellar/mariadb/10.5.7/include/mysql] and global paths.
  => source produced no result.
test config.sqldrivers.libraries.mysql FAILED
looking for library 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
looking for library 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
looking for library 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
looking for library 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
looking for library tds
Trying source 0 (type sybaseEnv) of library tds ...
  => source failed condition 'config.win32'.
Trying source 1 (type sybaseEnv) of library tds ...
+ cd /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && /Users/sy/Qt/5.15.1/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/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
> Project WARNING: Qt has only been tested with version 10.15 of the platform SDK, you're using 11.1.
> Project WARNING: This is an unsupported configuration. You may experience build issues, and by using
> Project WARNING: the 11.1 SDK you are opting in to new features that Qt has not been prepared for.
> Project WARNING: Please downgrade the SDK you use to build your app to version 10.15, or configure
> Project WARNING: with CONFIG+=sdk_no_version_check when running qmake to silence this warning.
+ cd /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && 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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -w -fPIC  -I. -I/usr/local/opt/openssl/include -I/Users/sy/Qt/5.15.1/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

Which file do I edit to apply?

CONFIG+=sdk_no_version_check

SGaist

This is the real error:

@SPlatten said in Set-up MariaDB library file location programmatically?:

Undefined symbols for architecture x86_64:

"_mysql_get_client_version"

SPlatten

@SGaist , After seeing the output and its recommendation I edited sqldrivers.pro and added:

TEMPLATE = subdirs
  
sqldrivers_standalone {
    _QMAKE_CACHE_ = $$shadowed($$SQLDRV_SRC_TREE)/.qmake.conf
    load(qt_configure)
}

qtConfig(sql-psql)     : SUBDIRS += psql
qtConfig(sql-mysql)    : SUBDIRS += mysql
qtConfig(sql-odbc)     : SUBDIRS += odbc
qtConfig(sql-tds)      : SUBDIRS += tds
qtConfig(sql-oci)      : SUBDIRS += oci
qtConfig(sql-db2)      : SUBDIRS += db2
qtConfig(sql-sqlite)   : SUBDIRS += sqlite
qtConfig(sql-sqlite2)  : SUBDIRS += sqlite2
qtConfig(sql-ibase)    : SUBDIRS += ibase

CONFIG+=sdk_no_version_check

I then removed all the config files including the cache with:

rm -R config.*

Then executed:

$QTDIRBIN/qmake -- MYSQL_INCDIR="/usr/local/Cellar/mariadb/10.5.7/include/mysql" "MYSQL_LIBDIR=/usr/local/Cellar/mariadb/10.5.7/lib" MYSQL_LIBS="-lmariadb"

All this as in:

/Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers

The result was config.log:


Running configuration tests...
Checking for DB2 (IBM)... no
Checking for InterBase... no
Checking for MySQL... no
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 .................................. 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/sy/Qt/5.15.1/clang_64'.

Prior to reconfiguration, make sure you remove any leftovers from
the previous build.

I then executed make:

cd sqlite/ && ( test -e Makefile || /Users/sy/Qt/5.15.1/clang_64/bin/qmake -o Makefile /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/sqlite/sqlite.pro ) && /Applications/Xcode.app/Contents/Developer/usr/bin/make -f Makefile 
make[1]: Nothing to be done for `first'.

Then make install:

cd sqlite/ && ( test -e Makefile || /Users/sy/Qt/5.15.1/clang_64/bin/qmake -o Makefile /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/sqlite/sqlite.pro ) && /Applications/Xcode.app/Contents/Developer/usr/bin/make -f Makefile install
/Users/sy/Qt/5.15.1/clang_64/bin/qmake -install qinstall -exe ../plugins/sqldrivers/libqsqlite.dylib /Users/sy/Qt/5.15.1/clang_64/plugins/sqldrivers/libqsqlite.dylib
/Users/sy/Qt/5.15.1/clang_64/bin/qmake -install qinstall /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/plugins/sqldrivers/libqsqlite.dylib.dSYM/Contents/Info.plist /Users/sy/Qt/5.15.1/clang_64/plugins/sqldrivers/libqsqlite.dylib.dSYM/Contents/Info.plist
/Users/sy/Qt/5.15.1/clang_64/bin/qmake -install qinstall /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/plugins/sqldrivers/libqsqlite.dylib.dSYM/Contents/Resources/DWARF/libqsqlite.dylib /Users/sy/Qt/5.15.1/clang_64/plugins/sqldrivers/libqsqlite.dylib.dSYM/Contents/Resources/DWARF/libqsqlite.dylib
/Users/sy/Qt/5.15.1/clang_64/bin/qmake -install qinstall /Users/sy/Qt/5.15.1/Src/qtbase/src/plugins/sqldrivers/lib/cmake/Qt5Sql/Qt5Sql_QSQLiteDriverPlugin.cmake /Users/sy/Qt/5.15.1/clang_64/lib/cmake/Qt5Sql/Qt5Sql_QSQLiteDriverPlugin.cmake

I've also tried to mysql.pro:

CONFIG+=sdk_no_version_check
  
TARGET = qsqlmysql

HEADERS += $$PWD/qsql_mysql_p.h
SOURCES += $$PWD/qsql_mysql.cpp $$PWD/main.cpp

QMAKE_USE += mysql

OTHER_FILES += mysql.json

PLUGIN_CLASS_NAME = QMYSQLDriverPlugin
include(../qsqldriverbase.pri)

Then repeated the above steps, still mysql shows no??? and same results. Is it looking for a mysql library because MariaDB mostly uses the name mysql as it is based on that but I've notice that there are a few folders where the name is actually mairadb and not mysql?

SGaist

Serious question: do you realise that you just silenced a warning unrelated to the actual error ?

I already pointed you to the real issue: a symbol is missing: _mysql_get_client_version.

In any case, Qt 5.15.2, MariaDB 10.5.8 is a working combo using the same qmake line you have with just the versions updated.

SPlatten

@SGaist , I have to switch back to 5.15.1 as 5.15.2 didn't come with any binaries, such as qmake.

Why is the symbol missing: _mysql_get_client_version ?

I'll try updating MariaDB now.

SPlatten

@SGaist , sorted now....I didn't realise that the version of MariaDB had already been updated on my system, so after correcting this in the command line everything is now working.

Thank you.