Re: How to debug authentication issues in Postgres

Поиск
Список
Период
Сортировка
От Hemil Ruparel
Тема Re: How to debug authentication issues in Postgres
Дата
Msg-id CANW1aT9uqFDwi-NspJhWJO22EP1qhcewsbN2L7TNcSe_OMigPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to debug authentication issues in Postgres  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Список pgsql-general
My password had ascii spaces in it which the jdbc implementation stripped as a part of normalization of scram passwords causing authentication failures. I have submitted a PR. Hope it gets merged. The fix was literally one character because of which I spent days chasing the bug lol

On Sun, Nov 29, 2020 at 4:38 PM Daniele Varrazzo <daniele.varrazzo@gmail.com> wrote:
IIRC you need libpq at least 10 to use password encryption other than md5. Maybe your java client uses an older version, or no libpq at all and the client library misses that feature?

-- Daniele 


On Sat, 28 Nov 2020, 16:12 Hemil Ruparel, <hemilruparel2002@gmail.com> wrote:
I am unable to connect using Java in general. And DataGrip runs on Java as far as I know. My backend in python runs perfectly fine using the psycopg2 library (postgres driver for python).

I was actually changing the database name and user name

On Sat, Nov 28, 2020 at 9:28 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 11/28/20 6:10 AM, Hemil Ruparel wrote:
> Line 88 is this line: host    database    user 0.0.0.0/0
> <http://0.0.0.0/0>               scram-sha-256.
>
> I might have forgotten to change one of the names in the earlier mails.
>

Change from what? This should just be a copy and paste or am I missing
something?


--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: error on connecting port 5432
Следующее
От: Atul Kumar
Дата:
Сообщение: Re: error on connecting port 5432