Can I use a domain name for the remote bind address?

lymperis-e / qgis_remote_db_plugin

A QGIS plugin to open SSH connections to remote database servers

https://plugins.qgis.org/plugins/remote_db/

GNU General Public License v3.0

4 stars 1 forks source link

Can I use a domain name for the remote bind address? #4

Open dakotabenjamin opened 11 months ago

dakotabenjamin commented 11 months ago

The reason being that my postgres server (RDS) is not on the same server as my bastion, and RDS does not provide IP addresses for their endpoint. For example in ssh config I can create a tunnel as follows:

Host bastion-tunnel
  HostName 111.222.333.444
  User ubuntu
  IdentityFile ~/.ssh/key.pem
  LocalForward localhost:5434 db.csdfgvsdfg.us-east-1.rds.amazonaws.com:5432

When I attempt to use the RDS server endpoint for my Remote Bind Address, it shows in red and won't save.

lymperis-e commented 11 months ago

Hey Benjamin, I am a bit confused, why don't you directly use your RDS server domain name in a PostgreSQL connection? I believe you do not need this plugin for your purpose. You can directly connect to your database using QGIS's builtin tools

letsgreentheplanet commented 9 months ago

I guess it's because the server is not on the public network?

Also, we have the same issue. We are currently using a static resolved IP address as a workaround but this can be a solution