Re: How to debug authentication issues in Postgres

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(dot)varrazzo(at)gmail(dot)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(at)gmail(dot)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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>>>
>>