[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: How to debug authentication issues in Postgres
From:       Daniele Varrazzo <daniele.varrazzo () gmail ! com>
Date:       2020-11-29 11:08:17
Message-ID: CA+mi_8avwXgPaWtPoUW=cu794R5hhJ8S+7u28ALasROtii-W-Q () mail ! gmail ! com
[Download RAW message or body]

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
>>
>

[Attachment #3 (text/html)]

<div dir="auto"><div>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?</div><div dir="auto"><br></div><div dir="auto">-- \
Daniele  </div><div dir="auto"><br><br><div class="gmail_quote" dir="auto"><div \
dir="ltr" class="gmail_attr">On Sat, 28 Nov 2020, 16:12 Hemil Ruparel, &lt;<a \
href="mailto:hemilruparel2002@gmail.com">hemilruparel2002@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>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). <br></div><div><br></div><div>I was actually changing the database name and \
user name<br></div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Sat, Nov 28, 2020 at 9:28 PM Adrian Klaver &lt;<a \
href="mailto:adrian.klaver@aklaver.com" target="_blank" \
rel="noreferrer">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">On 11/28/20 6:10 AM, Hemil Ruparel wrote:<br> &gt; \
Line 88 is this line: host      database      user <a href="http://0.0.0.0/0" \
rel="noreferrer noreferrer" target="_blank">0.0.0.0/0</a> <br> &gt; &lt;<a \
href="http://0.0.0.0/0" rel="noreferrer noreferrer" \
target="_blank">http://0.0.0.0/0</a>&gt;                      scram-sha-256.<br> &gt; \
<br> &gt; I might have forgotten to change one of the names in the earlier mails.<br>
&gt; <br>
<br>
Change from what? This should just be a copy and paste or am I missing <br>
something?<br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href="mailto:adrian.klaver@aklaver.com" target="_blank" \
rel="noreferrer">adrian.klaver@aklaver.com</a><br> </blockquote></div>
</blockquote></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]