dify Database Query DB-Lib error message 20002, severity 9

原创已于 2025-05-29 11:07:35 修改 · 349 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #服务器 #linux

于 2025-05-29 10:10:41 首次发布

dify Database Query plugin Microsoft SQL Server Error :DB-Lib error message 20002, severity 9

plugin verion 0.0.9

Failed to transform tool message: PluginInvokeError: {"args":{},"error_type":"Exception","message":"SQL query execution exception. (pymssql.exceptions.OperationalError) (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.10.XXX)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.10.XXX)\n')\n(Background on this error at: ==oohttps://sqlalche.me/e/20/e3q8)"}

issue ：sqlserver 用不了 #25

root cause, pymssql load freetds.conf from wrong path,just replicate freetds.conf to any path possible!

add freetds/freetds.conf

[global]
    tds version = 7.0
    client charset = UTF-8
    dump file = /tmp/freetds.log

[MSSQL]
    host = 192.168.10.128
    port = 1433
    tds version = 7.0

modify dify docker-compose.yaml, map your local freetds folder to container's /ect/freetds

docker compose up -d

install freetds in docker container

sudo apt update

sudo apt install freetds-dev freetds-bin

vi /etc/freetds/freetds.conf #tds version 改为7.0

cp /etc/freetds/freetds.conf /root/.freetds.conf

mkdir -p /usr/local/etc

cp /etc/freetds/freetds.conf  /usr/local/etc/freetds.conf

docker commit 883d41b43bed   langgenius/dify-plugin-daemon:0.1.1-local