Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. Installation and Deployment
  4. Mysql not defined when compiling mysql driver
Forum Updated to NodeBB v4.3 + New Features

Mysql not defined when compiling mysql driver

Scheduled Pinned Locked Moved Solved Installation and Deployment
39 Posts 3 Posters 5.7k Views 2 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.
  • T Thombou

    @MEMekaniske Thanks a lot! That works now.
    It turns out that it is my libmysql.dll file that was not working.
    I did different test and I figured out that if I just replace this file by the one provided in the link and keeping all other dll as I built them, it works.
    I found my libmysql.dll file in the installation folder of my mysql server C:\Program Files\MySQL\MySQL Server 8.0. Any idea of what could be wrong about this one?

    kshegunovK Offline
    kshegunovK Offline
    kshegunov
    Moderators
    wrote on last edited by
    #27

    @Thombou said in Mysql not defined when compiling mysql driver:

    I did different test and I figured out that if I just replace this file by the one provided in the link and keeping all other dll as I built them, it works.

    Did you check that the arch matches between the plugin and the client library? I'd hazard a guess that's what was wrong. Anyway, as you have it solved it wouldn't matter that much.

    Read and abide by the Qt Code of Conduct

    T 1 Reply Last reply
    0
    • kshegunovK kshegunov

      @Thombou said in Mysql not defined when compiling mysql driver:

      I did different test and I figured out that if I just replace this file by the one provided in the link and keeping all other dll as I built them, it works.

      Did you check that the arch matches between the plugin and the client library? I'd hazard a guess that's what was wrong. Anyway, as you have it solved it wouldn't matter that much.

      T Offline
      T Offline
      Thombou
      wrote on last edited by
      #28

      @kshegunov What do you call the client library? The libmysql.dll?

      kshegunovK 1 Reply Last reply
      0
      • T Thombou

        @kshegunov What do you call the client library? The libmysql.dll?

        kshegunovK Offline
        kshegunovK Offline
        kshegunov
        Moderators
        wrote on last edited by
        #29

        @Thombou said in Mysql not defined when compiling mysql driver:

        What do you call the client library? The libmysql.dll?

        Yes!

        Read and abide by the Qt Code of Conduct

        T 1 Reply Last reply
        0
        • kshegunovK kshegunov

          @Thombou said in Mysql not defined when compiling mysql driver:

          What do you call the client library? The libmysql.dll?

          Yes!

          T Offline
          T Offline
          Thombou
          wrote on last edited by Thombou
          #30

          @kshegunov I downloaded it from here https://dev.mysql.com/downloads/windows/installer/8.0.html.
          As it is installed in the Program Files and not the Program Files (x86) directory I'd say it's 64bits...
          Plus, this is what I installed so:
          4dec0bb9-2b74-4299-b658-851e8881cc69-image.png

          M 1 Reply Last reply
          0
          • T Thombou

            @kshegunov I downloaded it from here https://dev.mysql.com/downloads/windows/installer/8.0.html.
            As it is installed in the Program Files and not the Program Files (x86) directory I'd say it's 64bits...
            Plus, this is what I installed so:
            4dec0bb9-2b74-4299-b658-851e8881cc69-image.png

            M Offline
            M Offline
            MEMekaniske
            wrote on last edited by
            #31

            @Thombou It says X64 under the architecture tab so should be the correct version.

            1 Reply Last reply
            1
            • M Offline
              M Offline
              MEMekaniske
              wrote on last edited by
              #32

              Also, if you go into the "Add" tab, then expand MySQL Servers, then expand MySQL Server, then choose MySQL Server 8.0 you get the option to choose the availiable architectures :)

              1 Reply Last reply
              0
              • T Offline
                T Offline
                Thombou
                wrote on last edited by
                #33

                Yes that's what I di not understand. it seems that I have the correct version but a wrong version of the libmysql.dll... Anyway, i hope that it is fixed now, and that I won't have other surprises like that later on.
                Thank you very much for your help! It is much appreciated!

                M 1 Reply Last reply
                1
                • T Thombou

                  Yes that's what I di not understand. it seems that I have the correct version but a wrong version of the libmysql.dll... Anyway, i hope that it is fixed now, and that I won't have other surprises like that later on.
                  Thank you very much for your help! It is much appreciated!

                  M Offline
                  M Offline
                  MEMekaniske
                  wrote on last edited by
                  #34

                  @Thombou Yeah it is very frustrating.. hope all goes well with the next version!
                  Glad i could help :)

                  1 Reply Last reply
                  1
                  • T Offline
                    T Offline
                    Thombou
                    wrote on last edited by
                    #35

                    Shall I report a bug somewhere of shall I suppose the problem is on my side?

                    kshegunovK 1 Reply Last reply
                    1
                    • T Thombou

                      Shall I report a bug somewhere of shall I suppose the problem is on my side?

                      kshegunovK Offline
                      kshegunovK Offline
                      kshegunov
                      Moderators
                      wrote on last edited by
                      #36

                      @Thombou said in Mysql not defined when compiling mysql driver:

                      Shall I report a bug somewhere of shall I suppose the problem is on my side?

                      The latter. (And don't feel bad, it happens all the time, that's why this user forum exists)

                      Read and abide by the Qt Code of Conduct

                      T 1 Reply Last reply
                      1
                      • kshegunovK kshegunov

                        @Thombou said in Mysql not defined when compiling mysql driver:

                        Shall I report a bug somewhere of shall I suppose the problem is on my side?

                        The latter. (And don't feel bad, it happens all the time, that's why this user forum exists)

                        T Offline
                        T Offline
                        Thombou
                        wrote on last edited by
                        #37

                        @kshegunov Ok that's what I thought too :) haha. It's by doing that we learn!
                        Cheers :)

                        1 Reply Last reply
                        0
                        • T Offline
                          T Offline
                          Thombou
                          wrote on last edited by Thombou
                          #38

                          For those who are interested, I opened the 2 dlls with the dependancy walker. It turns out that the dll provided by mysqlserver required 2 additional dlls LIBSSL-1_1X64.DLL and LIBCRYPTO-1_1-x64.DLL which were not found. In the dll file that if working, those 2 additional dlls are not required. When placing those 2 DLLs in the folder of the executable everything works perfectly. This is the root cause of the problem.

                          M 1 Reply Last reply
                          1
                          • T Thombou

                            For those who are interested, I opened the 2 dlls with the dependancy walker. It turns out that the dll provided by mysqlserver required 2 additional dlls LIBSSL-1_1X64.DLL and LIBCRYPTO-1_1-x64.DLL which were not found. In the dll file that if working, those 2 additional dlls are not required. When placing those 2 DLLs in the folder of the executable everything works perfectly. This is the root cause of the problem.

                            M Offline
                            M Offline
                            MEMekaniske
                            wrote on last edited by
                            #39

                            @Thombou very helpful information indeed! :)

                            What if you download those dlls to your exe lib and (there you did it already in the edit I see :p) hehe..

                            Very good, then you have complied the library successfully! Congratz :)

                            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