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.varra...@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, <hemilruparel2...@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.kla...@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.kla...@aklaver.com >>> >>
