mysql plugin not compiling from source

[rahulvishwakarma]

this " -lrt" adding give following error:-
-------------------------------------------

/usr/lib/mysql/libmysqlclient_r.a(client_plugin.c.o): In function `do_add_plugin':
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:179: 
 
undefined reference to `dlclose'
/usr/lib/mysql/libmysqlclient_r.a(client_plugin.c.o): In function `mysql_client_plugin_deinit':
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:306: 
 
undefined reference to `dlclose'
/usr/lib/mysql/libmysqlclient_r.a(client_plugin.c.o): In function `mysql_load_plugin_v':
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:393: 
 
undefined reference to `dlopen'
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:422: 
 
undefined reference to `dlsym'
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:413: 
 
undefined reference to `dlerror'
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:425: 
 
undefined reference to `dlclose'
collect2: error: ld returned 1 exit status
make: *** [../../../../plugins/sqldrivers/libqsqlmysql.so] Error 1

/usr/lib/mysql/libmysqlclient_r.a(client_plugin.c.o): In function `do_add_plugin':
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:179: 

undefined reference to `dlclose'
/usr/lib/mysql/libmysqlclient_r.a(client_plugin.c.o): In function `mysql_client_plugin_deinit':
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:306: 

undefined reference to `dlclose'
/usr/lib/mysql/libmysqlclient_r.a(client_plugin.c.o): In function `mysql_load_plugin_v':
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:393: 

undefined reference to `dlopen'
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:422: 

undefined reference to `dlsym'
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:413: 

undefined reference to `dlerror'
/export/home/pb2/build/sb_0-14135570-1421675634.15/rpm/BUILD/mysql-5.6.23/mysql-5.6.23/sql-common/client_plugin.c:425: 

undefined reference to `dlclose'
collect2: error: ld returned 1 exit status
make: *** [../../../../plugins/sqldrivers/libqsqlmysql.so] Error 1

To copy to clipboard, switch view to plain text mode 

[high_flyer]

this is not the result of adding librt.
Adding librt solved the error you posted at first, now you are having another lib missing:
Now you have to add '-ldl'.
And if you continue getting such errors, google for the functions which the linker is complaining about and see in which lib they are defined, and add them to you linker line until all the dependencies are satisfied.

[rahulvishwakarma]

Thanks high_flyer, you solved my problem. I added -lrt and -ldl like this:-

# /opt/Qt5.2.1/5.2.1/gcc/bin/qmake "INCLUDEPATH+=/usr/include" "LIBS+=-L/usr/lib/mysql -lmysqlclient_r -lrt -ldl" mysql.pro
 
#make
# make install

# /opt/Qt5.2.1/5.2.1/gcc/bin/qmake "INCLUDEPATH+=/usr/include" "LIBS+=-L/usr/lib/mysql -lmysqlclient_r -lrt -ldl" mysql.pro

#make
# make install

To copy to clipboard, switch view to plain text mode 

and the problem was gone.

And finally tell me how to set this thread as SOLVED.