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.

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

Windows/SSPI: gives "unknown authentication response: 9" #25

Open
Bill-Stewart opened this issue Jun 26, 2019 · 2 comments
Open

Windows/SSPI: gives "unknown authentication response: 9" #25

Bill-Stewart opened this issue Jun 26, 2019 · 2 comments

Comments

@Bill-Stewart
Copy link

Trying to authenticate using SSPI on Windows - see

https://wiki.postgresql.org/wiki/Configuring_for_single_sign-on_using_SSPI_on_Windows

I can open a shell window using the Windows domain account and run PostgreSQL commands (Windows domain account is PostgreSQL superuser).

Can I do the same with pgmetrics? I try:

pgmetrics.exe -h localhost -U username -w databasename

Output:

pgmetrics: pq: unknown authentication response: 9

Or is this not supported?

@mdevan
Copy link
Contributor

mdevan commented Jun 27, 2019

Does it behave properly without SSPI auth (with trust/md5/scram)?

Collecting metrics from Postgres servers running on Windows has not been tested much. Bug reports welcome.

Neither of the 2 popular Go libraries for Postgres (lib/pq and jackc/pgx) support SSPI (or even GSSAPI), so SSPI support has to be added there first. We did patch lib/pq to support SCRAM, but that was easier to test.

@Bill-Stewart
Copy link
Author

Does it behave properly without SSPI auth (with trust/md5/scram)?

I don't know, since we only use SSPI.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants