这是indexloc提供的服务,不要输入任何密码
Skip to content

[FEAT]: MSSQLConnector Support additonal provider config for options.encrypt #4073

@jstawski

Description

@jstawski

How are you running AnythingLLM?

Docker (remote machine)

What happened?

When the agent tries to execute any SQL statement agains the Azure SQL Server database it fails with the following log

[36m[backend]�[0m �[32minfo�[39m: �[36m[AgentHandler]�[0m [debug]: @agent is attempting to call sql-get-table-schema tool
�[36m[backend]�[0m �[32minfo�[39m: �[36m[AgentHandler]�[0m Using the sql-get-table-schema tool.
�[36m[backend]�[0m �[32minfo�[39m: MSSQLConnector ConnectionError: Server requires encryption, set 'encrypt' config option to true.
at /app/server/node_modules/mssql/lib/tedious/connection-pool.js:85:17
at Connection.onConnect (/app/server/node_modules/tedious/lib/connection.js:838:9)
at Object.onceWrapper (node:events:632:26)
at Connection.emit (node:events:517:28)
at Connection.emit (/app/server/node_modules/tedious/lib/connection.js:959:18)
at /app/server/node_modules/tedious/lib/connection.js:2234:18
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
�[36m[backend]�[0m �[32minfo�[39m: �[36m[AgentHandler]�[0m sql-get-table-schema raised an error. Cannot read properties of null (reading 'close')

Are there known steps to reproduce?

  1. Turn on SQL Connector on Agent Skills
  2. Add a connection to a SQL Server hosted on Azure
  3. In the chat ask the agent to retrieve list of tables, or any prompt that will require reading from the database.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions