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]MySQL library problem
Forum Update on Monday, May 27th 2025

[SOLVED]MySQL library problem

Scheduled Pinned Locked Moved General and Desktop
mysqldriverpluginsql
36 Posts 3 Posters 12.9k 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
    SGaist
    Lifetime Qt Champion
    wrote on 27 Jun 2015, 19:47 last edited by
    #10

    Hi,

    Do you have the MySQL libraries installed in /opt ? (i.e. using macports) If not then the error message is normal.

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

    C 1 Reply Last reply 27 Jun 2015, 19:50
    0
    • S SGaist
      27 Jun 2015, 19:47

      Hi,

      Do you have the MySQL libraries installed in /opt ? (i.e. using macports) If not then the error message is normal.

      C Offline
      C Offline
      cpuin
      wrote on 27 Jun 2015, 19:50 last edited by
      #11

      @SGaist

      I have installed MySQL from the installer.I don't know where is the opt/ (the path to it)

      1 Reply Last reply
      0
      • S Offline
        S Offline
        SGaist
        Lifetime Qt Champion
        wrote on 27 Jun 2015, 19:53 last edited by
        #12

        Then you probably have the MySQL libraries in a path like /usr/local/mysql/. Right ?

        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
        • C Offline
          C Offline
          cpuin
          wrote on 27 Jun 2015, 19:53 last edited by
          #13

          YES it is there

          1 Reply Last reply
          0
          • S Offline
            S Offline
            SGaist
            Lifetime Qt Champion
            wrote on 27 Jun 2015, 19:57 last edited by SGaist
            #14

            Then you have to do

            install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /usr/local/mysql/PATH_TO_libmysqlclient.X.dylib PATH_TO_libqsqlmysql.dylib
            

            In any case, if you are not using it in your application, you can also ignore the message and remove the plugin from the bundle.

            [edit: added missing target SGaist]

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

            C 1 Reply Last reply 27 Jun 2015, 20:09
            0
            • C Offline
              C Offline
              cpuin
              wrote on 27 Jun 2015, 20:00 last edited by
              #15

              I deleted all plugins , left only libqsqlite.dylib
              The app doesn't work!

              1 Reply Last reply
              0
              • S Offline
                S Offline
                SGaist
                Lifetime Qt Champion
                wrote on 27 Jun 2015, 20:01 last edited by
                #16

                You have to give more details. "Doesn't work" doesn't give enough information to help you. Do you have any error message ?

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

                C 1 Reply Last reply 27 Jun 2015, 20:06
                0
                • M Offline
                  M Offline
                  mcosta
                  wrote on 27 Jun 2015, 20:01 last edited by
                  #17

                  seems that macqtdeploy has some hardcoded PATH for MySQL and PostgreSQL.

                  Once your problem is solved don't forget to:

                  • Mark the thread as SOLVED using the Topic Tool menu
                  • Vote up the answer(s) that helped you to solve the issue

                  You can embed images using (http://imgur.com/) or (http://postimage.org/)

                  1 Reply Last reply
                  0
                  • S Offline
                    S Offline
                    SGaist
                    Lifetime Qt Champion
                    wrote on 27 Jun 2015, 20:03 last edited by
                    #18

                    @mcosta not it doesn't, macdeployqt parses the output of otool to get the dependencies of the libraries/plugins of Qt. AFAICT, the plugins are built with dependencies coming from MacPorts hence the libmysqlclient.18.dylib in /opt/local/lib/

                    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 SGaist
                      27 Jun 2015, 20:01

                      You have to give more details. "Doesn't work" doesn't give enough information to help you. Do you have any error message ?

                      C Offline
                      C Offline
                      cpuin
                      wrote on 27 Jun 2015, 20:06 last edited by
                      #19

                      @SGaist said:

                      install_name_tool -

                      LSOpenURLsWithRole() failed with error -10810 for the file

                      1 Reply Last reply
                      0
                      • S SGaist
                        27 Jun 2015, 19:57

                        Then you have to do

                        install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /usr/local/mysql/PATH_TO_libmysqlclient.X.dylib PATH_TO_libqsqlmysql.dylib
                        

                        In any case, if you are not using it in your application, you can also ignore the message and remove the plugin from the bundle.

                        [edit: added missing target SGaist]

                        C Offline
                        C Offline
                        cpuin
                        wrote on 27 Jun 2015, 20:09 last edited by
                        #20

                        @SGaist said:

                        /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib

                        install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /usr/local/mysql-5.6.25-osx10.8-x86_64/lib/libmysqlclient.18.dylib
                        Usage: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/install_name_tool [-change old new] ... [-rpath old new] ... [-add_rpath new] ... [-delete_rpath old] ... [-id name] input

                        1 Reply Last reply
                        0
                        • S Offline
                          S Offline
                          SGaist
                          Lifetime Qt Champion
                          wrote on 27 Jun 2015, 20:25 last edited by
                          #21

                          Which version of OS X and Qt are you using ?

                          I've corrected the example line

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

                          C 2 Replies Last reply 27 Jun 2015, 20:31
                          0
                          • S SGaist
                            27 Jun 2015, 20:25

                            Which version of OS X and Qt are you using ?

                            I've corrected the example line

                            C Offline
                            C Offline
                            cpuin
                            wrote on 27 Jun 2015, 20:31 last edited by
                            #22

                            @SGaist

                            OS X 10.10.3
                            QT 5.4

                            1 Reply Last reply
                            0
                            • S SGaist
                              27 Jun 2015, 20:25

                              Which version of OS X and Qt are you using ?

                              I've corrected the example line

                              C Offline
                              C Offline
                              cpuin
                              wrote on 27 Jun 2015, 20:38 last edited by cpuin
                              #23

                              @SGaist said:

                              PATH_TO_libqsqlmysql.dylib

                              install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /usr/local/mysql-5.6.25-osx10.8-x86_64/lib/libmysqlclient.18.dylib Users/jorost/Qt5.4.2/5.4/clang_64/plugins/sqldrivers/libqsqlmysql.dylib
                              error: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/install_name_tool: can't open file: Users/jorost/Qt5.4.2/5.4/clang_64/plugins/sqldrivers/libqsqlmysql.dylib (No such file or directory)

                              1 Reply Last reply
                              0
                              • S Offline
                                S Offline
                                SGaist
                                Lifetime Qt Champion
                                wrote on 27 Jun 2015, 20:44 last edited by
                                #24

                                You're missing a slash before Users

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

                                C 1 Reply Last reply 27 Jun 2015, 20:46
                                0
                                • S SGaist
                                  27 Jun 2015, 20:44

                                  You're missing a slash before Users

                                  C Offline
                                  C Offline
                                  cpuin
                                  wrote on 27 Jun 2015, 20:46 last edited by
                                  #25

                                  @SGaist
                                  Now i got only Postgre error

                                  ERROR: no file at "/usr/local/lib/libpq.5.dylib"

                                  Does it mean that i have working mysql plugin?

                                  1 Reply Last reply
                                  0
                                  • S Offline
                                    S Offline
                                    SGaist
                                    Lifetime Qt Champion
                                    wrote on 27 Jun 2015, 21:43 last edited by
                                    #26

                                    You should, unless the libmysqlclient is very different from the one Qt was built with.

                                    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
                                    • C Offline
                                      C Offline
                                      cpuin
                                      wrote on 28 Jun 2015, 20:55 last edited by
                                      #27

                                      I have now mysql working, but i still can't have working app because of this:
                                      ERROR: no file at "/usr/local/lib/libpq.5.dylib"

                                      This is not very good approach: include all plug-ins w/out need of them.

                                      1 Reply Last reply
                                      0
                                      • S Offline
                                        S Offline
                                        SGaist
                                        Lifetime Qt Champion
                                        wrote on 28 Jun 2015, 20:58 last edited by
                                        #28

                                        That's the PostgreSQL plugin. Like I suggested before, just remove the plugins you don't need from your bundle.

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

                                        C 1 Reply Last reply 29 Jun 2015, 08:14
                                        0
                                        • S SGaist
                                          28 Jun 2015, 20:58

                                          That's the PostgreSQL plugin. Like I suggested before, just remove the plugins you don't need from your bundle.

                                          C Offline
                                          C Offline
                                          cpuin
                                          wrote on 29 Jun 2015, 08:14 last edited by
                                          #29

                                          @SGaist

                                          As i answered before when removing all other plugins from the bundle, the app doesn't open!

                                          1 Reply Last reply
                                          0

                                          19/36

                                          27 Jun 2015, 20:06

                                          • Login

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