Problem with QMYSQLDriver

[DoubleC122]

So here is the problem. I'm trying to connect to a mySQL database (localhost). I'm using the mysqlConnector driver from mySQL in conjunction with the QMYSQLDriver and QSqlDatabase classes in Qt. The problem arose when I was trying to use QMYSQLDriver. At first, it said that "QMYSQLDriver was not declared in this scope". After a bit of search I found out that if I included "qsqldriver_p.h" it should do the work. Unfortunately, after I got rid of that first error, now it says that in the qsqldriver_p.h file it prints the error "QtSql/private/qtsqlglobal_p.h no such file or directory". I surfed to almost any kind of forum, including qt ones, but I can't seem to make it work. I have all possible mysql libs. Qt version is 5.9.1. I would like to mention that I also looked upon similar problems regardin the qtsqlglobal_p .h file but apparently nothing from there helped me. I would be really glad if someone could help me.

[mrjj]

Hi
Why should you be using the _p.h private classes ?
Normally that is not needed or recommended.

You do have QT += sql in the .pro file ?

[DoubleC122]

Yes, I do have QT += sql. The problem is, normally if I don't include qsqldriver_p.h for example, I get: 'QMYSQLDriver was not declared in this scope'. I spent a day to try and find the solution but nothing worked except this. Of course, that didn't solve the problem entirely, hence my topic here.

[mrjj]

Hi
Did you build your own version of it ?
https://forum.qt.io/topic/59449/qsqldatabase-qmysql-driver-not-loaded-build-mysql-plugin

You should try
ldd to libqsqlmysql.so
and see if anything missing.

[DoubleC122]

Oh yes, I almost forgot about that. I tried to build it once, but I had problems with a certain library. Now I'm sure I have everything I need, so when I run qmake I don't get any message back (I'm not sure if that is a good sign). After that I run make, but I get 'make: Nothing to be done for 'first'. '.

[mrjj]

@DoubleC122
But it does build the actual .SO file?
Also what does
ldd libqsqlmysql.so
lists ?
any missing so files?

[DoubleC122]

So ldd libqsqlmysql.so returns this:

    linux-vdso.so.1 =>  (0x00007ffe14188000)
    libQt5Sql.so.5 => /home/catalin/Qt/5.9.1/gcc_64/plugins/sqldrivers/./../../lib/libQt5Sql.so.5 (0x00007fe6c35e1000)
    libQt5Core.so.5 => /home/catalin/Qt/5.9.1/gcc_64/plugins/sqldrivers/./../../lib/libQt5Core.so.5 (0x00007fe6c2ea7000)
    libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fe6c2c88000)
    libmysqlclient.so.18 => /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18 (0x00007fe6c273d000)
    libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007fe6c23b7000)
    libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fe6c2061000)
    libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007fe6c1e4a000)
    libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fe6c1a6a000)
    libicui18n.so.56 => /home/catalin/Qt/5.9.1/gcc_64/plugins/sqldrivers/./../../lib/libicui18n.so.56 (0x00007fe6c15d1000)
    libicuuc.so.56 => /home/catalin/Qt/5.9.1/gcc_64/plugins/sqldrivers/./../../lib/libicuuc.so.56 (0x00007fe6c1219000)
    libicudata.so.56 => /home/catalin/Qt/5.9.1/gcc_64/plugins/sqldrivers/./../../lib/libicudata.so.56 (0x00007fe6bf836000)
    libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fe6bf619000)
    libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fe6bf415000)
    libgthread-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007fe6bf213000)
    libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007fe6beeff000)
    /lib64/ld-linux-x86-64.so.2 (0x00007fe6c3a3b000)
    librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007fe6becf7000)
    libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007fe6bea85000)

Apparently there is none missing.

[mrjj]

Hi
Nope it looks good.
libmysqlclient.so.18 is a bit newer than i normally see but should work fine, i assume.

Also the error
"QMYSQLDriver was not declared in this scope"

does not sound the normal errors . ( driver not loaded )

Do it say it for your Qt code ?

[DoubleC122]

Ok, I'll try to get into a bit more detail. Even though it shouldnt be a major factor I guess, I have a QtWidget project and in the source file, in the constructor of the mainwindow, I typed QMYSQLDriver *drv = new QMYSQLDriver(con);. The major error is that one, but I also get "drv was not declared in this scope" (which seems fine, since it doesnt even recognize QMYSQLDriver), and also "expected type-specifier before QMYSQLDriver". Not sure how much of this is helping. Also, regarding the .so file generation, pardon my ignorance, but I'm not very accustomed with makefiles and such. The .so file should be generated in the very same file? Because if so, I don't have any .so right there.

[mrjj]

Hi
Normally it build in same folder or just a folder above it.

Im wondering if your use case is different from normal use.
Normally you dont new a driver yourself, but uses it via the Databaseclass
something like. ( not tested as i dont have mysql installed here)

#include "mainwindow.h"
#include <QApplication>
#include <QWidget>
#include <QtSql>
#include <QDebug>
#include "qsqldriver.h"


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

QString servername = "LOCALHOST//QMYSQL";
QString dbname = "test";
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");

db.setConnectOptions();

QString dsn = QString("DRIVER={SQL Native Client};SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(servername) .arg(dbname);

db.setDatabaseName(dsn);

if(db.open()){
    qDebug() << "Opened";
    db.close();
}
else{
    qDebug() << "Error =" << db.lastError().text();
    qDebug ( )  <<  QSqlDatabase :: drivers ( );
}

MainWindow w;

w.show();

return a.exec();
}

[DoubleC122]

Well yes if I use QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); it doesn't return any error. But what I wanted to do actually is doing what I saw in the QSqlDatabase help document in Qt. There it said I could use another driver (in this case the mySqlConnector) and use it through the QMYSQLDriver class. In the help document I followed the example (of course I used mySQL, not Postgres):

#include "qtdir/src/sql/drivers/psql/qsql_psql.cpp"

PGconn *con = PQconnectdb("host=server user=bart password=simpson dbname=springfield");
QPSQLDriver *drv = new QPSQLDriver(con);
QSqlDatabase db = QSqlDatabase::addDatabase(drv); // becomes the new default connection
QSqlQuery query;
query.exec("SELECT NAME, ID FROM STAFF");
...

[mrjj]

Hi
Ahhh. never tried that :)

it goes
#include "qtdir/src/sql/drivers/psql/qsql_psql.cpp"
QPSQLDriver *drv = new QPSQLDriver(con);

So I assumed you tried with
#include "qtdir\qtbase\src\plugins\sqldrivers\mysql\qsql_mysql.cpp"
QMYSQLDriver

and got errors ?

[DoubleC122]

Yes indeed, I followed that example but for QMYSQL. I stopped right after instantiating the drv pointer because it was not recognizing the QMYSQLDriver.

[mrjj]

@DoubleC122
and you changed the path to points to the mysql. cpp file ?
(the class is defined there)

[DoubleC122]

Yes, I changed everything there to go as it should. But apparently it didnt. I included just like this: #include "/home/catalin/Qt/5.9.1/Src/qtbase/src/plugins/sqldrivers/mysql/qsql_mysql.cpp". And Qt recognizes it. I also checked if there was actually that .cpp file there just to be sure, even if it is redundant to do so.

[mrjj]

@DoubleC122
and this .cpp should include the .h file and the object should be known. hmm.
Its not inside namespace or anything that would prevent it from knowing type ?

[DoubleC122]

Not really, I tried using that even in a simple non Qt project, to see if at least that would do, but it didn't. For instance, in a simple blank project, I include whatever I need, plus the mysql connector header files and the path to the .cpp. Then, in main, I have just these lines:

sql::Driver *driver;
sql::Connection *con;

driver = get_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "root", "root");

QMYSQLDriver *drv = new QMYSQLDriver(con);

And it says that #include <QtSql/private/qsqldriver_p.h> and #include <QtSql/private/qsqlresult_p.h> 'no such file or directory'. These are included in the qsql_mysql.cpp file. I certainly have those headers, since I looked a thousand times for them. If I try to include them 'manually', pretty much as I did for the qsql_mysql.cpp, it works, but I don't feel like it's a good idea also because then it moves on the other headers inside those I included and says the same error. Maybe the headers in qsql_mysql.cpp point somewhere else than where I looked for, I really have no idea.

[mrjj]

Hi
I wonder if you need something like (in .pro file)
QT += gui-private
as we do for other private headers.
(looking for right name)

[DoubleC122]

@mrjj said in Problem with QMYSQLDriver:

gui-private

Unfortunately it doesnt change anything. Actually, I saw something else. If I just include the .cpp file without writing anything else, it shows me the header errors. Before, it showed me that the QMYSQLDriver was not declared in this scope, now if I just include the .cpp file, it shows me this error, which it didn't before.

[SGaist]

Hi,

That would be sql-private. But from a quick look the plugin headers are not exported.