Linux QT5.2下编译MySQL5.6.7驱动
来源:互联网 发布:淘宝上适合少女的店铺 编辑:程序博客网 时间:2024/05/12 01:46
Linux 下编译MySQL驱动:
环境:Qt5.2.1 + MySql5.6.17 + ubuntu12.04
1、下载Mysql5.6.17安装包MySQL-5.6.17-1.linux_glibc2.5.i386.rpm-bundle.tar
2、安装alien工具将rpm包转换成deb:使用命令alien -d x.rpm 生成x.deb
3、mysql安装之后,执行命令:dpkg -l|grep mysql查看安装的mysql组件,要编译mysql驱动下边的组件必须安装:
ii mysql-client 5.6.17-2 MySQL - Client
ii mysql-devel 5.6.17-2 MySQL - Development header files and libraries
ii mysql-server 5.6.17-2 MySQL: a veryfast and reliable SQL database server
4、在qt安装目录mysql驱动源码所在的目录执行如下命令:
qmake"INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysql-lmysqlclient_r" mysql.pro
生成makefile文件
5、然后make
make过程中可能出现下列错误:
ers/mysql# make
….....................
-I/home/lhl/Qt5.2.1/5.2.1/gcc/include/QtCore/5.2.1-I/home/lhl/Qt5.2.1/5.2.1/gcc/include/QtCore/5.2.1/QtCore-I/home/lhl/Qt5.2.1/5.2.1/gcc/include/QtCore -I.moc -o .obj/moc_qsql_mysql_p.o.moc/moc_qsql_mysql_p.cpp
rm -f libqsqlmysql.so
g++ -Wl,--no-undefined -Wl,-O1-Wl,-rpath,/home/lhl/Qt5.2.1/5.2.1/gcc -Wl,-rpath,/home/lhl/Qt5.2.1/5.2.1/gcc-Wl,-rpath,/home/lhl/Qt5.2.1/5.2.1/gcc/lib -shared -o libqsqlmysql.so.obj/main.o .obj/qsql_mysql.o .obj/moc_qsql_mysql_p.o -L/usr/lib/mysql -ldl -lrt-Wl,-Bsymbolic-functions -rdynamic -lmysqlclient_r-L/home/lhl/Qt5.2.1/5.2.1/gcc/lib -lQt5Sql -lQt5Core -lpthread
/usr/lib/mysql/libmysqlclient_r.a(my_getsystime.c.o):In function `my_getsystime':
/export/home/pb2/build/sb_0-11763321-1394831461.01/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/mysys/my_getsystime.c:44:undefined reference to `clock_gettime'
/usr/lib/mysql/libmysqlclient_r.a(client_plugin.c.o):In function `do_add_plugin':
/export/home/pb2/build/sb_0-11763321-1394831461.01/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/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-11763321-1394831461.01/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/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-11763321-1394831461.01/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/sql-common/client_plugin.c:393:undefined reference to `dlopen'
/export/home/pb2/build/sb_0-11763321-1394831461.01/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/sql-common/client_plugin.c:422:undefined reference to `dlsym'
/export/home/pb2/build/sb_0-11763321-1394831461.01/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/sql-common/client_plugin.c:413:undefined reference to `dlerror'
/export/home/pb2/build/sb_0-11763321-1394831461.01/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/sql-common/client_plugin.c:425:undefined reference to `dlclose'
collect2: ld 返回 1
make: *** [../../../../plugins/sqldrivers/libqsqlmysql.so]错误1
以上错误解决办法:
第一种:可以在第4步生成的makefile文件中添加LIBS +=-lpthread -lrt-ldl 就可以编译通过
第二种:qmake"INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysql-lmysqlclient_r" mysql.pro LIBS+=-lpthread -lrt-ldl
- Linux QT5.2下编译MySQL5.6.7驱动
- Ubuntu下Qt5.2编译mysql驱动
- 记录:编译Qt5.0连接MySql5.5数据库的驱动
- 编译mysql5.7.11的Qt5.6驱动QMYSQL
- macOS下qt5连接mysql5.7驱动问题
- Qt5.1.0 下编译生成Mysql驱动
- Ubuntu下Qt5.2.0编译mysql驱动
- Win7下编译Qt5.4OCI驱动和MySQL驱动
- win7 qt5 oracle11g 64位下编译oci驱动
- QT5.4下编译MySQL数据库驱动,并建立连接
- windows下Qt5.6.0 编译Mysql驱动,并使用。
- linux下mysql5.5.19编译安装笔记
- Linux下编译安装MySQL5.1
- Linux下编译安装MySQL5.5
- linux下mysql5.5.19编译安装笔记
- linux下mysql5.5.11编译安装笔记
- linux下mysql5.5.11编译安装笔记
- linux下编译安装mysql5.6
- 单元选择合并变色
- nginx,apache,tomcat常见web服务器性能调优
- c/c++函数调用
- 条款02:尽量以const,enum,inline替换#indefine
- struts2之文件上传
- Linux QT5.2下编译MySQL5.6.7驱动
- 创立一个网站的前前后后(起因,域名,云平台,备案,CDN等等)(1)
- fork exec
- 刚刚建立的团队,作为管理者,难
- 常见面试题栏目引用地址~
- JSF学习笔记
- 【解题报告】uva103_Stacking Boxes(堆砌盒子, dp)
- 移动应用必定不会长久(PS:耐心看完你会有一个新的思路)
- 初涉A*剪枝