为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:WIN10 CENTOS7
【CPU】: 64
【问题描述】*:
根据文档的要求安装好了环境sqlalchemy1.3.23, python3.6.8
支持ipv4地址连接达梦,改成ipv6地址后提示如下错误
# success
import dmPython
# conn=dmPython.connect(user='SYSDBA',password='111111111',server= '[fe80::fdd0:b325:2aba:b843%16]',port=5236)
conn = dmPython.connect('SYSDBA/111111111@[fe80::fdd0:b325:2aba:b843%16]:5236/SYSDBA')
cursor = conn.cursor()
cursor.execute('select * from SYSDBA.BGPFS_BATCH_UPLOAD_LOG')
# cursor.execute("insert into UAN.sdn_acl_template (data_state, created_time, updated_time) values(1, '2023-10-11 14:39:02', '2023-10-11 14:39:02')")
values = cursor.fetchall()
print(values)
cursor.close()
conn.close()
错误信息
load fun EVP_sm3_fun fail!
Traceback (most recent call last):
File "dmtest.py", line 5, in <module>
conn = dmPython.connect('SYSDBA/111111111@[fe80::fdd0:b325:2aba:b843%16]:5236/SYSDBA')
ValueError: invalid literal for int() with base 10: ':fdd0:b325:2aba:b843%16]:5236'
这很明显达梦的dsn这个解析把冒号后边的给当成端口转成int了?怎么办怎么办啊?
把端口号后面的 /SYSDBA 去掉试试呢