search

n8n-io / n8n

Free and source-available fair-code licensed workflow automation tool. Easily automate tasks across different services.
https://n8n.io
Other
42.32k stars 5.48k forks source link

Cannot test PostgreSQL trigger with ssh tunnel #8970

Open DanFaudemer opened 3 months ago

DanFaudemer commented 3 months ago

Bug Description

When testing a PostgreSQL trigger with an ssh tunnel credential I get the following error : 

Problem in node ‘Postgres Trigger‘
connect ECONNREFUSED 127.0.0.1:5432

To Reproduce

  1. Create a PostgreSQL trigger
  2. Add a PostgreSQL credential with a ssh tunnel
  3. Test the trigger

Expected behavior

I should be able to test my trigger

Operating System

Kubernetes

n8n Version

1.33.1

Node.js Version

18.19.1

Database

PostgreSQL

Execution mode

main (default)

Joffcom commented 3 months ago

Hey @DanFaudemer,

That is a good spot, it looks like when we added support for SSH tunnels we may not have updated the Postgres Trigger. I have created NODE-1267 as the internal ticket to fix this.