DataGrip + SSH Tunnel with GnuPG authentication and ToolBox
Hi there,
I tried to find similar topics, but the ones I found only partially covered my problem.
System: Mac OSX Sierra 10.12.4
App:
- DataGrip 2017.1.2 - installed with the JetBrains ToolBox
- JetBrains ToolBox 1.2.2314
THE DATAGRIP ISSUE
Situation: For my live environment I have to connect to database through SSH tunnel:
- local machine > Live Webserver with SSH @ port: 22 > Live Database server with Socket @ port: 3306
- To connect to the live webserver I have to use a login name and a YubiKey which uses the GnuPG (a.k.a GPG) authentication (not my decision).
- The live database server allows only socket connection from the given webserver.
- To connect to the live database server from the webserver I use the same loginname and an SSH key generated on the webserver. The security policy doesn't allow to use this SSH key file to connect to the webserver too.
Problem: So I have no password nor private/public RSA keys in files to connect to the webserver only a hardware authentication device. And in the DataGrip there is no option for this type of connection. And I get an "SSH: Auth fail" message.
In comparison with other applications, the MySQL Workbench (I have to use this now, but it's uncomfortable and buggy) and the Sequel Pro (I found it very insecure since it doesn't ask for confirmation on executing queries) can both can handle this kind of GPG authentication SSH tunneling. But I'd like to use DataGrip :)
THE TOOLBOX ISSUE
User-unfriendliness issue #1: to be able to use the MySQL Workbench and the Sequel Pro with the GPG authentication, I have to start the application from the Terminal window (as a user with Administrator rights) like: `open /Application/MySQLWorkbench.app`.
This is the only way the application can use the GnuPG authentication. The "user-unfriendliness" issue of the DataGrip comes with the JetBrains Toolbox, because it installs all the JetBrains products into an own path and doesn't create any symlinks to the Application folder. I had to do it manually to simplify the "administrator" execution:
/Applications/DataGrip.app -> /Users/g.ivan/Library/Application\ Support/JetBrains/Toolbox/apps/datagrip/ch-0/171.4249.43/DataGrip.app
I would be happy if the ToolBox could create the symlink for the active versions of the installed JetBrains applications and don't show them as "LOCAL" in the ToolBox window.
User-unfriendliness issue #2: the other problem is connected to the previous one. In OSX I like the most used application to "Keep in Dock". But since the ToolBox installs every version of every application into a separate folder and there's no support for unified symlinks in the /Application folder, after each update the Dock icon still points to the "old" version. It simply doesn't come to my hand to start these apps from the ToolBox window (+1 additional pointer click) while all the other applications (e.g.: Skype, Outlook, browser etc) are in the Dock. And also very uncomfortable.
Can you improve it?
Thank you for listening (reading).
Best,
Gabor
请先登录再写评论。
Hi,
There is a discussion about YubiKey https://youtrack.jetbrains.com/issue/IDEA-160256#comment=27-1677790
As for Toolbox App you can track the following issues:
Thank you.