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. QMYSQL : Driver not loaded
Forum Updated to NodeBB v4.3 + New Features

QMYSQL : Driver not loaded

Scheduled Pinned Locked Moved Unsolved General and Desktop
15 Posts 4 Posters 3.9k 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.
  • SGaistS Offline
    SGaistS Offline
    SGaist
    Lifetime Qt Champion
    wrote on last edited by
    #5

    Hi,

    What does otool -L libqsqlmysql.dylib return ?

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

    TravT 1 Reply Last reply
    0
    • SGaistS SGaist

      Hi,

      What does otool -L libqsqlmysql.dylib return ?

      TravT Offline
      TravT Offline
      Trav
      wrote on last edited by
      #6

      @SGaist said in QMYSQL : Driver not loaded:

      otool -L libqsqlmysql.dylib

      Thank you for the reply!
      trav$ otool -L libqsqlmysql.dylib
      /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/objdump: 'libqsqlmysql.dylib': No such file or directory.
      fatal error: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/otool: internal objdump command failed

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

        otool -L /path/to/location/of/libqsqlmysql.dylib

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

        TravT 1 Reply Last reply
        0
        • TravT Offline
          TravT Offline
          Trav
          wrote on last edited by
          #8
          This post is deleted!
          1 Reply Last reply
          0
          • SGaistS SGaist

            otool -L /path/to/location/of/libqsqlmysql.dylib

            TravT Offline
            TravT Offline
            Trav
            wrote on last edited by
            #9

            @SGaist

            trav$ otool -L /usr/local/Cellar/mysql/5.7.17/lib/libmysqlclient.dylib

            /usr/local/Cellar/mysql/5.7.17/lib/libmysqlclient.dylib:
            /usr/local/opt/mysql/lib/libmysqlclient.20.dylib (compatibility version 20.0.0, current version 20.0.0)
            /usr/local/opt/openssl/lib/libssl.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0)
            /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0)
            /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 307.4.0)
            /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1238.0.0)

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

              I'm asking you to run otool on the Qt MySQL plugin. The path I've used in the command samples are meant to be replaced by the actual path to where the plugin is located. I don't know where it is on your system, so don't just copy paste the command, update it as well.

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

              TravT 1 Reply Last reply
              0
              • SGaistS SGaist

                I'm asking you to run otool on the Qt MySQL plugin. The path I've used in the command samples are meant to be replaced by the actual path to where the plugin is located. I don't know where it is on your system, so don't just copy paste the command, update it as well.

                TravT Offline
                TravT Offline
                Trav
                wrote on last edited by Trav
                #11

                @SGaist Sorry was 3 am. Deleted that comment as soon as I knew what I did I updated it immediately though with the correct path ^

                trav$ otool -L /usr/local/Cellar/mysql/5.7.17/lib/libmysqlclient.dylib

                /usr/local/Cellar/mysql/5.7.17/lib/libmysqlclient.dylib:
                /usr/local/opt/mysql/lib/libmysqlclient.20.dylib (compatibility version 20.0.0, current version 20.0.0)
                /usr/local/opt/openssl/lib/libssl.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0)
                /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0)
                /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 307.4.0)
                /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1238.0.0)

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

                  Not the MySQL client library, the Qt MySQL plugiin libqsqlmysql.dylib that can be found in the plugins/sqldrivers folder in your Qt installation.

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

                  TravT 1 Reply Last reply
                  1
                  • SGaistS SGaist

                    Not the MySQL client library, the Qt MySQL plugiin libqsqlmysql.dylib that can be found in the plugins/sqldrivers folder in your Qt installation.

                    TravT Offline
                    TravT Offline
                    Trav
                    wrote on last edited by
                    #13

                    @SGaist
                    pwd
                    /Users/trav/Qt/5.6/clang_64/plugins/sqldrivers

                    trav$ otool -L libqsqlmysql.dylib
                    libqsqlmysql.dylib:
                    libqsqlmysql.dylib (compatibility version 0.0.0, current version 0.0.0)
                    /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib (compatibility version 18.0.0, current version 18.0.0)
                    /usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.5)
                    @rpath/QtSql.framework/Versions/5/QtSql (compatibility version 5.6.0, current version 5.6.0)
                    @rpath/QtCore.framework/Versions/5/QtCore (compatibility version 5.6.0, current version 5.6.0)
                    /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 120.1.0)
                    /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1225.1.1)
                    Traviss-Air:sqldrivers trav$

                    A 1 Reply Last reply
                    0
                    • TravT Trav

                      @SGaist
                      pwd
                      /Users/trav/Qt/5.6/clang_64/plugins/sqldrivers

                      trav$ otool -L libqsqlmysql.dylib
                      libqsqlmysql.dylib:
                      libqsqlmysql.dylib (compatibility version 0.0.0, current version 0.0.0)
                      /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib (compatibility version 18.0.0, current version 18.0.0)
                      /usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.5)
                      @rpath/QtSql.framework/Versions/5/QtSql (compatibility version 5.6.0, current version 5.6.0)
                      @rpath/QtCore.framework/Versions/5/QtCore (compatibility version 5.6.0, current version 5.6.0)
                      /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 120.1.0)
                      /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1225.1.1)
                      Traviss-Air:sqldrivers trav$

                      A Offline
                      A Offline
                      ambershark
                      wrote on last edited by
                      #14

                      @Trav said in QMYSQL : Driver not loaded:

                      @SGaist
                      pwd
                      /Users/trav/Qt/5.6/clang_64/plugins/sqldrivers

                      trav$ otool -L libqsqlmysql.dylib
                      libqsqlmysql.dylib:
                      libqsqlmysql.dylib (compatibility version 0.0.0, current version 0.0.0)
                      /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib (compatibility version 18.0.0, current version 18.0.0)

                      Here's your problem... It is looking for mysql in the /opt/local/lib directory (which is a weird directory), when according to your post above it is in /usr/local/opt/mysql.

                      Usually people use /usr/local or /opt. I've never seen /opt/local. But it's not like there's set rules for directories or anything, so to each their own.

                      Anyway use otool to fix those paths and it should work.

                      My L-GPL'd C++ Logger github.com/ambershark-mike/sharklog

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

                        It's not weird for tools that are external to the distribution if we talk Linux style.

                        In this case, it's macports that is using it like that.

                        In any cas, the parameters passed to install_name_tool must be correct there's no error message telling you that the paths are invalid.

                        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
                        1

                        • Login

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