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
3yrs passed and still no banner? have stuck with same issue in PHPStorm 2025.2