Connect with database standing on host which requires SSH connection using Qt
-
It's possible (I do it with a remote (only accessible with ssh) Microsoft's SQLServer)
Establish the tunnel using ssh, preferably with 5432 on both sides, e.g.
ssh -L 5432:localhost:5432 userFromAbove@host.with.database.comthen start a QSqlDatabase connected to localhost:5432
wrote on 10 Jan 2020, 20:28 last edited by@hskoglund Thanks, seems like connection was created, but now I receive new error
psql: FATAL: Ident authentication failed for user "userFromAboveHost"despite of passing valid credentials. How to avoid that?
-
wrote on 10 Jan 2020, 20:49 last edited by
Hmm in the screenshot above it's ""userFromAboveServer" not ""userFromAboveHost"?
-
wrote on 10 Jan 2020, 21:00 last edited by
@hskoglund Oh I see, it argues with postgres on my local machine and when I set hostname to "localhost", it tries to connect local database rather than remote. In fact
ssh -L 5432:localhost:5432 userFromAboveHost@host.with.database.comseems to have no effect.
Generally, db tries to establish connection with local machine postgres all the time. Local postgres listen on 5432. Any ideas how to solve that? I think that I'm going to achieve the goal but it's still far away... :(
-
@marcus74 said in Connect with database standing on host which requires SSH connection using Qt:
Any ideas how to solve that?
Use another port - you can't open a ssh tunnel on a port which is already in use.
-
wrote on 10 Jan 2020, 21:10 last edited by
Still does not work.
ssh -L 5000:localhost:22 userFromAboveHost@host.with.database.comhave no effect too.
-
Hi,
@Christian-Ehrlicher suggested to change the port on your local host side to avoid the clash no the two. You can also disable temporarily your local PostgreSQL during the testing.
-
Hi,
@Christian-Ehrlicher suggested to change the port on your local host side to avoid the clash no the two. You can also disable temporarily your local PostgreSQL during the testing.
-
@marcus74 said in Connect with database standing on host which requires SSH connection using Qt:
I've done it on screen and it didn't work as well
ssh -L 5000:localhost:22 userFromAboveHost@host.with.database.comNo, you're now connecting to port 22 on your database server
-
wrote on 10 Jan 2020, 21:30 last edited by
The procedure is pretty good (and officially) documented by PostgreSQL
-
@marcus74 said in Connect with database standing on host which requires SSH connection using Qt:
I've done it on screen and it didn't work as well
ssh -L 5000:localhost:22 userFromAboveHost@host.with.database.comNo, you're now connecting to port 22 on your database server
wrote on 10 Jan 2020, 21:31 last edited by@Christian-Ehrlicher On screen code I tried in second line:
ssh -L 5000:localhost:5432 userFromAboveHost@host.with.database.comand it gave above output.
-
wrote on 10 Jan 2020, 21:37 last edited by hskoglund 1 Oct 2020, 21:43
Again hmm,, in the screenshot above you're using
server.using.tunnel.com(not ```host.with.database.com``)?Edit: I mean you should try this SSH:
ssh -L 5000:host.with.database.com:5432 userFromAboveServer@server.using.tunnel.com -
Again hmm,, in the screenshot above you're using
server.using.tunnel.com(not ```host.with.database.com``)?Edit: I mean you should try this SSH:
ssh -L 5000:host.with.database.com:5432 userFromAboveServer@server.using.tunnel.comwrote on 10 Jan 2020, 22:27 last edited by@hskoglund Again, I receive errors about not accepting TCP/IP connections. Maybe I should pass by some way a password in process object for
userFromAboveServer@server.using.tunnel.combecause in Windows cmd I am requested for password after doing this:
ssh -L 5000:host.with.database.com:5432 userFromAboveServer@server.using.tunnel.com -
wrote on 10 Jan 2020, 22:35 last edited by
Yeah, if you're establishing the SSH tunnel via a command line, then there's no stable way to submit the password.
I think putty can be used in an automatic way, or, if you have a admin rights on server.using.tunnel.com you could create keys, so that no password is needed, more for example here -
wrote on 10 Jan 2020, 22:39 last edited by marcus74 1 Oct 2020, 22:40
Ok, after long perturbations I used program:
https://geekflare.com/create-port-listener-in-windows-or-linux/
and created listening port 5000, then ran Qt project and everything is fine.
Thanks for all your patience :)To conclude, passing passoword as I mentioned above is not mandatory.
13/17