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.
  • SGaistS Offline
    SGaistS Offline
    SGaist
    Lifetime Qt Champion
    wrote on 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
    • SGaistS SGaist

      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 last edited by
      #19

      @SGaist said:

      install_name_tool -

      LSOpenURLsWithRole() failed with error -10810 for the file

      1 Reply Last reply
      0
      • SGaistS SGaist

        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 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
        • SGaistS Offline
          SGaistS Offline
          SGaist
          Lifetime Qt Champion
          wrote on 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
          0
          • SGaistS SGaist

            Which version of OS X and Qt are you using ?

            I've corrected the example line

            C Offline
            C Offline
            cpuin
            wrote on last edited by
            #22

            @SGaist

            OS X 10.10.3
            QT 5.4

            1 Reply Last reply
            0
            • SGaistS SGaist

              Which version of OS X and Qt are you using ?

              I've corrected the example line

              C Offline
              C Offline
              cpuin
              wrote on 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
              • SGaistS Offline
                SGaistS Offline
                SGaist
                Lifetime Qt Champion
                wrote on 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
                0
                • SGaistS SGaist

                  You're missing a slash before Users

                  C Offline
                  C Offline
                  cpuin
                  wrote on 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
                  • SGaistS Offline
                    SGaistS Offline
                    SGaist
                    Lifetime Qt Champion
                    wrote on 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 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
                      • SGaistS Offline
                        SGaistS Offline
                        SGaist
                        Lifetime Qt Champion
                        wrote on 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
                        0
                        • SGaistS SGaist

                          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 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
                          • SGaistS Offline
                            SGaistS Offline
                            SGaist
                            Lifetime Qt Champion
                            wrote on last edited by
                            #30

                            I didn't suggest to remove all other plugins, just the SQL related plugins you don't use

                            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
                            0
                            • SGaistS SGaist

                              I didn't suggest to remove all other plugins, just the SQL related plugins you don't use

                              C Offline
                              C Offline
                              cpuin
                              wrote on last edited by
                              #31

                              @SGaist Exactly, i left only sqlite plugin and the app doesn't open

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

                                Start it from the command line, what does it tell you ?

                                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
                                1
                                • SGaistS SGaist

                                  Start it from the command line, what does it tell you ?

                                  C Offline
                                  C Offline
                                  cpuin
                                  wrote on last edited by cpuin
                                  #33

                                  @SGaist Strangely the ERROR disappear and working app bundle was created w/out changing anything.Unfortunately the app created database.db in the path i set (in this case in the program.app/contents/MacOS but can't write inside!

                                  Starting the app from QT can write in to the db, but starting it outside Qt doesn't write, but creates it.

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

                                    You need to use a writable path (look at QStandardPaths) Writing in the bundle itself is not something to do and it's even prohibited if you use the App Store to distribute your application.

                                    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
                                    0
                                    • SGaistS SGaist

                                      You need to use a writable path (look at QStandardPaths) Writing in the bundle itself is not something to do and it's even prohibited if you use the App Store to distribute your application.

                                      C Offline
                                      C Offline
                                      cpuin
                                      wrote on last edited by
                                      #35

                                      @SGaist

                                      Do you tell me that Qt Desktop application can be submitted in Apple App Store?As i know they don't allowed external frameworks?

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

                                        Yes, you can, they have restriction but no, external frameworks are not prohibited.

                                        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