Thread: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)
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
Mobile: +91 976-788-8246
Attachment
Thanks - patch applied.
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.--Akshay JoshiSr. Software ArchitectPhone: +91 20-3058-9517
Mobile: +91 976-788-8246
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Mon, Jul 23, 2018 at 6:36 PM, Dave Page <dpage@pgadmin.org> wrote:
Hi AkshayOn 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?
Steps on Ubuntu 18.04 64 bit:
- Clone psycopg2 from https://github.com/psycopg/psycopg2.git
- Activate the virtual environment.
- Add path of PostgreSQL 10(/opt/PostgreSQL/10/bin) to PATH variable, so that psycopg2 will compile against libpq version greater or equal to 100000.
- Go to the psycopg2 folder and run the following:
- python setup.py build
- python setup.py install
- It will create psycopg2-2.8.dev0-py2.7-linux-x86_64.egg
- Remove/Move all other folders or files with the name of "psycopg2" from site-packages.
--Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Akshay Joshi
Sr. Software Architect
Phone: +91 20-3058-9517
Mobile: +91 976-788-8246
Mobile: +91 976-788-8246