search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
32.29k stars 3.5k forks source link

[Feature]: SSH Tunnel for Postgres #30792

Open Nikhil-Nandagopal opened 5 months ago

Nikhil-Nandagopal commented 5 months ago

Is there an existing issue for this?

Summary

Most of the companies have their production database behind a server. So providing an SSH tunnel will enable those users to use the platform with confidence and not compromising on security.

Why should this be worked on?

We have requests for this on https://github.com/appsmithorg/appsmith/issues/518

gabrielgarza commented 5 months ago

We can't use appsmith without this

ame-appsmith commented 4 months ago

Another user asked about this feature.

rohan-arthur commented 3 months ago

will be added with #31326

cdolan92 commented 3 months ago

Unable to use Appsmith without SSH tunnelling, wish this was supported!

Nikhil-Nandagopal commented 3 months ago

@cdolan92 I believe this is now supported. Which version are you on?

cdolan92 commented 2 months ago

Postgres 16 and I just installed appsmith via docker @Nikhil-Nandagopal

MySQL seems to have the option but Postgres does not

cdolan92 commented 2 months ago

Here is a screenshot of a fresh installation via Docker of the Community Edition:

notice there is no option for "SSH Tunnel" connection option like there is for MySQL

image
rohan-arthur commented 2 months ago

@cdolan92 thank you for reaching out to us. We're real close to releasing this feature, you can track it on #5183

sumitsum commented 2 months ago

Hi @rohan-arthur I think there might be small confusion here. Please correct me if that is not the case. This particular issue is for SSH feature while #5183 is for SSL. I am reopening this issue. Please close it if this is not the case.

GreenFlux commented 2 months ago

@rohan-arthur a user in Discord reported a similar issue with MySQL. Should we create a separate issue for it? https://discord.com/channels/725602949748752515/1225186370096726157/1225594304383156344

cdolan92 commented 2 months ago

Correct this is for SSH tunneling for a Postgres DB

Not related to SSL certificates

sumitsum commented 2 months ago

Hi @GreenFlux SSH tunnel should already be available for MySQL.

sebak2003 commented 2 months ago

My main problem with SSH to connect to MYSQL is that it is disconnected every day (or I guess every few hours of inactivity), then the end user cannot access the data to use the application. It requires a developer to go to the configuration and save it again. And then reconnect.

I have connected to this database with the same SSH key with other applications like n8n, or Tableplus. Same connection and none of them ask for the data every day to reconnect.

How can I get Appsmith to allow the connection or auto connect for end users automatically?

I just leave this here in case it is something that can be solved for both mysql and postgresql in its connection with SSH which is fundamental. Thanks!

sumitsum commented 2 months ago

Hi @sebak2003 thanks for reporting this issue. I have created another issue to track it.

prerakhere commented 3 days ago

Hi, any update for SSH tunnel support for Postgres? This was a blocker for me 6-8 months ago and it still is. Really hoping this comes out fast!