Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. macOS Big Sur and Database driver
Forum Updated to NodeBB v4.3 + New Features

macOS Big Sur and Database driver

Scheduled Pinned Locked Moved Unsolved General and Desktop
28 Posts 3 Posters 4.6k Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • jsulmJ jsulm

    @SPlatten Doesn't matter. You have to tell the compiler where to look for the headers (and the linker where to look for the libs) if those are not in system include dirs.

    SPlattenS Offline
    SPlattenS Offline
    SPlatten
    wrote on last edited by
    #9

    @jsulm thank you, I know how to do this on a PC, how do I do that on a MAC?

    jsulmJ 1 Reply Last reply
    0
    • SPlattenS SPlatten

      @jsulm thank you, I know how to do this on a PC, how do I do that on a MAC?

      jsulmJ Offline
      jsulmJ Offline
      jsulm
      Lifetime Qt Champion
      wrote on last edited by
      #10

      @SPlatten Should be the same on MAC (is a UNIX)

      https://forum.qt.io/topic/113070/qt-code-of-conduct

      SPlattenS 1 Reply Last reply
      0
      • jsulmJ jsulm

        @SPlatten Should be the same on MAC (is a UNIX)

        SPlattenS Offline
        SPlattenS Offline
        SPlatten
        wrote on last edited by
        #11

        @jsulm , I'm trying to add the library to the project, by selecting the Add Library... option from the project context menu, but I cannot or don't know how to navigate to the path as /usr/local doesn't appear to be available.

        jsulmJ 1 Reply Last reply
        0
        • SPlattenS SPlatten

          @jsulm , I'm trying to add the library to the project, by selecting the Add Library... option from the project context menu, but I cannot or don't know how to navigate to the path as /usr/local doesn't appear to be available.

          jsulmJ Offline
          jsulmJ Offline
          jsulm
          Lifetime Qt Champion
          wrote on last edited by
          #12

          @SPlatten said in macOS Big Sur and Database driver:

          Add Library...

          ?
          Aren't you building MySQL driver on the command line? How is "Add Library..." related to this?

          https://forum.qt.io/topic/113070/qt-code-of-conduct

          SPlattenS 2 Replies Last reply
          0
          • jsulmJ jsulm

            @SPlatten said in macOS Big Sur and Database driver:

            Add Library...

            ?
            Aren't you building MySQL driver on the command line? How is "Add Library..." related to this?

            SPlattenS Offline
            SPlattenS Offline
            SPlatten
            wrote on last edited by
            #13

            @jsulm , yes, sorry, you are quite correct.

            1 Reply Last reply
            0
            • jsulmJ jsulm

              @SPlatten said in macOS Big Sur and Database driver:

              Add Library...

              ?
              Aren't you building MySQL driver on the command line? How is "Add Library..." related to this?

              SPlattenS Offline
              SPlattenS Offline
              SPlatten
              wrote on last edited by
              #14

              @jsulm , I added:

              INCLUDEPATH += /usr/local/include
              

              To sqldrivers.pro and removed all the config:

              rm -R config.*
              

              Then ran:

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

              config.log still shows:

              > 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
              
              jsulmJ 1 Reply Last reply
              0
              • SPlattenS SPlatten

                @jsulm , I added:

                INCLUDEPATH += /usr/local/include
                

                To sqldrivers.pro and removed all the config:

                rm -R config.*
                

                Then ran:

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

                config.log still shows:

                > 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
                
                jsulmJ Offline
                jsulmJ Offline
                jsulm
                Lifetime Qt Champion
                wrote on last edited by
                #15

                @SPlatten From a clean state (no build artefacts from previous attempt)?

                https://forum.qt.io/topic/113070/qt-code-of-conduct

                SPlattenS 1 Reply Last reply
                0
                • jsulmJ jsulm

                  @SPlatten From a clean state (no build artefacts from previous attempt)?

                  SPlattenS Offline
                  SPlattenS Offline
                  SPlatten
                  wrote on last edited by
                  #16

                  @jsulm , can you elaborate please?

                  jsulmJ 1 Reply Last reply
                  0
                  • SPlattenS SPlatten

                    @jsulm , can you elaborate please?

                    jsulmJ Offline
                    jsulmJ Offline
                    jsulm
                    Lifetime Qt Champion
                    wrote on last edited by
                    #17

                    @SPlatten You already tried to build before, right? That means there are build artefacts (like object files, Makefile, ...). You should make sure you delete all these build artefacts before trying again...
                    Even better are out-of-source builds (create a build folder, go there and call qmake from there).

                    https://forum.qt.io/topic/113070/qt-code-of-conduct

                    SPlattenS 1 Reply Last reply
                    0
                    • jsulmJ jsulm

                      @SPlatten You already tried to build before, right? That means there are build artefacts (like object files, Makefile, ...). You should make sure you delete all these build artefacts before trying again...
                      Even better are out-of-source builds (create a build folder, go there and call qmake from there).

                      SPlattenS Offline
                      SPlattenS Offline
                      SPlatten
                      wrote on last edited by
                      #18

                      @jsulm I just did:

                      make clean
                      

                      From:

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

                      Result was:

                      rm -f .moc/moc_predefs.h
                      rm -f .moc/moc_qsql_mysql_p.cpp
                      rm -f .moc/main.moc
                      rm -f .obj/qsql_mysql.o .obj/main.o .obj/moc_qsql_mysql_p.o
                      rm -f *~ core *.core
                      cd sqlite/ && ( test -e Makefile || /Users/sy/Qt/5.15.2/clang_64/bin/qmake -o Makefile /Users/sy/Qt/5.15.2/Src/qtbase/src/plugins/sqldrivers/sqlite/sqlite.pro ) && /Applications/Xcode.app/Contents/Developer/usr/bin/make -f Makefile clean
                      rm -f .moc/moc_predefs.h
                      rm -f .moc/moc_qsql_sqlite_p.cpp
                      rm -f .moc/smain.moc
                      rm -f .obj/qsql_sqlite.o .obj/smain.o .obj/sqlite3.o .obj/moc_qsql_sqlite_p.o
                      rm -f *~ core *.core
                      

                      Then rerun:

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

                      And waited for build to finish. Same result, log file still reports:

                      > 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.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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -w -fPIC  -I. -I/usr/local/opt/openssl/include -I/Users/sy/Qt/5.15.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
                      
                      jsulmJ 1 Reply Last reply
                      0
                      • SPlattenS SPlatten

                        @jsulm I just did:

                        make clean
                        

                        From:

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

                        Result was:

                        rm -f .moc/moc_predefs.h
                        rm -f .moc/moc_qsql_mysql_p.cpp
                        rm -f .moc/main.moc
                        rm -f .obj/qsql_mysql.o .obj/main.o .obj/moc_qsql_mysql_p.o
                        rm -f *~ core *.core
                        cd sqlite/ && ( test -e Makefile || /Users/sy/Qt/5.15.2/clang_64/bin/qmake -o Makefile /Users/sy/Qt/5.15.2/Src/qtbase/src/plugins/sqldrivers/sqlite/sqlite.pro ) && /Applications/Xcode.app/Contents/Developer/usr/bin/make -f Makefile clean
                        rm -f .moc/moc_predefs.h
                        rm -f .moc/moc_qsql_sqlite_p.cpp
                        rm -f .moc/smain.moc
                        rm -f .obj/qsql_sqlite.o .obj/smain.o .obj/sqlite3.o .obj/moc_qsql_sqlite_p.o
                        rm -f *~ core *.core
                        

                        Then rerun:

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

                        And waited for build to finish. Same result, log file still reports:

                        > 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.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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -w -fPIC  -I. -I/usr/local/opt/openssl/include -I/Users/sy/Qt/5.15.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
                        
                        jsulmJ Offline
                        jsulmJ Offline
                        jsulm
                        Lifetime Qt Champion
                        wrote on last edited by
                        #19

                        @SPlatten said in macOS Big Sur and Database driver:

                        /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.2/clang_64/mkspecs/macx-clang -o main.o main.cpp

                        According to this compiler invocation /usr/local/include was not passed as additional include directory...

                        https://forum.qt.io/topic/113070/qt-code-of-conduct

                        SPlattenS 1 Reply Last reply
                        0
                        • jsulmJ jsulm

                          @SPlatten said in macOS Big Sur and Database driver:

                          /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.2/clang_64/mkspecs/macx-clang -o main.o main.cpp

                          According to this compiler invocation /usr/local/include was not passed as additional include directory...

                          SPlattenS Offline
                          SPlattenS Offline
                          SPlatten
                          wrote on last edited by
                          #20

                          @jsulm I tried adding another symbolic link to the sqldrivers folder, still same result, where did your output come from?

                          jsulmJ 2 Replies Last reply
                          0
                          • SPlattenS SPlatten

                            @jsulm I tried adding another symbolic link to the sqldrivers folder, still same result, where did your output come from?

                            jsulmJ Offline
                            jsulmJ Offline
                            jsulm
                            Lifetime Qt Champion
                            wrote on last edited by
                            #21

                            @SPlatten said in macOS Big Sur and Database driver:

                            where did your output come from?

                            It's the output you posted...

                            https://forum.qt.io/topic/113070/qt-code-of-conduct

                            1 Reply Last reply
                            0
                            • SPlattenS SPlatten

                              @jsulm I tried adding another symbolic link to the sqldrivers folder, still same result, where did your output come from?

                              jsulmJ Offline
                              jsulmJ Offline
                              jsulm
                              Lifetime Qt Champion
                              wrote on last edited by
                              #22

                              @SPlatten Take a look at this: https://forum.qt.io/topic/39337/qt-5-2-1-mysql-sql-driver-installieren-solved/10
                              You can see how you can define additional include directories when calling qmake (and also libs).

                              https://forum.qt.io/topic/113070/qt-code-of-conduct

                              SPlattenS 1 Reply Last reply
                              0
                              • jsulmJ jsulm

                                @SPlatten Take a look at this: https://forum.qt.io/topic/39337/qt-5-2-1-mysql-sql-driver-installieren-solved/10
                                You can see how you can define additional include directories when calling qmake (and also libs).

                                SPlattenS Offline
                                SPlattenS Offline
                                SPlatten
                                wrote on last edited by SPlatten
                                #23
                                This post is deleted!
                                jsulmJ 1 Reply Last reply
                                0
                                • SPlattenS SPlatten

                                  This post is deleted!

                                  jsulmJ Offline
                                  jsulmJ Offline
                                  jsulm
                                  Lifetime Qt Champion
                                  wrote on last edited by
                                  #24

                                  @SPlatten It's German. But the relevant part is: ""INCLUDEPATH+=C:/MySQL/include" "LIBS+=C:/MYSQL/MySQL Server <version>/lib/opt/libmysql.lib""
                                  So, in your case: "INCLUDEPATH+=/usr/local/include" "LIBS+=/usr/local/lib"

                                  https://forum.qt.io/topic/113070/qt-code-of-conduct

                                  SPlattenS 2 Replies Last reply
                                  1
                                  • jsulmJ jsulm

                                    @SPlatten It's German. But the relevant part is: ""INCLUDEPATH+=C:/MySQL/include" "LIBS+=C:/MYSQL/MySQL Server <version>/lib/opt/libmysql.lib""
                                    So, in your case: "INCLUDEPATH+=/usr/local/include" "LIBS+=/usr/local/lib"

                                    SPlattenS Offline
                                    SPlattenS Offline
                                    SPlatten
                                    wrote on last edited by
                                    #25

                                    @jsulm , thank you.

                                    1 Reply Last reply
                                    0
                                    • jsulmJ jsulm

                                      @SPlatten It's German. But the relevant part is: ""INCLUDEPATH+=C:/MySQL/include" "LIBS+=C:/MYSQL/MySQL Server <version>/lib/opt/libmysql.lib""
                                      So, in your case: "INCLUDEPATH+=/usr/local/include" "LIBS+=/usr/local/lib"

                                      SPlattenS Offline
                                      SPlattenS Offline
                                      SPlatten
                                      wrote on last edited by
                                      #26

                                      @jsulm said in macOS Big Sur and Database driver:

                                      INCLUDEPATH+=/usr/local/include" "LIBS+=/usr/local/lib"

                                      Ok, so started off from:

                                      rm -R config.*
                                      make clean
                                      $QTDIRBIN/qmake -- MYSQL_INCDIR="/usr/local/Cellar/mariadb/10.5.8/include/mysql" MYSQL_LIBDIR=“/usr/local/Cellar/mariadb/10.5.8/lib" MYSQL_LIBS="-lmariadb" "INCLUDEPATH+=/usr/local/include" "LIBS+=/usr/local/lib”
                                      make 
                                      make install
                                      

                                      Same result, config.log:

                                      > 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.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/MacOSX11.1.sdk -mmacosx-version-min=10.13 -w -fPIC  -I. -I/usr/local/opt/openssl/include -I/Users/sy/Qt/5.15.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
                                      
                                      1 Reply Last reply
                                      0
                                      • SGaistS Offline
                                        SGaistS Offline
                                        SGaist
                                        Lifetime Qt Champion
                                        wrote on last edited by
                                        #27

                                        Hi,

                                        Since you are only interested in the MySQL driver, why do you care about the TDS checks errors ?

                                        This will just disable the TDS plugin build.

                                        Interested in AI ? www.idiap.ch
                                        Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                                        SPlattenS 1 Reply Last reply
                                        1
                                        • SGaistS SGaist

                                          Hi,

                                          Since you are only interested in the MySQL driver, why do you care about the TDS checks errors ?

                                          This will just disable the TDS plugin build.

                                          SPlattenS Offline
                                          SPlattenS Offline
                                          SPlatten
                                          wrote on last edited by
                                          #28

                                          @SGaist , thank you, somewhere along the line I now have a working driver.

                                          1 Reply Last reply
                                          0

                                          • Login

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved