[SOLVED]QT5 unable to build MySQL driver under ubuntu

mbnoimi

I want to build QMYSQL plug-in for MySQL driver under ubuntu but I got this error message:

bq. mbnoimi-pc mysql # qmake "INCLUDEPATH+=/usr/local/include" "LIBS+=-L/usr/local/lib -lmysqlclient_r" mysql.pro
WARNING: /opt/Qt5.0.1/5.0.1/Src/qtbase/src/plugins/sqldrivers/qsqldriverbase.pri:4: Unable to find file for inclusion qt_plugin
Project MESSAGE: Warning: unknown QT: sql-private

How can I fix this issue?

PS

I've installed libmysqlclient-dev, libmysql++-dev packages

mbnoimi

I believe this is matter of error paths I tried to use the following but it didn't work:

bq. qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/x86_64-linux-gnu -lmysqlclient_r" mysql.pro

PS

I forgot to tell you that I'm using ubuntu 12.10 x64

mbnoimi

The solution of this issue is by calling qmake as absolute path because it was using Qt4's qmake.

anubhav87

very very new to the forum sites :)
what is mysql.pro here please tell

mbnoimi

[quote author="anubhav87" date="1371193722"]very very new to the forum sites :)
what is mysql.pro here please tell[/quote]

Project file of Qt MySQL plugin

anubhav87

I have mysql installed
when i run mysql --version
i get
mysql Ver 14.14 Distrib 5.5.29, for debian-linux-gnu (x86_64) using readline 6.2
But When i try to connect MySql With Qt uisng QSqldatabase it give the error below

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE

From where to start now can you tell me

mbnoimi

[quote author="anubhav87" date="1371195516"]I have mysql installed
when i run mysql --version
i get
mysql Ver 14.14 Distrib 5.5.29, for debian-linux-gnu (x86_64) using readline 6.2
But When i try to connect MySql With Qt uisng QSqldatabase it give the error below

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE

From where to start now can you tell me [/quote]

The system show you that you havn't Qt plugin for MySQL (you have SQLite) so try to build your own Qt MySQL plugin from https://qt-project.org/doc/qt-5.0/qtsql/sql-driver.html#qmysql

PS
I suppose you're using Qt5

anubhav87

Yes I am using Qt5

mbnoimi

[quote author="anubhav87" date="1371196499"]Yes I am using Qt5[/quote]

Try to use the mentioned steps above and don't forget to read documentation page I've linked it to you :)

anubhav87

Hi,
I am running below mentioned command

qmake "INCLUDEPATH+=/usr/local/include" "LIBS+=-L/usr/local/lib -lmysqlclient_r" mysql.pro
make

but it is saying
Cannot find file: mysql.pro

where will i get mysql.pro

mbnoimi

Where you've installed Qt5 on your machine?

anubhav87

My Home Folder (Linux Mint 14.0)

anubhav87

But i am still struggling with mysql.pro file where is this

mbnoimi

OK, try to do the following (considering installation directory is /home/usename/Qt5.0.2):

@usename@usename-pc ~ $ sudo apt-get install tasksel
usename@usename-pc ~ $ sudo tasksel install LAMP
usename@usename-pc ~ $ sudo tasksel install libmysqlclient-dev
usename@usename-pc ~ $ cd /home/usename/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/sqldrivers/mysql
usename@usename-pc ~ $ /home/usename/Qt5.0.2/5.0.2/gcc_64/bin/qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/x86_64-linux-gnu -lmysqlclient_r" mysql.pro
usename@usename-pc ~ $ make
usename@usename-pc ~ $ make install@

anubhav87

As you said i did that too but again where is this mysql.pro

my output as you said

username@username ~ $ sudo tasksel
[sudo] password for username:
sudo: tasksel: command not found
username@username ~ $ cd Qt5.0.0/5.0.0/
username@username ~/Qt5.0.0/5.0.0 $ cd gcc_64/
username@username ~/Qt5.0.0/5.0.0/gcc_64 $ cd plugins/
username@username ~/Qt5.0.0/5.0.0/gcc_64/plugins $ cd sqldrivers/
username@username ~/Qt5.0.0/5.0.0/gcc_64/plugins/sqldrivers $ /home/username/Q
Qt5.0.0/ QT_APP/
username@username ~/Qt5.0.0/5.0.0/gcc_64/plugins/sqldrivers $ /home/username/Qt5.0.0/5.0.0/gcc_64/bin/qm
qmake qmlmin qmlscene
qml1plugindump qmlplugindump qmltestrunner
qmlbundle qmlprofiler qmlviewer
username@username ~/Qt5.0.0/5.0.0/gcc_64/plugins/sqldrivers $ /home/username/Qt5.0.0/5.0.0/gcc_64/bin/qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/x86_64-linux-gnu

^C
username@username ~/Qt5.0.0/5.0.0/gcc_64/plugins/sqldrivers $ /home/username/Qt5.0.0/5.0.0/gcc_64/bin/qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/x86_64-linux-gnu -lmysqlclient_r" mysql.pro
Cannot find file: mysql.pro.
username@username ~/Qt5.0.0/5.0.0/gcc_64/plugins/sqldrivers $

mbnoimi

First of all, Could you please put the log inside code format.

give me the output of the following:
@cd ~
find ./ -name "mysql.pro"@

anubhav87

I find query.txt located on my desktop it gives the correct location but for mysql.pro it return nothing

username@username ~ $ find ./ -name "query.txt"
./Desktop/query.txt
username@username ~ $ find ./ -name "mysql.pro"
username@username ~ $

mbnoimi

It seems that you didn't install Qt into your home directory. Try to run find where Qt installed.

anubhav87

Below is the path where i have installed my qt
/home/myusername/Qt5.0.0

mbnoimi

Try to download recent Qt installer (currently 5.0.2) , through installation wizard choose all available components (it has Qt' source code). Then:

@cd ~
find ./ -name “mysql.pro”@