sqlserver 用不了

[Ai5562]

Please confirm before submission 在提交之前，请确认

• [x] I have searched for existing issues search for existing issues, including closed ones. 我已经搜索了现有问题搜索现有问题，包括已关闭的问题。"

Dify version Dify版本

1.2.0

db_query or db_query_pre_auth

Database Query 数据库查询

Plugin version 插件版本

0.0.6

database and version 数据库及版本

sqlserver 2008R2

Problem description 问题描述

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 (172.16.31.88)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (172.16.31.88)\n')\n(Background on this error at: https://sqlalche.me/e/20/e3q8)"} pymssql包已经安装了没有用，我用pyodbc python脚本测试可以连接数据库，同一个数据源用你这个工具无法连接数据库

[junjiem]

先验证网络

[Ai5562]

您好，您的信件我已收到。如有必要我会尽快回复，谢谢！

[wzpabc]

遇到同样的问题，是不是pymssql不对，或者没有安装freetds; 我装的是docker版的dify,修复环境都不知道从哪个容器入手。。。 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: https://sqlalche.me/e/20/e3q8)"}

[Ai5562]

您好，您的信件我已收到。如有必要我会尽快回复，谢谢！

[zhangzc]

同样的问题，请问是否有解决办法？是不是2008r2版本太老了？

[wzpabc]

遇到同样的问题，是不是pymssql不对，或者没有安装freetds; 我装的是docker版的dify,修复环境都不知道从哪个容器入手。。。 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: https://sqlalche.me/e/20/e3q8)"}%22%7D)

1. enter plugin deamon container...Executing task: docker exec -it fff89445beb2eaa3f55192a bash
2. firstly,install freetds in docker container ​

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 volumes: - ./volumes/plugin_daemon:/app/storage - ./freetds:/etc/freetds depends_on:

docker compose up -d ​ 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

solution