Qt and MySQL Database Connection

[shamik]

hiii,

Please help me connect Qt and MySQL in Linux(RH9). I am using Qt 3.3.0 and MySQL 5.0.0 alpha.

I am not able to do database connection in Qt with MySQL.

When I go to "project->database connections" the only driver that is listed is "QMYSQL3" and after providing the information in all the fields when i click "connect" then the whole window disappears and I have to start Qt again.

I have already installed all the drivers and compiled as is given in the manual.
but still cant connect.

Please help me build this database connection.

Thanks and Regards.
shamik

[wysota]

Qt3 doesn't support MySQL 5.0. About the crash - run QtDesigner under a debugger and see why it crashes. You might be missing some symbols if you don't have a proper mysql client library.

[shamik]

qt3 supports mysql5 and it has been done before by somebody and also has been confirmed by the trolltech support team.

i have compiled the drivers using following qmake command :

qmake -0 Makefile "INCLUDEPATH+=/usr/local/mysql/include" "LIBS+=-L/usr/local/mysql/lib" mysql.pro

make.

it compiled fine.

the driver QMYSQL3 is shown in the driver list in project->database connection.

i have written a small code to setup the database connection.

it also compiles well without error and exe is formed.

but when i try to run the exe from the shell it gives the following error :

[root@RedhatLinux database setup]# ./dbsetup
./dbsetup: relocation error: /usr/local/qt/plugins/sqldrivers/libqsqlmysql.so: undefined symbol: mysql_server_init
[root@RedhatLinux database setup]#

i dont know what to do know. i think all the libraries are included and all the paths are set correctly. the file libqsqlmysql.so also exists in the given folder.

please tell me whatz wrong here.

shamik

[wysota]

qt3 supports mysql5 and it has been done before by somebody and also has been confirmed by the trolltech support team.

Yes, but probably not out of the box.

i have compiled the drivers using following qmake command :

qmake -0 Makefile "INCLUDEPATH+=/usr/local/mysql/include" "LIBS+=-L/usr/local/mysql/lib" mysql.pro

Do you have /usr/local/mysql/lib in your linker path?

the driver QMYSQL3 is shown in the driver list in project->database connection.

Are you sure it is the same driver you compiled? Did you install the driver? Compiling it is not enough, it should be put in an appropriate place for Qt to find it.

i have written a small code to setup the database connection.

Can you present the code here?

but when i try to run the exe from the shell it gives the following error :

[root@RedhatLinux database setup]# ./dbsetup
./dbsetup: relocation error: /usr/local/qt/plugins/sqldrivers/libqsqlmysql.so: undefined symbol: mysql_server_init

Make sure the plugin tries to link against the proper mysqlclient library. You can do that using ldd.

[shamik]

hii,

thanks for the detailed information.

the code is here :

#include<qapplication.h>
#include<qsqldatabase.h>

int main(int argc, char **argv)
{
Qapplication a(argc,argv);
QsqlDatabase *defaultDB=QsqlDatabase::addDatabase(“QMYSQL 3”);
defaultDB->setDatabaseName(“manager”);
defaultDB->setPassword(“ “);
defaultDB->setHostName(“localhost”);

if(defaultDB->open())
{
qWarning(“Database connection successful”);
}

else
{
qWarning(“Database connection failed”);
}

return a.exec();

}

and yes, please tell what do u mean by
"Yes, but probably not out of the box."
"Do you have /usr/local/mysql/lib in your linker path?"

i have compiled the same driver.
and yes i have inquired about the plugin,

i think it requires, mysqlclient.so.15, as somebody else suggested me, but i am not sure. As against this i have got mysqlclient.so.10 which gets installed after i install mysql-devel package.

if this is the case then can you please tell me where can i get this *.*15 file from. how can i download it or the entire package which contains this file.

regards
shamik

[wysota]

and yes, please tell what do u mean by
"Yes, but probably not out of the box."

I mean that binary distributed qmysql3 plugins won't use the mysqlclient library from MySQL5. You have to recompile the driver from sources.

"Do you have /usr/local/mysql/lib in your linker path?"

I mean does your linker know to look for libraries in /usr/local/mysql/lib?

i think it requires, mysqlclient.so.15, as somebody else suggested me, but i am not sure.

That's very bad, as you ought to be sure. Use ldd on the driver to find out what it needs and what it finds.

As against this i have got mysqlclient.so.10 which gets installed after i install mysql-devel package.

And probably it gets linked with the driver instead of the version from MySQL5 causing relocation errors.

if this is the case then can you please tell me where can i get this *.*15 file from. how can i download it or the entire package which contains this file.

Install MySQL5 on your system. And make sure the dynamic linker can find it.

BTW. Does this thread have anything to do with Designer? Moving to Qt Programming. Or maybe it should end up in "Installation"?

[shamik]

ya thanks

i know it has got nothing to do with designer, ill surely move it to installation, but before that tell me how to move this thread.

and yes i know dont know which is the exact driver, wheather it is mysqlclient.so.10 or ..15. the connection doesnt work with 10. but cant say wheather definitely it is 15. if you know then please tell me. i cant find any source to know this. also in mysql.com and other sites also i have searched for the same, but i dint even got ..15.

as i told you i have done a new fresh instalation, i am quite sure that the actual driver only gets linked. i have posted the qmake command which i use.
the errors all the remain same after the installation too.

and about installig mysql5, let me inform you that the project is already in use in "indian space research organization" and we are just adding a new feature to it. so my seniors are not convinced about changing any kind of specification in the softwares used to build up the project. thats the tragedy with me that even after such advanced version of qt, kdevelop, mysql and redhat, i have to still work on with the older ones.

can you tel me wheather i m using the correct driver or not. its mysqlclient.so.10. if not then please tell me which is the correct one. from where can i get it.

[wysota]

i know it has got nothing to do with designer, ill surely move it to installation, but before that tell me how to move this thread.

You can't. I can and I already did.

and yes i know dont know which is the exact driver, wheather it is mysqlclient.so.10 or ..15. the connection doesnt work with 10. but cant say wheather definitely it is 15. if you know then please tell me. i cant find any source to know this. also in mysql.com and other sites also i have searched for the same, but i dint even got ..15.

I have already told you -- use ldd.

as i told you i have done a new fresh instalation, i am quite sure that the actual driver only gets linked.

Sure it gets linked, but against what?

i have posted the qmake command which i use.
the errors all the remain same after the installation too.

Because it has nothing to do with Qt, only with linker path.

can you tel me wheather i m using the correct driver or not. its mysqlclient.so.10. if not then please tell me which is the correct one. from where can i get it.

mysqlclient.10 is an old library, MySQL 3.3 I think...

I suggest you read a little about things such as dynamic linking, ldd, ldconfig, LD_LIBRARY_PATH and /etc/ld.so.conf.

[shamik]

hii there

now let me make somethings clear which i have come to know recently

all the installation cds which we use are made by those who have already made the software using these. those guys have now left the company and we have lost contact with them. we only have to add a new feature to the existing one. so compulsorily we have to use these softwares only. and since these have worked in the past it should work now also right?

what happened today is in one of the pcs the when i pressed 'connect' in 'project->database settings' the qt window dint disappear as it used to.
the settings under that are as follows
connection name : default
driver : QMYSQL3
database name : mysql
user : root
password :
host : localhost
port : default

and when press connect the following exclamation had come :

"
Could not connect to database.
Please ensure that the database server is running and that all the connection information is correct.
[QMYSQL3 : Unable to connect.
Cant connect to local MySQL server through socket 'tmp/mysql.sock' (2)]
"
the file mysql.sock is present in /var/lib/mysql dir. and not in /tmp
and now there are now problems in running mysql as we were facing previously. the only thing is that everytime i start mysql i have to run /etc/init.d/mysqld start .

and yes the mysql server is running when i see under server setting->services.

i have also tried to run the code which i have already posted.

when i try to run the exe from the shell it gives following error: (exe's name is driver)

QSqlDatabase Warning : QMySQL3 driver not loaded
QSqlDatabase : available drivers :
Database Connection failed (this is the message from our code)
[2]+stopped ./driver

so this all is new.

now lets go back again.
in my pc as you told to try out ldd
i tried it on libqsqlmysql.so which is in /usr/local/qt/plugins/sqldrivers
it listed the library file of mysql called libmysqlclient.so.10 along with many others.

when i try to run nm on this file which is in /usr/lib/mysql/ it says no symbols found
again on the file libqsqlmysql.so i had tried out nm and it shows that mysql_server_init is undefined.

now i am quite sure that the file ..10 is the correct driver and not ..15 because this has been done before by somebody.

what now!!?!?

shamik

[wysota]

i tried it on libqsqlmysql.so which is in /usr/local/qt/plugins/sqldrivers
it listed the library file of mysql called libmysqlclient.so.10 along with many others.

So it links against MySQL3 and not MySQL5 client library.

when i try to run nm on this file which is in /usr/lib/mysql/ it says no symbols found

That's because the library is stripped, don't worry, that's perfectly normal.

again on the file libqsqlmysql.so i had tried out nm and it shows that mysql_server_init is undefined.

That's normal too, because it will be defined when dynamic loader links the driver against mysql library.

now i am quite sure that the file ..10 is the correct driver and not ..15 because this has been done before by somebody.

So you need MySQL3 or MySQL5? Do you have libmysqlclient.so.10? (locate libmysqlclient.so should help find it)

what now!!?!?

Does ldd report any missing paths? (try ldd libqsqlmysql.so|grep "not found" or something simmilar)

From the message you provided I can see that the driver plugin can't be loaded. It is either not found at all (where is the file located?) or it can't find one of its dependencies (ldd should verify that).

[shamik]

So it links against MySQL3 and not MySQL5 client library.


no, but i told u that it should work against mysql5 also as it has been done before.


So you need MySQL3 or MySQL5? Do you have libmysqlclient.so.10? (locate libmysqlclient.so should help find it)

ya i have libmysqlclient.so.10 and it is /usr/lib/mysql directory.

Does ldd report any missing paths? (try ldd libqsqlmysql.so|grep "not found" or something simmilar)

this is the result of ldd:

[root@localhost sqldrivers]# ldd libqsqlmysql.so
libmysqlclient.so.10 => /usr/lib/mysql/libmysqlclient.so.10 (0x40023000)
libqt.so.3 => /usr/local/qt/lib/libqt.so.3 (0x4005a000)
libXrender.so.1 => /usr/X11R6/lib/libXrender.so.1 (0x4081e000)
libXrandr.so.2 => /usr/X11R6/lib/libXrandr.so.2 (0x40826000)
libXcursor.so.1 => /usr/X11R6/lib/libXcursor.so.1 (0x4082b000)
libXft.so.2 => /usr/X11R6/lib/libXft.so.2 (0x40834000)
libfreetype.so.6 => /usr/lib/libfreetype.so.6 (0x40846000)
libfontconfig.so.1 => /usr/lib/libfontconfig.so.1 (0x40897000)
libXext.so.6 => /usr/X11R6/lib/libXext.so.6 (0x408bc000)
libX11.so.6 => /usr/X11R6/lib/libX11.so.6 (0x408ca000)
libSM.so.6 => /usr/X11R6/lib/libSM.so.6 (0x409aa000)
libICE.so.6 => /usr/X11R6/lib/libICE.so.6 (0x409b3000)
libdl.so.2 => /lib/libdl.so.2 (0x409ca000)
libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x409cd000)
libm.so.6 => /lib/tls/libm.so.6 (0x40a80000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x40aa2000)
libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
libz.so.1 => /usr/lib/libz.so.1 (0x40aab000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40ab9000)
libnsl.so.1 => /lib/libnsl.so.1 (0x40ae6000)
libexpat.so.0 => /usr/lib/libexpat.so.0 (0x40afb000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
[root@localhost sqldrivers]#ldd libqsqlmysql.so | grep "not found"
[root@localhost sqldrivers]#



From the message you provided I can see that the driver plugin can't be loaded. It is either not found at all (where is the file located?) or it can't find one of its dependencies (ldd should verify that).

so as ldd doesnt report anything missing , everything else is fine.
i think i am just little bit far from the end.