SQLite Connection with SSH Tunnel
Answered
I am trying to connect to a database through an SSH tunnel. The SSH tunnel is already set-up and allows me to connect to a remote interpreter, so I know it is working correctly. However, I am not entirely sure how to set-up the URL to connect to the remote database. I keep getting the "Unable to apply SSH settings: Host & port not found. Fix URL or create template" error, but there is no explanation of what I need to do. The documentation online does not provide enough information on how to structure the URL template and how to link it with the SSH Tunnel option, so I am at a loss.
Please sign in to leave a comment.
Hi Geoff Klein,
I'm dealing with a similar issue, what tutorial did you follow for setting up a SQLite ssh tunnel as I'm looking to do the same. I found this link of a similar nature but will follow your issue. https://intellij-support.jetbrains.com/hc/en-us/community/posts/360000145044--Database-Source-SSH-Unable-to-find-host-port-in-URL
Have you specified the SSH tunnel in the datasource properties?
Konstantin Annikov yes I have that setup. Its the same SSH tunnel configuration I already use for remote interpreters so I know it works.
PyCharm can't do that using JDBC connection. You can do it using sqlite3 and run commands remotely http://unix.stackexchange.com/questions/41611/perform-remote-sqlite-command
There is an issue https://youtrack.jetbrains.com/issue/DBE-1436 about your problem
Why can't I if the option for SSH tunneling is there?
Here you could find the comment regarding that: https://youtrack.jetbrains.com/issue/DBE-1436/SQLite-remote-tunneling#focus=Comments-27-6205323.0-0
If SSH tunneling is not allowed with SQLight, then why does the option exist?
We will add the banner that SSH does not work in 2022.3