I have problems with QMYSQL Driver!

kaloo

Thanks for your help.

At the begin there is no mysql folder, but I made a new project named mysql and put it in the sqldrives. That is what should I do? Or I did it wrong?

andre

There is (or at least should be) a mysql.pro file in your Qt sources. If there isn't, you either are not looking hard enough, or you have an incomplete installation of the Qt sources. The former is more likely. Just making up a .pro file yourself is obviously not going to result in a valid project that is going to help you build the drivers.

kaloo

Andre I think I found the mysql.pro through the source files. Ill try tomorrow to make the QMYSQL Driver. If Ill have any problems, I`ll make a reply tomorrow.

kaloo

I found the right mysql.pro, I tiped
@
qmake "INCLUDE+=C:..." "LIBS+=C:...\libmysql.a" -o Makefile mysql.pro
mingw32-make
@

then I got !http://img651.imageshack.us/img651/614/unledswx.png!
Where is the problem?

andre

Did you prepare the MySql libs for use with the MinGw compiler, as is described in the countless other topics you claimed to have read on this issue?

kaloo

Yes I did. I crated the libmysql.a

cincirin

@kallo here are the steps to build mysql plug-in driver ( and I assure you it works :-) ):

download mysql-connector-c-noinstall-6.0.2-win32 binary package from mysql downloads.
open %QTDIR%\src\plugins\sqldrivers\mysql\mysql.pro in QtCreator
add LIBS and INCLUDEPATH in mysql.pro to match with your mysql-connector-c-noinstall-6.0.2-win32 path
after mysql.pro is succesfully build, copy the qsqlmysqld4.dll + qsqlmysql4.dll in %QTDIR%\Desktop...etc...\plugins\sqldrivers (there should already be qsqlite4.dll)
copy libmysql.dll in %QTDIR%\Desktop...etc...\bin

that's all

andre

No cincirin, that is not all. It depends on your toolchain. If you use minGw, as kaloo is doing, you need some additional steps.

cincirin

I use mingw toolchain and they work.

kaloo

So I did how cincirin said
!http://img51.imageshack.us/img51/5876/unledcj.png!

the output says
@
cannot find -libmysql
@

Where should libmysql stay? or what I did wrong?

cincirin

Do you have libmysql*.a* ? Don't you have libmysql.lib ?
Also you have to put only the path to libmysql.lib LIBS += yourPath

kaloo

I have libmysql.a

cincirin

From what I see, you didn't download mysql conector binary builds. Your path is towards xampp/...

kaloo

I have mysql-connector-c-noinstall-6.0.2-win32, extracted in the xampp/mysql folder

edit:
if I put
@
INCLUDEPATH += C:/xampp/mysql/include
LIBS += C:/xampp/mysql/lib/libmysql.a@
before
@
include(../../../sql/drivers/mysql/qsql_mysql.pri)
include(../qsqldriverbase.pri)
@
The output gives me 83 errors with undefined reference

cincirin

Ok, then your project should look as: ... LIBS += c:/xampp/mysql/lib
Anyway, I don't have libmysql*.a*

kaloo

I created the libmysql.a with
@ reimp C:/xampp/mysql/lib/libmysql.lib @

cincirin

You have to put only the path to mysql lib directory, because qsql_mysql.pri already do: LIBS += -llibmysql
Did you try with LIBS += -Lc:/xampp/mysql/lib ?

kaloo

the mysql.pro is now:
@
TARGET = qsqlmysql

SOURCES = main.cpp

INCLUDEPATH += C:/xampp/mysql/include
LIBS += C:/xampp/mysql/lib

include(../../../sql/drivers/mysql/qsql_mysql.pri)
include(../qsqldriverbase.pri)
@

and the output sais
@
C:/xampp/mysql/lib No such file: Permission Denied
@

but the folder is not read only... I don`t know what to do...

cincirin

Your project should be:
@
TARGET = qsqlmysql

SOURCES = main.cpp
include(../../../sql/drivers/mysql/qsql_mysql.pri)

include(../qsqldriverbase.pri)

INCLUDEPATH = C:/xampp/mysql/include
LIBS += -LC:/xampp/mysql/lib
@

kaloo

Yes, now is
@
TARGET = qsqlmysql

SOURCES = main.cpp
include(../../../sql/drivers/mysql/qsql_mysql.pri)

include(../qsqldriverbase.pri)

INCLUDEPATH = C:/xampp/mysql/include
LIBS += -LC:/xampp/mysql/lib
@
but again
@
cannot find -libmysql
@

Where should be that file? in the lib folder of mysql?