Thread: pgadmin4 2.0 and Scram
Since pgAdmin4 2.0 is targetting v10 of PostgreSQL, I thought it would support scram authentication in addition to md5. In fact, I thought this would happen automatically simply by virtue of using the latest libpq.dll, without any coding changes to pgAdmin4 itself.
But when I set myself a scram-hashed password (using psql) and then try to connect with pgAdmin4, I get the message "authentication method 10 not supported", which is the message you get from pre-v10 versions of libpq.
Is this a known issue? Does the installer include the wrong libpq.dll?
Cheers,
Jeff
Since pgAdmin4 2.0 is targetting v10 of PostgreSQL, I thought it would support scram authentication in addition to md5. In fact, I thought this would happen automatically simply by virtue of using the latest libpq.dll, without any coding changes to pgAdmin4 itself.But when I set myself a scram-hashed password (using psql) and then try to connect with pgAdmin4, I get the message "authentication method 10 not supported", which is the message you get from pre-v10 versions of libpq.Is this a known issue? Does the installer include the wrong libpq.dll?
pgAdmin4 uses psycopg2 in order to communicate with Postgres and psycopg2 is lacking support for Scram at a moment, and I think developers are already working on adding support for PG10 (https://github.com/psycopg/psycopg2/pull/576).
Cheers,Jeff
On Fri, Oct 6, 2017 at 10:18 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Since pgAdmin4 2.0 is targetting v10 of PostgreSQL, I thought it would support scram authentication in addition to md5. In fact, I thought this would happen automatically simply by virtue of using the latest libpq.dll, without any coding changes to pgAdmin4 itself.But when I set myself a scram-hashed password (using psql) and then try to connect with pgAdmin4, I get the message "authentication method 10 not supported", which is the message you get from pre-v10 versions of libpq.Is this a known issue? Does the installer include the wrong libpq.dll?pgAdmin4 uses psycopg2 in order to communicate with Postgres and psycopg2 is lacking support for Scram at a moment, and I think developers are already working on adding support for PG10 (https://github.com/psycopg/psycopg2/pull/576).
That item is about changing the password through psycopg2, which does require work from the client software (if you don't want to send the password itself to the server). But I am just talking about using an existing password to log on, which is purely a function of libpq and shouldn't require any changes from the client. When I log in from python scripts via psycopg2 or from perl with DBD::Pg, old versions of psycopg2 or perl work fine with a SCRAM password as long as the latest libpq is loaded.
However, I've only tested python direct usage and perl from Linux, and only tested pgAdmin from Windows. So it could be an OS issue. I've tried using ListDLLs to see which dll pgAdmin is loading to make sure it is not finding the wrong one, but it says it doesn't have permission to inspect the DLL for that program, so I don't know what else to check from Windows.
Cheers,
Jeff