QMYSQL driver not loaded on Ubuntu

SGaist · wrote on 4 Jan 2014, 22:46

You have the version 18 and not the 16.

So two solutions here:

find the version 16
build the Qt MySQL plugin yourself with this version of the client library (best)

? Offline · wrote on 5 Jan 2014, 10:51

[quote author="SGaist" date="1388875572"]You have the version 18 and not the 16.

So two solutions here:

find the version 16

build the Qt MySQL plugin yourself with this version of the client library (best)[/quote]

Sorry , but can you help me for find or build qt mysql plugin ?
I run this command : root@Gigabyte-Z68P-DS3:/opt/Qt5.2.0/5.2.0/Src/qtbase/src/plugins/sqldrivers/mysql# qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysql -lmysqlclient_r" mysql.pro

I think my command is not true ! in QT 5.2 any folders and roots is different...

SGaist · wrote on 5 Jan 2014, 20:56

did you call make after that ?

? Offline · wrote on 5 Jan 2014, 21:14

I run first this command : root@Gigabyte-Z68P-DS3:~# cd /opt/Qt5.2.0/5.2.0/Src/qtbase/src/plugins/sqldrivers/mysql

after :

root@Gigabyte-Z68P-DS3:/opt/Qt5.2.0/5.2.0/Src/qtbase/src/plugins/sqldrivers/mysql# qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysql -lmysqlclient_r" mysql.pro
qmake: could not find a Qt installation of ''
root@Gigabyte-Z68P-DS3:/opt/Qt5.2.0/5.2.0/Src/qtbase/src/plugins/sqldrivers/mysql#

SGaist · wrote on 5 Jan 2014, 21:52

Are you sure you are using the right qmake ?

Also, why are you developing as root ?

? Offline · wrote on 6 Jan 2014, 16:15

[quote author="SGaist" date="1388958771"]Are you sure you are using the right qmake ?

Also, why are you developing as root ?[/quote]

I,m not sure ! for this reason I need to help. :D

SGaist · wrote on 6 Jan 2014, 22:00

what does qmake --version and which qmake return ?

? Offline · wrote on 7 Jan 2014, 12:11

[quote author="SGaist" date="1389045618"]what does qmake --version and which qmake return ?[/quote]

root@Gigabyte-Z68P-DS3:~# dpkg --get-selections | grep qmake
qt5-qmake install

and return : qmake: could not find a Qt installation of ''

SGaist · wrote on 7 Jan 2014, 17:14

Check what other Qt 5 package you have installed

? Offline · wrote on 8 Jan 2014, 20:36

Please see this :

root@Gigabyte-Z68P-DS3:~# dpkg --get-selections | grep qt
appmenu-qt install
appmenu-qt5 install
checkbox-qt install
libaccounts-qt5-1 install
libdbusmenu-qt2:amd64 install
libdbusmenu-qt2:i386 install
libdbusmenu-qt5:amd64 install
libqt4-dbus:amd64 install
libqt4-dbus:i386 install
libqt4-declarative:amd64 install
libqt4-declarative:i386 install
libqt4-designer:amd64 install
libqt4-help:amd64 install
libqt4-network:amd64 install
libqt4-network:i386 install
libqt4-opengl:amd64 install
libqt4-opengl:i386 install
libqt4-script:amd64 install
libqt4-script:i386 install
libqt4-scripttools:amd64 install
libqt4-sql:amd64 install
libqt4-sql:i386 install
libqt4-sql-mysql:amd64 install
libqt4-sql-mysql:i386 install
libqt4-sql-sqlite:amd64 install
libqt4-svg:amd64 install
libqt4-test:amd64 install
libqt4-webkit install
libqt4-xml:amd64 install
libqt4-xml:i386 install
libqt4-xmlpatterns:amd64 install
libqt4-xmlpatterns:i386 install
libqt53d5:amd64 install
libqt5core5:amd64 install
libqt5dbus5:amd64 install
libqt5gui5:amd64 install
libqt5location5:amd64 install
libqt5network5:amd64 install
libqt5opengl5:amd64 install
libqt5printsupport5:amd64 install
libqt5qml5:amd64 install
libqt5quick5:amd64 install
libqt5sensors5:amd64 install
libqt5sql5:amd64 install
libqt5sql5-mysql:amd64 install
libqt5sql5-sqlite:amd64 install
libqt5test5:amd64 install
libqt5v8-5:amd64 install
libqt5webkit5:amd64 install
libqt5widgets5:amd64 install
libqt5xml5:amd64 install
libqtassistantclient4:amd64 install
libqtcore4:amd64 install
libqtcore4:i386 install
libqtgui4:amd64 install
libqtgui4:i386 install
libqtwebkit4:amd64 install
libqtwebkit4:i386 install
libsignon-qt5-1 install
python-qt4 install
python-qt4-dbus install
qt-at-spi:amd64 install
qt5-qmake install
qtchooser install
sni-qt:amd64 install
sni-qt:i386 install
ubuntu-sso-client-qt install
ubuntuone-control-panel-qt install
root@Gigabyte-Z68P-DS3:~#

SGaist · wrote on 8 Jan 2014, 21:38

Do you also have the dev package installed ?

? Offline · wrote on 8 Jan 2014, 21:41

here :

root@Gigabyte-Z68P-DS3:~# dpkg --get-selections | grep dev

comerr-dev install
dpkg-dev install
freeglut3-dev:amd64 install
gir1.2-gudev-1.0 install
krb5-multidev install
libalut-dev install
libasprintf-dev:amd64 install
libboost1.53-dev:amd64 install
libc-dev-bin install
libc6-dev:amd64 install
libdevmapper-event1.02.1:amd64 install
libdevmapper1.02.1:amd64 install
libdrm-dev:amd64 install
libfreetype6-dev install
libgcc-4.8-dev:amd64 install
libgettextpo-dev:amd64 install
libgfortran-4.8-dev:amd64 install
libgl1-mesa-dev install
libgl2ps-dev install
libglu1-mesa-dev install
libgudev-1.0-0:amd64 install
libice-dev:amd64 install
libimobiledevice4 install
libkrb5-dev install
libmtdev1:amd64 install
libmysql++-dev install
libmysqlclient-dev install
libmysqlcppconn-dev install
libopenal-dev:amd64 install
libpcre3-dev:amd64 install
libpthread-stubs0-dev:amd64 install
libroot-core-dev install
libroot-geom-dev install
libroot-graf2d-gpad-dev install
libroot-graf2d-graf-dev install
libroot-graf3d-gl-dev install
libroot-gui-dev install
libroot-hist-dev install
libroot-io-dev install
libroot-math-mathcore-dev install
libroot-math-matrix-dev install
libroot-net-dev install
libroot-proof-dev install
libroot-tree-dev install
libsm-dev:amd64 install
libssl-dev:amd64 install
libstdc++-4.8-dev:amd64 install
libudev1:amd64 install
libudev1:i386 install
libv4l-dev:amd64 install
libx11-dev:amd64 install
libx11-xcb-dev install
libxau-dev:amd64 install
libxcb-dri2-0-dev:amd64 install
libxcb-glx0-dev:amd64 install
libxcb1-dev:amd64 install
libxdamage-dev:amd64 install
libxdmcp-dev:amd64 install
libxext-dev:amd64 install
libxfixes-dev:amd64 install
libxpm-dev:amd64 install
libxt-dev:amd64 install
libxxf86vm-dev:amd64 install
linux-libc-dev:amd64 install
makedev install
manpages-dev install
mesa-common-dev install
python-dbus-dev install
system-config-printer-udev install
udev install
unity-scope-devhelp install
x11proto-core-dev install
x11proto-damage-dev install
x11proto-dri2-dev install
x11proto-fixes-dev install
x11proto-gl-dev install
x11proto-input-dev install
x11proto-kb-dev install
x11proto-xext-dev install
x11proto-xf86vidmode-dev install
xserver-xorg-input-evdev install
xserver-xorg-video-fbdev install
xtrans-dev install
zlib1g-dev:amd64 install
root@Gigabyte-Z68P-DS3:~#

SGaist · wrote on 8 Jan 2014, 21:48

I don't see any Qt related dev package

? Offline · wrote on 8 Jan 2014, 21:50

How can I install Qt related dev package ?

SGaist · wrote on 8 Jan 2014, 21:53

IIRC you can install qt5-default then the same qt5 packages with a trailing -dev in the name

? Offline · wrote on 8 Jan 2014, 22:05

See now i installed qt dev package :

...
...
qtbase5-dev:amd64 install
qtbase5-dev-tools install
qtdeclarative5-dev install

Check latest lines...

root@Gigabyte-Z68P-DS3:~# aptitude show qt5-default
Package: qt5-default
State: installed
Automatically installed: no
Multi-Arch: same
Version: 5.0.2+dfsg1-7ubuntu11.1
Priority: optional
Section: libs
Maintainer: Ubuntu Developers ubuntu-devel-discuss@lists.ubuntu.com
Architecture: amd64
Uncompressed Size: 93.2 k
Depends: qtbase5-dev, qtchooser
Suggests: qt5-qmake, qtbase5-dev-tools
Conflicts: qt4-default, qt4-default
Breaks: qt5-default (!= 5.0.2+dfsg1-7ubuntu11.1)
Replaces: qt5-default (< 5.0.2+dfsg1-7ubuntu11.1)
Provides: qt-default
Description: Qt 5 development defaults package
Qt is a cross-platform C++ application framework. Qt's primary feature is its rich set of widgets
that provide standard GUI functionality.

This package sets Qt 5 to be the default Qt version to be used when using development binaries like
qmake. It provides a default configuration for qtchooser, but does not prevent alternative Qt
installations from being used.
Homepage: http://qt-project.org/

root@Gigabyte-Z68P-DS3:~# dpkg --get-selections | grep dev
comerr-dev install
dpkg-dev install
freeglut3-dev:amd64 install
gir1.2-gudev-1.0 install
krb5-multidev install
libalut-dev install
libasprintf-dev:amd64 install
libboost1.53-dev:amd64 install
libc-dev-bin install
libc6-dev:amd64 install
libdevmapper-event1.02.1:amd64 install
libdevmapper1.02.1:amd64 install
libdrm-dev:amd64 install
libfreetype6-dev install
libgcc-4.8-dev:amd64 install
libgettextpo-dev:amd64 install
libgfortran-4.8-dev:amd64 install
libgl1-mesa-dev install
libgl2ps-dev install
libglu1-mesa-dev install
libgudev-1.0-0:amd64 install
libice-dev:amd64 install
libimobiledevice4 install
libkrb5-dev install
libmtdev1:amd64 install
libmysql++-dev install
libmysqlclient-dev install
libmysqlcppconn-dev install
libopenal-dev:amd64 install
libpcre3-dev:amd64 install
libpthread-stubs0-dev:amd64 install
libqt5opengl5-dev:amd64 install
libroot-core-dev install
libroot-geom-dev install
libroot-graf2d-gpad-dev install
libroot-graf2d-graf-dev install
libroot-graf3d-gl-dev install
libroot-gui-dev install
libroot-hist-dev install
libroot-io-dev install
libroot-math-mathcore-dev install
libroot-math-matrix-dev install
libroot-net-dev install
libroot-proof-dev install
libroot-tree-dev install
libsm-dev:amd64 install
libssl-dev:amd64 install
libstdc++-4.8-dev:amd64 install
libudev1:amd64 install
libudev1:i386 install
libv4l-dev:amd64 install
libx11-dev:amd64 install
libx11-xcb-dev install
libxau-dev:amd64 install
libxcb-dri2-0-dev:amd64 install
libxcb-glx0-dev:amd64 install
libxcb1-dev:amd64 install
libxdamage-dev:amd64 install
libxdmcp-dev:amd64 install
libxext-dev:amd64 install
libxfixes-dev:amd64 install
libxpm-dev:amd64 install
libxt-dev:amd64 install
libxxf86vm-dev:amd64 install
linux-libc-dev:amd64 install
makedev install
manpages-dev install
mesa-common-dev install
python-dbus-dev install
qtbase5-dev:amd64 install
qtbase5-dev-tools install
qtdeclarative5-dev install
system-config-printer-udev install
udev install
unity-scope-devhelp install
x11proto-core-dev install
x11proto-damage-dev install
x11proto-dri2-dev install
x11proto-fixes-dev install
x11proto-gl-dev install
x11proto-input-dev install
x11proto-kb-dev install
x11proto-xext-dev install
x11proto-xf86vidmode-dev install
xserver-xorg-input-evdev install
xserver-xorg-video-fbdev install
xtrans-dev install
zlib1g-dev:amd64 install
root@Gigabyte-Z68P-DS3:~#

SGaist · wrote on 9 Jan 2014, 08:28

Did you retry to run qmake now ?

? Offline · wrote on 9 Jan 2014, 08:38

[quote author="SGaist" date="1389256104"]Did you retry to run qmake now ?[/quote]

Ok...

Yes... please see again an error:

root@Gigabyte-Z68P-DS3:/opt/Qt5.2.0/5.2.0/Src/qtbase/src/plugins/sqldrivers/mysql# qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysql -lmysqlclient_r" mysql.pro

Project ERROR: addExclusiveBuilds() requires at least two arguments

SGaist · wrote on 9 Jan 2014, 09:00

Since you installed Qt 5.2 Why didn't you use the qmake from that Qt rather than the one from the system ?

? Offline · wrote on 9 Jan 2014, 09:11

Well , I want to build mysql plugin for Qt 5.2 !
I get error message : QMySQL driver not found loaded.

I try test with a minimal code :

Main :

@
#include <QCoreApplication>
#include <QtSql/QSqlDatabase>
#include <QtSql>
#include <QDebug>

//remplacer l'affichage par la commande cout
#define q2c(string) string.toStdString()

int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
   db.setHostName("localhost");
   db.setDatabaseName("qtdatabase");
   db.setUserName("root");
   db.setPassword("");
   bool ok = db.open();

return a.exec&#40;&#41;;

}

@

and .pro :

@
#-------------------------------------------------

Project created by QtCreator 2014-01-01T09:22:46

#-------------------------------------------------

QT += core
QT += sql
QT -= gui

TARGET = untitled18
CONFIG += console
CONFIG -= app_bundle

QTPLUGIN += qsqlmysql
TEMPLATE = app

SOURCES += main.cpp

@