这个报错是啥原因：Traceback (most recent call last):<br>  File "dbtpy-test.py", line 9, in <br>    conn=DbtPy.connect(connectStr, "gbasedbt", "rsgop2023")<br>Exception: [GBasedbt][GBasedbt ODBC Driver][GBasedbt]数据库地点信息不匹配。 SQLCODE=-23197<br>

活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

操作系统：CentOS 7.8 64-bit  
软件需求：  
Python 3.6.8 及Python-devel 3.6.8  

### 有互联网连接的情况下，可以直接安装DbtPy (仅限Linux x64和Win x64)  
#### 1，直接pip3安装DbtPy，将自动安装最新的DbtPy
```text
[root@a02 ~]# pip3 install DbtPy
Collecting DbtPy
  Downloading http://mirrors.cloud.aliyuncs.com/pypi/packages/1f/45/22d842ffe40fbcb58878b891ba8f4e319a3585afd0f09ac13fd3d51b0a9b/DbtPy-3.0.5.tar.gz (165kB)
    100% |████████████████████████████████| 174kB 13.0MB/s
# 注：对于Linux x64和Win x64，这步可以需要些时间下载对应的csdk驱动。
Installing collected packages: DbtPy
  Running setup.py install for DbtPy ... done
Successfully installed DbtPy-3.0.5
```




#### 2，然后通过pip3 list查看已经安装的版本
```text
[root@a02 ~]# pip3 list | grep DbtPy
DbtPy (3.0.5)
```

#### 3，设置环境变量
```text
[root@a02 ~]# export GBASEDBTDIR=/usr/local/lib64/python3.6/site-packages/gbase8s-odbc-driver
[root@a02 ~]# export LD_LIBRARY_PATH=$GBASEDBTDIR/lib:$GBASEDBTDIR/lib/cli:$GBASEDBTDIR/lib/esql:$LD_LIBRARY_PATH
```
注：GBASEDBTDIR的路径与python的版本有关，请注意修改。  

#### 4，Python3通过DbtPy连接GBase 8s数据库测试
编写测试脚本程序TestDbtPy.py，内容如下：  
```python
#!/usr/bin/python3
# filename: TestDbtPy.py

import sys
import DbtPy

print("Python DbtPy测试程序开始运行.\n")
connectStr="PROTOCOL=onsoctcp;HOST=a02.gbasedbt.com;SERVICE=9088;SERVER=gbase01;DATABASE=testdb;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8"
conn=DbtPy.connect(connectStr, "gbasedbt", "GBase123")

DbtPy.exec_immediate(conn, "drop table if exists company")

DbtPy.exec_immediate(conn, "create table company(coid serial,coname varchar(255),coaddr varchar(255))")

DbtPy.exec_immediate(conn, "insert into company(coname,coaddr) values ('南大通用','天津市普天创新园')")
DbtPy.exec_immediate(conn, "insert into company(coname,coaddr) values ('南大通用北京分公司','北京市朝阳区太阳宫')")

stmt = DbtPy.exec_immediate(conn, "select * from company")
data = DbtPy.fetch_assoc(stmt)

rc = 0
while data != False:
    rc += 1
    print (data)
    data = DbtPy.fetch_assoc(stmt)

DbtPy.free_result(stmt)
DbtPy.free_stmt(stmt)
DbtPy.close(conn)

print("\nPython DbtPy测试程序结束运行.")
sys.exit(0)

```
python TestDbtPy.py执行并输出结果：  
```text
[root@a02 ~]# python3 TestDbtPy.py
Python DbtPy测试程序开始运行.

{'coid': 1, 'coname': '南大通用', 'coaddr': '天津市普天创新园'}
{'coid': 2, 'coname': '南大通用北京分公司', 'coaddr': '北京市朝阳区太阳宫'}

Python DbtPy测试程序结束运行.
```

### 如果是内网环境，无法通过互联网连接。
#### 1，从互联网上下载DbtPy源码包和CSDK安装包（或者自己手工安装CSDK）
```text
[root@a02 ~]# wget https://gbasedbt.com/odbc/GBase8s_3.0-Linux64-ODBC-Driver.tar.gz
--2021-04-02 09:57:30--  https://gbasedbt.com/odbc/GBase8s_3.0-Linux64-ODBC-Driver.tar.gz
Resolving gbasedbt.com (gbasedbt.com)... 106.55.146.212
Connecting to gbasedbt.com (gbasedbt.com)|106.55.146.212|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 36029201 (34M) [application/x-gzip]
Saving to: ‘GBase8s_3.0-Linux64-ODBC-Driver.tar.gz’

100%[==========================================================================================================>] 36,029,201   637KB/s   in 56s

2021-04-02 09:58:26 (627 KB/s) - ‘GBase8s_3.0-Linux64-ODBC-Driver.tar.gz’ saved [36029201/36029201]

[root@a02 ~]# wget https://gbasedbt.com/dl/DbtPy/DbtPy-3.0.5.tar.gz
--2021-04-02 09:59:44--  https://gbasedbt.com/dl/DbtPy/DbtPy-3.0.5.tar.gz
Resolving gbasedbt.com (gbasedbt.com)... 106.55.146.212
Connecting to gbasedbt.com (gbasedbt.com)|106.55.146.212|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 172254 (168K) [application/x-gzip]
Saving to: ‘DbtPy-3.0.5.tar.gz’

100%[==========================================================================================================>] 172,254     --.-K/s   in 0.03s

2021-04-02 09:59:44 (6.30 MB/s) - ‘DbtPy-3.0.5.tar.gz’ saved [172254/172254]
```
#### 2，解压GBase8s_3.0-Linux64-ODBC-Driver.tar.gz，并配置环境变量
```text
[root@a02 ~]# tar -zxf GBase8s3.0.0_1-Linux64-ODBC-Driver.tar.gz -C /opt/
```
将在指定的目录/opt下生成gbase8s-odbc-driver目录  
配置环境变量，包含GBASEDBTDIR、CSDK_HOME和LD_LIBRARY_PATH  
```shell
export GBASEDBTDIR=/opt/gbase8s-odbc-driver
export CSDK_HOME=$GBASEDBTDIR
export LD_LIBRARY_PATH=$CSDK_HOME/lib:$CSDK_HOME/lib/cli:$CSDK_HOME/lib/esql:$LD_LIBRARY_PATH
```
#### 3，手动安装DbtPy
解压缩DbtPy-3.0.5.tar.gz  
```text
[root@a02 ~]# tar -zxvf DbtPy-3.0.5.tar.gz && cd DbtPy-3.0.5
```
执行安装  
```text
[root@a02 DbtPy-3.0.5]# python3 setup.py install
Detected 64-bit Python
Smart Triggers are not available.
running install
running bdist_egg
running egg_info
writing DbtPy.egg-info/PKG-INFO
writing dependency_links to DbtPy.egg-info/dependency_links.txt
writing top-level names to DbtPy.egg-info/top_level.txt
reading manifest file 'DbtPy.egg-info/SOURCES.txt'
reading manifest template 'MANIFEST.in'
warning: no files found matching '*.pyd'
writing manifest file 'DbtPy.egg-info/SOURCES.txt'
installing library code to build/bdist.linux-x86_64/egg
running install_lib
running build_py
creating build
creating build/lib.linux-x86_64-3.6
copying DbtPyDbi.py -> build/lib.linux-x86_64-3.6

(省略)

creating dist
creating 'dist/DbtPy-3.0.5-py3.6-linux-x86_64.egg' and adding 'build/bdist.linux-x86_64/egg' to it
removing 'build/bdist.linux-x86_64/egg' (and everything under it)
Processing DbtPy-3.0.5-py3.6-linux-x86_64.egg
creating /usr/local/lib64/python3.6/site-packages/DbtPy-3.0.5-py3.6-linux-x86_64.egg
Extracting DbtPy-3.0.5-py3.6-linux-x86_64.egg to /usr/local/lib64/python3.6/site-packages
Adding DbtPy 3.0.5 to easy-install.pth file

Installed /usr/local/lib64/python3.6/site-packages/DbtPy-3.0.5-py3.6-linux-x86_64.egg
Processing dependencies for DbtPy==3.0.5
Finished processing dependencies for DbtPy==3.0.5
```
#### 4，然后通过pip3 list查看已经安装的版本
```text
[root@a02 ~]# pip3 list | grep DbtPy
DbtPy (3.0.5)
```
#### 5，Python3通过DbtPy连接GBase 8s数据库测试
编写测试脚本程序TestDbtPy.py，内容如下：  
```python
#!/usr/bin/python3
# filename: TestDbtPy.py

import sys
import DbtPy

print("Python DbtPy测试程序开始运行.\n")
connectStr="PROTOCOL=onsoctcp;HOST=a02.gbasedbt.com;SERVICE=9088;SERVER=gbase01;DATABASE=testdb;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8"
conn=DbtPy.connect(connectStr, "gbasedbt", "GBase123")

DbtPy.exec_immediate(conn, "drop table if exists company")

DbtPy.exec_immediate(conn, "create table company(coid serial,coname varchar(255),coaddr varchar(255))")

DbtPy.exec_immediate(conn, "insert into company(coname,coaddr) values ('南大通用','天津市普天创新园')")
DbtPy.exec_immediate(conn, "insert into company(coname,coaddr) values ('南大通用北京分公司','北京市朝阳区太阳宫')")

stmt = DbtPy.exec_immediate(conn, "select * from company")
data = DbtPy.fetch_assoc(stmt)

rc = 0
while data != False:
    rc += 1
    print (data)
    data = DbtPy.fetch_assoc(stmt)

DbtPy.free_result(stmt)
DbtPy.free_stmt(stmt)
DbtPy.close(conn)

print("\nPython DbtPy测试程序结束运行.")
sys.exit(0)

```
python TestDbtPy.py执行并输出结果：  
```text
[root@a02 ~]# python3 TestDbtPy.py
Python DbtPy测试程序开始运行.

{'coid': 1, 'coname': '南大通用', 'coaddr': '天津市普天创新园'}
{'coid': 2, 'coname': '南大通用北京分公司', 'coaddr': '北京市朝阳区太阳宫'}

Python DbtPy测试程序结束运行.
```

Linux下Python3通过DbtPy连接到GBase 8s数据库

Linux下Python3通过DbtPy连接到GBase 8s数据库

评论

热门帖子