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