pgAdmin4 needs information of v10 SCRAM authentication

[Akshay Joshi <akshay.joshi@xxxxxxxxxxxxxxxx>]

Hi All

We are into development phase where we are trying to incorporate the v10 changes into pgAdmin4. v10 added support for the SCRAM authentication into database server, so pgAdmin4 needs to incorporate that feature(for 'Change Password'). Now problem I am facing is, unable to find correct set of python api's which I can use to perform SCRAM encryption/decryption through pgAdmin4 (Most of you already know that pgAdmin4 is re-written in Python and Web technologies). 

 

I have googled for how to encrypt password for scram and found https://passlib.readthedocs.io/en/1.6.2/lib/passlib.hash.scram.html?highlight=scram#passlib.hash.scram . I have tried below logic to encrypt the password:

from passlib.hash import scram
hash = scram.encrypt(data['newPassword']) -- This function provide password for all the supported digest like [md5, sha-1, sha-256, sha-512]. Didn't work I have tried with all the passwords. 
test = scram.extract_digest_info(hash, "sha-256") -- This function extract info for specified digest "sha-256". I have retrieve the password which was in hexadecimal. Didn't work as well.
Now I am stuck here and no clue how to encrypt/decrypt the password for SCRAM authentication. Can someone guide me out here. 

--

Akshay Joshi

Principal Software Engineer 

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