Qt MySQL Driver Mingw32-make not working
-
I am trying to install the QMySQL driver, but it keeps giving me this error whenever I use mingw32-make.
The previous steps in order to install the MySQL Driver were succesfull.Does anyone know what to do?
C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers>mingw32-make install cd odbc\ && ( if not exist Makefile C:\Qt\5.12.5\mingw73_32\bin\qmake.exe -o Makefile C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers\odbc\odbc.pro ) && mingw32-make -f Makefile install mingw32-make[1]: Entering directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc' mingw32-make -f Makefile.Release install mingw32-make[2]: Entering directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc' g++ -Wl,-s -shared -Wl,-subsystem,windows -Wl,--out-implib,C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\libqsqlodbc.a -o ..\plugins\sqldrivers\qsqlodbc.dll .obj/release/qsql_odbc.o .obj/release/main.o .obj/release/moc_qsql_odbc_p.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.6.11-win32\lib -LC:\Utils\postgresql\pgsql\lib C:\Program Files (x86)\MySQL\MySQL Server 5.5\lib\libmysql.lib C:\Qt\5.12.5\mingw73_32\lib\libQt5Sql.a C:\Qt\5.12.5\mingw73_32\lib\libQt5Core.a "C:\Program Files (x86)\Windows Kits\10\lib\10.0.17763.0\um\x86\odbc32.lib" .obj\release\qsqlodbc_resource_res.o g++: error: C:\Program: No such file or directory g++: error: Files: No such file or directory g++: error: (x86)\MySQL\MySQL: No such file or directory g++: error: Server: No such file or directory g++: error: 5.5\lib\libmysql.lib: No such file or directory mingw32-make[2]: *** [Makefile.Release:69: ../plugins/sqldrivers/qsqlodbc.dll] Error 1 mingw32-make[2]: Leaving directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc' mingw32-make[1]: *** [Makefile:48: release-install] Error 2 mingw32-make[1]: Leaving directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc' mingw32-make: *** [Makefile:56: sub-odbc-install_subtargets] Error 2
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
error: (x86)\MySQL\MySQL: No such file or directory
You installed MySQL stuff in a directory containing spaces. You should avoid this as it can cause issues (like in your case). Install it in a directory without spaces and try again.
-
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
error: (x86)\MySQL\MySQL: No such file or directory
You installed MySQL stuff in a directory containing spaces. You should avoid this as it can cause issues (like in your case). Install it in a directory without spaces and try again.
-
@jsulm so I should re-install the entire mysql workbench and server?
@hobbyProgrammer Workbench I think (I think this one contains the client libs)
-
@hobbyProgrammer Workbench I think (I think this one contains the client libs)
@jsulm
I already noticed that it went wrong with the spaces, but I was hoping that there was a simple solution for this instead of reinstalling the entire mysql workbench/server.But I'll give it a try as I am desperate to get this connection working
-
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
reinstalling the entire mysql workbench/server.
why? Moving the two needed directories to somewhere else should be enough.
-
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
reinstalling the entire mysql workbench/server.
why? Moving the two needed directories to somewhere else should be enough.
@Christian-Ehrlicher I can just make a new folder without spaces and move all the files to there?
-
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
reinstalling the entire mysql workbench/server.
why? Moving the two needed directories to somewhere else should be enough.
@Christian-Ehrlicher @Christian-Ehrlicher I moved it and used this command (from this tutorial:
cd C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers qmake -- MYSQL_INCDIR=C:\MySQL\include "MYSQL_LIBDIR=C:\MySQL\lib" mingw32-makebut still get the same errors..
-
@Christian-Ehrlicher @Christian-Ehrlicher I moved it and used this command (from this tutorial:
cd C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers qmake -- MYSQL_INCDIR=C:\MySQL\include "MYSQL_LIBDIR=C:\MySQL\lib" mingw32-makebut still get the same errors..
@hobbyProgrammer Do a clean rebuild
-
@hobbyProgrammer Do a clean rebuild
@jsulm still results in getting the same error. I should rebuild sqldrivers.pro right?
-
@Christian-Ehrlicher @Christian-Ehrlicher I moved it and used this command (from this tutorial:
cd C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers qmake -- MYSQL_INCDIR=C:\MySQL\include "MYSQL_LIBDIR=C:\MySQL\lib" mingw32-makebut still get the same errors..
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
cd C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers
You're doing in source build which is bad.
Make sure there are no build artefacts. -
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
cd C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers
You're doing in source build which is bad.
Make sure there are no build artefacts. -
@jsulm why is that bad? I'm quite new and just following the instructions from the docs, so I'd like to learn how to do things properly :')
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
why is that bad?
Because you're polluting source tree with build artefacts. If you then want to do a clean rebuild you need to delete all build artefacts and there can be many of them all over the place. Out of source builds are way easier:
- Create a build directory
- Go to that directory
- qmake
- make
- make install
For a clean rebuild delete everything inside build directory (or delete it and create again) and repeat steps 2..5.
By the way: QtCreator does out of source builds by default, so your source tree is clean and it's easier to use version control systems like Git :-)
-
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
why is that bad?
Because you're polluting source tree with build artefacts. If you then want to do a clean rebuild you need to delete all build artefacts and there can be many of them all over the place. Out of source builds are way easier:
- Create a build directory
- Go to that directory
- qmake
- make
- make install
For a clean rebuild delete everything inside build directory (or delete it and create again) and repeat steps 2..5.
By the way: QtCreator does out of source builds by default, so your source tree is clean and it's easier to use version control systems like Git :-)
@jsulm Thank you for your answer. I'm gonna retry to make the driver with this information in mind.
-
I still did not get it to work.
What I did:
- Moved all the content from MySQL server directory (contained a lot of spaced) to C:/MySQL.
- Used these commands:
cd C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers qmake -- MYSQL_INCDIR=:C\MySQL\include "MYSQL_LIBDIR=C:\MySQL\lib" mingw32-makeyet it still doesn't work. Is there anyone who knows why and can help me? I really want to connect to my MySQL database..
-
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
MYSQL_INCDIR=:C\MySQL\include
typo?
What was the output of the qmake command?
-
You have the : before the C. Is this just a typo here ?
-
@Christian-Ehrlicher @SGaist
yes that was a typo, but the output stays the same: "Project ERROR: Could not find feature sql-mysql." -
That's not the complete output. Please remove all intermediate files create by qmake (run first 'make distclean', then also remove qmake.cache) and rerun qmake again with the correct mysql parameters. Then show us the output.
-
That's not the complete output. Please remove all intermediate files create by qmake (run first 'make distclean', then also remove qmake.cache) and rerun qmake again with the correct mysql parameters. Then show us the output.
@Christian-Ehrlicher right now this is my output:
C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers>qmake -- MYSQL_INCDIR=C:\MySQL\include "MYSQL_LIBDIR=C:\MySQL\lib"
Running configuration tests...
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) ........................... noQt is now configured for building. Just run 'mingw32-make'.
Once everything is built, you must run 'mingw32-make install'.
Qt will be installed into 'C:\Qt\5.12.5\mingw73_32'.Prior to reconfiguration, make sure you remove any leftovers from
the previous build.Then I ran mingw32-make:
C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers>mingw32-make
cd odbc\ && ( if not exist Makefile C:\Qt\5.12.5\mingw73_32\bin\qmake.exe -o Makefile C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers\odbc\odbc.pro ) && mingw32-make -f Makefile
mingw32-make[1]: Entering directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc'
mingw32-make -f Makefile.Release all
mingw32-make[2]: Entering directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc'
mingw32-make[2]: Nothing to be done for 'all'.
mingw32-make[2]: Leaving directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc'
mingw32-make -f Makefile.Debug all
mingw32-make[2]: Entering directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc'
mingw32-make[2]: Nothing to be done for 'all'.
mingw32-make[2]: Leaving directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc'
mingw32-make[1]: Leaving directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/odbc'
cd sqlite\ && ( if not exist Makefile C:\Qt\5.12.5\mingw73_32\bin\qmake.exe -o Makefile C:\Qt\5.12.5\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && mingw32-make -f Makefile
mingw32-make[1]: Entering directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make -f Makefile.Release all
mingw32-make[2]: Entering directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make[2]: Nothing to be done for 'all'.
mingw32-make[2]: Leaving directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make -f Makefile.Debug all
mingw32-make[2]: Entering directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make[2]: Nothing to be done for 'all'.
mingw32-make[2]: Leaving directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make[1]: Leaving directory 'C:/Qt/5.12.5/Src/qtbase/src/plugins/sqldrivers/sqlite' -
@hobbyProgrammer said in Qt MySQL Driver Mingw32-make not working:
MySql .................................. no
So why do you even try to call mingw32-make when the configure step says it could not find the mysql stuff?
There is a config.log (iirc) where you can take a look into why the mysql plugins are not found.MYSQL_INCDIR=C:\MySQL\include "MYSQL_LIBDIR=C:\MySQL\lib"
Why one with " and one without? It's not needed ...
