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
-
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
@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?
-
@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.
-
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
-
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
@Christian-Ehrlicher On screen code I tried in second line:
ssh -L 5000:localhost:5432 userFromAboveHost@host.with.database.comand it gave above output.
-
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@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 -
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 -
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.
