Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. Installation and Deployment
  4. MariaDB plugin
Forum Updated to NodeBB v4.3 + New Features

MariaDB plugin

Scheduled Pinned Locked Moved Solved Installation and Deployment
17 Posts 4 Posters 1.3k 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.
  • S Offline
    S Offline
    Stefanoxjx
    wrote on last edited by
    #3

    Hi and thanks for answer.
    With qtenv2.bat the situation has improved.
    The parameter "-libmariadb" gave an errore and I had to delete it.
    Moreover the procedure asked me to compile with mingw32 and not 64. Is normal?

    I would like to ask if you can tell me wich is the advantage to use Qt driver instead ODBC (sure more simple and rapid to configure).

    Thanks.

    P.S. The PC is still compiling the driver, I hope everything goes well until the end.

    1 Reply Last reply
    0
    • S Offline
      S Offline
      Stefanoxjx
      wrote on last edited by
      #4

      Compilation error :(

      In file included from qwindowsintegration.cpp:85:
      qwindowseglcontext.h:45:10: fatal error: EGL/egl.h: No such file or directory
       #include <EGL/egl.h>
                ^~~~~~~~~~~
      compilation terminated.
      mingw32-make[5]: *** [Makefile.Release:3296: .obj/release/qwindowsintegration.o] Error 1
      mingw32-make[5]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/platforms/windows'
      mingw32-make[4]: *** [Makefile:45: release] Error 2
      mingw32-make[4]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/platforms/windows'
      mingw32-make[3]: *** [Makefile:103: sub-windows-make_first] Error 2
      mingw32-make[3]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/platforms'
      mingw32-make[2]: *** [Makefile:108: sub-platforms-make_first] Error 2
      mingw32-make[2]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src/plugins'
      mingw32-make[1]: *** [Makefile:834: sub-plugins-make_first] Error 2
      mingw32-make[1]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src'
      mingw32-make: *** [Makefile:54: sub-src-make_first] Error 2
      

      I try to install "DirectX SDK" (https://bugreports.qt.io/browse/QTBUG-65602) but have an error during installation, prerhaps I use a virtual machine !?

      Christian EhrlicherC 1 Reply Last reply
      0
      • mrjjM Offline
        mrjjM Offline
        mrjj
        Lifetime Qt Champion
        wrote on last edited by
        #5

        @Stefanoxjx said in MariaDB plugin:

        I would like to ask if you can tell me wich is the advantage to use Qt driver instead ODBC

        From a programming perspective, there will be no different but it could be faster than ODBC, and might offer integration/features not available via ODBC but its not certain.

        Sorry about the compile error. I have never set it complains about
        EGL/egl.h: bulding the sql plugins. really strange. I have no idea why.

        1 Reply Last reply
        1
        • S Stefanoxjx

          Compilation error :(

          In file included from qwindowsintegration.cpp:85:
          qwindowseglcontext.h:45:10: fatal error: EGL/egl.h: No such file or directory
           #include <EGL/egl.h>
                    ^~~~~~~~~~~
          compilation terminated.
          mingw32-make[5]: *** [Makefile.Release:3296: .obj/release/qwindowsintegration.o] Error 1
          mingw32-make[5]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/platforms/windows'
          mingw32-make[4]: *** [Makefile:45: release] Error 2
          mingw32-make[4]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/platforms/windows'
          mingw32-make[3]: *** [Makefile:103: sub-windows-make_first] Error 2
          mingw32-make[3]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/platforms'
          mingw32-make[2]: *** [Makefile:108: sub-platforms-make_first] Error 2
          mingw32-make[2]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src/plugins'
          mingw32-make[1]: *** [Makefile:834: sub-plugins-make_first] Error 2
          mingw32-make[1]: Leaving directory 'C:/Users/Stefano/Programmi/Qt/5.15.0/Src/qtbase/src'
          mingw32-make: *** [Makefile:54: sub-src-make_first] Error 2
          

          I try to install "DirectX SDK" (https://bugreports.qt.io/browse/QTBUG-65602) but have an error during installation, prerhaps I use a virtual machine !?

          Christian EhrlicherC Offline
          Christian EhrlicherC Offline
          Christian Ehrlicher
          Lifetime Qt Champion
          wrote on last edited by
          #6

          @Stefanoxjx said in MariaDB plugin:

          In file included from qwindowsintegration.cpp:85:
          qwindowseglcontext.h:45:10: fatal error: EGL/egl.h: No such file or directory
          #include <EGL/egl.h>

          You don't have to compile the complete qt - please follow the instructions on how to build the driver, in a clean source dir.

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

          mrjjM 1 Reply Last reply
          3
          • Christian EhrlicherC Christian Ehrlicher

            @Stefanoxjx said in MariaDB plugin:

            In file included from qwindowsintegration.cpp:85:
            qwindowseglcontext.h:45:10: fatal error: EGL/egl.h: No such file or directory
            #include <EGL/egl.h>

            You don't have to compile the complete qt - please follow the instructions on how to build the driver, in a clean source dir.

            mrjjM Offline
            mrjjM Offline
            mrjj
            Lifetime Qt Champion
            wrote on last edited by
            #7

            @Christian-Ehrlicher
            But in the first post it clearly looks like he is only building plugin ?

            Christian EhrlicherC 1 Reply Last reply
            1
            • mrjjM mrjj

              @Christian-Ehrlicher
              But in the first post it clearly looks like he is only building plugin ?

              Christian EhrlicherC Offline
              Christian EhrlicherC Offline
              Christian Ehrlicher
              Lifetime Qt Champion
              wrote on last edited by
              #8

              @mrjj but not on the second - at least make / mingw32-make was run in the wrong directory

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

              1 Reply Last reply
              1
              • S Offline
                S Offline
                Stefanoxjx
                wrote on last edited by Stefanoxjx
                #9

                Hi, I'm returned :D
                I'm still trying to make mariadb driver, but I've a problem (as usual :( )
                This are my steps:

                • I moved to directory: \Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers
                • I run command: \Qt\5.15.0\mingw81_64\bin\qmake -- MYSQL_INCDIR="C:/Program Files/MariaDB 10.5/include" MYSQL_LIBDIR="C:/Program Files/MariaDB 10.5/lib"
                  but I've this result:
                Running configuration tests...
                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 '\Qt\5.15.0\mingw81_64'.
                
                Prior to reconfiguration, make sure you remove any leftovers from
                the previous build.
                

                Why MySql is = no?
                What am I missing, and why tell to run mingw32-make and not 64?
                Thanks for help.

                1 Reply Last reply
                0
                • Christian EhrlicherC Offline
                  Christian EhrlicherC Offline
                  Christian Ehrlicher
                  Lifetime Qt Champion
                  wrote on last edited by
                  #10

                  @Stefanoxjx said in MariaDB plugin:

                  Why MySql is = no?

                  As stated in the docs - take a look in the config.log and see why it does not find mysql libs in the directories you passed to qmake

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

                  1 Reply Last reply
                  1
                  • S Offline
                    S Offline
                    Stefanoxjx
                    wrote on last edited by
                    #11

                    Hi Christian and thanks for your help.
                    To be honest, I don't find the documentation very clear.
                    Probably because I don't very well English.

                    This is Config.log:

                    Command line: "MYSQL_INCDIR=C:/Program Files/MariaDB 10.5/include" "MYSQL_LIBDIR=C:/Program Files/MariaDB 10.5/lib" "MYSQL_LIBS=-llibmariadb"
                    Global lib dirs: [C:\\openssl\\lib C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib] [D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0 D:/Programmi/Qt/Tools/mingw810_32/lib/gcc D:/Programmi/Qt/Tools/mingw810_32/i686-w64-mingw32/lib D:/Programmi/Qt/Tools/mingw810_32/lib]
                    Global inc dirs: [C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include] [D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++ D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/i686-w64-mingw32 D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/backward D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include-fixed D:/Programmi/Qt/Tools/mingw810_32/i686-w64-mingw32/include]
                    loaded result for library config.sqldrivers.libraries.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
                    loaded result for library config.sqldrivers.libraries.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
                    loaded result for library config.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 ...
                    + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && D:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"-LC:\\Program Files\\MariaDB\\MariaDB Connector C 64-bit/lib\" -llibmariadb" "QMAKE_INCDIR_MYSQL = \"C:\\Program Files\\MariaDB\\MariaDB Connector C 64-bit/include\"" D:/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
                    > Info: creating stash file D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\.qmake.stash
                    + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& mingw32-make
                    > 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-winx64\include -IC:\Utils\postgresql\pgsql\include -I"C:\Program Files\MariaDB\MariaDB Connector C 64-bit\include" -ID:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\lib -LC:\Utils\postgresql\pgsql\lib -L"C:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib" -llibmariadb   
                    > 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 6 (type inline) of library mysql ...
                    + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && D:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"-LC:\\Program Files\\MariaDB\\MariaDB Connector C 64-bit/lib\" -llibmysql" "QMAKE_INCDIR_MYSQL = \"C:\\Program Files\\MariaDB\\MariaDB Connector C 64-bit/include\"" D:/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
                    + cd /d D:\Programmi\Qt\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-winx64\include -IC:\Utils\postgresql\pgsql\include -I"C:\Program Files\MariaDB\MariaDB Connector C 64-bit\include" -ID:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\lib -LC:\Utils\postgresql\pgsql\lib -L"C:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib" -llibmysql   
                    > D:/Programmi/Qt/Tools/mingw810_32/bin/../lib/gcc/i686-w64-mingw32/8.1.0/../../../../i686-w64-mingw32/bin/ld.exe: cannot find -llibmysql
                    > 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
                    loaded result for library config.sqldrivers.libraries.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
                    loaded result for library config.sqldrivers.libraries.odbc
                    Trying source 0 (type inline) of library odbc ...
                    + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && D:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = -lodbc32" D:/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
                    + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& mingw32-make
                    > 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-winx64\include -IC:\Utils\postgresql\pgsql\include -ID:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\lib -LC:\Utils\postgresql\pgsql\lib -lodbc32   
                     => source accepted.
                    test config.sqldrivers.libraries.odbc succeeded
                    loaded result for library config.sqldrivers.libraries.psql
                    Trying source 0 (type pkgConfig) of library psql ...
                    pkg-config use disabled globally.
                      => source produced no result.
                    Trying source 1 (type psqlConfig) of library psql ...
                    pg_config not found.
                      => source produced no result.
                    Trying source 2 (type psqlEnv) of library psql ...
                    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
                    loaded result for library config.sqldrivers.libraries.sqlite2
                    Trying source 0 (type inline) of library sqlite2 ...
                    sqlite.h not found in [] and global paths.
                      => source produced no result.
                    test config.sqldrivers.libraries.sqlite2 FAILED
                    loaded result for library config.sqldrivers.libraries.tds
                    Trying source 0 (type sybaseEnv) of library tds ...
                    + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && D:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += tds" "QMAKE_LIBS_TDS = -lNTWDBLIB" D:/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
                    + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && set MAKEFLAGS=& mingw32-make
                    > 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-winx64\include -IC:\Utils\postgresql\pgsql\include -ID:\Programmi\Qt\5.15.0\mingw81_64\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:498: 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 tried to follow the steps in this discussion: https://forum.qt.io/topic/90065/how-to-create-the-plugin-of-mariadb-for-qt5/19

                    But when SGaist ask to compile into mysql folder, I've a different error:

                    Project ERROR: Library 'mysql' is not defined.
                    
                    JKSHJ 1 Reply Last reply
                    0
                    • JKSHJ Offline
                      JKSHJ Offline
                      JKSH
                      Moderators
                      wrote on last edited by
                      #12

                      Hi @Stefanoxjx, I'm seeing several different paths in your posts:

                      • C:\Program Files\MariaDB\MariaDB Connector C 64-bit\include
                      • C:\Program Files\MariaDB 10.5\include
                      • C:\Utils\my_sql\mysql-5.7.25-winx64\include

                      Please double-check where you've installed MySQL or MariaDB. Where is mysql.h? Where is libmysql.lib or libmariadb.lib?

                      Qt Doc Search for browsers: forum.qt.io/topic/35616/web-browser-extension-for-improved-doc-searches

                      1 Reply Last reply
                      1
                      • S Offline
                        S Offline
                        Stefanoxjx
                        wrote on last edited by
                        #13

                        Hi, you see different paths because initially I had MariaDB connector installed too.
                        Now MariaDB connector is unistalled.
                        Answering your questions:
                        MariaDB is installed to: C:\Program Files\MariaDB 10.5
                        mysql.h is to: C:\Program Files\MariaDB 10.5\include\mysql
                        libmariadb.lib is to: C:\Program Files\MariaDB 10.5\lib

                        Now, I recheck paths and execute these steps:

                        set path=%path%;C:\Program Files\MariaDB 10.5\lib;C:\Program Files\MariaDB 10.5\include;C:\Program Files\MariaDB 10.5\include\mysql;D:\Programmi\Qt\5.15.0\mingw81_64\bin
                        
                        cd D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\mysql
                        
                        qmake -- MYSQL_INCDIR="C:/Program Files/MariaDB 10.5/include/;C:/Program Files/MariaDB 10.5/include/Mysql" MYSQL_LIBDIR="C:/Program Files/MariaDB 10.5/lib" MYSQL_LIBS="-llibmariadb"
                        

                        and result is the same: MYSQL = NO

                        1 Reply Last reply
                        -1
                        • Christian EhrlicherC Offline
                          Christian EhrlicherC Offline
                          Christian Ehrlicher
                          Lifetime Qt Champion
                          wrote on last edited by
                          #14

                          @Stefanoxjx said in MariaDB plugin:

                          and result is the same: MYSQL = NO

                          And again you did not look into the config.log to see where the error is... I'm giving up.

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

                          1 Reply Last reply
                          0
                          • S Offline
                            S Offline
                            Stefanoxjx
                            wrote on last edited by Stefanoxjx
                            #15

                            @Christian-Ehrlicher said in MariaDB plugin:

                            And again you did not look into the config.log to see where the error is.

                            No Christian, I'm watched config.log, but is the same already posted:

                            loaded result for library config.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
                            • S Stefanoxjx

                              Hi Christian and thanks for your help.
                              To be honest, I don't find the documentation very clear.
                              Probably because I don't very well English.

                              This is Config.log:

                              Command line: "MYSQL_INCDIR=C:/Program Files/MariaDB 10.5/include" "MYSQL_LIBDIR=C:/Program Files/MariaDB 10.5/lib" "MYSQL_LIBS=-llibmariadb"
                              Global lib dirs: [C:\\openssl\\lib C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib] [D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0 D:/Programmi/Qt/Tools/mingw810_32/lib/gcc D:/Programmi/Qt/Tools/mingw810_32/i686-w64-mingw32/lib D:/Programmi/Qt/Tools/mingw810_32/lib]
                              Global inc dirs: [C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include] [D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++ D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/i686-w64-mingw32 D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include/c++/backward D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include D:/Programmi/Qt/Tools/mingw810_32/lib/gcc/i686-w64-mingw32/8.1.0/include-fixed D:/Programmi/Qt/Tools/mingw810_32/i686-w64-mingw32/include]
                              loaded result for library config.sqldrivers.libraries.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
                              loaded result for library config.sqldrivers.libraries.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
                              loaded result for library config.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 ...
                              + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && D:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"-LC:\\Program Files\\MariaDB\\MariaDB Connector C 64-bit/lib\" -llibmariadb" "QMAKE_INCDIR_MYSQL = \"C:\\Program Files\\MariaDB\\MariaDB Connector C 64-bit/include\"" D:/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
                              > Info: creating stash file D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\.qmake.stash
                              + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& mingw32-make
                              > 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-winx64\include -IC:\Utils\postgresql\pgsql\include -I"C:\Program Files\MariaDB\MariaDB Connector C 64-bit\include" -ID:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\lib -LC:\Utils\postgresql\pgsql\lib -L"C:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib" -llibmariadb   
                              > 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 6 (type inline) of library mysql ...
                              + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && D:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"-LC:\\Program Files\\MariaDB\\MariaDB Connector C 64-bit/lib\" -llibmysql" "QMAKE_INCDIR_MYSQL = \"C:\\Program Files\\MariaDB\\MariaDB Connector C 64-bit/include\"" D:/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
                              + cd /d D:\Programmi\Qt\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-winx64\include -IC:\Utils\postgresql\pgsql\include -I"C:\Program Files\MariaDB\MariaDB Connector C 64-bit\include" -ID:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\lib -LC:\Utils\postgresql\pgsql\lib -L"C:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib" -llibmysql   
                              > D:/Programmi/Qt/Tools/mingw810_32/bin/../lib/gcc/i686-w64-mingw32/8.1.0/../../../../i686-w64-mingw32/bin/ld.exe: cannot find -llibmysql
                              > 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
                              loaded result for library config.sqldrivers.libraries.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
                              loaded result for library config.sqldrivers.libraries.odbc
                              Trying source 0 (type inline) of library odbc ...
                              + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && D:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = -lodbc32" D:/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
                              + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& mingw32-make
                              > 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-winx64\include -IC:\Utils\postgresql\pgsql\include -ID:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\lib -LC:\Utils\postgresql\pgsql\lib -lodbc32   
                               => source accepted.
                              test config.sqldrivers.libraries.odbc succeeded
                              loaded result for library config.sqldrivers.libraries.psql
                              Trying source 0 (type pkgConfig) of library psql ...
                              pkg-config use disabled globally.
                                => source produced no result.
                              Trying source 1 (type psqlConfig) of library psql ...
                              pg_config not found.
                                => source produced no result.
                              Trying source 2 (type psqlEnv) of library psql ...
                              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
                              loaded result for library config.sqldrivers.libraries.sqlite2
                              Trying source 0 (type inline) of library sqlite2 ...
                              sqlite.h not found in [] and global paths.
                                => source produced no result.
                              test config.sqldrivers.libraries.sqlite2 FAILED
                              loaded result for library config.sqldrivers.libraries.tds
                              Trying source 0 (type sybaseEnv) of library tds ...
                              + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && D:\Programmi\Qt\5.15.0\mingw81_64\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-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.7.25-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += tds" "QMAKE_LIBS_TDS = -lNTWDBLIB" D:/Programmi/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
                              + cd /d D:\Programmi\Qt\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && set MAKEFLAGS=& mingw32-make
                              > 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-winx64\include -IC:\Utils\postgresql\pgsql\include -ID:\Programmi\Qt\5.15.0\mingw81_64\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:498: 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 tried to follow the steps in this discussion: https://forum.qt.io/topic/90065/how-to-create-the-plugin-of-mariadb-for-qt5/19

                              But when SGaist ask to compile into mysql folder, I've a different error:

                              Project ERROR: Library 'mysql' is not defined.
                              
                              JKSHJ Offline
                              JKSHJ Offline
                              JKSH
                              Moderators
                              wrote on last edited by
                              #16

                              @Stefanoxjx said in MariaDB plugin:

                              Command line: "MYSQL_INCDIR=C:/Program Files/MariaDB 10.5/include" "MYSQL_LIBDIR=C:/Program Files/MariaDB 10.5/lib" "MYSQL_LIBS=-llibmariadb"

                              Well, your mysql.h is not found in C:\Program Files\MariaDB 10.5\include so that's why it failed here.

                              @Stefanoxjx said in MariaDB plugin:

                              No Christian, I'm watched config.log, but is the same already posted:

                              If you pass different command line arguments to qmake, then the config.log will definitely contain different text.

                              (Also, remember to delete all the output files before you call qmake again)

                              loaded result for library config.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 ...
                              

                              Post the whole log, not just that small part.

                              Qt Doc Search for browsers: forum.qt.io/topic/35616/web-browser-extension-for-improved-doc-searches

                              1 Reply Last reply
                              2
                              • S Offline
                                S Offline
                                Stefanoxjx
                                wrote on last edited by
                                #17

                                Hi JKSH, I've solved now.
                                I tried to build the plugin from another PC and it worked right away.
                                The slashes instead of back slashes in MariaDB path was childs of various desperate tests.

                                Thanks at all for help.

                                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