How to create Qt 6.5 mysql driver with cmake?

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 :)

JonB

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

I have no idea about it if u r saying me to run that application directly from the terminal. Sorry :)

Then you should as a developer. Just type the path to the executable.

Saad02

@JonB Sir, can you please be more specific?

mzimmers

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

I have no idea about it if u r saying me to run that application directly from the terminal.

Yes, that's what he's asking for (I believe):

From a terminal window:

go to the folder with your executable
enter "./<your executable filename>
hit return
post the output

JonB

@Saad02
Following @mzimmers steps, don't forget to type the set QT_DEBUG_PLUGINS=1 before running your executable, else it's all a waste of time....