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. [SOLVED] Qt MySQL plugin - installing plugin does not work
Forum Updated to NodeBB v4.3 + New Features

[SOLVED] Qt MySQL plugin - installing plugin does not work

Scheduled Pinned Locked Moved General and Desktop
17 Posts 6 Posters 9.5k Views 1 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.
  • P Offline
    P Offline
    Peppy
    wrote on last edited by
    #1

    Hello guys, I have an issue of installing MySQL plugin - debugger says that the mysql plugin is available (installed into plugins directory, refreshed cache, added into project's sqldrivers subdirectory) but somehow it can't be loaded (Unable to load QMYSQL)...

    Is there any way to specify why? Probably I have mixed platforms...

    !http://img163.imageshack.us/img163/9200/qtmysqlplugin.png(Qt plugin is not loaded but present)!

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

      Hi,

      Do you have the mysql binaries available in your PATH ?

      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
      • Q Offline
        Q Offline
        qxoz
        wrote on last edited by
        #3

        Try put libmysql.dll into same folder with *.exe

        1 Reply Last reply
        0
        • P Offline
          P Offline
          Peppy
          wrote on last edited by
          #4

          @qxoz: Nope, nothing has changed.
          @SGaist: Nope, I don't. Nothing has changed when I did so.

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

            Try to update the PATH of you run environment so that it also points to the folder where the mysql dlls are

            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
            • P Offline
              P Offline
              Peppy
              wrote on last edited by
              #6

              Nothing, buddy. It did not worked for me...

              1 Reply Last reply
              0
              • M Offline
                M Offline
                mbnoimi
                wrote on last edited by
                #7

                I faced this issue before. try to fix it as following:

                • put libmysql.dll in your application path (not in your project path in case you configured run from shadow build path)
                • put SQLDrivers folder in your application's path
                1 Reply Last reply
                0
                • P Offline
                  P Offline
                  Peppy
                  wrote on last edited by
                  #8

                  @mbnoimi: Yea man, that's it!

                  [quote author="mbnoimi" date="1366202366"]I faced this issue before. try to fix it as following:

                  • put libmysql.dll in your application path (not in your project path in case you configured run from shadow build path)
                  • put SQLDrivers folder in your application's path[/quote]

                  Solved.

                  1 Reply Last reply
                  0
                  • D Offline
                    D Offline
                    dan82
                    wrote on last edited by
                    #9

                    Hello, guys!
                    I have same problem with my Ubuntu 12.04

                    "QSqlDatabase: QMYSQL driver not loaded
                    QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
                    can't conect to database server. QSqlError(-1, "Driver not loaded", "Driver not loaded") "

                    In foldel pluguns/sqldriver have library: libqsqlmysql.so

                    How and where i can fix this problem?

                    1 Reply Last reply
                    0
                    • R Offline
                      R Offline
                      Romaniy
                      wrote on last edited by
                      #10

                      bq. Hello, guys!
                      I have same problem with my Ubuntu 12.04
                      “QSqlDatabase: QMYSQL driver not loaded
                      QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
                      can’t conect to database server. QSqlError(-1, “Driver not loaded”, “Driver not loaded”) “
                      In foldel pluguns/sqldriver have library: libqsqlmysql.so
                      How and where i can fix this problem?

                      Hello,

                      look in my topic(the same problem, but I try to fix OCI driver)
                      "Your text to link here...":http://qt-project.org/forums/viewthread/33398/

                      Hope, something help you.

                      1 Reply Last reply
                      0
                      • M Offline
                        M Offline
                        mbnoimi
                        wrote on last edited by
                        #11

                        [quote author="dan82" date="1381235196"]Hello, guys!
                        I have same problem with my Ubuntu 12.04

                        "QSqlDatabase: QMYSQL driver not loaded
                        QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
                        can't conect to database server. QSqlError(-1, "Driver not loaded", "Driver not loaded") "

                        In foldel pluguns/sqldriver have library: libqsqlmysql.so

                        How and where i can fix this problem?
                        [/quote]

                        Try to install the following:
                        [code]
                        sudo apt-get install libqt4-sql-mysql libqt5sql5-mysql
                        [/code]

                        1 Reply Last reply
                        0
                        • D Offline
                          D Offline
                          dan82
                          wrote on last edited by
                          #12

                          I am install libqt4-sql-mysql alredy.
                          When i try run sudo apt-get install libqt4-sql-mysql libqt5sql5-mysql
                          see
                          sudo apt-get install libqt5sql5-mysql
                          Reading package lists... Done
                          Building dependency tree
                          Reading state information... Done
                          E: Unable to locate package libqt5sql5-mysql

                          Google have't answer, how install libqt5sql5-mysql for Ubuntu 12.04
                          Do you have some idea?

                          1 Reply Last reply
                          0
                          • M Offline
                            M Offline
                            mbnoimi
                            wrote on last edited by
                            #13

                            [quote author="dan82" date="1381251183"]
                            Google have't answer, how install libqt5sql5-mysql for Ubuntu 12.04
                            Do you have some idea?[/quote]

                            Sorry my mistake, I forgot you use 12.04 (I'm using 13.04) just call:
                            [code]sudo apt-get install libqt4-sql-mysql[/code]

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

                              Yes, cap! I was install libqt4-sql-mysql alredy.
                              Not work...
                              Find at internet this:
                              ldd libqsqlmysql.so

                              linux-gate.so.1 => (0xb77b6000)
                              libmysqlclient_r.so.16 => not found
                              libQt5Sql.so.5 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libQt5Sql.so.5 (0xb774a000)
                              libQt5Core.so.5 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libQt5Core.so.5 (0xb72c6000)
                              libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 (0xb71dd000)
                              libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7033000)
                              libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb7018000)
                              libicui18n.so.51 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libicui18n.so.51 (0xb6df6000)
                              libicuuc.so.51 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libicuuc.so.51 (0xb6c7c000)
                              libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb6c77000)
                              libgthread-2.0.so.0 => /usr/lib/i386-linux-gnu/libgthread-2.0.so.0 (0xb6c74000)
                              librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb6c6b000)
                              libglib-2.0.so.0 => /lib/i386-linux-gnu/libglib-2.0.so.0 (0xb6b6f000)
                              libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb6b42000)
                              libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb6b24000)
                              /lib/ld-linux.so.2 (0xb77b7000)
                              libicudata.so.51 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libicudata.so.51 (0xb55db000)
                              libpcre.so.3 => /lib/i386-linux-gnu/libpcre.so.3 (0xb559b000)

                              For normaly work need libmysqlclient_r.so.16 - but what need to do - i don't knot...

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

                                IIRC, you need to also install libmysqlclient-dev

                                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
                                  dan82
                                  wrote on last edited by
                                  #16

                                  I was installed libmysqlclient-dev - nosing change, application not work. same error

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

                                    So, i was upgrade Ubuntu 12.04 to 13.04
                                    reinstall libqt4-sql-mysql libqt5sql5-mysql libs and all works.
                                    Thks for help!
                                    Solved.

                                    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