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. How to create the plugin of MYSQL for Qt
Forum Updated to NodeBB v4.3 + New Features

How to create the plugin of MYSQL for Qt

Scheduled Pinned Locked Moved General and Desktop
33 Posts 17 Posters 39.7k Views 4 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.
  • A Offline
    A Offline
    arsinte_andrei
    wrote on last edited by
    #12

    Even today Qt doesn't have a MySql proper plugin delivered with? any way.. thanks for this great job... that save me a lot of trouble I wish to do something similar with HeidiSql and this was a good start point.. Thanks again

    1 Reply Last reply
    0
    • B Offline
      B Offline
      BlackStar
      wrote on last edited by
      #13

      You're all welcome :), for the guys who are asking for linux or Os X, but i don't know :(, try to fetch the doc.

      1 Reply Last reply
      1
      • D Offline
        D Offline
        danny36
        wrote on last edited by
        #14

        Hello, I'm new to QT and I have installed QT from this installer on Windows 7 64bit:
        qt-opensource-windows-x86-1.6.0-5-online.exe

        but I don't see the src folder and I don't have a QT Sdk. How can I install the sdk? thanks.

        1 Reply Last reply
        0
        • SGaistS Offline
          SGaistS Offline
          SGaist
          Lifetime Qt Champion
          wrote on last edited by
          #15

          Hi and welcome to devnet,

          You need to first install the sources. Use the installer for that

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

          1 Reply Last reply
          0
          • D Offline
            D Offline
            danny36
            wrote on last edited by
            #16

            OK now I have installed the sources (maybe) and I have a folder called Src, this is my path: C:\Qt\5.3\Src.

            I try to follow the tutorial but in my situation when prompt "reimp libmysql.dll" I receive this message:

            "reimp: libmysql.dll: invalid or corrupt import library"

            but if prompt "reimp libmysql.lib" seems to work.

            1 Reply Last reply
            0
            • D Offline
              D Offline
              danny36
              wrote on last edited by
              #17

              now I'm arrived to step 5 but I think I have some problem, this is the ouput after lunch the command:

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

              Creating qmake...
              mingw32-make: Nothing to be done for 'first'.
              Running configuration tests...
              g++: error: CreateProcess: No such file or directory
              mingw32-make: *** [arch.o] Error 1
              Could not find output file: No such file or directory
              WARNING: The DirectX SDK could not be detected:
              There is no Direct X SDK installed or the environment variable "DXSDK_DIR" is
              not set.
              Disabling the ANGLE backend.

              WARNING: Using OpenGL ES 2.0 without ANGLE.
              Specify -opengl desktop to use Open GL.
              The build will most likely fail.

              1 Reply Last reply
              0
              • SGaistS Offline
                SGaistS Offline
                SGaist
                Lifetime Qt Champion
                wrote on last edited by
                #18

                Either install the Direct X SDK or pass -opengl desktop to configure

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

                1 Reply Last reply
                0
                • D Offline
                  D Offline
                  danny36
                  wrote on last edited by
                  #19

                  I'm sorry and frustrated but
                  but unfortunately for me it is the first time with C++ and QT.
                  I lunch configure:

                  configure.exe -opengl desktop

                  and the result is:

                  g++ -c -o qlibraryinfo.o -DUNICODE -ffunction-sections -g -IC:\Qt\5.3\Src\qtbas
                  e/qmake -IC:\Qt\5.3\Src\qtbase/qmake/library -IC:\Qt\5.3\Src\qtbase/qmake/genera
                  tors -IC:\Qt\5.3\Src\qtbase/qmake/generators/unix -IC:\Qt\5.3\Src\qtbase/qmake/g
                  enerators/win32 -IC:\Qt\5.3\Src\qtbase/qmake/generators/mac -IC:\Qt\5.3\Src\qtba
                  se/qmake/generators/integrity -IC:\Qt\5.3\Src\qtbase\include -IC:\Qt\5.3\Src\qtb
                  ase\include/QtCore -IC:\Qt\5.3\Src\qtbase\include/QtCore/5.3.2 -IC:\Qt\5.3\Src\q
                  tbase\include/QtCore/5.3.2/QtCore -IC:\Qt\5.3\Src\qtbase/src/corelib/global -DHA
                  VE_QCONFIG_CPP -IC:\Qt\5.3\Src\qtbase\mkspecs\win32-g++ -IC:\Qt\5.3\Src\qtbase/t
                  ools/shared -DQT_BUILD_QMAKE -DQT_BOOTSTRAPPED -DPROEVALUATOR_FULL -DQT_NO_TEXTC
                  ODEC -DQT_NO_UNICODETABLES -DQT_NO_COMPONENT -DQT_NO_COMPRESS -DQT_NO_THREAD -DQ
                  T_NO_QOBJECT -DQT_NO_GEOM_VARIANT -DQT_NO_DATASTREAM -DQT_CRYPTOGRAPHICHASH_ONLY
                  SHA1 -DQT_JSON_READONLY C:\Qt\5.3\Src\qtbase/src/corelib/global/qlibraryinfo.cp
                  p
                  g++: error: CreateProcess: No such file or directory
                  Makefile:275: recipe for target 'qlibraryinfo.o' failed
                  mingw32-make: *** [qlibraryinfo.o] Error 1
                  rm -f project.o option.o property.o main.o ioutils.o proitems.o qmakevfs.o qmake
                  globals.o qmakeparser.o qmakeevaluator.o qmakebuiltins.o makefile.o unixmake2.o
                  unixmake.o mingw_make.o winmakefile.o projectgenerator.o meta.o makefiledeps.o m
                  etamakefile.o xmloutput.o pbuilder_pbx.o msvc_vcproj.o msvc_vcxproj.o msvc_nmake
                  .o msvc_objectmodel.o msbuild_objectmodel.o gbuild.o cesdkhandler.o qtextcodec.o
                  qutfcodec.o qstring.o qstring_compat.o qstringbuilder.o qtextstream.o qiodevice
                  .o qmalloc.o qglobal.o qarraydata.o qbytearray.o qbytearraymatcher.o qdatastream
                  .o qbuffer.o qlist.o qfiledevice.o qfile.o qfilesystementry.o qfilesystemengine.
                  o qfsfileengine.o qfsfileengine_iterator.o qregexp.o qvector.o qbitarray.o qdir.
                  o qdiriterator.o quuid.o qhash.o qfileinfo.o qdatetime.o qstringlist.o qabstract
                  fileengine.o qtemporaryfile.o qmap.o qmetatype.o qsettings.o qsystemerror.o qlib
                  raryinfo.o qvariant.o qvsnprintf.o qlocale.o qlocale_tools.o qlinkedlist.o qnume
                  ric.o qcryptographichash.o qxmlstream.o qxmlutils.o qlogging.o qjson.o qjsondocument.o qjsonparser.o qjsonarray.o qjsonobject.o qjsonvalue.o qfilesystemengine_w
                  in.o qfilesystemiterator_win.o qfsfileengine_win.o qlocale_win.o qsettings_win.o
                  qsystemlibrary.o registry.o
                  g++ -c -o project.o -DUNICODE -ffunction-sections -g -IC:\Qt\5.3\Src\qtbase/qma
                  ke -IC:\Qt\5.3\Src\qtbase/qmake/library -IC:\Qt\5.3\Src\qtbase/qmake/generators
                  -IC:\Qt\5.3\Src\qtbase/qmake/generators/unix -IC:\Qt\5.3\Src\qtbase/qmake/genera
                  tors/win32 -IC:\Qt\5.3\Src\qtbase/qmake/generators/mac -IC:\Qt\5.3\Src\qtbase/qm
                  ake/generators/integrity -IC:\Qt\5.3\Src\qtbase\include -IC:\Qt\5.3\Src\qtbase\i
                  nclude/QtCore -IC:\Qt\5.3\Src\qtbase\include/QtCore/5.3.2 -IC:\Qt\5.3\Src\qtbase
                  \include/QtCore/5.3.2/QtCore -IC:\Qt\5.3\Src\qtbase/src/corelib/global -DHAVE_QC
                  ONFIG_CPP -IC:\Qt\5.3\Src\qtbase\mkspecs\win32-g++ -IC:\Qt\5.3\Src\qtbase/tools/
                  shared -DQT_BUILD_QMAKE -DQT_BOOTSTRAPPED -DPROEVALUATOR_FULL -DQT_NO_TEXTCODEC
                  -DQT_NO_UNICODETABLES -DQT_NO_COMPONENT -DQT_NO_COMPRESS -DQT_NO_THREAD -DQT_NO

                  QOBJECT -DQT_NO_GEOM_VARIANT -DQT_NO_DATASTREAM -DQT_CRYPTOGRAPHICHASH_ONLY_SHA1
                  -DQT_JSON_READONLY C:\Qt\5.3\Src\qtbase/qmake/project.cpp
                  g++: error: CreateProcess:* No such file or directory*
                  Makefile:196: recipe for target 'project.o' failed
                  mingw32-make: *** [project.o] Error 1
                  Building qmake failed, return code 2

                  1 Reply Last reply
                  1
                  • SGaistS Offline
                    SGaistS Offline
                    SGaist
                    Lifetime Qt Champion
                    wrote on last edited by
                    #20

                    Just one question, do you only need to build the MySQL plugin ? If so, there's no need to rebuild Qt completely

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

                    1 Reply Last reply
                    0
                    • D Offline
                      D Offline
                      danny36
                      wrote on last edited by
                      #21

                      This is the first time for me with C++ and QT so for me it's all new and I do not know what are the requirements needed to achieve my goal.
                      I want to make a windows application that keep some signal from a RFID antenna attached to notebook from serial and store data in a mysql database.
                      To start I want only to connect to mysql database and read a table data.

                      So I guess I need only mysql plugin.

                      1 Reply Last reply
                      0
                      • SGaistS Offline
                        SGaistS Offline
                        SGaist
                        Lifetime Qt Champion
                        wrote on last edited by
                        #22

                        Then just compile the MySQL plugin like described in the documentation, no need to rebuild everything.

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

                        1 Reply Last reply
                        0
                        • K Offline
                          K Offline
                          kambokdol
                          wrote on last edited by
                          #23

                          @
                          case "re":
                          include("$folderPath_php/write.php");
                          break;
                          case "re_ok":
                          include("$folderPath_php/write_ok.php");
                          break;
                          case "del":
                          include("$folderPath_php/del_ok.php");
                          break;
                          case "all_del_ok":
                          include("$folderPath_php/all_del_ok.php");
                          break;
                          case "all_move_ok":
                          include("$folderPath_php/all_move_ok.php");
                          break;
                          default:
                          include("$folderPath_php/list.php");
                          break;
                          @

                          1 Reply Last reply
                          -1
                          • SGaistS Offline
                            SGaistS Offline
                            SGaist
                            Lifetime Qt Champion
                            wrote on last edited by
                            #24

                            What does that message have to do with the current question ?

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

                            1 Reply Last reply
                            0
                            • M Offline
                              M Offline
                              masum
                              wrote on last edited by
                              #25

                              what about other platform?

                              Kind Regards

                              Md. Rashidul Hasan
                              Software Architect
                              OnnoRokom Software Ltd.
                              Cell: 8801836885252

                              1 Reply Last reply
                              -1
                              • SGaistS Offline
                                SGaistS Offline
                                SGaist
                                Lifetime Qt Champion
                                wrote on last edited by
                                #26

                                Can you be more specific ?

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

                                1 Reply Last reply
                                0
                                • D Offline
                                  D Offline
                                  danny36
                                  wrote on last edited by
                                  #27

                                  Hi all,

                                  after trying to build mysql plugin now I cannot to compile a simple hello world project, the error is:

                                  g++: error: CreateProcess: No such file or directory

                                  this is my debugger output:

                                  @11:46:35: Running steps for project CEV-Crono...
                                  11:46:35: Configuration unchanged, skipping qmake step.
                                  11:46:35: Starting: "C:\Qt\5.3\mingw482_32\bin\mingw32-make.exe"
                                  C:/Qt/5.3/mingw482_32/bin/mingw32-make -f Makefile.Debug
                                  mingw32-make[1]: Entering directory 'F:/WORKSPACE/CPP/build-CEV-Crono-Desktop_Qt_5_3_MinGW_32bit-Debug'
                                  g++ -c -pipe -fno-keep-inline-dllexport -g -frtti -Wall -Wextra -fexceptions -mthreads -DUNICODE -DQT_WIDGETS_LIB -DQT_GUI_LIB -DQT_CORE_LIB -DQT_NEEDS_QMAIN -I..\CEV-Crono -I"C:\Qt\5.3\mingw482_32\include" -I"C:\Qt\5.3\mingw482_32\include\QtWidgets" -I"C:\Qt\5.3\mingw482_32\include\QtGui" -I"C:\Qt\5.3\mingw482_32\include\QtCore" -I"debug" -I"." -I"." -I"C:\Qt\5.3\mingw482_32\mkspecs\win32-g++" -o debug\main.o ..\CEV-Crono\main.cpp
                                  g++: error: CreateProcess: No such file or directory
                                  Makefile.Debug:341: recipe for target 'debug/main.o' failed
                                  mingw32-make[1]: *** [debug/main.o] Error 1
                                  mingw32-make[1]: Leaving directory 'F:/WORKSPACE/CPP/build-CEV-Crono-Desktop_Qt_5_3_MinGW_32bit-Debug'
                                  Makefile:34: recipe for target 'debug' failed
                                  mingw32-make: *** [debug] Error 2
                                  11:46:35: The process "C:\Qt\5.3\mingw482_32\bin\mingw32-make.exe" exited with code 2.
                                  Error while building/deploying project CEV-Crono (kit: Desktop Qt 5.3 MinGW 32bit)
                                  When executing step "Make"
                                  11:46:35: Elapsed time: 00:01.@

                                  1 Reply Last reply
                                  0
                                  • R Offline
                                    R Offline
                                    root0x
                                    wrote on last edited by
                                    #28

                                    That would of been useful about 2 months ago, but thanks for posting it

                                    1 Reply Last reply
                                    0
                                    • B Offline
                                      B Offline
                                      BlackStar
                                      wrote on last edited by
                                      #29

                                      I m sorry for not being able to reply ^^ cause i ve moved to the web development world for a moment, thus i have forgotten about this post! anyway the instructions i did were for Windows, but i never tried the other platforms tough :/ sorry! @massum, and a big thanks to @SGaist ^^

                                      1 Reply Last reply
                                      0
                                      • SGaistS Offline
                                        SGaistS Offline
                                        SGaist
                                        Lifetime Qt Champion
                                        wrote on last edited by
                                        #30

                                        Each platform has it's own gotchas but the *nix variants are generally more easy to deal with when it comes to dependencies like MySQL

                                        You're welcome :)

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

                                        1 Reply Last reply
                                        0
                                        • S Offline
                                          S Offline
                                          sujit25
                                          wrote on last edited by
                                          #31

                                          Hello EveryOne,
                                          I am a beginner to qt and unable to build a mysql driver. I'am stuck at step4 of above given steps.
                                          reimp -d libmysql.dll ,gives me error
                                          "reimp: libmysql.dll: invalid or corrupt import library"

                                          iam also unable to
                                          reimp libmysql.lib, gives me error
                                          "reimp: libmysql.lib: invalid or corrupt import library"

                                          reimp.exe is available from mingw-utils-0.3, but i am totally frustrated now due to failure occured multiple times.
                                          I need help urgently, since project deadline is near. Will anyone please upload libqsqlmysql.a and qsqlmysql.dll on any ftp site or mail me these as an attachment. i followed all the given steps, but failed to compile.
                                          my mail id is: technosujit25@gmail.com
                                          plz guys,help me!!!!!
                                          I seriously need ur help in order to complete this project.

                                          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