Postgres Pro
Downloads
Home   >   mailing lists

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

From Akshay Joshi
Subject [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)
Date
Msg-id CANxoLDdvJGxgE3NVa-qHiV0joG+WCQ-UF2GZr57Bk9PGoBBm+Q@mail.gmail.com
Whole thread Raw
Responses Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)  (Dave Page <dpage@pgadmin.org>)
Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)  (Dave Page <dpage@pgadmin.org>)
List pgadmin-hackers
Tree view
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-9517
Mobile: +91 976-788-8246
Attachment

pgadmin-hackers by date:

Previous
From: Khushboo Vashi
Date:
Subject: Re: [pgAdmin4][Patch]: Partition table fix
Next
From: Dave Page
Date:
Subject: Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)