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
QtWS25 Last Chance

[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 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
                      • S Offline
                        S Offline
                        SGaist
                        Lifetime Qt Champion
                        wrote on 30 Jun 2015, 12:52 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 30 Jun 2015, 13:03
                        0
                        • S SGaist
                          30 Jun 2015, 12:52

                          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 30 Jun 2015, 13:03 last edited by
                          #31

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

                          1 Reply Last reply
                          0
                          • S Offline
                            S Offline
                            SGaist
                            Lifetime Qt Champion
                            wrote on 30 Jun 2015, 13:07 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 30 Jun 2015, 13:37
                            1
                            • S SGaist
                              30 Jun 2015, 13:07

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

                              C Offline
                              C Offline
                              cpuin
                              wrote on 30 Jun 2015, 13:37 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
                              • S Offline
                                S Offline
                                SGaist
                                Lifetime Qt Champion
                                wrote on 30 Jun 2015, 16:44 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 1 Jul 2015, 14:54
                                0
                                • S SGaist
                                  30 Jun 2015, 16:44

                                  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 1 Jul 2015, 14:54 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
                                  • S Offline
                                    S Offline
                                    SGaist
                                    Lifetime Qt Champion
                                    wrote on 1 Jul 2015, 23:43 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

                                    29/36

                                    29 Jun 2015, 08:14

                                    • Login

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