Postgres Pro
Downloads
Home   >   mailing lists

Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support) - Mailing list pgadmin-hackers

From Dave Page
Subject Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)
Date
Msg-id CA+OCxowVSXkPjxgHseDpBWYUBmWC-9ovLUBPY0ABh0tiSqEXKg@mail.gmail.com
Whole thread Raw
In response to [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
Responses Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)
List pgadmin-hackers
Tree view
Hi Akshay

On Mon, Jul 23, 2018 at 2:03 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
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.     

Cool. Do you have any tips or hints on the easiest way to build psycopg2 from the tree, without using PIP?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-hackers by date:

Previous
From: Akshay Joshi
Date:
Subject: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)
Next
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Fix panel errors seen when click on partitions.