Re: How to debug authentication issues in Postgres
| От | Hemil Ruparel |
|---|---|
| Тема | Re: How to debug authentication issues in Postgres |
| Дата | |
| Msg-id | CANW1aT9Ne-_ynNisWfQA6Q5exNDt0L6Ocu+aAY=zHEUkMpEGgw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to debug authentication issues in Postgres (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: How to debug authentication issues in Postgres
|
| Список | pgsql-general |
Thanks for the clarification. According to this page, https://jdbc.postgresql.org/documentation/changelog.html#version_42.2.0, scram support was added in JDBC driver 42.2.0. I am on 42.2.18. And using the java code mentioned above, I still get the same error.
On Fri, Nov 27, 2020 at 9:06 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Hemil Ruparel <hemilruparel2002@gmail.com> writes:
> When I try to connect to the database, the log says:
>> FATAL: password authentication failed for user "user"
>> DETAIL: Connection matched pg_hba.conf line 88: "host user
> password 0.0.0.0/0 scram-sha-256"
> So I think the client is using scram-sha-256
No, what that says is that the server is going to insist on scram-sha-256.
If the client can't handle SCRAM, then a failure would be expected.
regards, tom lane
В списке pgsql-general по дате отправления: