QMYSQL driver not loaded, but source file not found to rebuild

rhonaldjr

Have tried all these links & forums:

https://forum.qt.io/topic/73732/qt-mysql-support
https://forum.qt.io/topic/73577/qt5-8-0-mysql-driver-not-found
https://forum.qt.io/topic/69280/integration-mysql-and-qt5-7/10

Look like most of the newbies gave up after a bit of try

SGaist

Hi and welcome to devnet,

2 solutions:

Use your distribution provided Qt
Build the plugin yourself.

For 2:

Download the Qt sources through e.g. the Maintenance tool
Install the MySQL dev package for your distribution
Follow the documentation on how to build the plugin
Don't forget to call make install once built.

SGaist

By the way, the plugin sources are in qtbase.

rhonaldjr

@SGaist thanks, worked, but found another error saying that the Qt5 Kit is not a valid one. After a bit of searching, I had to install "qt5-default" to resolve this.

Thanks a lot.

SGaist

How did you setup Qt ?

Looks like you are mixing the one from your distribution and the one from the official installer.

walter-j

I have the same problem. i got the error MYSQdriver not loaded and i have followed all suggestions in forums but the issue is not fixed. can someone help me please?

thanks,

JK

SGaist

Hi and welcome to devnet,

What exactly don't work ?
What error are you getting ?
Did you follow the step by step guide I wrote earlier ?
If so, did one of the point fail at any time ?
What version of Qt are you using ?
On what OS ?
With what compiler ?

walter-j

im using linux mint 18. Qt version 5.1.1. i received this error: mysql driver not loaded. yes i have try all these suggestions but i don't know how to begin since im new in linux

walter-j

ldd /home/walter-j/Qt5.1.1/5.1.1/gcc_64/plugins/sqldrivers/libqsqlmysql.so
linux-vdso.so.1 => (0x00007ffedfdda000)
libmysqlclient_r.so.16 => /usr/lib/x86_64-linux-gnu/libmysqlclient_r.so.16 (0x00007f949e3a8000)
libQt5Sql.so.5 => /home/walter-j/Qt5.1.1/5.1.1/gcc_64/plugins/sqldrivers/../../lib/libQt5Sql.so.5 (0x00007f949e169000)
libQt5Core.so.5 => /home/walter-j/Qt5.1.1/5.1.1/gcc_64/plugins/sqldrivers/../../lib/libQt5Core.so.5 (0x00007f949dade000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f949d75c000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f949d393000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f949d175000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f949ce6c000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f949cc52000)
libicui18n.so.51 => /home/walter-j/Qt5.1.1/5.1.1/gcc_64/plugins/sqldrivers/../../lib/libicui18n.so.51 (0x00007f949c838000)
libicuuc.so.51 => /home/walter-j/Qt5.1.1/5.1.1/gcc_64/plugins/sqldrivers/../../lib/libicuuc.so.51 (0x00007f949c4b2000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f949c2ae000)
libgthread-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007f949c0ab000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f949bea3000)
libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f949bb92000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f949b97b000)
/lib64/ld-linux-x86-64.so.2 (0x000055c820f7a000)
libicudata.so.51 => /home/walter-j/Qt5.1.1/5.1.1/gcc_64/plugins/sqldrivers/../../lib/libicudata.so.51 (0x00007f949a232000)
libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f9499fc1000)

SGaist

Did you also print the exact error you got ?

The plugin looks fine.

walter-j

0_1481840852645_upload-a114047b-129c-4c7a-b22d-5f25d662ab65

#include <QCoreApplication>

#include <QtSql/QSql>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlDriver>
#include <QtSql/QSqlQuery>
#include <QDebug>

bool createConnection();

int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
if (!createConnection()){
qDebug() << "Not connected!";
return 1;
}
else{
qDebug() << "Connected";
QSqlQuery query;
query.exec("SELECT name FROM student");

    while (query.next()) {
        QString name = query.value(0).toString();
        qDebug() << "name:" << name;
    }
    return 0;
}

return a.exec();

}

bool createConnection() {

// QApplication::addLibraryPath("/home/walter-j/Qt5.1.1/5.1.1/gcc_64/plugins/sqldrivers");
QSqlDatabase db = QSqlDatabase::addDatabase("QSLITE");
db.setHostName("localhost");
db.setDatabaseName("test.db");
db.setUserName("root");
db.setPassword("");
// db.setPort(3306);
// QSqlDriver *driver = QSqlDatabase::database().driver();
if(!db.open()){
qDebug() << "Database error occurred";
return false;
}

return true;

}

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

Project created by QtCreator 2016-12-15T19:04:16

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

QT += core sql

QT -= gui

TARGET = test
CONFIG += console
CONFIG -= app_bundle

TEMPLATE = app

SOURCES += main.cpp

walter-j

the plugin looks fine but im still getting a error. i don'tknow exactly what wrong

SGaist

You are not use the MySQL driver and you are using the wrong name for the SQLite driver. It's QSQLITE .

walter-j

i tried mysql, sqlite, postgres i m having the same error

SGaist

Print the text returned by db.lastError()

Just saying that it doesn't work with the "Driver not loaded" message doesn't help much.

Based on your current code, it's not really surprising:

You gave the driver name wrong.
You are mixing the setup for the sqlite driver with the setup for a server based database.

One other important detail: do you have any of the SQL server running on your machine to connect to ? Is it properly configured ?

walter-j

Thank you dear friend .

You're right . the drivers names were wrong . it works now