Support authentication using client certificates #218

Closed
jakob opened this Issue May 17, 2016 · 4 comments

Comments

Projects
None yet
2 participants
@jakob
Owner

jakob commented May 17, 2016

Currently, Postico will authenticate with client certificates if you store the cert and key at the paths ~/.postgresql/postgresql.crt and ~/.postgresql/postgresql.key respectively.

It would be convenient to be able to chose files at a different location, and to use different settings per favorite.

@twrobel3

This comment has been minimized.

Show comment
Hide comment
@twrobel3

twrobel3 May 18, 2016

👍

This would be great. So far Postico is the only graphical SQL client that I've found that works with CockroachDB, but that ONLY supports auth using client certs (and in all the tutorials show multiple users, with their own cert sets), so a more convenient way to toggle user certs/have them tied to a favorite would be far more convenient.

Cockroach is still in early beta, but is gaining a lot of speed and attention, so being the first/only graphical client to support them will likely generate a lot of new users ;)

👍

This would be great. So far Postico is the only graphical SQL client that I've found that works with CockroachDB, but that ONLY supports auth using client certs (and in all the tutorials show multiple users, with their own cert sets), so a more convenient way to toggle user certs/have them tied to a favorite would be far more convenient.

Cockroach is still in early beta, but is gaining a lot of speed and attention, so being the first/only graphical client to support them will likely generate a lot of new users ;)

@jakob jakob added the enhancement label May 25, 2016

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob May 26, 2016

Owner

I've added a new issue concerning general CockroachDB compatibility: #224

Owner

jakob commented May 26, 2016

I've added a new issue concerning general CockroachDB compatibility: #224

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob May 27, 2016

Owner

I've now added a way to select client certificates per favorite:

  1. click on the "Edit" favorite button
  2. In the "Options" popup menu, click "Use TLS Client Certificate"
  3. Now select both the .key and .crt files

This feature will be released in the next update. You can download a prerelease here:
https://eggerapps-downloads.s3-eu-west-1.amazonaws.com/postico-1436.zip

Owner

jakob commented May 27, 2016

I've now added a way to select client certificates per favorite:

  1. click on the "Edit" favorite button
  2. In the "Options" popup menu, click "Use TLS Client Certificate"
  3. Now select both the .key and .crt files

This feature will be released in the next update. You can download a prerelease here:
https://eggerapps-downloads.s3-eu-west-1.amazonaws.com/postico-1436.zip

@jakob jakob added the done label May 27, 2016

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Jun 1, 2016

Owner

Fixed in 1.0.7

Owner

jakob commented Jun 1, 2016

Fixed in 1.0.7

@jakob jakob closed this Jun 1, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment