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. Qt MySQL Driver Mingw32-make not working
Forum Updated to NodeBB v4.3 + New Features

Qt MySQL Driver Mingw32-make not working

Scheduled Pinned Locked Moved Unsolved General and Desktop
46 Posts 6 Posters 7.1k Views 3 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.
  • J jsulm
    29 Nov 2019, 08:45

    @hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:

    C:\Program Files\MySQL\MySQL Server 8.0\include

    put this in "" as it contains spaces

    H Offline
    H Offline
    hobbyProgrammer
    wrote on 29 Nov 2019, 08:56 last edited by
    #28

    @jsulm yes I already tried that, but it failed to work

    K 1 Reply Last reply 29 Nov 2019, 09:05
    0
    • J jsulm
      29 Nov 2019, 08:45

      @hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:

      C:\Program Files\MySQL\MySQL Server 8.0\include

      put this in "" as it contains spaces

      H Offline
      H Offline
      hobbyProgrammer
      wrote on 29 Nov 2019, 08:58 last edited by hobbyProgrammer
      #29

      @jsulm just to be sure, it is just this command right?

      qmake -- "MYSQL_INCDIR=C:\Program Files\MySQL\MySQL Server 8.0\include" "MYSQL_LIBDIR=C:\Program Files\MySQL\MySQL Server 8.0\lib"

      not that I should add sqldrivers.pro behind it?

      qmake -- "MYSQL_INCDIR=C:\Program Files\MySQL\MySQL Server 8.0\include" "MYSQL_LIBDIR=C:\Program Files\MySQL\MySQL Server 8.0\lib" sqldrivers.pro

      J 1 Reply Last reply 29 Nov 2019, 09:04
      0
      • H hobbyProgrammer
        29 Nov 2019, 08:58

        @jsulm just to be sure, it is just this command right?

        qmake -- "MYSQL_INCDIR=C:\Program Files\MySQL\MySQL Server 8.0\include" "MYSQL_LIBDIR=C:\Program Files\MySQL\MySQL Server 8.0\lib"

        not that I should add sqldrivers.pro behind it?

        qmake -- "MYSQL_INCDIR=C:\Program Files\MySQL\MySQL Server 8.0\include" "MYSQL_LIBDIR=C:\Program Files\MySQL\MySQL Server 8.0\lib" sqldrivers.pro

        J Offline
        J Offline
        jsulm
        Lifetime Qt Champion
        wrote on 29 Nov 2019, 09:04 last edited by
        #30

        @hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:

        not that I should add sqldrivers.pro behind it?

        Depends in which directory you are. If you're in the directory where sqldrivers.pro is then no need to mention it. It looks like you're not doing out of source build which you should do. Also, are you sure qmake you're calling is the correct one (because you do not specify complete path)?

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

        1 Reply Last reply
        0
        • H hobbyProgrammer
          29 Nov 2019, 08:56

          @jsulm yes I already tried that, but it failed to work

          K Offline
          K Offline
          kshegunov
          Moderators
          wrote on 29 Nov 2019, 09:05 last edited by kshegunov
          #31

          I had the same problem the other day. qmake refused to find the mysql libs for whatever reason.
          So here's what I did:

          1. cd into C:/Qt/5.12.5/Src/qtbase
          2. $> configure.exe -prefix C:\Qt\5.12.5\mingw73_32 -release -platform win32-g++ -sql-mysql MYSQL_INCDIR="C:\Program Files (x86)\MySQL\MySQL Connector C 6.1\include" MYSQL_LIBDIR="C:\Program Files (x86)\MySQL\MySQL Connector C 6.1\lib"
            Adjust the prefix and mysql paths as needed.
          3. If configure complains about QMAKESPEC and other variables - unset them; i.e. $> set QMAKESPEC=
          4. Rerun configure and make sure in the summary the mysql is detected
          5. Do a partial build of Qt: $> mingw32-make module-qtbase
          6. Go to C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers and install the plugins in the prefix location:
            mingw32-make install

          Good luck.

          PS. That's for a release build, for the debug version you need to set the appropriate flag to configure to build both.

          Read and abide by the Qt Code of Conduct

          H 1 Reply Last reply 29 Nov 2019, 09:19
          2
          • K kshegunov
            29 Nov 2019, 09:05

            I had the same problem the other day. qmake refused to find the mysql libs for whatever reason.
            So here's what I did:

            1. cd into C:/Qt/5.12.5/Src/qtbase
            2. $> configure.exe -prefix C:\Qt\5.12.5\mingw73_32 -release -platform win32-g++ -sql-mysql MYSQL_INCDIR="C:\Program Files (x86)\MySQL\MySQL Connector C 6.1\include" MYSQL_LIBDIR="C:\Program Files (x86)\MySQL\MySQL Connector C 6.1\lib"
              Adjust the prefix and mysql paths as needed.
            3. If configure complains about QMAKESPEC and other variables - unset them; i.e. $> set QMAKESPEC=
            4. Rerun configure and make sure in the summary the mysql is detected
            5. Do a partial build of Qt: $> mingw32-make module-qtbase
            6. Go to C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers and install the plugins in the prefix location:
              mingw32-make install

            Good luck.

            PS. That's for a release build, for the debug version you need to set the appropriate flag to configure to build both.

            H Offline
            H Offline
            hobbyProgrammer
            wrote on 29 Nov 2019, 09:19 last edited by
            #32

            @kshegunov I can't seem to find configure.exe, should it be .exe or can it also be a different type of file?

            K 1 Reply Last reply 29 Nov 2019, 09:21
            0
            • H hobbyProgrammer
              29 Nov 2019, 09:19

              @kshegunov I can't seem to find configure.exe, should it be .exe or can it also be a different type of file?

              K Offline
              K Offline
              kshegunov
              Moderators
              wrote on 29 Nov 2019, 09:21 last edited by
              #33

              @hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:

              I can't seem to find configure.exe, should it be .exe or can it also be a different type of file?

              It's an exe. It's in your Qt source folder.

              Read and abide by the Qt Code of Conduct

              H 1 Reply Last reply 29 Nov 2019, 10:30
              1
              • H Offline
                H Offline
                hobbyProgrammer
                wrote on 29 Nov 2019, 09:26 last edited by hobbyProgrammer
                #34

                @kshegunov
                I see 3 configure files:
                config.txt
                configure (which is labelled as 'file')
                configure.bat
                configure.json

                1 Reply Last reply
                0
                • K kshegunov
                  29 Nov 2019, 09:21

                  @hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:

                  I can't seem to find configure.exe, should it be .exe or can it also be a different type of file?

                  It's an exe. It's in your Qt source folder.

                  H Offline
                  H Offline
                  hobbyProgrammer
                  wrote on 29 Nov 2019, 10:30 last edited by
                  #35

                  @kshegunov I tried with the .bat file, which seems to work properly, but I get this:

                  ERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.

                  Which doesn't seem ideal.
                  Also when I checked it with a sql project I still got:
                  QSqlDatabase: QMYSQL driver not loaded
                  QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7

                  K 1 Reply Last reply 29 Nov 2019, 18:47
                  0
                  • H hobbyProgrammer
                    29 Nov 2019, 10:30

                    @kshegunov I tried with the .bat file, which seems to work properly, but I get this:

                    ERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.

                    Which doesn't seem ideal.
                    Also when I checked it with a sql project I still got:
                    QSqlDatabase: QMYSQL driver not loaded
                    QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7

                    K Offline
                    K Offline
                    kshegunov
                    Moderators
                    wrote on 29 Nov 2019, 18:47 last edited by
                    #36

                    @hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:

                    ERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.

                    Then either you haven't provided the correct paths to the mysql headers and libraries or they're incompatible for some reason (e.g. they're 32bits while your compiler is 64bits or vice versa).

                    Read and abide by the Qt Code of Conduct

                    H 1 Reply Last reply 3 Dec 2019, 19:02
                    1
                    • K kshegunov
                      29 Nov 2019, 18:47

                      @hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:

                      ERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.

                      Then either you haven't provided the correct paths to the mysql headers and libraries or they're incompatible for some reason (e.g. they're 32bits while your compiler is 64bits or vice versa).

                      H Offline
                      H Offline
                      hobbyProgrammer
                      wrote on 3 Dec 2019, 19:02 last edited by
                      #37

                      @kshegunov alright, I managed to get it right on my PC, but I'd also like to have it on my laptop. The reimp worked and the MySQL folder\lib now contains libmysql.def and libmysql.a, however whenever I run configure.exe it doesn't work.

                      configure.exe -debug-and-release -platform win32-g++ -qt-sql-mysql -l mysql -I C:\MySQL\include -L C:\MySQL\lib
                      

                      gives me this:

                      Bootstrapping qmake ...
                      mingw32-make: Nothing to be done for 'first'.
                      ERROR: Invalid value given for boolean command line option 'sql-mysql'.
                      
                      ERROR: Unknown command line option '-l'.
                      
                      1 Reply Last reply
                      0
                      • S Offline
                        S Offline
                        SGaist
                        Lifetime Qt Champion
                        wrote on 3 Dec 2019, 20:02 last edited by
                        #38

                        Hi,

                        As the error text suggests, remove that -l option. The configure script doesn't support it. It only wants the include and library paths.

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

                        H 1 Reply Last reply 3 Dec 2019, 20:33
                        0
                        • S SGaist
                          3 Dec 2019, 20:02

                          Hi,

                          As the error text suggests, remove that -l option. The configure script doesn't support it. It only wants the include and library paths.

                          H Offline
                          H Offline
                          hobbyProgrammer
                          wrote on 3 Dec 2019, 20:33 last edited by
                          #39

                          @SGaist alright that solves the last error, but I still have this one:

                          ERROR: Invalid value given for boolean command line option 'sql-mysql'.
                          
                          J 1 Reply Last reply 4 Dec 2019, 06:33
                          0
                          • H hobbyProgrammer
                            3 Dec 2019, 20:33

                            @SGaist alright that solves the last error, but I still have this one:

                            ERROR: Invalid value given for boolean command line option 'sql-mysql'.
                            
                            J Offline
                            J Offline
                            jsulm
                            Lifetime Qt Champion
                            wrote on 4 Dec 2019, 06:33 last edited by
                            #40

                            @hobbyProgrammer Can you show your current configure call?

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

                            H 1 Reply Last reply 4 Dec 2019, 07:01
                            0
                            • J jsulm
                              4 Dec 2019, 06:33

                              @hobbyProgrammer Can you show your current configure call?

                              H Offline
                              H Offline
                              hobbyProgrammer
                              wrote on 4 Dec 2019, 07:01 last edited by
                              #41

                              @jsulm

                              i tried:

                              configure.exe -debug-and-release -platform win32-g++ -qt-sql-mysql -I C:\MySQL\include -L C:\MySQL\lib

                              which gave me this error:

                              ERROR: Invalid value given for boolean command line option 'sql-mysql'.
                              

                              configure.exe -debug-and-release -platform win32-g++ -sql-mysql -I C:\MySQL\include -L C:\MySQL\lib

                              which gave me this error:

                              ERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.
                              
                              J 1 Reply Last reply 4 Dec 2019, 07:06
                              0
                              • H hobbyProgrammer
                                4 Dec 2019, 07:01

                                @jsulm

                                i tried:

                                configure.exe -debug-and-release -platform win32-g++ -qt-sql-mysql -I C:\MySQL\include -L C:\MySQL\lib

                                which gave me this error:

                                ERROR: Invalid value given for boolean command line option 'sql-mysql'.
                                

                                configure.exe -debug-and-release -platform win32-g++ -sql-mysql -I C:\MySQL\include -L C:\MySQL\lib

                                which gave me this error:

                                ERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.
                                
                                J Offline
                                J Offline
                                jsulm
                                Lifetime Qt Champion
                                wrote on 4 Dec 2019, 07:06 last edited by
                                #42

                                @hobbyProgrammer It should be -sql-mysql
                                Check the configure log to see what exactly is missing.

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

                                H 1 Reply Last reply 4 Dec 2019, 08:07
                                0
                                • C Offline
                                  C Offline
                                  Christian Ehrlicher
                                  Lifetime Qt Champion
                                  wrote on 4 Dec 2019, 07:11 last edited by
                                  #43

                                  I still don't understand why you try to compile Qt just to create the mysql plugin...

                                  Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
                                  Visit the Qt Academy at https://academy.qt.io/catalog

                                  H 1 Reply Last reply 4 Dec 2019, 07:54
                                  1
                                  • C Christian Ehrlicher
                                    4 Dec 2019, 07:11

                                    I still don't understand why you try to compile Qt just to create the mysql plugin...

                                    H Offline
                                    H Offline
                                    hobbyProgrammer
                                    wrote on 4 Dec 2019, 07:54 last edited by
                                    #44

                                    @Christian-Ehrlicher I am following this tutorial:
                                    https://forum.qt.io/topic/40672/how-to-create-the-plugin-of-mysql-for-qt/34

                                    Should I just do the qmake for the sqldriver? or what else do you recommend?

                                    so only qmake "MYSQL_INCDIR+=<path>" "MYSQL_LIBS+=<path>" ?

                                    1 Reply Last reply
                                    0
                                    • J jsulm
                                      4 Dec 2019, 07:06

                                      @hobbyProgrammer It should be -sql-mysql
                                      Check the configure log to see what exactly is missing.

                                      H Offline
                                      H Offline
                                      hobbyProgrammer
                                      wrote on 4 Dec 2019, 08:07 last edited by
                                      #45

                                      @jsulm Hi,

                                      There's so much there...

                                      I managed to get it down to this:

                                      None of [libgds32_ms.dll.a libgds32_ms.a gds32_ms.dll.a gds32_ms.a gds32_ms.lib] found in [] and global paths.
                                        => source produced no result.
                                      Trying source 1 (type inline) of library ibase ...
                                        => source failed condition '!config.win32'.
                                      test config.qtbase_sqldrivers.libraries.ibase FAILED
                                      loaded result for library config.qtbase_sqldrivers.libraries.mysql
                                      Trying source 0 (type mysqlConfig) of library mysql ...
                                      mysql_config not found.
                                        => source produced no result.
                                      Trying source 1 (type mysqlConfig) of library mysql ...
                                      mysql_config not found.
                                        => source produced no result.
                                      Trying source 2 (type mysqlConfig) of library mysql ...
                                      mysql_config not found.
                                        => source produced no result.
                                      Trying source 3 (type mysqlConfig) of library mysql ...
                                      mysql_config not found.
                                        => source produced no result.
                                      Trying source 4 (type inline) of library mysql ...
                                        => source failed condition '!config.win32'.
                                      Trying source 5 (type inline) of library mysql ...
                                      
                                      1 Reply Last reply
                                      0
                                      • M Offline
                                        M Offline
                                        mashood45
                                        Banned
                                        wrote on 4 Dec 2019, 08:16 last edited by mashood45 12 Apr 2019, 08:24
                                        #46
                                        This post is deleted!
                                        1 Reply Last reply
                                        0

                                        37/46

                                        3 Dec 2019, 19:02

                                        • Login

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