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. libmysqlclient.so.18 is missing
Forum Updated to NodeBB v4.3 + New Features

libmysqlclient.so.18 is missing

Scheduled Pinned Locked Moved Unsolved General and Desktop
18 Posts 6 Posters 3.9k 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.
  • O Offline
    O Offline
    orzel1244
    wrote on 23 Feb 2018, 19:20 last edited by
    #1

    Hello, I'm trying to make an server application on linux, I made it on my local machine with installed Qt and it works, I use linuxdeploytool and it says I'm missing libmysqlclient.so.18, but I uploaded the app to my server, it's running but it doesn't access database (it just says I'm missing plugin).

    I've tried to apt-get mysql, mysql-dev and other simillar as I found on other forums, but it does nothing, I'm still missing it. Some people says I have to compile qt, but it makes no sense to compile whole big Qt framework to get just one plugin. I was looking for the lib in usr/lib, /usr/local/lib, /lib, qt/lib, also qt/plugins/ and sadly I can't find it.

    1 Reply Last reply
    0
    • O Offline
      O Offline
      orzel1244
      wrote on 23 Feb 2018, 19:28 last edited by
      #2

      http://imgur.com/xpzd9vEl.png That's how my application logs looks like when trying to access database

      1 Reply Last reply
      0
      • P Offline
        P Offline
        Pablo J. Rogina
        wrote on 23 Feb 2018, 19:37 last edited by
        #3

        @orzel1244 please be aware that the image you posted says "QSQLITE driver not loaded" Are you sure you're effectively using a MySQL connection/DB as backend?

        Upvote the answer(s) that helped you solve the issue
        Use "Topic Tools" button to mark your post as Solved
        Add screenshots via postimage.org
        Don't ask support requests via chat/PM. Please use the forum so others can benefit from the solution in the future

        O 1 Reply Last reply 23 Feb 2018, 19:46
        0
        • P Pablo J. Rogina
          23 Feb 2018, 19:37

          @orzel1244 please be aware that the image you posted says "QSQLITE driver not loaded" Are you sure you're effectively using a MySQL connection/DB as backend?

          O Offline
          O Offline
          orzel1244
          wrote on 23 Feb 2018, 19:46 last edited by
          #4

          @Pablo-J.-Rogina I'm using sqlite

          1 Reply Last reply
          0
          • P Offline
            P Offline
            Pablo J. Rogina
            wrote on 23 Feb 2018, 19:54 last edited by
            #5

            @orzel1244 said in libmysqlclient.so.18 is missing:

            I use linuxdeploytool and it says I'm missing libmysqlclient.so.18

            It looks like you're referencing MySQL somehow which is not really needed, and you're missing to reference/include Sqlite which you indeed want to use.

            Upvote the answer(s) that helped you solve the issue
            Use "Topic Tools" button to mark your post as Solved
            Add screenshots via postimage.org
            Don't ask support requests via chat/PM. Please use the forum so others can benefit from the solution in the future

            1 Reply Last reply
            0
            • P Offline
              P Offline
              Pablo J. Rogina
              wrote on 23 Feb 2018, 19:58 last edited by Pablo J. Rogina
              #6

              @orzel1244 said in libmysqlclient.so.18 is missing:

              linuxdeploytool

              If you are actually using this linuxdeployqt tool, please take a look at this issue.

              Upvote the answer(s) that helped you solve the issue
              Use "Topic Tools" button to mark your post as Solved
              Add screenshots via postimage.org
              Don't ask support requests via chat/PM. Please use the forum so others can benefit from the solution in the future

              O 1 Reply Last reply 23 Feb 2018, 20:04
              0
              • P Pablo J. Rogina
                23 Feb 2018, 19:58

                @orzel1244 said in libmysqlclient.so.18 is missing:

                linuxdeploytool

                If you are actually using this linuxdeployqt tool, please take a look at this issue.

                O Offline
                O Offline
                orzel1244
                wrote on 23 Feb 2018, 20:04 last edited by
                #7

                @Pablo-J.-Rogina It doesn't help me

                1 Reply Last reply
                0
                • S Offline
                  S Offline
                  SGaist
                  Lifetime Qt Champion
                  wrote on 23 Feb 2018, 20:10 last edited by
                  #8

                  Hi,

                  You likely have have MySQL version 20 if you have a recent Linux distribution.

                  But since you are not using MySQL with your application. Why not just ignore that warning ?

                  What do you get if you call ldd on the Qt SQLite plugin ?

                  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
                  • O Offline
                    O Offline
                    orzel1244
                    wrote on 23 Feb 2018, 20:19 last edited by
                    #9

                    https://pastebin.com/ipHUP0j5 <- logs from linuxdeployqt

                    1 Reply Last reply
                    0
                    • O Offline
                      O Offline
                      orzel1244
                      wrote on 23 Feb 2018, 20:27 last edited by
                      #10

                      @SGaist said in libmysqlclient.so.18 is missing:

                      Why not just ignore that warning ?

                      Because the warning doesn't allow me to access my sqlite database

                      ldd on the plugin gives me:
                      https://pastebin.com/7Vs9bSB0

                      1 Reply Last reply
                      0
                      • S Offline
                        S Offline
                        SGaist
                        Lifetime Qt Champion
                        wrote on 23 Feb 2018, 20:28 last edited by
                        #11

                        Looks like there's a missing feature to disable unused SQL plugins for linuxdeployqt.

                        Then you should consider re-building the MySQL plugin against the version you installed on your system.

                        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
                        • O Offline
                          O Offline
                          orzel1244
                          wrote on 23 Feb 2018, 20:45 last edited by
                          #12

                          I'm still getting error while trying to compile Qt from sources, I think it's too hard for me and it's better to use other lib for database :/

                          1 Reply Last reply
                          0
                          • S Offline
                            S Offline
                            SGaist
                            Lifetime Qt Champion
                            wrote on 23 Feb 2018, 20:50 last edited by
                            #13

                            Then as a quick work around:

                            • Make a copy your sqldrivers folder.
                            • Remove all plugins in the original folder except the one you use.
                            • Re-run linuxdeployqt

                            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
                            • O Offline
                              O Offline
                              orzel1244
                              wrote on 23 Feb 2018, 21:01 last edited by
                              #14

                              You want me to copy sqldrivers from Qt dir to the application dir or what? I'm sorry I don't understand what you meant

                              1 Reply Last reply
                              0
                              • S Offline
                                S Offline
                                SGaist
                                Lifetime Qt Champion
                                wrote on 23 Feb 2018, 21:04 last edited by
                                #15

                                No, make a copy of the sqldrivers folder from the Qt installation you used to build your application. So you keep all the original files safe. Then in the original folder from your Qt installation, delete all the non SQLite related files. Doing so, linuxdeployqt will only deploy the SQLite driver. Once your done, just delete the modified sqldrivers folder and put back the copy you made just before.

                                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
                                • A Offline
                                  A Offline
                                  APSH
                                  wrote on 5 Mar 2025, 05:54 last edited by
                                  #16

                                  Tried to generate AppImage with linuxdeployqt , I get libmimerapi.so not found . There is no such plugin available . But when i build with cmake from Qt creator , build succeeds and app works as expected

                                  jsulmJ 1 Reply Last reply 5 Mar 2025, 07:01
                                  0
                                  • A APSH
                                    5 Mar 2025, 05:54

                                    Tried to generate AppImage with linuxdeployqt , I get libmimerapi.so not found . There is no such plugin available . But when i build with cmake from Qt creator , build succeeds and app works as expected

                                    jsulmJ Offline
                                    jsulmJ Offline
                                    jsulm
                                    Lifetime Qt Champion
                                    wrote on 5 Mar 2025, 07:01 last edited by
                                    #17

                                    @APSH said in libmysqlclient.so.18 is missing:

                                    There is no such plugin available

                                    libmimerapi.so is not a plug-in, it's a library you have to install. Search for the package in your Linux distribution which installs it.

                                    https://forum.qt.io/topic/113070/qt-code-of-conduct

                                    1 Reply Last reply
                                    0
                                    • Christian EhrlicherC Offline
                                      Christian EhrlicherC Offline
                                      Christian Ehrlicher
                                      Lifetime Qt Champion
                                      wrote on 5 Mar 2025, 07:11 last edited by
                                      #18

                                      ... Or simply delete the Qt mimer sql plug in if it is not needed.

                                      Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
                                      Visit the Qt Academy at https://academy.qt.io/catalog

                                      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