[FEATURE] SSH Tunnel for Database connections (MySQL) about appsmith HOT 30 CLOSED

It would be basic to have this feature for my company to start using AppSmith

from appsmith.

After a bit of deliberation, we recommend anyone trying to access their db behind a VPC to whitelist our ip
In the meanwhile, we'll work on a slightly more involved solution to support SSH Tunnel and remove the incorrect tunnel option for other databases.

from appsmith.

Hi guys, any update about this feature. I'm really interested on it.
Thanks

from appsmith.

from appsmith.

Hello @akbansa, thank you for reporting this. The SSH Tunnel configuration in the Postgres datasources is a bug, since the feature is not currently supported by Appsmith. A solution to this problem is currently already being worked upon.

from appsmith.

Looks like there's now a task for this #22064. 🤞

from appsmith.

Any workarounds you would suggest in case of postgres? Otherwise I can't access the data and I am completely blocked in that case.

from appsmith.

• @rohan-arthur @sribalajig

from appsmith.

@akbansa Thanks for the feature request! I believe we do support this feature today. Were you having trouble accessing it? What type of database are you trying to connect to?

Here is a screenshot of our tunnel feature

from appsmith.

@Nikhil-Nandagopal Yes, it's there for PostgreSQL but not for MySQL.

Here is the screenshot for the same:

from appsmith.

Got another request from a friend about SSH for MySQL.

from appsmith.

@areyabhishek, I've written about this in a GitHub discussion recently (link: https://github.com/appsmithorg/appsmith/discussions/4094#discussioncomment-652646). Is there a reason they prefer to connect via SSH tunneling as opposed to whitelisting our IP for direct connections? Asking because that'll put into perspective whatever I'm missing in their use cases.

from appsmith.

Linking an internal discussion thread regarding this issue https://theappsmith.slack.com/archives/C01HUHMDPS9/p1622718510217300 for future reference.

from appsmith.

What time can we expect a SSH tunnel for MySQL / MariaDB?

from appsmith.

Is this still active in development? We too use MySql server that listens at localhost level and the only way to access the DB from an external app is via SSH Tunnel.

from appsmith.

Hello Guys do you have any update about this feature on the near roadmap of developing? This feature will be great because my Postgres and MsSql are in local server and the connections we do by ssh certificate.

from appsmith.

we need this

from appsmith.

We need this feature too, we can't connect to our Postgres DB unless we have SSH Tunneling. We would start using Appsmith if not for this

from appsmith.

Interesting! The SSH Tunneling gives us the best security when accessing our data remotely.
I think it's a must for now.

from appsmith.

My web host only allows database connections via a SSH tunnel. I'm trying to connect to WordPress-powered ecommerce data. This is a blocker for me to be able to use Appsmith—please add!

from appsmith.

This should definitely be there as most hosts block all access by default and some setups, specifically using Appsmith via docker locally might have roaming/changing IPs, so whitelisting can be tedious every time you connect.

Workaround for some users might be to create local MySQL DB and then use Airbyte, which does offer MySQL over SSH, to sync to a local DB on the same server as Appsmith or another of your choice as Airbyte is a 2 way sync tool.

Essentially you would be making your own data-warehouse, but it is a simple solution.

from appsmith.

+1

from appsmith.

I agree with the others. Our SysOps-Team decided that SSH tunnel for database access is the way to go. As a developer I can not circumvent that setup, I also can not make them whiteliste an IP for direct access.

I would love to use appsmith for development but the lack of this feature prevents me from using your product.

from appsmith.

Any Updates on this?

This is a blocker for my team too. Without SSH Tunneling for DB connections, we cannot use Appsmith.

from appsmith.

@fahall Good news: @mohanarpit shared on Hacker News that they were going to bump this on the internal priority list!

https://news.ycombinator.com/item?id=35371190

from appsmith.

Closing it as core changes have been merged in release.

from appsmith.

I still can't see SSH options while connecting to my postgres database sitting inside an isolated subnet inside a VPC. I can only connect to my database by SSHing through a bastion host.

from appsmith.

Hi @prerak-jain the SSH tunnel feature is only implement for MySQL integration at the moment.

from appsmith.

Same as @prerakhere, we can not use Appsmith until SSH Tunnel to PostgreSQL database is possible as our database is secured behind a Bastion.

from appsmith.

@andredealmei @prerakhere I've raised a feature request for this here #30792 you can leave a comment there to get it prioritised

from appsmith.