Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Connect using a Postgres connection string #193

Closed
zarakay opened this issue Feb 17, 2022 · 1 comment · Fixed by #200
Closed

Connect using a Postgres connection string #193

zarakay opened this issue Feb 17, 2022 · 1 comment · Fixed by #200
Assignees
@Fabio286
Labels
enhancement 🚀 New feature or request

Comments

@zarakay
Copy link

zarakay commented Feb 17, 2022

Is your feature request related to a problem? Please describe.

We are working to use teleport to connect to our remote databases. This service uses certificate based proxying to connect to databases. The output of this tool is a connection string (in our case a postgres connection string). Its a real pain to take the connection string and separate out the bits to put it in each dialog box. Especially since credentials are short lived.

Describe the solution you'd like

The ability to optionally paste a connection string that is parsed and auto inserted into the appropriate input boxes maybe as a starting point after which the input boxes can be further modified.

Describe alternatives you've considered

Manually entering credentials each time :(
@Fabio286 Fabio286 added enhancement 🚀 New feature or request good first issue Good for newcomers labels Feb 17, 2022
@Fabio286 Fabio286 added this to 📌 To do in Antares SQL via automation Feb 17, 2022
@Fabio286
Copy link
Member

Hi Zara,

it should be quite simple to add a function to fill in the connection form via connection string.
I add it to the list of future implementations.

Thanks for your idea

raliqala added a commit to raliqala/antares that referenced this issue Mar 6, 2022
@raliqala
feat(PostgreSQL): ✨ Postgress connection string feature for local and…
f4a63ea 
… server connection string

This feature is based on this [issue](antares-sql#193)  I tested with the following posgress connection strings postgresql://postgres:pgpassword@127.0.0.1:5432/my_local_databse?connection=local postgres://serveruser:serverpass@test.db.elephantsql.com/my_remote_databse?connection=server  postgres://serveruser:serverpass@test.db.elephantsql.com:5432/my_remote_databse postgresql://postgres:pgpassword@127.0.0.1:5432/my_local_databse.

The connection string decoder is loaded before "test-connection", "check-connection", and "connect"
@raliqala raliqala mentioned this issue Mar 6, 2022
Merged
4 tasks
@Fabio286 Fabio286 linked a pull request Mar 6, 2022 that will close this issue
feat(PostgreSQL): ✨ Postgress connection string feature for … #200
Merged
4 tasks
Antares SQL automation moved this from 📌 To do to ✔ Done Mar 6, 2022
Fabio286 pushed a commit that referenced this issue Mar 6, 2022
@raliqala @Fabio286
feat(PostgreSQL): ✨ Postgress connection string feature for local and…
6305752 
… server connection string

This feature is based on this [issue](#193)  I tested with the following posgress connection strings postgresql://postgres:pgpassword@127.0.0.1:5432/my_local_databse?connection=local postgres://serveruser:serverpass@test.db.elephantsql.com/my_remote_databse?connection=server  postgres://serveruser:serverpass@test.db.elephantsql.com:5432/my_remote_databse postgresql://postgres:pgpassword@127.0.0.1:5432/my_local_databse.

The connection string decoder is loaded before "test-connection", "check-connection", and "connect"
@Fabio286 Fabio286 removed this from ✔ Done in Antares SQL Mar 29, 2022
@Fabio286 Fabio286 removed the good first issue Good for newcomers label Jun 2, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Fabio286 Fabio286

Labels
enhancement 🚀 New feature or request
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat(PostgreSQL): ✨ Postgress connection string feature for … raliqala/antares
2 participants
@zarakay @Fabio286