Private Postgres Connection through Bastion

[fredl]

• Goal: I'm trying to connect to postgres in a private subnet using an SSH bastion

• Steps: I setup an SSH bastion server which I was hoping would allow retool to connect to the DB in the private subnet

• Details: when I attempt to connect to the private IP address I get a connection timeout. I can connect to the same IP address from resources within my subnet

• Screenshots:
  

  

Is there a way to get it to connect through the SSH bastion I have setup?

[ZeroCodez]

Hello @fredl

You can refer to the Retool documentation to set up a connection to PostgreSQL.

Configure SSH tunneling for resources | Retool Docs

Configure SSL connections for data sources | Retool Docs

Connect a PostgreSQL database | Retool Docs

[fredl]

FYI this is now fixed. The linked article helped.

For anyone seeing this in the future the issue was that this line needed to be added to the SSH Config:

PubkeyAcceptedKeyTypes +ssh-rsa

Quick question, given that RSA keys are now deprecated by openssh are there any plans to move over to a non-deprecated key type, perhaps as an account option?