-
-
Notifications
You must be signed in to change notification settings - Fork 5.4k
Description
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-schematool
�[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?
- Turn on SQL Connector on Agent Skills
- Add a connection to a SQL Server hosted on Azure
- In the chat ask the agent to retrieve list of tables, or any prompt that will require reading from the database.