Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)
Дата
Msg-id CA+OCxoyWmJdOXxudXFq9f=R-1PAOsEU-fvWxgudJMHYw9ysrQg@mail.gmail.com
обсуждение исходный текст
Ответ на [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
Список pgadmin-hackers
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 "PQencryptPasswordConnhas 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



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

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

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: pgAdmin 4 commit: Add support for SCRAM password changes (requirespsyc
Следующее
От: Dave Page
Дата:
Сообщение: pgAdmin 4 commit: SESSION_SKIP_PATHS should be set before we loadlocal