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. Build MySQL plugin - cannot run compiler error
Forum Updated to NodeBB v4.3 + New Features

Build MySQL plugin - cannot run compiler error

Scheduled Pinned Locked Moved Solved General and Desktop
22 Posts 3 Posters 2.1k Views
  • 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.
  • B Bonnie

    @chihwah
    What's the output of qmake?
    Do you have a "yes" on the right of "MySql"?

    Sure a separate build folder is better, but the plugin projects are a bit different from normal ones.
    So for newbies, I prefer to let them run commands according to the doc...

    C Offline
    C Offline
    chihwah
    wrote on last edited by
    #13

    @Bonnie it says no for both the configuration tests and Sql drivers:
    Info: creating stash file C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers.qmake.stash

    Running configuration tests...
    Checking for DB2 (IBM)... no
    Checking for InterBase... no
    Checking for MySQL... no
    Checking for OCI (Oracle)... no
    Checking for ODBC... yes
    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 ................................... yes
    PostgreSQL ............................. no
    SQLite2 ................................ no
    SQLite ................................. yes
    Using system provided SQLite ......... no
    TDS (Sybase) ........................... no

    Qt is now configured for building. Just run 'mingw32-make'.
    Once everything is built, you must run 'mingw32-make install'.
    Qt will be installed into 'C:\Programming\5.15.0\mingw81_32'.

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

    C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>nmake sub-mysql
    'nmake' is not recognized as an internal or external command,
    operable program or batch file.

    C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>mingw32-make sub-mysql
    mingw32-make: *** No rule to make target 'sub-mysql'. Stop.

    C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>qmake -- MYSQL_INCDIR="C:\MySQL\MySQLServer8.0\include" MYSQL_LIBDIR="C:\MySQL\MySQLServer8.0\lib"

    Running configuration tests...
    Checking for DB2 (IBM)... no
    Checking for InterBase... no
    Checking for MySQL... no
    Checking for OCI (Oracle)... no
    Checking for ODBC... yes
    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 ................................... yes
    PostgreSQL ............................. no
    SQLite2 ................................ no
    SQLite ................................. yes
    Using system provided SQLite ......... no
    TDS (Sybase) ........................... no

    Qt is now configured for building. Just run 'mingw32-make'.
    Once everything is built, you must run 'mingw32-make install'.
    Qt will be installed into 'C:\Programming\5.15.0\mingw81_32'.

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

    Separately, can someone recommend a resource I can read to learn more about building and compiling? That would help me rebuild the plugin for the build folder. I can't really understand how to do an out of source build. I can see a build folder for my project, but not sure what commands to use to run qmake over that build folder.

    Would like to learn more about how all of this works so I can troubleshoot my own problems. I've tried reading numerous Qt documentation and forum posts, but it doesn't seem to help me much because there's quite a bit of presumed knowledge and I don't have a computing background.

    B 1 Reply Last reply
    0
    • C chihwah

      @Bonnie it says no for both the configuration tests and Sql drivers:
      Info: creating stash file C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers.qmake.stash

      Running configuration tests...
      Checking for DB2 (IBM)... no
      Checking for InterBase... no
      Checking for MySQL... no
      Checking for OCI (Oracle)... no
      Checking for ODBC... yes
      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 ................................... yes
      PostgreSQL ............................. no
      SQLite2 ................................ no
      SQLite ................................. yes
      Using system provided SQLite ......... no
      TDS (Sybase) ........................... no

      Qt is now configured for building. Just run 'mingw32-make'.
      Once everything is built, you must run 'mingw32-make install'.
      Qt will be installed into 'C:\Programming\5.15.0\mingw81_32'.

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

      C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>nmake sub-mysql
      'nmake' is not recognized as an internal or external command,
      operable program or batch file.

      C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>mingw32-make sub-mysql
      mingw32-make: *** No rule to make target 'sub-mysql'. Stop.

      C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>qmake -- MYSQL_INCDIR="C:\MySQL\MySQLServer8.0\include" MYSQL_LIBDIR="C:\MySQL\MySQLServer8.0\lib"

      Running configuration tests...
      Checking for DB2 (IBM)... no
      Checking for InterBase... no
      Checking for MySQL... no
      Checking for OCI (Oracle)... no
      Checking for ODBC... yes
      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 ................................... yes
      PostgreSQL ............................. no
      SQLite2 ................................ no
      SQLite ................................. yes
      Using system provided SQLite ......... no
      TDS (Sybase) ........................... no

      Qt is now configured for building. Just run 'mingw32-make'.
      Once everything is built, you must run 'mingw32-make install'.
      Qt will be installed into 'C:\Programming\5.15.0\mingw81_32'.

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

      Separately, can someone recommend a resource I can read to learn more about building and compiling? That would help me rebuild the plugin for the build folder. I can't really understand how to do an out of source build. I can see a build folder for my project, but not sure what commands to use to run qmake over that build folder.

      Would like to learn more about how all of this works so I can troubleshoot my own problems. I've tried reading numerous Qt documentation and forum posts, but it doesn't seem to help me much because there's quite a bit of presumed knowledge and I don't have a computing background.

      B Offline
      B Offline
      Bonnie
      wrote on last edited by Bonnie
      #14

      @chihwah

      1. Make sure there is a mysql.h file in the MYSQL_INCDIR folder (in your case it is "C:\MySQL\MySQLServer8.0\include") and a libmysql.lib file in the MYSQL_LIBDIR folder.
      2. Delete the config.log and config.cache file in the "C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers"
        Then run the qmake command again, if you still get no for mysql, post your newly generated "config.log".
      C 1 Reply Last reply
      1
      • B Bonnie

        @chihwah

        1. Make sure there is a mysql.h file in the MYSQL_INCDIR folder (in your case it is "C:\MySQL\MySQLServer8.0\include") and a libmysql.lib file in the MYSQL_LIBDIR folder.
        2. Delete the config.log and config.cache file in the "C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers"
          Then run the qmake command again, if you still get no for mysql, post your newly generated "config.log".
        C Offline
        C Offline
        chihwah
        wrote on last edited by
        #15

        @Bonnie thanks... I had previously tried to delete config.cache and reran but it still didn't work. This time I deleted both config.cache and config.log and it still says no. I've checked and those files are definitely in those directories. My config log is:
        Command line: "MYSQL_INCDIR=C:\MySQL\MySQLServer8.0\include" "MYSQL_LIBDIR=C:\MySQL\MySQLServer8.0\lib"
        Global lib dirs: [C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib] [C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0 C:/Programming/Tools/mingw810_32/lib/gcc C:/Programming/Tools/mingw810_32/i686-w64-mingw32/lib C:/Programming/Tools/mingw810_32/lib]
        Global inc dirs: [C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include] [C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++ C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/i686-w64-mingw32 C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/backward C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include-fixed C:/Programming/Tools/mingw810_32/i686-w64-mingw32/include]
        looking for library db2
        Trying source 0 (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.
        Trying source 1 (type inline) of library db2 ...
        => source failed condition '!config.win32'.
        test config.sqldrivers.libraries.db2 FAILED
        looking for library ibase
        Trying source 0 (type inline) of library ibase ...
        ibase.h not found in [] and global paths.
        => source produced no result.
        Trying source 1 (type inline) of library ibase ...
        => source failed condition '!config.win32'.
        test config.sqldrivers.libraries.ibase FAILED
        looking for library 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 ...

        • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Programming\5.15.0\mingw81_32\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = -LC:\MySQL\MySQLServer8.0\lib -llibmariadb" "QMAKE_INCDIR_MYSQL = C:\MySQL\MySQLServer8.0\include" C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
        • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

        del main.o
        g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresql\pgsql\include -IC:\MySQL\MySQLServer8.0\include -IC:\Programming\5.15.0\mingw81_32\mkspecs\win32-g++ -o main.o main.cpp
        g++ -Wl,-s -Wl,-subsystem,console -mthreads -o mysql.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-win32\lib -LC:\Utils\postgresql\pgsql\lib -LC:\MySQL\MySQLServer8.0\lib -llibmariadb
        C:/Programming/Tools/mingw810_32/bin/../lib/gcc/i686-w64-mingw32/8.1.0/../../../../i686-w64-mingw32/bin/ld.exe: cannot find -llibmariadb
        collect2.exe: error: ld returned 1 exit status
        mingw32-make: *** [Makefile:69: mysql.exe] Error 1
        => source failed verification.
        Trying source 6 (type inline) of library mysql ...

        • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Programming\5.15.0\mingw81_32\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = -LC:\MySQL\MySQLServer8.0\lib -llibmysql" "QMAKE_INCDIR_MYSQL = C:\MySQL\MySQLServer8.0\include" C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
        • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

        del main.o
        g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresql\pgsql\include -IC:\MySQL\MySQLServer8.0\include -IC:\Programming\5.15.0\mingw81_32\mkspecs\win32-g++ -o main.o main.cpp
        g++ -Wl,-s -Wl,-subsystem,console -mthreads -o mysql.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-win32\lib -LC:\Utils\postgresql\pgsql\lib -LC:\MySQL\MySQLServer8.0\lib -llibmysql
        main.o:main.cpp:(.text.startup+0xc): undefined reference to `mysql_get_client_version@0'
        collect2.exe: error: ld returned 1 exit status
        mingw32-make: *** [Makefile:69: mysql.exe] Error 1
        => source failed verification.
        Trying source 7 (type inline) of library mysql ...
        => source failed condition '!config.win32'.
        Trying source 8 (type inline) of library mysql ...
        => source failed condition '!config.win32'.
        test config.sqldrivers.libraries.mysql FAILED
        looking for library oci
        Trying source 0 (type inline) of library oci ...
        oci.h not found in [] and global paths.
        => source produced no result.
        Trying source 1 (type inline) of library oci ...
        => source failed condition '!config.win32'.
        test config.sqldrivers.libraries.oci FAILED
        looking for library odbc
        Trying source 0 (type inline) of library odbc ...

        • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && C:\Programming\5.15.0\mingw81_32\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = -lodbc32" C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
        • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

        del main.o
        g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_32\mkspecs\win32-g++ -o main.o main.cpp
        g++ -Wl,-s -Wl,-subsystem,console -mthreads -o odbc.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-win32\lib -LC:\Utils\postgresql\pgsql\lib -lodbc32
        => source accepted.
        test config.sqldrivers.libraries.odbc succeeded
        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 ...
        libpq-fe.h not found in [] and global paths.
        => source produced no result.
        Trying source 3 (type psqlEnv) of library psql ...
        => source failed condition '!config.win32'.
        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 ...

        • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && C:\Programming\5.15.0\mingw81_32\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += tds" "QMAKE_LIBS_TDS = -lNTWDBLIB" C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
        • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

        del main.o
        Could Not Find C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds\main.o
        g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_32\mkspecs\win32-g++ -o main.o main.cpp
        main.cpp:2:10: fatal error: sybfront.h: No such file or directory
        #include <sybfront.h>
        ^~~~~~~~~~~~
        compilation terminated.
        mingw32-make: *** [Makefile:496: main.o] Error 1
        => source failed verification.
        Trying source 1 (type sybaseEnv) of library tds ...
        => source failed condition '!config.win32'.
        test config.sqldrivers.libraries.tds FAILED

        I've tried looking up some of these errors yesterday but couldn't figure out what's causing it. From what I can see all the files are in the directories that I've directed qmake to.

        B 1 Reply Last reply
        0
        • C chihwah

          @Bonnie thanks... I had previously tried to delete config.cache and reran but it still didn't work. This time I deleted both config.cache and config.log and it still says no. I've checked and those files are definitely in those directories. My config log is:
          Command line: "MYSQL_INCDIR=C:\MySQL\MySQLServer8.0\include" "MYSQL_LIBDIR=C:\MySQL\MySQLServer8.0\lib"
          Global lib dirs: [C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib] [C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0 C:/Programming/Tools/mingw810_32/lib/gcc C:/Programming/Tools/mingw810_32/i686-w64-mingw32/lib C:/Programming/Tools/mingw810_32/lib]
          Global inc dirs: [C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include] [C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++ C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/i686-w64-mingw32 C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/backward C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include C:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include-fixed C:/Programming/Tools/mingw810_32/i686-w64-mingw32/include]
          looking for library db2
          Trying source 0 (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.
          Trying source 1 (type inline) of library db2 ...
          => source failed condition '!config.win32'.
          test config.sqldrivers.libraries.db2 FAILED
          looking for library ibase
          Trying source 0 (type inline) of library ibase ...
          ibase.h not found in [] and global paths.
          => source produced no result.
          Trying source 1 (type inline) of library ibase ...
          => source failed condition '!config.win32'.
          test config.sqldrivers.libraries.ibase FAILED
          looking for library 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 ...

          • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Programming\5.15.0\mingw81_32\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = -LC:\MySQL\MySQLServer8.0\lib -llibmariadb" "QMAKE_INCDIR_MYSQL = C:\MySQL\MySQLServer8.0\include" C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
          • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

          del main.o
          g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresql\pgsql\include -IC:\MySQL\MySQLServer8.0\include -IC:\Programming\5.15.0\mingw81_32\mkspecs\win32-g++ -o main.o main.cpp
          g++ -Wl,-s -Wl,-subsystem,console -mthreads -o mysql.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-win32\lib -LC:\Utils\postgresql\pgsql\lib -LC:\MySQL\MySQLServer8.0\lib -llibmariadb
          C:/Programming/Tools/mingw810_32/bin/../lib/gcc/i686-w64-mingw32/8.1.0/../../../../i686-w64-mingw32/bin/ld.exe: cannot find -llibmariadb
          collect2.exe: error: ld returned 1 exit status
          mingw32-make: *** [Makefile:69: mysql.exe] Error 1
          => source failed verification.
          Trying source 6 (type inline) of library mysql ...

          • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Programming\5.15.0\mingw81_32\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = -LC:\MySQL\MySQLServer8.0\lib -llibmysql" "QMAKE_INCDIR_MYSQL = C:\MySQL\MySQLServer8.0\include" C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
          • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

          del main.o
          g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresql\pgsql\include -IC:\MySQL\MySQLServer8.0\include -IC:\Programming\5.15.0\mingw81_32\mkspecs\win32-g++ -o main.o main.cpp
          g++ -Wl,-s -Wl,-subsystem,console -mthreads -o mysql.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-win32\lib -LC:\Utils\postgresql\pgsql\lib -LC:\MySQL\MySQLServer8.0\lib -llibmysql
          main.o:main.cpp:(.text.startup+0xc): undefined reference to `mysql_get_client_version@0'
          collect2.exe: error: ld returned 1 exit status
          mingw32-make: *** [Makefile:69: mysql.exe] Error 1
          => source failed verification.
          Trying source 7 (type inline) of library mysql ...
          => source failed condition '!config.win32'.
          Trying source 8 (type inline) of library mysql ...
          => source failed condition '!config.win32'.
          test config.sqldrivers.libraries.mysql FAILED
          looking for library oci
          Trying source 0 (type inline) of library oci ...
          oci.h not found in [] and global paths.
          => source produced no result.
          Trying source 1 (type inline) of library oci ...
          => source failed condition '!config.win32'.
          test config.sqldrivers.libraries.oci FAILED
          looking for library odbc
          Trying source 0 (type inline) of library odbc ...

          • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && C:\Programming\5.15.0\mingw81_32\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = -lodbc32" C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
          • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

          del main.o
          g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_32\mkspecs\win32-g++ -o main.o main.cpp
          g++ -Wl,-s -Wl,-subsystem,console -mthreads -o odbc.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-win32\lib -LC:\Utils\postgresql\pgsql\lib -lodbc32
          => source accepted.
          test config.sqldrivers.libraries.odbc succeeded
          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 ...
          libpq-fe.h not found in [] and global paths.
          => source produced no result.
          Trying source 3 (type psqlEnv) of library psql ...
          => source failed condition '!config.win32'.
          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 ...

          • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && C:\Programming\5.15.0\mingw81_32\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-win32\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-win32\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += tds" "QMAKE_LIBS_TDS = -lNTWDBLIB" C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
          • cd /d C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

          del main.o
          Could Not Find C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds\main.o
          g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_32\mkspecs\win32-g++ -o main.o main.cpp
          main.cpp:2:10: fatal error: sybfront.h: No such file or directory
          #include <sybfront.h>
          ^~~~~~~~~~~~
          compilation terminated.
          mingw32-make: *** [Makefile:496: main.o] Error 1
          => source failed verification.
          Trying source 1 (type sybaseEnv) of library tds ...
          => source failed condition '!config.win32'.
          test config.sqldrivers.libraries.tds FAILED

          I've tried looking up some of these errors yesterday but couldn't figure out what's causing it. From what I can see all the files are in the directories that I've directed qmake to.

          B Offline
          B Offline
          Bonnie
          wrote on last edited by Bonnie
          #16

          @chihwah
          The config.log does not affect the result, I just want to make sure you post the most updated info. :)
          I kind of get it.
          The mysql 8.0 only has 64bit version and you are using 32bit MinGW, so the linking failed.
          Did you also install the "MinGW 8.1.0 64-bit" version of Qt? Use that instead.
          And if you need to use 32bit, then use older versions of mysql.

          C 1 Reply Last reply
          2
          • B Bonnie

            @chihwah
            The config.log does not affect the result, I just want to make sure you post the most updated info. :)
            I kind of get it.
            The mysql 8.0 only has 64bit version and you are using 32bit MinGW, so the linking failed.
            Did you also install the "MinGW 8.1.0 64-bit" version of Qt? Use that instead.
            And if you need to use 32bit, then use older versions of mysql.

            C Offline
            C Offline
            chihwah
            wrote on last edited by
            #17

            @Bonnie that worked! can't believe it was bit version that caused it to trip up - I thought I had checked that.

            So I continued following the instructions and ran mingw32-make install, then ran mingw32-make sub-mysql, then ran mingw32-make install again. Then I built my program in Qt using the MinGW 64-bit kit, but it still says QMySQL Driver not loaded.

            Thanks heaps for your help so far - I feel like it's very nearly there, but I must be missing something else.

            I've put the cmd results below if that helps:
            C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>mingw32-make install
            cd mysql\ && ( if not exist Makefile C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -o Makefile C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\mysql\mysql.pro ) && mingw32-make -f Makefile install
            mingw32-make[1]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            mingw32-make -f Makefile.Release install
            mingw32-make[2]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            g++ -c -fno-keep-inline-dllexport -O2 -g -std=c++1z -fno-exceptions -Wall -Wextra -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0\QtCore -IC:\Programming\5.15.0\mingw81_64\include -IC:\Programming\5.15.0\mingw81_64\include\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore -I.moc\release -IC:\MySQL\MySQLServer8.0\include -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_64\mkspecs\win32-g++ -o .obj\release\qsql_mysql.o qsql_mysql.cpp
            g++ -fno-keep-inline-dllexport -O2 -g -std=c++1z -fno-exceptions -Wall -Wextra -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -dM -E -o .moc\release\moc_predefs.h C:\Programming\5.15.0\mingw81_64\mkspecs\features\data\dummy.cpp
            C:\Programming\5.15.0\mingw81_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB --include C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql/.moc/release/moc_predefs.h -IC:/Programming/5.15.0/mingw81_64/mkspecs/win32-g++ -IC:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql -IC:/Programming/5.15.0/mingw81_64/include/QtSql/5.15.0 -IC:/Programming/5.15.0/mingw81_64/include/QtSql/5.15.0/QtSql -IC:/Programming/5.15.0/mingw81_64/include/QtCore/5.15.0 -IC:/Programming/5.15.0/mingw81_64/include/QtCore/5.15.0/QtCore -IC:/Programming/5.15.0/mingw81_64/include -IC:/Programming/5.15.0/mingw81_64/include/QtSql -IC:/Programming/5.15.0/mingw81_64/include/QtCore -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++ -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/i686-w64-mingw32 -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/backward -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include-fixed -IC:/Programming/Tools/mingw810_32/i686-w64-mingw32/include main.cpp -o .moc\release\main.moc
            g++ -c -fno-keep-inline-dllexport -O2 -g -std=c++1z -fno-exceptions -Wall -Wextra -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0\QtCore -IC:\Programming\5.15.0\mingw81_64\include -IC:\Programming\5.15.0\mingw81_64\include\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore -I.moc\release -IC:\MySQL\MySQLServer8.0\include -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_64\mkspecs\win32-g++ -o .obj\release\main.o main.cpp
            C:\Programming\5.15.0\mingw81_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB --include C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql/.moc/release/moc_predefs.h -IC:/Programming/5.15.0/mingw81_64/mkspecs/win32-g++ -IC:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql -IC:/Programming/5.15.0/mingw81_64/include/QtSql/5.15.0 -IC:/Programming/5.15.0/mingw81_64/include/QtSql/5.15.0/QtSql -IC:/Programming/5.15.0/mingw81_64/include/QtCore/5.15.0 -IC:/Programming/5.15.0/mingw81_64/include/QtCore/5.15.0/QtCore -IC:/Programming/5.15.0/mingw81_64/include -IC:/Programming/5.15.0/mingw81_64/include/QtSql -IC:/Programming/5.15.0/mingw81_64/include/QtCore -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++ -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/i686-w64-mingw32 -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/backward -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include-fixed -IC:/Programming/Tools/mingw810_32/i686-w64-mingw32/include qsql_mysql_p.h -o .moc\release\moc_qsql_mysql_p.cpp
            g++ -c -fno-keep-inline-dllexport -O2 -g -std=c++1z -fno-exceptions -Wall -Wextra -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0\QtCore -IC:\Programming\5.15.0\mingw81_64\include -IC:\Programming\5.15.0\mingw81_64\include\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore -I.moc\release -IC:\MySQL\MySQLServer8.0\include -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_64\mkspecs\win32-g++ -o .obj\release\moc_qsql_mysql_p.o .moc\release\moc_qsql_mysql_p.cpp
            windres -i qsqlmysql_resource.rc -o .obj\release\qsqlmysql_resource_res.o --include-dir=. -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB
            g++ -shared -Wl,-subsystem,windows -Wl,--out-implib,C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\libqsqlmysql.a -o ..\plugins\sqldrivers\qsqlmysql.dll .obj/release/qsql_mysql.o .obj/release/main.o .obj/release/moc_qsql_mysql_p.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-winx64\lib -LC:\Utils\postgresql\pgsql\lib C:\Programming\5.15.0\mingw81_64\lib\libQt5Sql.a C:\Programming\5.15.0\mingw81_64\lib\libQt5Core.a -LC:\MySQL\MySQLServer8.0\lib -llibmysql .obj\release\qsqlmysql_resource_res.o
            objcopy --only-keep-debug ../plugins/sqldrivers/qsqlmysql.dll ../plugins/sqldrivers/qsqlmysql.dll.debug && objcopy --strip-debug ../plugins/sqldrivers/qsqlmysql.dll && objcopy --add-gnu-debuglink=../plugins/sqldrivers/qsqlmysql.dll.debug ../plugins/sqldrivers/qsqlmysql.dll
            C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\qsqlmysql.dll.debug C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlmysql.dll.debug
            copy /y ..\plugins\sqldrivers\qsqlmysql.dll C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlmysql.dll
            1 file(s) copied.
            C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QMYSQLDriverPlugin.cmake C:\Programming\5.15.0\mingw81_64\lib\cmake\Qt5Sql\Qt5Sql_QMYSQLDriverPlugin.cmake
            mingw32-make[2]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            mingw32-make[1]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            cd odbc\ && ( if not exist Makefile C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -o Makefile C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\odbc\odbc.pro ) && mingw32-make -f Makefile install
            mingw32-make[1]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc'
            mingw32-make -f Makefile.Release install
            mingw32-make[2]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc'
            g++ -c -fno-keep-inline-dllexport -O2 -g -std=c++1z -fno-exceptions -Wall -Wextra -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0\QtCore -IC:\Programming\5.15.0\mingw81_64\include -IC:\Programming\5.15.0\mingw81_64\include\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_64\mkspecs\win32-g++ -o .obj\release\qsql_odbc.o qsql_odbc.cpp
            g++ -fno-keep-inline-dllexport -O2 -g -std=c++1z -fno-exceptions -Wall -Wextra -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -dM -E -o .moc\release\moc_predefs.h C:\Programming\5.15.0\mingw81_64\mkspecs\features\data\dummy.cpp
            C:\Programming\5.15.0\mingw81_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB --include C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc/.moc/release/moc_predefs.h -IC:/Programming/5.15.0/mingw81_64/mkspecs/win32-g++ -IC:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc -IC:/Programming/5.15.0/mingw81_64/include/QtSql/5.15.0 -IC:/Programming/5.15.0/mingw81_64/include/QtSql/5.15.0/QtSql -IC:/Programming/5.15.0/mingw81_64/include/QtCore/5.15.0 -IC:/Programming/5.15.0/mingw81_64/include/QtCore/5.15.0/QtCore -IC:/Programming/5.15.0/mingw81_64/include -IC:/Programming/5.15.0/mingw81_64/include/QtSql -IC:/Programming/5.15.0/mingw81_64/include/QtCore -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++ -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/i686-w64-mingw32 -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/backward -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include-fixed -IC:/Programming/Tools/mingw810_32/i686-w64-mingw32/include main.cpp -o .moc\release\main.moc
            g++ -c -fno-keep-inline-dllexport -O2 -g -std=c++1z -fno-exceptions -Wall -Wextra -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0\QtCore -IC:\Programming\5.15.0\mingw81_64\include -IC:\Programming\5.15.0\mingw81_64\include\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_64\mkspecs\win32-g++ -o .obj\release\main.o main.cpp
            C:\Programming\5.15.0\mingw81_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB --include C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc/.moc/release/moc_predefs.h -IC:/Programming/5.15.0/mingw81_64/mkspecs/win32-g++ -IC:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc -IC:/Programming/5.15.0/mingw81_64/include/QtSql/5.15.0 -IC:/Programming/5.15.0/mingw81_64/include/QtSql/5.15.0/QtSql -IC:/Programming/5.15.0/mingw81_64/include/QtCore/5.15.0 -IC:/Programming/5.15.0/mingw81_64/include/QtCore/5.15.0/QtCore -IC:/Programming/5.15.0/mingw81_64/include -IC:/Programming/5.15.0/mingw81_64/include/QtSql -IC:/Programming/5.15.0/mingw81_64/include/QtCore -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++ -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/i686-w64-mingw32 -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/backward -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include -IC:/Programming/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include-fixed -IC:/Programming/Tools/mingw810_32/i686-w64-mingw32/include qsql_odbc_p.h -o .moc\release\moc_qsql_odbc_p.cpp
            g++ -c -fno-keep-inline-dllexport -O2 -g -std=c++1z -fno-exceptions -Wall -Wextra -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtSql\5.15.0\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0 -IC:\Programming\5.15.0\mingw81_64\include\QtCore\5.15.0\QtCore -IC:\Programming\5.15.0\mingw81_64\include -IC:\Programming\5.15.0\mingw81_64\include\QtSql -IC:\Programming\5.15.0\mingw81_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Programming\5.15.0\mingw81_64\mkspecs\win32-g++ -o .obj\release\moc_qsql_odbc_p.o .moc\release\moc_qsql_odbc_p.cpp
            windres -i qsqlodbc_resource.rc -o .obj\release\qsqlodbc_resource_res.o --include-dir=. -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DQT_NO_LINKED_LIST -DQT_NO_JAVA_STYLE_ITERATORS -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB
            g++ -shared -Wl,-subsystem,windows -Wl,--out-implib,C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\libqsqlodbc.a -o ..\plugins\sqldrivers\qsqlodbc.dll .obj/release/qsql_odbc.o .obj/release/main.o .obj/release/moc_qsql_odbc_p.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-winx64\lib -LC:\Utils\postgresql\pgsql\lib C:\Programming\5.15.0\mingw81_64\lib\libQt5Sql.a C:\Programming\5.15.0\mingw81_64\lib\libQt5Core.a -lodbc32 .obj\release\qsqlodbc_resource_res.o
            objcopy --only-keep-debug ../plugins/sqldrivers/qsqlodbc.dll ../plugins/sqldrivers/qsqlodbc.dll.debug && objcopy --strip-debug ../plugins/sqldrivers/qsqlodbc.dll && objcopy --add-gnu-debuglink=../plugins/sqldrivers/qsqlodbc.dll.debug ../plugins/sqldrivers/qsqlodbc.dll
            C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\qsqlodbc.dll.debug C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlodbc.dll.debug
            copy /y ..\plugins\sqldrivers\qsqlodbc.dll C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlodbc.dll
            1 file(s) copied.
            C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QODBCDriverPlugin.cmake C:\Programming\5.15.0\mingw81_64\lib\cmake\Qt5Sql\Qt5Sql_QODBCDriverPlugin.cmake
            mingw32-make[2]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc'
            mingw32-make[1]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc'
            cd sqlite\ && ( if not exist Makefile C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -o Makefile C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && mingw32-make -f Makefile install
            mingw32-make[1]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/sqlite'
            C:\Programming\5.15.0\mingw81_32\bin\qmake.exe -o Makefile sqlite.pro
            mingw32-make -f Makefile.Release install
            mingw32-make[2]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/sqlite'
            C:\Programming\5.15.0\mingw81_32\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\qsqlite.dll.debug C:\Programming\5.15.0\mingw81_32\plugins\sqldrivers\qsqlite.dll.debug
            copy /y ..\plugins\sqldrivers\qsqlite.dll C:\Programming\5.15.0\mingw81_32\plugins\sqldrivers\qsqlite.dll
            1 file(s) copied.
            C:\Programming\5.15.0\mingw81_32\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake C:\Programming\5.15.0\mingw81_32\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake
            mingw32-make[2]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/sqlite'
            mingw32-make[1]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/sqlite'

            C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>mingw32-make sub-mysql
            cd mysql\ && ( if not exist Makefile C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -o Makefile C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\mysql\mysql.pro ) && mingw32-make -f Makefile
            mingw32-make[1]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            mingw32-make -f Makefile.Release
            mingw32-make[2]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            mingw32-make[2]: Nothing to be done for 'first'.
            mingw32-make[2]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            mingw32-make[1]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'

            C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers>mingw32-make install
            cd mysql\ && ( if not exist Makefile C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -o Makefile C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\mysql\mysql.pro ) && mingw32-make -f Makefile install
            mingw32-make[1]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            mingw32-make -f Makefile.Release install
            mingw32-make[2]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\qsqlmysql.dll.debug C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlmysql.dll.debug
            copy /y ..\plugins\sqldrivers\qsqlmysql.dll C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlmysql.dll
            1 file(s) copied.
            C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QMYSQLDriverPlugin.cmake C:\Programming\5.15.0\mingw81_64\lib\cmake\Qt5Sql\Qt5Sql_QMYSQLDriverPlugin.cmake
            mingw32-make[2]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            mingw32-make[1]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/mysql'
            cd odbc\ && ( if not exist Makefile C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -o Makefile C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\odbc\odbc.pro ) && mingw32-make -f Makefile install
            mingw32-make[1]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc'
            mingw32-make -f Makefile.Release install
            mingw32-make[2]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc'
            C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\qsqlodbc.dll.debug C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlodbc.dll.debug
            copy /y ..\plugins\sqldrivers\qsqlodbc.dll C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlodbc.dll
            1 file(s) copied.
            C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QODBCDriverPlugin.cmake C:\Programming\5.15.0\mingw81_64\lib\cmake\Qt5Sql\Qt5Sql_QODBCDriverPlugin.cmake
            mingw32-make[2]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc'
            mingw32-make[1]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/odbc'
            cd sqlite\ && ( if not exist Makefile C:\Programming\5.15.0\mingw81_64\bin\qmake.exe -o Makefile C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && mingw32-make -f Makefile install
            mingw32-make[1]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/sqlite'
            mingw32-make -f Makefile.Release install
            mingw32-make[2]: Entering directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/sqlite'
            C:\Programming\5.15.0\mingw81_32\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\qsqlite.dll.debug C:\Programming\5.15.0\mingw81_32\plugins\sqldrivers\qsqlite.dll.debug
            copy /y ..\plugins\sqldrivers\qsqlite.dll C:\Programming\5.15.0\mingw81_32\plugins\sqldrivers\qsqlite.dll
            1 file(s) copied.
            C:\Programming\5.15.0\mingw81_32\bin\qmake.exe -install qinstall C:\Programming\5.15.0\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake C:\Programming\5.15.0\mingw81_32\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake
            mingw32-make[2]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/sqlite'
            mingw32-make[1]: Leaving directory 'C:/Programming/5.15.0/Src/qtbase/src/plugins/sqldrivers/sqlite'

            1 Reply Last reply
            0
            • B Offline
              B Offline
              Bonnie
              wrote on last edited by
              #18

              Your cmd output is quite messy, it has both 32bit and 64bit qmake output.
              But normally if you want to use mysql plugin, you'll need to:

              1. copy libmysql.dll to the Qt bin folder or with your exe.
              2. Have msvc & openssl runtimes installed in your pc. Or use libmysql.dll from some older versions of mysql (referring to my signature).
              3. set QT_DEBUG_PLUGINS environment variable to non-zero to get diagnostic information from the output when running your app.
              C 1 Reply Last reply
              0
              • B Bonnie

                Your cmd output is quite messy, it has both 32bit and 64bit qmake output.
                But normally if you want to use mysql plugin, you'll need to:

                1. copy libmysql.dll to the Qt bin folder or with your exe.
                2. Have msvc & openssl runtimes installed in your pc. Or use libmysql.dll from some older versions of mysql (referring to my signature).
                3. set QT_DEBUG_PLUGINS environment variable to non-zero to get diagnostic information from the output when running your app.
                C Offline
                C Offline
                chihwah
                wrote on last edited by
                #19

                @Bonnie I can see libmysql.dll in the Qt MinGW bin folder.

                I think msvc is installed... I've installed Visual Studio 2019 and it appears as one of the kits in Qt. However, it has a yellow flag beside it because I don't have a compiler specified for it. Don't know about openssl though - I don't think I've installed that previously.

                I set QT_DEBUG_PLUGINS environment to 1 and got some interesting output:
                QFactoryLoader::QFactoryLoader() checking directory path "my_path_to_build_folder/build-Accounting-Desktop_Qt_5_15_0_MinGW_64_bit-Debug/debug/sqldrivers" ...
                Cannot load library C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlmysql.dll: The specified module could not be found.
                QLibraryPrivate::loadPlugin failed on "C:/Programming/5.15.0/mingw81_64/plugins/sqldrivers/qsqlmysql.dll" : "Cannot load library C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlmysql.dll: The specified module could not be found."

                Odd thing is I can see qsqlmysql.dll in the mingw81_64/plugins/sqldrivers folder, so I don't know why it can't find it!

                B 1 Reply Last reply
                0
                • C chihwah

                  @Bonnie I can see libmysql.dll in the Qt MinGW bin folder.

                  I think msvc is installed... I've installed Visual Studio 2019 and it appears as one of the kits in Qt. However, it has a yellow flag beside it because I don't have a compiler specified for it. Don't know about openssl though - I don't think I've installed that previously.

                  I set QT_DEBUG_PLUGINS environment to 1 and got some interesting output:
                  QFactoryLoader::QFactoryLoader() checking directory path "my_path_to_build_folder/build-Accounting-Desktop_Qt_5_15_0_MinGW_64_bit-Debug/debug/sqldrivers" ...
                  Cannot load library C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlmysql.dll: The specified module could not be found.
                  QLibraryPrivate::loadPlugin failed on "C:/Programming/5.15.0/mingw81_64/plugins/sqldrivers/qsqlmysql.dll" : "Cannot load library C:\Programming\5.15.0\mingw81_64\plugins\sqldrivers\qsqlmysql.dll: The specified module could not be found."

                  Odd thing is I can see qsqlmysql.dll in the mingw81_64/plugins/sqldrivers folder, so I don't know why it can't find it!

                  B Offline
                  B Offline
                  Bonnie
                  wrote on last edited by
                  #20

                  @chihwah
                  It probably means the modules it depends on could not be found. :)
                  Actually it needs vs2015 runtimes, I'm not sure if it would be installed with vs2019.
                  You don't need to install the whole visual studio, the redistributable package would be enough.
                  The doc provides a link of vcredist.exe, you can install that. Remember to choose the x64 version.
                  For openssl ones, if you don't have v1.1+ installed to PATH, you can copy libssl-1_1-x64.dll and libcrypto-1_1-x64.dll from MySQL bin folder to let them be with libmysql.dll.
                  The dependencies can be really annoying, so I prefer to use older versions of mysql without those dependencies.

                  C 1 Reply Last reply
                  2
                  • B Bonnie

                    @chihwah
                    It probably means the modules it depends on could not be found. :)
                    Actually it needs vs2015 runtimes, I'm not sure if it would be installed with vs2019.
                    You don't need to install the whole visual studio, the redistributable package would be enough.
                    The doc provides a link of vcredist.exe, you can install that. Remember to choose the x64 version.
                    For openssl ones, if you don't have v1.1+ installed to PATH, you can copy libssl-1_1-x64.dll and libcrypto-1_1-x64.dll from MySQL bin folder to let them be with libmysql.dll.
                    The dependencies can be really annoying, so I prefer to use older versions of mysql without those dependencies.

                    C Offline
                    C Offline
                    chihwah
                    wrote on last edited by
                    #21

                    @Bonnie Success! It was the OpenSSL I was missing I think. Once I copied it over it worked like a charm. :) Thanks heaps for putting up with my ineptitude on this topic!

                    Where can I learn more about how all of this stuff works? I expect I will need to dabble more in this in the future.

                    B 1 Reply Last reply
                    0
                    • C chihwah

                      @Bonnie Success! It was the OpenSSL I was missing I think. Once I copied it over it worked like a charm. :) Thanks heaps for putting up with my ineptitude on this topic!

                      Where can I learn more about how all of this stuff works? I expect I will need to dabble more in this in the future.

                      B Offline
                      B Offline
                      Bonnie
                      wrote on last edited by
                      #22

                      @chihwah
                      Well, I just learned from googling and practicing. I used to have a lot of third-party libraries building work...

                      1 Reply Last reply
                      1

                      • Login

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