search

warp-tech / warpgate

Smart SSH, HTTPS and MySQL bastion that requires no additional client-side software
Apache License 2.0
3.88k stars 120 forks source link

Request to add PostgreSQL Connection Instructions in WarpGate UI #1069

Open vjmax opened 1 month ago

vjmax commented 1 month ago

I have configured a PostgreSQL target in WarpGate and need assistance with the correct connection command. I have set up the warpgate.yaml configuration file as follows:

**postgres:
  enable: true
  listen: "0.0.0.0:55432"
  external_port: ~
  certificate: yes/tls.certificate.pem**

I added the PostgreSQL target through the WarpGate UI, but unlike the SSH and MySQL targets, there are no example connection commands provided for PostgreSQL.

Steps Taken:

Connection Attempt: Used the following command to connect but it did not work:

psql -U "admin#targetname" --host "warpgatehost" --port 55432

I’m unsure of the correct format for the psql command or if additional configuration is required.

Request:

Could you please provide:

An example command for connecting to a PostgreSQL target through WarpGate. Any additional configuration that might be necessary.

Thank you!

Eugeny commented 1 month ago

Are you doing it on the branch (#1021) build? It's still not ready and is missing things like these.

vjmax commented 1 month ago

I have used this package - https://nightly.link/warp-tech/warpgate/workflows/build/postgres

Eugeny commented 1 month ago

Gotcha - that PR isn't ready yet and is missing connection instructions, but your command should be correct (you can also try : instead of # as target separator, both are supported).

What's the connection error? Are there any messages in the warpgate output? You can add --debug for more verbose logging