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

Поиск
Список
Период
Сортировка
От Akshay Joshi
Тема Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)
Дата
Msg-id CANxoLDdW6DS_RUG6LndYhSyCdrmFNP4RMPam00MgSZDqf5hBoQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [pgAdmin4][Patch]: RM #2214 PostgreSQL 10.0 compatibility (SCRAMauthentication support)  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-hackers
Дерево обсуждения


On Mon, Jul 23, 2018 at 6:36 PM, Dave Page <dpage@pgadmin.org> wrote:
Hi Akshay

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.     

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

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

Предыдущее
От: Dave Page
Дата:
Сообщение: pgAdmin 4 commit: SESSION_SKIP_PATHS should be set before we loadlocal
Следующее
От: pgAdmin 4 Jenkins
Дата:
Сообщение: Build failed in Jenkins: pgadmin4-master-python27 #698