Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?

SGaist

@BAHRAMUDIN-ADIL said in Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?:

@SimonSchroeder If you see carefully I have already added sql

To the wrong variable. You added it to CONFIG but you shall add it to QT as @SimonSchroeder wrote.

[edit: Answer to the original post SGaist]

BAHRAMUDIN ADIL

@SimonSchroeder Yes, I did not add the SQL module correctly in .pro file. But now I got this error:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7

BAHRAMUDIN ADIL

@SGaist Hmmm, yes, it was my fault, but now I got the next error, what is your opinion?
I have already added these two DLL files in Qt bin directory:

libmysqld.dll
libmysql.dll

And also I have tried these three as well:

ssleay32.dll
libeay32.dll
libmysql.lib

Also not solved the problem.

J.Hilk

@BAHRAMUDIN-ADIL
after modifying your pro file, ALWAYS clean and run qmake

you added a new module so I would go a step further and delete the build directory for a complete rebuild

BAHRAMUDIN ADIL

@J-Hilk Yes, I did that as you said, but the problem still exists. Can you tell me what files and libs I need to add and add them in which place? Thanks!

SGaist

@BAHRAMUDIN-ADIL said in Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7

As you can see from the listing, you don't have the plugin at all.

As for why: the licensing of MySQL changed so only GPL and Commercial are available now. Since the pre-built binaries are usable also under the LGPL, the plugin can't be provided.

You also have the option of building it with MariaDB which fixes the licensing issue.

See QTBUG-78241

BAHRAMUDIN ADIL

@SGaist You mean that I need to build Qt from source with the needed plugins? Or I just need to build the MySQL plugin? If the second case is right, then to build the only plugin, what should I need, and how to build? Is there any guide to show how to build?
Thanks!

aha_1980

@BAHRAMUDIN-ADIL

you need to build the plugin as described here: https://doc.qt.io/qt-5/sql-driver.html#qmysql

Regards

BAHRAMUDIN ADIL

@aha_1980 Yes, before you send me the answer I saw this documentation, but can you tell me where is it?

cd %QTDIR%\qtbase\src\plugins\sqldrivers

I did not find in whole Qt installation directory.

Thank you so much!!!

Christian Ehrlicher

@BAHRAMUDIN-ADIL said in Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?:

I did not find in whole Qt installation directory.

As you can see there is 'src' - you need the Qt sources...

BAHRAMUDIN ADIL

@Christian-Ehrlicher Hmmm, so for a small plugin I need to download the whole Qt source code? It definitely takes a lot of time and takes much space. I think the Qt team should think about it to make it easy just to download only what I need not all the source code or provide some other way to overcome this problem because MySql users are very a lot on all over the world. If all the users download the source code it will so be extra pressure on Qt side server and also not good user experience.

I hope the Qt becomes more beautiful in the feature!!

aha_1980

@BAHRAMUDIN-ADIL You don't need to tell us - we are just users like you and not related to the Qt company.

You might also want to use the MariaDB plugin which does not have the MySQL licence restrictions.

Btw: you can download the sources with the MaintenanceTool.

Regards

BAHRAMUDIN ADIL

@aha_1980 What is the problem with the following output? I did everything step by step as the document, but why I am getting this error?
Note: I am using MySql 8 and installed successfully and there is no problem with MySql server.

C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers>qmake -- MYSQL_INCDIR="C:/Program Files/MySQL/MySQL Server 8.0/include" MYSQL_LIBDIR="C:/Program Files/MySQL/MySQL Server 8.0/lib"
Info: creating stash file C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers\.qmake.stash

Running configuration tests...
Checking for DB2 (IBM)... no
Checking for InterBase... no
Checking for MySQL... no
Checking for OCI (Oracle)... no
Checking for ODBC... yes
Checking for PostgreSQL... no
Checking for SQLite (version 2)... no
Checking for TDS (Sybase)... no
Done running configuration tests.

Configure summary:

Qt Sql Drivers:
  DB2 (IBM) .............................. no
  InterBase .............................. no
  MySql .................................. no
  OCI (Oracle) ........................... no
  ODBC ................................... yes
  PostgreSQL ............................. no
  SQLite2 ................................ no
  SQLite ................................. yes
    Using system provided SQLite ......... no
  TDS (Sybase) ........................... no

Qt is now configured for building. Just run 'nmake'.
Once everything is built, you must run 'nmake install'.
Qt will be installed into 'C:\Qt\5.14.0\msvc2017_64'.

Prior to reconfiguration, make sure you remove any leftovers from
the previous build.


C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers>nmake sub-mysql

Microsoft (R) Program Maintenance Utility Version 14.24.28316.0
Copyright (C) Microsoft Corporation.  All rights reserved.

NMAKE : fatal error U1073: don't know how to make 'sub-mysql'
Stop.

C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers>

SGaist

Take a closer look at the configure test logs to see exactly why the detection failed.

BAHRAMUDIN ADIL

@SGaist Still it is throwing error, I going to not use Qt anymore, and go for Java, the best and the easy language all over the word it is why Java is always on the top of all of the languages.

SGaist

Without the information located in the test logs it's impossible to know what is going on.

BAHRAMUDIN ADIL

@SGaist OK, I will tell you what is going on. First of all, every step is done according to the documentation.
It is what did I try and what did I get:
I have MySql 8 installed on my machine, and works well Java, command line, and other database tools and software.
Because of the license problem the Qt team not provide MySql driver anymore and must be compiled by the user. For this, I downloaded and reinstalled Qt with source code, which took me a lot of time and wasted me a lot of internets and disk space (which is a very bad user experience).
Then I start to compile the source code of the MySql drive, first I tried the documentation way, there are three commands need to execute:

qmake -- MYSQL_INCDIR="C:/Program Files/MySQL/MySQL Connector C 6.1/include" MYSQL_LIBDIR="C:/Program Files/MySQL/MySQL Connector C 6.1/lib"
nmake sub-mysql
nmake install

The first command executed without error, but from the log which I sent here in before post, it says that did not find MySql:

Running configuration tests...
Checking for DB2 (IBM)... no
Checking for InterBase... no
Checking for MySQL... no
Checking for OCI (Oracle)... no
Checking for ODBC... yes
Checking for PostgreSQL... no
Checking for SQLite (version 2)... no
Checking for TDS (Sybase)... no
Done running configuration tests.

Configure summary:

Qt Sql Drivers:
  DB2 (IBM) .............................. no
  InterBase .............................. no
  MySql .................................. no
  OCI (Oracle) ........................... no
  ODBC ................................... yes
  PostgreSQL ............................. no
  SQLite2 ................................ no
  SQLite ................................. yes
    Using system provided SQLite ......... no
  TDS (Sybase) ........................... no

And then when I execute the second command it shows error:

C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers>nmake sub-mysql

Microsoft (R) Program Maintenance Utility Version 14.24.28316.0
Copyright (C) Microsoft Corporation.  All rights reserved.

NMAKE : fatal error U1073: don't know how to make 'sub-mysql'
Stop.

It is what I got when running the commands, I don't know where I am wrong, I did every step as the documentation says.

The second way I have tried is: I opened Qt-Creator and then import the mysql project, and then when I build the project, it says:

Project ERROR: Library 'mysql' is not defined.

Then in .pro file I configured MySql lib and include dir also the same error.

The third way I have installed Qt-VS tools for Microsoft Visual Studio, and then when I open the project in the Visual Studio, then also shows errors the project not opened:

--- (Import): Generating new project of mysql.pro file
--- (qmake) : Using: C:\QT\5.14.1\MSVC2017_64\bin\qmake
--- (qmake) : Working Directory: C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers\mysql
--- (qmake) : Arguments: -tp vc "mysql.pro" -o "mysql.vcxproj" QMAKE_INCDIR_QT=$(QTDIR)\include QMAKE_LIBDIR=$(QTDIR)\lib QMAKE_MOC=$(QTDIR)\bin\moc.exe QMAKE_QMAKE=$(QTDIR)\bin\qmake.exe

[1] - Info: creating stash file C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers\.qmake.stash

--- (Import): Success: 1
[1] - Cannot read C:/Qt/5.14.1/Src/qtbase/src/plugins/sqldrivers/qtsqldrivers-config.pri: No such file or directory
[2] - Project ERROR: Library 'mysql' is not defined.

--- (Import): Error(s): 2
--- (qmake) : Exit Code: 3

Then you say what should I do? In the 21st Century even one small plugin not getting compiled by Qt.

JKSH

@BAHRAMUDIN-ADIL said in Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?:

I have MySql 8

...

qmake -- MYSQL_INCDIR="C:/Program Files/MySQL/MySQL Connector C 6.1/include" MYSQL_LIBDIR="C:/Program Files/MySQL/MySQL Connector C 6.1/lib"

You told qmake to use MySQL 6.1, not MySQL 8.0.

Note: MySQL 8.0 has a different folder structure than previous versions. Check your MySQL installation folder to find the correct paths to the include and lib folders.

I downloaded and reinstalled Qt with source code, which took me a lot of time and wasted me a lot of internets and disk space

For future reference, you don't need to re-install Qt to get the source code. You have 2 options:

(Using the online installer) Run MaintenanceTool.exe, select "Add/Remove Components", and select Qt > Qt 5.14.1 > Sources
(Using direct download) Get the sources from http://download.qt.io/official_releases/qt/5.14/5.14.1/single/ — the *.zip file is for Windows, the *.tar.xz file is for Linux/macOS

BAHRAMUDIN ADIL

@JKSH Thanks! I know the command, I pasted that command from the documentation, when I executed I modified the command for my self. I am not new to coding I have 10 years experience with coding. So I know these basic steps.

qmake -- MYSQL_INCDIR="C:/Program Files/MySQL/MySQL Server 8.0/include" MYSQL_LIBDIR="C:/Program Files/MySQL/MySQL Server 8.0/lib"

The second one I also know how to install to and modify the Qt installation by MaintenanceTool which will be installed when installing Qt.

I did a fresh installation to there do not be any reason for the compatibility between source code and the installed binary packages.

I saw there a lot of shortcomings in the Qt framework. I did not remember using Qt without a problem, the problem which takes so much time to solve.