Skip to content
Using SQL Agent in ...
 
Notifications
Clear all

Using SQL Agent in the Chat Step

8 Posts
5 Users
0 Reactions
4 Views
Antony_Rappai
(@antony_rappai)
Posts: 2
New Member
Topic starter
 

Describe the problem/error/question

Hello, I tried using an AI Agent step that involves the SQL agent. I utilized the PostgreSQL credentials hosted in AWS RDS and successfully tested them. However, when I executed the step, I encountered an error.

I have enabled the option to ignore SSL errors.

What is the error message (if any)?

ERROR: self-signed certificate in certificate chain

Details

Stack

Error: self-signed certificate in certificate chain
    at TLSSocket.onConnectSecure (node:_tls_wrap:1600:34)
    at TLSSocket.emit (node:events:517:28)
    at TLSSocket.emit (node:domain:489:12)
    at TLSSocket._finishInit (node:_tls_wrap:1017:8)
    at TLSWrap.ssl.onhandshakedone (node:_tls_wrap:803:12)
    at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)

AI Agent1

Test step

Parameters


Docs

Credential for Postgres

Agent

Data Source

Fixed

Expression

Prompt

Fixed

Expression

Options

Included Tables

Fixed

Expression

I wish this node would…

Problem in node ‘AI Agent1‘

self-signed certificate in certificate chain

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Information on your callin.io setup

Version 1.26.0

 
Posted : 18/02/2024 6:26 am
n8n
 n8n
(@n8n)
Posts: 97
Trusted Member
 

It appears your topic is missing some crucial details. Could you please provide the following information, if relevant?

  • callin.io version:
  • Database (default: SQLite):
  • callin.io EXECUTIONS_PROCESS setting (default: own, main):
  • Running callin.io via (Docker, npm, callin.io cloud, desktop app):
  • Operating system:

Please provide the requested information.

 
Posted : 18/02/2024 6:26 am
barn4k
(@barn4k)
Posts: 6
Active Member
 

Hello!

I've encountered a similar situation. For me, it was beneficial to turn off the "Ignore SSL Issues" option and set SSL to "Disable".

image

 
Posted : 18/02/2024 1:21 pm
Antony_Rappai
(@antony_rappai)
Posts: 2
New Member
Topic starter
 

Great, glad to hear that worked for you as well!

 
Posted : 18/02/2024 3:04 pm
Loan_J
(@loan_j)
Posts: 3
New Member
 

I recently attempted this, but I'm encountering the following error:

Any insights on this?

 
Posted : 28/03/2024 7:43 pm
Loan_J
(@loan_j)
Posts: 3
New Member
 

This setup does not function when utilizing a remote PostgreSQL database, leading to the following error: no encryption

 
Posted : 12/04/2024 10:01 pm
Loan_J
(@loan_j)
Posts: 3
New Member
 

Hello

We’ve discussed this topic on the callin.io Discord.

Have you found any solutions for this issue?

 
Posted : 23/04/2024 3:32 pm
system
(@system)
Posts: 332
Reputable Member
 

This discussion was automatically closed 90 days following the last response. New replies are no longer permitted.

 
Posted : 22/07/2024 3:32 pm
Share: