QMYSQL Driver (undefined symbol: mysql_server_init)

[przemek]

Hello,
I have problem with app with mysql.
When I run app with mysql I get:

symbol lookup error: /usr/local/Trolltech/QtEmbedded-4.6.2-arm/plugins/sqldrivers/libqsqlmysql.so: undefined symbol: mysql_server_init

symbol lookup error: /usr/local/Trolltech/QtEmbedded-4.6.2-arm/plugins/sqldrivers/libqsqlmysql.so: undefined symbol: mysql_server_init

To copy to clipboard, switch view to plain text mode 

I run app on ARM-board with mysql ver. 14.14 distrib 5.1.40, for angstrom-linux-gnueabi (arm) using EditLine wrapper.

I built database drivers using:

qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysqlclient_r" mysql.pro
make

qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysqlclient_r" mysql.pro
make

To copy to clipboard, switch view to plain text mode 

on Ubuntu without errors.

I don't know where is error.. Could you help me?

thanks,
Przemek

[saa7_go]

Try to recompile the driver using:

qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib -lmysqlclient_r" mysql.pro
make

qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib -lmysqlclient_r" mysql.pro
make

To copy to clipboard, switch view to plain text mode 

[przemek]

Try to recompile the driver using:

qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib -lmysqlclient_r" mysql.pro
make

qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib -lmysqlclient_r" mysql.pro
make

To copy to clipboard, switch view to plain text mode 

in result I get:

cannot find -lmysqlclient_r"

cannot find -lmysqlclient_r"

To copy to clipboard, switch view to plain text mode 

[saa7_go]

Is there any libmysql*.a in /usr/lib?

[przemek]

yes, in /usr/lib I have:

-rw-r--r--  1 root root  2819966 2010-06-07 21:58 libmysqlclient.a
-rw-r--r--  1 root root     1068 2010-06-07 21:57 libmysqlclient.la
-rw-r--r--  1 root root  2834652 2010-06-07 21:58 libmysqlclient_r.a
-rw-r--r--  1 root root     1122 2010-06-07 21:57 libmysqlclient_r.la
lrwxrwxrwx  1 root root       22 2010-07-08 16:31 libmysqlclient_r.so -> libmysqlclient_r.so.16
lrwxrwxrwx  1 root root       26 2010-07-08 16:31 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
-rw-r--r--  1 root root  2047772 2010-06-07 21:58 libmysqlclient_r.so.16.0.0
lrwxrwxrwx  1 root root       20 2010-07-08 16:31 libmysqlclient.so -> libmysqlclient.so.16
lrwxrwxrwx  1 root root       24 2010-07-08 16:31 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
-rw-r--r--  1 root root  2039580 2010-06-07 21:58 libmysqlclient.so.16.0.0

-rw-r--r--  1 root root  2819966 2010-06-07 21:58 libmysqlclient.a
-rw-r--r--  1 root root     1068 2010-06-07 21:57 libmysqlclient.la
-rw-r--r--  1 root root  2834652 2010-06-07 21:58 libmysqlclient_r.a
-rw-r--r--  1 root root     1122 2010-06-07 21:57 libmysqlclient_r.la
lrwxrwxrwx  1 root root       22 2010-07-08 16:31 libmysqlclient_r.so -> libmysqlclient_r.so.16
lrwxrwxrwx  1 root root       26 2010-07-08 16:31 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
-rw-r--r--  1 root root  2047772 2010-06-07 21:58 libmysqlclient_r.so.16.0.0
lrwxrwxrwx  1 root root       20 2010-07-08 16:31 libmysqlclient.so -> libmysqlclient.so.16
lrwxrwxrwx  1 root root       24 2010-07-08 16:31 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
-rw-r--r--  1 root root  2039580 2010-06-07 21:58 libmysqlclient.so.16.0.0

To copy to clipboard, switch view to plain text mode 

[saa7_go]

When I run app with mysql I get:

symbol lookup error: /usr/local/Trolltech/QtEmbedded-4.6.2-arm/plugins/sqldrivers/libqsqlmysql.so: undefined symbol: mysql_server_init

symbol lookup error: /usr/local/Trolltech/QtEmbedded-4.6.2-arm/plugins/sqldrivers/libqsqlmysql.so: undefined symbol: mysql_server_init

To copy to clipboard, switch view to plain text mode 

I think you successfully build qmysql driver. How did you build it?

[przemek]

My *cpp, *pro files and Makefile in attachments.
Do you think, that it could be problem with my linux on arm, or ubuntu, qt, or etc.?
I haven't got any idea how to solve my problem.
Maybe I should recompile all qt?

edit:
I recompile plugin on other computer and copy libqsqlmysql.so to arm-board and now I have message:

QSqlDatabase: QMYSQL driver not loaded

QSqlDatabase: QMYSQL driver not loaded

To copy to clipboard, switch view to plain text mode 

[saa7_go]

My *cpp, *pro files and Makefile in attachments.
Do you think, that it could be problem with my linux on arm, or ubuntu, qt, or etc.?
I haven't got any idea how to solve my problem.
Maybe I should recompile all qt?

edit:
I recompile plugin on other computer and copy libqsqlmysql.so to arm-board and now I have message:

QSqlDatabase: QMYSQL driver not loaded

QSqlDatabase: QMYSQL driver not loaded

To copy to clipboard, switch view to plain text mode 

I don't know. BTW, Do you use mysql from your host operating system(ubuntu) or angstrom?

[miroslavgojic]

Touday I tray to resolve this QMSQL

But no chance with qmake

I recive next message qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib -lmysqlclient_r" mysql.pro

Error processing project file: /usr/lib/qt4/plugins/sqldrivers/mysql/mysql.pro

and QT will not make application witout this mysql driver

I have ubuntu and QT4

Can somebody help

Please

[saa7_go]

Touday I tray to resolve this QMSQL

But no chance with qmake

I recive next message qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib -lmysqlclient_r" mysql.pro

Error processing project file: /usr/lib/qt4/plugins/sqldrivers/mysql/mysql.pro

and QT will not make application witout this mysql driver

I have ubuntu and QT4

Can somebody help

Please

Do you run qmake as root or using sudo?

[miroslavgojic]

I use

$ sudo su

$ sudo su

To copy to clipboard, switch view to plain text mode 

for entering as root

[saa7_go]

Maybe, there is a problem with your mysql.pro. Can you attach it here?

[miroslavgojic]

I don't have mysql.pro

that file is not available on my Ubuntu,

[saa7_go]

What i mean is this /usr/lib/qt4/plugins/sqldrivers/mysql/mysql.pro. If mysql.pro doesn't exist, i assume you install Qt from your package management. Maybe you can search Qt MySQL plugin package using synaptic or something like that.

[miroslavgojic]

yes, I was install Qt from synaptic install manager

I install all package but mysql.pro is not present

and I have qt4 and qt3, can this make problems

[saa7_go]

I install all package but mysql.pro is not present.
and I have qt4 and qt3, can this make problems.

I'm not sure. But, have you search Qt4 MySQL plugin using synaptic?

[miroslavgojic]

I have look in synaptic and I have Qt mysql driver, it is installed at my Ubuntu

Qt4 Mysql database driver - this is name of synaptic package

[saa7_go]

So, you don't need to rebuilt Qt MySQL driver. Try to create simple application using MySQL driver.

[miroslavgojic]

I try to create simply application Qt and Mysql
and there I find some unexpected problems.

I make one project on C not C++, and it work, but this is not from QT, simply C code from gedit and gcc

I have one project in QT

one file is

connector.h

#ifndef CONNECTOR_H
#define CONNECTOR_H
#include <QSqlDatabase>
#include <QMessageBox>
 
bool createConnection()
{
    if (QSqlDatabase::isDriverAvailable("QMYSQL"))
    {
         QSqlDatabase db = QSqlDatabase.addDatabase("QMYSQL");
        db.setHostName("localhost");
        db.setDatabaseName("test");
        db.setUserName("user");
        db.setPassword("pass");
 
            if (!db.open())
            {
                QMessageBox m;
                m.setText("Greska I");
                m.exec();
                return false;
            }
        else
            {
                return true;
            }
    }
    else
    {
        QMessageBox m;
        m.setText("Nema drajver za DB");
        m.exec();
        return false;
    }
 
}
 
#endif // CONNECTOR_H

#ifndef CONNECTOR_H
#define CONNECTOR_H
#include <QSqlDatabase>
#include <QMessageBox>

bool createConnection()
{
    if (QSqlDatabase::isDriverAvailable("QMYSQL"))
    {
         QSqlDatabase db = QSqlDatabase.addDatabase("QMYSQL");
        db.setHostName("localhost");
        db.setDatabaseName("test");
        db.setUserName("user");
        db.setPassword("pass");

            if (!db.open())
            {
                QMessageBox m;
                m.setText("Greska I");
                m.exec();
                return false;
            }
        else
            {
                return true;
            }
    }
    else
    {
        QMessageBox m;
        m.setText("Nema drajver za DB");
        m.exec();
        return false;
    }

}

#endif // CONNECTOR_H

To copy to clipboard, switch view to plain text mode 

and main.cpp

#include <QtGui/QApplication>
#include "mainwindow.h"
#include "connector.h"
 
int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
 
    if(!createConnection())
        return 1;
 
    MainWindow w;
    w.show();
    return a.exec();
}

#include <QtGui/QApplication>
#include "mainwindow.h"
#include "connector.h"

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

    if(!createConnection())
        return 1;

    MainWindow w;
    w.show();
    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

and this project not work at QT

[saa7_go]

Are there any error/warning messages from your application?