(MySQL) qsqlmysql.dll doesn't get created.
-
@SGaist The help article at https://doc.qt.io/qt-6/sql-driver.html literally shows the driver building directory as bin.
Pulled directly from the article
C:\Qt\6.0.0\mingw81_64\bin\qt-cmake -G Ninja C:\Qt\6.0.0\Src\qtbase\src\plugins\sqldrivers -DMySQL_INCLUDE_DIR="C:\mysql-8.0.22-winx64\include" -DMySQL_LIBRARY="C:\mysql-8.0.22-winx64\lib\libmysql.lib" -DCMAKE_INSTALL_PREFIX="C:\Qt\6.0.0\mingw81_64" Configure summary: Qt Sql Drivers: DB2 (IBM) .............................. no InterBase .............................. no MySql .................................. yes OCI (Oracle) ........................... no ODBC ................................... yes PostgreSQL ............................. no SQLite ................................. yes Using system provided SQLite ......... no -- Configuring done -- Generating done -- Build files have been written to: C:/build-qt6-sqldriversIt feels as though MySQL has taken a tangent from QT support; it's clear they aren't working closely together. I can go ahead and write my program using SQLite and revisit this in the future because i'm all out of ideas.
I really do appreciate all of yalls help though, there were a few moments when I thought I almost had it.
The last line is important: everything happens in ˋc:/build-qt6-sqldrivers`.
-
@SGaist
I'm going reinstall Qt and try again.I'll open up a cmd prompt
C:\mysql
and then invoke qt-cmake using it's pathC:\Qt\6.4.3\msvc2019_64\bin\qt-cmakeI'll let you know how it goes. Ninja won't install on my system, give some sort of error regarding Microsoft Store.
-
@SGaist
I'm going reinstall Qt and try again.I'll open up a cmd prompt
C:\mysql
and then invoke qt-cmake using it's pathC:\Qt\6.4.3\msvc2019_64\bin\qt-cmakeI'll let you know how it goes. Ninja won't install on my system, give some sort of error regarding Microsoft Store.
Are you installing it through the Qt installer ?
-
@SGaist It is bundled with Qt in the
C:\Qt\Tools\Ninja\folder but I can't "install" it. I tried searching for an answer it seems that its blocked by Microsoft Defender or something else in my environment that I can't disable. Do you think the drivers can be built without it?BTW, i'm a linux guy at heart and I'm probably going to try to set my Ubuntu environment at home for this.
-
@SGaist It is bundled with Qt in the
C:\Qt\Tools\Ninja\folder but I can't "install" it. I tried searching for an answer it seems that its blocked by Microsoft Defender or something else in my environment that I can't disable. Do you think the drivers can be built without it?BTW, i'm a linux guy at heart and I'm probably going to try to set my Ubuntu environment at home for this.
Then there's nothing more you need to do. It should just work (tm). Ninja should be available.
On Linux you can use your distribution's Qt dev packages. It will be easier.
-
Then there's nothing more you need to do. It should just work (tm). Ninja should be available.
On Linux you can use your distribution's Qt dev packages. It will be easier.
@SGaist
Normally I have to modify the qt-cmake.bat file to direct it to the correct folder for CMake. Should I be modifying that or should I move my CMake installation folder to where its currently represented in the file? Same question for Ninja. -
@SGaist
Normally I have to modify the qt-cmake.bat file to direct it to the correct folder for CMake. Should I be modifying that or should I move my CMake installation folder to where its currently represented in the file? Same question for Ninja.You shouldn't need to do that at all.
If cmake is not found, you are likely using a terminal not configured properly.You can modify the PATH environment variable.
-
You shouldn't need to do that at all.
If cmake is not found, you are likely using a terminal not configured properly.You can modify the PATH environment variable.
BREAKTHROUGH!!!
explanation incoming
-
You shouldn't need to do that at all.
If cmake is not found, you are likely using a terminal not configured properly.You can modify the PATH environment variable.
Here's what I did and what I got.
Before I go any further I'd really like to thank you @SGaist, @Christian-Ehrlicher , @jsulm for your help. I am approaching this as a complete beginner and this is no simple task to understand.
After I got by butt out of the QT folder for building I used the Start Menu terminal entry for the platform my app will be in (MSVC2019_64) and navigated to my self-made
C:\mysqlfolder.I was able to build the plugins using
qt-cmake C:\Qt\6.4.3\Src\qtbase\src\plugins\sqldrivers -DMySQL_INCLUDE_DIR="C:\Program Files\MySQL\MySQL Connector C 6.1\include" -DMySQL_LIBRARY="C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.lib"Once the plugins were created I was able to build
qsqlmysql.dllandqsqlmysql.pdbby opening the ALL_BUILD.vcxproj in visual studio and building it there (which is what I think @Christian-Ehrlicher was trying to tell me instead of using the command line).I transferred the newly made
qsqlmysql.dllandqsqlmysql.pdbto the platform folder ofC:\Qt\6.4.3\msvc2019_64\plugins\sqldrivers.I believe I still have to install the drivers but this is obviously the result I've yet to get up to this point.
EDIT:
Did the same process of opening up INSTALL.vcxproj in Visual Studio and building it there and it was also a success. Now I imagine I just have the right #includes in my project and should be able to connect to MySQL. If it would benefit the community I'd be happy to write up an in depth breakdown of how this is done for my system.
-
Either open the generated solution and build the debug version (can also be done from the command line but I don't remember the commands) or use
-G Ninjaor-G NMake Makefilesfor the cmake generator - they both produce rules to create both plugins directly. Maybe we should add this to the documentation. MSBuild is not meant to be run on the command line and therefore has a lot of strange switches...Where do I find the project that builds the debug version? I have the release qsqlmysql.<dll.pdb> but not qsqlmysqld<dll.pdb>
-
Where do I find the project that builds the debug version? I have the release qsqlmysql.<dll.pdb> but not qsqlmysqld<dll.pdb>
@Thelonious You can change the build type in the msvc IDE.
But as I said - use NMake Makefiles or Ninja to create both of them directly on the command line...
-
T Thelonious has marked this topic as solved on
