How to create Qt 6.5 mysql driver with cmake?

jsulm

@Saad02 said in How to create Qt 6.5 mysql driver with cmake?:

you mean that file with ".pro" extension right?

No, I did not say a single word about the pro file.
You were asked to set QT_DEBUG_PLUGINS anvironment variable to 1 before starting your application.
You can set it in QtCreator if you go to "Projects/Build & Run/Run/Run Environment".

Saad02

@jsulm Sir, I don't have "run environment" in run...

jsulm

@Saad02 said in How to create Qt 6.5 mysql driver with cmake?:

I don't have "run environment" in run

Of course you have, you just need to look bellow the part you posted, really...

Saad02

@jsulm Sir, the red marked one showing me my system variables, not run environment variable.

And this is the rest-

Here is all I have in "run".
By the way, the internet connection in our local is currently unstable. Can it be the reason for that driver not to load?

SGaist

@Saad02 do you see the arrow at the far right ? Click on it to show the variables.

Plugin loading and internet connection are unrelated

Saad02

@SGaist Sir, it is showing me my system variable. Not "run variable". I think I am doing something wrong. Should I reinstall QT? And what version should I install?

JonB

@Saad02
It seems to clearly show your Run environment, and that by default is the same as your System environment.

You have been asked to add a QT_DEBUG_PLUGINS environment variable into the Run environment, so do so.

Or, just run your executable from a terminal shell and add the environment variable there.

Saad02

@JonB Done and nothing much happened.

Application Output:
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMARIADB QMYSQL QODBC QPSQL

Compile Output:
18:27:06: Running steps for project database...
18:27:06: Starting: "C:\Qt\6.5.1\mingw_64\bin\qmake.exe" "C:\Users\Saad\Documents\qt c++\database\database.pro" -spec win32-g++ "CONFIG+=debug" "CONFIG+=qml_debug"
18:27:10: The process "C:\Qt\6.5.1\mingw_64\bin\qmake.exe" exited normally.
18:27:10: Starting: "C:\Qt\Tools\mingw1120_64\bin\mingw32-make.exe" -f "C:/Users/Saad/Documents/qt c++/build-database-Desktop_Qt_6_5_1_MinGW_64_bit-Debug/Makefile" qmake_all
mingw32-make: Nothing to be done for 'qmake_all'.
18:27:10: The process "C:\Qt\Tools\mingw1120_64\bin\mingw32-make.exe" exited normally.
18:27:10: Starting: "C:\Qt\Tools\mingw1120_64\bin\mingw32-make.exe" -j4
C:/Qt/Tools/mingw1120_64/bin/mingw32-make -f Makefile.Debug
mingw32-make[1]: Entering directory 'C:/Users/Saad/Documents/qt c++/build-database-Desktop_Qt_6_5_1_MinGW_64_bit-Debug'
mingw32-make[1]: Nothing to be done for 'first'.
mingw32-make[1]: Leaving directory 'C:/Users/Saad/Documents/qt c++/build-database-Desktop_Qt_6_5_1_MinGW_64_bit-Debug'
18:27:11: The process "C:\Qt\Tools\mingw1120_64\bin\mingw32-make.exe" exited normally.
18:27:11: Elapsed time: 00:05.

JonB

@Saad02
I can only say that, although you seem to have done the right thing, this is not correct output when setting QT_DEBUG_PLUGINS=1. You can verify that by searching the hundreds of occasions it has been used in this forum's questions or on the web.

Since I don't know exactly about Creator I suggest you set it in a shell and run your executable from there.

jsulm

@Saad02 said in How to create Qt 6.5 mysql driver with cmake?:

Application Output:

There should be more output if QT_DEBUG_PLUGINS was set - is that really all you get?

Saad02

@jsulm Yes, sir.

Should I shift to qt 5, since it's easier to create one for qt as it uses qmake? And if I do, then what will I miss there?

JonB

@Saad02

@JonB said in How to create Qt 6.5 mysql driver with cmake?:

Since I don't know exactly about Creator I suggest you set it [set QT_DEBUG_PLUGINS=1] in a shell and run your executable from there.

Did you try this? You have to know how to run your executable outside of Creator, else it will be useless in the the long-term, you cannot always require your code to run inside Creator!

Saad02

@JonB Isn't this what he meant-

Please let me know if I have run it in the wrong terminal.

JonB

@Saad02 Yes, that is right, now you have to run your program from there.

Saad02

@JonB Sir, I did it before and now again but nothing changed.

JonB

@Saad02
I wish you would show a screenshot of what you do in that terminal immediately after the set QT_DEBUG_PLUGINS=1....

If you read through this forum or search the web you will find "hundreds" of occasions where people get a

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMARIADB QMYSQL QODBC QPSQL

and they set the environment variable, run their application and get diagnostic output as to why it has failed to load QMYSQL driver. Not one of them has ever reported it failed to produce the diagnostic output. I find it hard to believe your case is any different.....

Saad02

@JonB Ok, I am providing you the screenshots.

(Rest of the tabs are empty)
This site is not allowing me to upload full screenshots. That's why I cropped and uploaded these.

JonB

@Saad02
I already suggested you run this in a terminal, not in Creator, so we can see what is going on. Repeatedly showing it is not working from your Creator isn't getting us anywhere.

I don't know why you don't see the diagnostic output in Creator.
It occurs to me: when run in terminal I am not sure where you get the diagnostic output under Windows. It may not be in terminal, may have to go to some debugger. You can probably search the forum or elsewhere, I don't use Windows for Qt. Otherwise I leave someone else to suggest.

thecodemonkey

@Saad02 could you show us some code you're running? You may edit out sensitive data like passwords etc. For example, if I remove a line like

QSqlDatabase sqlConn = QSqlDatabase::addDatabase(QStringLiteral("QMYSQL"));

then there's no QMYSQL plugin debug output despite QT_DEBUG_PLUGINS

Saad02

@JonB This is what I did after running "set QT_EBUG_PLUGINS=1" on the terminal. I have no idea about it if u r saying me to run that application directly from the terminal. Sorry :)