From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAM authentication support) |
Date: | 2018-07-23 14:50:31 |
Message-ID: | CANxoLDdW6DS_RUG6LndYhSyCdrmFNP4RMPam00MgSZDqf5hBoQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
On Mon, Jul 23, 2018 at 6:36 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> Hi Akshay
>
> On Mon, Jul 23, 2018 at 2:03 PM, Akshay Joshi <
> akshay(dot)joshi(at)enterprisedb(dot)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
<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-9517Mobile: +91 976-788-8246*
From | Date | Subject | |
---|---|---|---|
Next Message | pgAdmin 4 Jenkins | 2018-07-23 14:55:35 | Build failed in Jenkins: pgadmin4-master-python27 #698 |
Previous Message | Dave Page | 2018-07-23 14:45:00 | pgAdmin 4 commit: SESSION_SKIP_PATHS should be set before we load local |