[SOLVED]QT5 unable to build MySQL driver under ubuntu

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”@