Qt5连接PostgreSQL出错
Tofloor
poster avatar
b***j@126.com
deepin
2019-10-18 01:50
Author
使用命令安装Qt5:
$sudo apt install qtcreator qt5-default
安装完成后,发现缺少PostgreSQL驱动so包,手工拷入后运行程序出错:
/home/zuoyh/QtWork/HT_MSS/build-HT_MSS-unknown-Release/HT_MSS: relocation error: /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlpsql.so: symbol _ZdlPvm version Qt_5 not defined in file libQt5Core.so.5 with link time reference

Reply Favorite View the author
All Replies
avatar
走钢丝
deepin
2019-10-18 02:07
#1
问题是到底有没有。。。

参考:https://www.linuxidc.com/Linux/2015-01/111678.htm
Reply View the author
avatar
Feng Yu
deepin
2019-10-18 03:48
#2
不要自己乱拷贝so。官方仓库明明有插件,为啥就是不喜欢用软件仓库?

明明就能search到一个qt的postgresql driver: libqt5sql5-psql
Reply View the author
avatar
b***j@126.com
deepin
2019-10-18 18:18
#3
https://bbs.deepin.org/post/183914
不要自己乱拷贝so。官方仓库明明有插件,为啥就是不喜欢用软件仓库?

明明就能search到一个qt的postgresql ...

我还不清楚如何下载插件,能否给个操作步骤?
Reply View the author
avatar
走钢丝
deepin
2019-10-18 18:23
#4
https://bbs.deepin.org/post/183914
我还不清楚如何下载插件,能否给个操作步骤?

仓库....sudo apt install xxx
Reply View the author
avatar
b***j@126.com
deepin
2019-10-18 18:34
#5
sudo apt-cache search postgresql driver
aolserver4-nspostgres - AOLserver 4 module: Postgres connector
eekboek-db-postgresql - PostgreSQL database driver for EekBoek
erlang-p1-pgsql - Pure Erlang PostgreSQL driver golang-gopkg-pg.v5-dev - PostgreSQL client and ORM for Golang
kamailio-postgres-modules - PostgreSQL database connectivity module for the Kamailio SIP server
kexi-plugin-postgresql - transitional dummy package for kexi-postgresql-driver
kexi-postgresql-driver - PostgreSQL support for kexi
libaprutil1-dbd-pgsql - Apache Portable Runtime Utility Library - PostgreSQL Driver
libdatetime-format-dbi-perl - abstraction layer for DateTime over some database vendors
libdbd-pg-perl - Perl DBI driver for the PostgreSQL database server
libdbd-pgsql - PostgreSQL database server driver for libdbi
libdbd-sqlite2-perl - Perl DBI driver with a self-contained RDBMS (SQLite2 version)
libdbd-sqlite3-perl - Perl DBI driver with a self-contained RDBMS
libdbi-perl - Perl Database Interface (DBI)
libdbix-datasource-perl - database-independent module to create and drop functions
libdbix-dbschema-perl - Perl module to manipulate schemas independently of databases
libdbix-introspector-perl - module to detect what database code is connected to
libghc-haskelldb-hdbc-postgresql-dev - HaskellDB support for the HDBC PostgreSQL driver
libghc-haskelldb-hdbc-postgresql-doc - HaskellDB support for the HDBC PostgreSQL driver; documentation
libghc-haskelldb-hdbc-postgresql-prof - HaskellDB support for the HDBC PostgreSQL driver; profiling libraries
libghc-hdbc-dev - Haskell Database Connectivity, GHC package
libghc-hdbc-odbc-dev - unixODBC HDBC (Haskell Database Connectivity) Driver for GHC
libghc-hdbc-odbc-doc - unixODBC HDBC (Haskell Database Connectivity) Documentation
libghc-hdbc-odbc-prof - unixODBC Haskell Database Connectivity Driver; profiling libraries
libghc-hdbc-postgresql-dev - PostgreSQL HDBC (Haskell Database Connectivity) Driver for GHC
libghc-hdbc-postgresql-prof - PostgreSQL HDBC Driver for GHC; profiling libraries
libghc-hdbc-sqlite3-dev - Sqlite v3 HDBC (Haskell Database Connectivity) Driver for GHC
libghc-hdbc-sqlite3-prof - Sqlite v3 HDBC Driver for GHC; profiling libraries
libh2-java - H2 Database Engine
libh2-java-doc - H2 Database Engine (documentation)
libkdb3-driver-postgresql - PostgreSQL driver for KDb
libkdb3-driver-postgresql-dbgsym - Debug symbols for libkdb3-driver-postgresql
libpostgresql-jdbc-java - Java database (JDBC) driver for PostgreSQL
libpostgresql-jdbc-java-doc - Java database (JDBC) driver for PostgreSQL (documentation)
libqt4-sql-psql - Qt 4 PostgreSQL database driver
libqt5sql5-psql - Qt 5 PostgreSQL database driver
libreoffice-base-drivers - Database connectivity drivers for LibreOffice
libreoffice-sdbc-postgresql - PostgreSQL SDBC driver for LibreOffice
odbc-postgresql - ODBC driver for PostgreSQL
odbc-postgresql-dbg - ODBC driver for PostgreSQL - debug symbols
opensips-postgres-module - PostgreSQL database connectivity module for OpenSIPS
pgadmin3 - graphical administration tool for PostgreSQL
php-mdb2-driver-pgsql - pgsql MDB2 driver
postgresql-10-ogr-fdw - PostgreSQL foreign data wrapper for OGR
postgresql-9.6-ogr-fdw - PostgreSQL foreign data wrapper for OGR
python-pg8000 - Pure-Python PostgreSQL Driver (Python 2)
python-pg8000-doc - Pure-Python PostgreSQL Driver (documentation)
python3-aiopg - PostgreSQL integration with asyncio
python3-asyncpg - asyncio PosgtreSQL driver
python3-pg8000 - Pure-Python PostgreSQL Driver (Python 3)
python3-postgresql - pgsql driver, cluster management tools, and client tools
r-cran-rodbc - GNU R package for ODBC database access
r-cran-rpostgresql - GNU R package providing database interface and driver for PostgreSQL
ruby-dbd-pg - Ruby/DBI PostgreSQL driver
syslog-ng-mod-extra - Enhanced system logging daemon (extra plugins)
syslog-ng-mod-lua - Enhanced system logging daemon (Lua destination)
syslog-ng-mod-perl - Enhanced system logging daemon (Perl destination)
tcl8.6-tdbc-postgres - Tcl Database Connectivity
Reply View the author
avatar
b***j@126.com
deepin
2019-10-18 18:36
#6
$ sudo apt-get install libqt5sql5-psql
正在读取软件包列表... 完成
正在分析软件包的依赖关系树      
正在读取状态信息... 完成      
下列【新】软件包将被安装:
  libqt5sql5-psql
升级了 0 个软件包,新安装了 1 个软件包,要卸载 0 个软件包,有 128 个软件包未被升级。
需要下载 71.0 kB 的归档。
解压缩后会消耗 229 kB 的额外空间。
获取:1 http://packages.deepin.com/deepin panda/main amd64 libqt5sql5-psql amd64 5.10.1+dfsg-15deepin [71.0 kB]
已下载 71.0 kB,耗时 1秒 (95.0 kB/s)     
正在选中未选择的软件包 libqt5sql5-psql:amd64。
(正在读取数据库 ... 系统当前共安装有 206372 个文件和目录。)
正准备解包 .../libqt5sql5-psql_5.10.1+dfsg-15deepin_amd64.deb  ...
正在解包 libqt5sql5-psql:amd64 (5.10.1+dfsg-15deepin) ...
正在设置 libqt5sql5-psql:amd64 (5.10.1+dfsg-15deepin) ...
Reply View the author
avatar
b***j@126.com
deepin
2019-10-18 19:03
#7
$ sudo apt-cache search mysql driver
[sudo] zuoyh 的密码:
aolserver4-nsmysql - AOLserver 4 module: module for accessing MySQL databases
cl-qmynd - MySQL Native Driver for Common Lisp
erlang-p1-mysql - pure Erlang MySQL driver golang-github-go-sql-driver-mysql-dev - MySQL-Driver for Go's database/sql package
kamailio-mysql-modules - MySQL database connectivity module for Kamailio
kexi-mysql-driver - MySQL support for kexi
kexi-plugin-mysql - transitional dummy package for kexi-mysql-driver
libaprutil1-dbd-mysql - Apache Portable Runtime Utility Library - MySQL Driver
libdatetime-format-dbi-perl - abstraction layer for DateTime over some database vendors
libdbd-mock-perl - Mock database driver for testing
libdbd-mysql - MySQL database server driver for libdbi
libdbd-mysql-perl - Perl5 database interface to the MariaDB/MySQL database
libdbd-sqlite2-perl - Perl DBI driver with a self-contained RDBMS (SQLite2 version)
libdbd-sqlite3-perl - Perl DBI driver with a self-contained RDBMS
libdbi-perl - Perl Database Interface (DBI)
libdbix-datasource-perl - database-independent module to create and drop functions
libdbix-dbschema-perl - Perl module to manipulate schemas independently of databases
libdbix-easy-perl - Easy to Use DBI Interface
libdbix-introspector-perl - module to detect what database code is connected to
libghc-hdbc-dev - Haskell Database Connectivity, GHC package
libghc-hdbc-odbc-dev - unixODBC HDBC (Haskell Database Connectivity) Driver for GHC
libghc-hdbc-odbc-doc - unixODBC HDBC (Haskell Database Connectivity) Documentation
libghc-hdbc-odbc-prof - unixODBC Haskell Database Connectivity Driver; profiling libraries
libghc-hdbc-sqlite3-dev - Sqlite v3 HDBC (Haskell Database Connectivity) Driver for GHC
libghc-hdbc-sqlite3-prof - Sqlite v3 HDBC Driver for GHC; profiling libraries
libglpk36 - linear programming kit with integer (MIP) support
libglpk39 - linear programming kit with integer (MIP) support
libglpk40 - linear programming kit with integer (MIP) support
libkdb3-driver-mysql - MySQL driver for KDb
libkdb3-driver-mysql-dbgsym - Debug symbols for libkdb3-driver-mysql
libmyodbc - the MySQL ODBC driver
libmysql-cil-dev - MySQL database connector for CLI
libmysql-java - Java database (JDBC) driver for MySQL
libmysql6.4-cil - MySQL database connector for CLI
libqt4-sql-mysql - Qt 4 MySQL database driver
libqt5sql5-mysql - Qt 5 MySQL database driver
libreoffice-base-drivers - Database connectivity drivers for LibreOffice
libsqlclient-dev - SQL client library for GNUstep (development files)
libsqlclient1.7 - SQL client library for GNUstep (runtime library)
libsqlclient1.8 - SQL client library for GNUstep (runtime library)
opensips-mysql-module - MySQL database connectivity module for OpenSIPS
parser3-mysql - MySQL driver for Parser 3
php-db - Database Abstraction Layer
php-mdb2-driver-mysql - mysql MDB2 driver
php5-adodb - Extension optimising the ADOdb database abstraction library
php5-mysqlnd - MySQL module for php5 (Native Driver)
python-mysql.connector - pure Python implementation of MySQL Client/Server protocol
python-pymysql - Pure-Python MySQL driver - Python 2.x
python-pymysql-doc - Pure-Python MySQL driver - doc
python3-mysql.connector - pure Python implementation of MySQL Client/Server protocol (Python3)
python3-pymysql - Pure-Python MySQL Driver - Python 3.x
r-cran-rodbc - GNU R package for ODBC database access
ruby-dbd-mysql - Ruby/DBI MySQL driver
tcl8.6-tdbc-mysql - Tcl Database Connectivity
test-kitchen - integration tool for Chef
Reply View the author
avatar
b***j@126.com
deepin
2019-10-18 19:05
#8
$ sudo apt-get install libqt5sql5-mysql
正在读取软件包列表... 完成
正在分析软件包的依赖关系树      
正在读取状态信息... 完成      
下列【新】软件包将被安装:
  libqt5sql5-mysql
升级了 0 个软件包,新安装了 1 个软件包,要卸载 0 个软件包,有 128 个软件包未被升级。
需要下载 69.9 kB 的归档。
解压缩后会消耗 225 kB 的额外空间。
获取:1 http://packages.deepin.com/deepin panda/main amd64 libqt5sql5-mysql amd64 5.10.1+dfsg-15deepin [69.9 kB]
已下载 69.9 kB,耗时 2秒 (41.3 kB/s)        
正在选中未选择的软件包 libqt5sql5-mysql:amd64。
(正在读取数据库 ... 系统当前共安装有 206377 个文件和目录。)
正准备解包 .../libqt5sql5-mysql_5.10.1+dfsg-15deepin_amd64.deb  ...
正在解包 libqt5sql5-mysql:amd64 (5.10.1+dfsg-15deepin) ...
正在设置 libqt5sql5-mysql:amd64 (5.10.1+dfsg-15deepin) ...
Reply View the author
avatar
b***j@126.com
deepin
2019-10-18 19:17
#9
https://bbs.deepin.org/post/183914
仓库....sudo apt install xxx

谢谢你!
Reply View the author
avatar
Feng Yu
deepin
2019-10-18 19:26
#10
https://bbs.deepin.org/post/183914
我还不清楚如何下载插件,能否给个操作步骤?

如果你走的是软件仓库安装,那么统一走软件仓库安装肯定没问题。

如果你用的是qt的二进制安装包,那么一路用那玩意就行了。

保持安装方式的统一很重要,可以规避很多麻烦的事。

按照Debian的软件包套路,大型的软件通常都会编译为core + plugin模式,也就是说你需要分别安装核心组件包和插件包,它们分属于不同的软件包,比如php这种的,直接apt install php就只有php命令行,其他插件分成了php-mysql等这一类的包,包括python也一样。所以你的qt按照这种套路,search一下就会发现了
Reply View the author
avatar
b***j@126.com
deepin
2019-10-18 19:35
#11
https://bbs.deepin.org/post/183914
如果你走的是软件仓库安装,那么统一走软件仓库安装肯定没问题。

如果你用的是qt的二进制安装包,那么一 ...

多谢!方便加个QQ好友?
我的QQ:37981826
多交流
Reply View the author