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
QtWS25 Last Chance

How to create the plugin of MYSQL for Qt

Scheduled Pinned Locked Moved General and Desktop
33 Posts 17 Posters 38.8k 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.
  • S Offline
    S Offline
    Suraj Golliwar
    wrote on last edited by
    #7

    This is Awesome....Great Job..BlackStar.

    1 Reply Last reply
    1
    • B Offline
      B Offline
      bhupathyap
      wrote on last edited by
      #8

      How to create on for linux (ubuntu)? Pls Help......

      1 Reply Last reply
      0
      • E Offline
        E Offline
        euclidQt
        wrote on last edited by
        #9

        Does that work for OS X 10.9

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

          Hi both,

          Like written in the post, these instructions are for Windows. Linux and OS X are far less problematic. On OS X install mysql through e.g. macports with sudo port install mysql56 and on Linux, install the mysql dev packages.

          For the rest just follow Qt's Sql Driver documentation

          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
          4
          • K Offline
            K Offline
            kshots
            wrote on last edited by
            #11

            I recently ran into an issue with mysql (mariadb) in a linux environment - apparently, the 5.3.1 release ties to an older version of mysql that my system no longer supports (apparently, qt-5.3.1-release wants version .16, while my system uses .18). If you have this problem, an ldd of /path/to/qt5/plugins/sqldrivers/libqsqlmysql.so should show that it can't find your mysql libs. To fix this, go into the source directory at qtbase/src/plugins/sqldrivers/mysql, run qmake (specifically for 5.3.1, not the system qmake), and then make install.

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

                                          • Login

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