The built-in tunneling support requires the user have shell access. In our environment we require ssh tunneling for certain production environment but don't grant shell access to the jump boxes. Creating the tunnel from our mac shell prompt, we use the ssh -N option: port traffic is forwarded but the user can't open a terminal. Unfortunately this isn't an option within ADS so we have to create the tunnel outside of ADS.
It would really be nice if you could supply the ssh tunnel config within the DB connection too. MySQL MySQLWorkbench supports this, and creates the tunnel without requiring shell access too.
This issue isn't minor for us because of this: ADS simply hangs if a query runs more than 4 minutes, all open windows entirely unresponsive until the query finishes. As we frequently have to run long running queries, we simply can't use ADS exclusively... I need to use other query tools while ADS is hung up. I prefer ADS for many reasons but can't recommend it to my peers simply because of this issue.
Issue #15879 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
This issue isn't minor for us because of this: ADS simply hangs if a query runs more than 4 minutes, all open windows entirely unresponsive until the query finishes. As we frequently have to run long running queries, we simply can't use ADS exclusively... I need to use other query tools while ADS is hung up. I prefer ADS for many reasons but can't recommend it to my peers simply because of this issue.