QSqlDatabase: QMYSQL driver not loaded / Build MySQL Plugin

[Peter Van Grieken]

Thanks!

I'll take a good look at the PATH variable.

[SGaist]

Leave it clean, that way you ensure that you're not mixing things on your system while building the driver.

[RalfSchaefer]

Hi,

i'm facing a similiar sort of problem, not completely solvable by the steps above.
I recompiled the QMYSQL-plugin and it's linked to the correct mysql-libraries.
After doing ldd /opt/Qt/5.5/gcc_64/plugins/sqldrivers/libqsqlmysql.so I got this:

ldd /opt/Qt/5.5/gcc_64/plugins/sqldrivers/libqsqlmysql.so 
       linux-vdso.so.1 (0x00007fffd7d83000)
       libmysqlclient.so.18 => /usr/lib64/libmysqlclient.so.18 (0x00007f9eb8607000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f9eb83f0000)
        libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f9eb81b5000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f9eb7f9d000)
        libssl.so.1.0.0 => /lib64/libssl.so.1.0.0 (0x00007f9eb7d34000)
        libcrypto.so.1.0.0 => /lib64/libcrypto.so.1.0.0 (0x00007f9eb7941000)
        libQt5Sql.so.5 => /opt/Qt/5.5/gcc_64/lib/libQt5Sql.so.5 (0x00007f9eb7701000)
        libQt5Core.so.5 => /opt/Qt/5.5/gcc_64/lib/libQt5Core.so.5 (0x00007f9eb6fba000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9eb6d9d000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f9eb6a1b000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f9eb6719000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f9eb6502000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f9eb615b000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f9eb5f56000)
        libicui18n.so.54 => /opt/Qt/5.5/gcc_64/lib/libicui18n.so.54 (0x00007f9eb5ae8000)
        libicuuc.so.54 => /opt/Qt/5.5/gcc_64/lib/libicuuc.so.54 (0x00007f9eb5739000)
        libicudata.so.54 => /opt/Qt/5.5/gcc_64/lib/libicudata.so.54 (0x00007f9eb3d0f000)
        libgthread-2.0.so.0 => /usr/lib64/libgthread-2.0.so.0 (0x00007f9eb3b0d000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f9eb3904000)
        libglib-2.0.so.0 => /usr/lib64/libglib-2.0.so.0 (0x00007f9eb35f5000)
        /lib64/ld-linux-x86-64.so.2 (0x000055fc1f3d8000)
        libpcre.so.1 => /usr/lib64/libpcre.so.1 (0x00007f9eb338e000)

So, erverything looks fine here.

When I try to connect to the database, it still doesn't work. It seems, QSqlDatabase loads the plugin without problems, setting dabase specific stuff fails.

My code-snippet, containing additional debug-stuff:

    QPluginLoader loader;
    loader.setFileName("/opt/Qt/5.5/gcc_64/plugins/sqldrivers/libqsqlmysql.so");
    qDebug() << "PluginLoader worked =" << loader.load();
    qDebug() << "Plugin Loader error=" << loader.errorString();

    QStringList driverlist =QSqlDatabase::drivers();
    qDebug() << "Databases: ";
    for (int i = 0; i < driverlist.size(); ++i)
    {
        qDebug() << driverlist.at(i);
    }

    if (!db_opened)
    {
            db = new QSqlDatabase();
            qDebug() << "Step 1 - Database:    is valid=" << db->isValid();
            db->addDatabase("QMYSQL3","cooptimedb");
            qDebug() << "Step 2 - Database:    is valid=" << db->isValid();

            db->setHostName("localhost");
            db->setDatabaseName("cooptime");
            db->setUserName("cooptime");
            db->setPassword("...");
            db->setPort(3306);

            qDebug() << "Database\n========\nHostname: " << db->hostName() << "\nDatabasename: " << db->databaseName() << "\nUsername: " << db->userName() << "\nPassword: " << db->password()  << "\nPort: " << db->port();


            if (! db->open())
            {
                qDebug() << "db errorcode=" <<  db->lastError().nativeErrorCode();
                qDebug() << "db errormessage=" << db->lastError() .text();
            }

The output of the code above is:

PluginLoader worked = true
Plugin Loader error= "Unknown error"
Databases: 
"QSQLITE"
"QMYSQL"
"QMYSQL3"
"QPSQL"
"QPSQL7"
Step 1 - Database:    is valid= false
Step 2 - Database:    is valid= false
Database
========
Hostname:  "" 
Databasename:  "" 
Username:  "" 
Password:  "" 
Port:  -1
db errorcode= ""
db errormessage= "Driver not loaded Driver not loaded"

So it seems, the driver still doesn't load.

Any help would be very appreciated. Thanks in advance.

[SGaist]

Hi and welcome to devnet,

Your code is wrong, you are creating an invalid QSqlDatabase object on the heap and then you call a static function on it.

Please take a look at QSqlDatabase's detailed documentation. There's an example there on how to do the setup and connection.

[RalfSchaefer]

@SGaist Thanks for your help!! That's it. Now all works fine for me!

[fikou1335]

Hi SGaist,

I have a new problem with QMysql, everything worked fine since today, actually when I executede this line

    DB = QSqlDatabase::addDatabase( "QMYSQL");

I have this error

libgcc_s.so.1 must be installed for pthread_cancel to work

I don't know why,

the plugin is correctly compiled without error, and using the ldd he found the libgcc_s.so.1

Can you help me please!

[SGaist]

Hi and welcome to devnet,

Which architecture are on ?

[fikou1335]

Hi and thanks for your quick response

I m working on Ubuntu 64bits
i got this

Precision-M4600:/usr/local/Trolltech/Qt-4.8.6/plugins/sqldrivers$ ldd libqsqlmysql.so 	linux-vdso.so.1 =>  (0x00007ffceb314000)
	libmysqlclient.so.18 => /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18 (0x00007f7a884c6000)
	libQtSql.so.4 => /usr/local/Trolltech/Qt-4.8.6/lib/libQtSql.so.4 (0x00007f7a88285000)
	libQtCore.so.4 => /usr/local/Trolltech/Qt-4.8.6/lib/libQtCore.so.4 (0x00007f7a87d91000)
	libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f7a87a7f000)
	libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f7a87868000)
	libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f7a874a3000)
	libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f7a8728a000)
	libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f7a87086000)
	libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f7a86e68000)
	libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f7a86b62000)
	librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f7a8695a000)
	/lib64/ld-linux-x86-64.so.2 (0x00007f7a88c10000)

and this

Precision-M4600:/usr/lib/x86_64-linux-gnu$ ldd libmysqlclient.so.18
	linux-vdso.so.1 =>  (0x00007ffe50bc0000)
	libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fe8f4940000)
	libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fe8f473c000)
	libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fe8f451e000)
	libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fe8f4218000)
	libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fe8f3e53000)
	/lib64/ld-linux-x86-64.so.2 (0x00007fe8f5091000)

If I comment the addBase line in my code everything works fine without connecting to the Database of course.
when I try to list the drivers using

QStringList driverlist =QSqlDatabase::drivers();

I got this

Databases: QSQLITE QMYSQL3 QMYSQL

Everything works fine Monday, I checked the database, I could write on it fine,, but yesterday, it crash my application
hope it can help!

[fikou1335]

I have just created a new app with the main function and it works and connect fine to my database.

In my code I comment all the last code that I added this week and SURPRISE it works as well.
the problem is probably due to a third library that i started to use this week. I ll check why it cause a crach to mysql o_O

[SGaist]

What new library did you add ?

[fikou1335]

This one Dahua SDK

You can check by yourslef, they have a source example, PTZControl that works fine, but try to add

      DB = QSqlDatabase::addDatabase( "QMYSQL");   

and you should get the same error.

this sdk is used to control PTZ cams of Dahua brand.
I changed my code by creating a new app to control cameras and get the informations of position from my big application.

put this main instsead of it

#include <QtGui/QApplication>
#include "dialog.h"
#include <QTextCodec>
#include <QObject>
#include <QtSql/QSqlDatabase>
#include <QStringList>
#include <QtSql/QSqlQuery>
#include <QtSql/QSqlRecord>
#include <QVariant>
#include <iostream>



int main(int argc, char *argv[])
{
    QSqlDatabase DB;
    cout <<endl<< "try connect MYSQL "<< endl;
    try
    {
        DB = QSqlDatabase::addDatabase( "QMYSQL");
    }
    catch(...)
    {
        cout << "fatal error"<< endl;
    }
    cout << "add database"<< endl;
    DB.setDatabaseName( "intrusiondetection" );
    DB.setUserName( "root" );

    DB.setPassword( "root" );
    cout << "1"<< endl;

    DB.setHostName( "" );

    cout << "try to connect"<< endl;
    if (DB.open())
    {
        cout << "QMYSQL correctly connected "<< endl;
    }
    else
    {
        cout << "QMYSQL not connected "<< endl;
    }


    QApplication a(argc, argv);
    QTextCodec::setCodecForCStrings(QTextCodec::codecForName("UTF-8"));
    Dialog w;
    w.show();

    return a.exec();
}

tell me if you got the same error.?

[SGaist]

One thing that you should first correct: move the database initialization code after the QApplication object creation.

[fikou1335]

i already tried every configuration but doesn't work! just a question by the way:
Is the QDbus available on the Ubuntu system since they said it is Unix only library..? I try to communicate between PTZcontrol process and my application

[SGaist]

Ubuntu is a unix based OS since it's based on the Debian distribution. QDBus is available on Linux, OS X and Windows (the two later requires that you install dbus by hand)

[Hervinsen]

Thanks to your guide, it is working on Kubuntu 16 with Qt 5.8
here is my output :

• /opt/Qt5.8.0/5.8/gcc_64/plugins/sqldrivers$ ldd libqsqlmysql.so
  linux-vdso.so.1 => (0x00007ffcf0bf4000)
  libQt5Sql.so.5 => /opt/Qt5.8.0/5.8/gcc_64/plugins/sqldrivers/./../../lib/libQt5Sql.so.5 (0x00007f28a7452000)
  libQt5Core.so.5 => /opt/Qt5.8.0/5.8/gcc_64/plugins/sqldrivers/./../../lib/libQt5Core.so.5 (0x00007f28a6d32000)
  libmysqlclient.so.20 => /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 (0x00007f28a66fa000)
  libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f28a6372000)
  libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f28a5fa2000)
  libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f28a5d82000)
  libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f28a5a72000)
  libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f28a585a000)
  libicui18n.so.56 => /opt/Qt5.8.0/5.8/gcc_64/plugins/sqldrivers/./../../lib/libicui18n.so.56 (0x00007f28a53ba000)
  libicuuc.so.56 => /opt/Qt5.8.0/5.8/gcc_64/plugins/sqldrivers/./../../lib/libicuuc.so.56 (0x00007f28a5002000)
  libicudata.so.56 => /opt/Qt5.8.0/5.8/gcc_64/plugins/sqldrivers/./../../lib/libicudata.so.56 (0x00007f28a361a000)
  libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f28a3412000)
  librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f28a320a000)
  libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f28a2fea000)
  libgthread-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007f28a2de2000)
  libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f28a2aca000)
  /lib64/ld-linux-x86-64.so.2 (0x0000560448d0b000)
  libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f28a285a000)

[Amit Talbot]

im using qt 5.9 on mac this piece of code worked like charm for me

brew install mysql-connector-c