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 40.4k 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.
  • 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