[pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAM authentication support)

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAM authentication support)
Date: 2018-07-23 13:03:44
Message-ID: CANxoLDdvJGxgE3NVa-qHiV0joG+WCQ-UF2GZr57Bk9PGoBBm+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Hackers,

A new password encryption method "*scram-sha-256*" has been introduce in
PostgreSQL10. Along with that a new method "*PQencryptPasswordConn*" has
been exposed to get the encrypted password. This new method is not
supported in "psycopg2". Ashesh has send the patch https://github.com/
psycopg/psycopg2/pull/576 and has been merged into the master branch of
psycopg2 and will be available in their next release 2.8

"*Change password*" functionality was not working, as pgAdmin4 not able to
encrypt the password in scram. I have downloaded the latest code of
psycopg2, compile it with libpq version 10 and implement the logic in
pgAdmin4.

Attached is the patch to fix that issue. Please review it.

--
*Akshay Joshi*

*Sr. Software Architect *

*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*

Attachment Content-Type Size
RM_2214.patch application/octet-stream 3.5 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2018-07-23 13:06:35 Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAM authentication support)
Previous Message Khushboo Vashi 2018-07-23 05:03:57 Re: [pgAdmin4][Patch]: Partition table fix