RE: Two Factor Authentication and the Query Tool

Great, thank you!

Jeremi

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Sent: May 25, 2020 1:08 AM
To: Potvin, Jérémi <Jeremi(dot)Potvin(at)cra-arc(dot)gc(dot)ca>
Cc: PgAdmin Support List <pgadmin-support(at)lists(dot)postgresql(dot)org>; Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Subject: Re: Two Factor Authentication and the Query Tool

***ATTENTION***

This email originated from outside of the Government of Canada. Do not click links or open attachments unless you recognize the sender and believe the content is safe. For more information regarding reporting suspicious emails, please visit the KnowHow webpage: Suspicious emails - how to report<http://druid/KnowHow/sec-suseml-e.asp>

Ce courriel provient de l'extérieur du Gouvernement du Canada. Ne cliquez pas sur les liens et n’ouvrez pas les pièces jointes, à moins de connaître l'expéditeur et croire que le contenu est sécuritaire. Pour de plus amples renseignements sur la façon de signaler les courriels suspects, veuillez consulter la page Web SavoirFaire: Courriels suspects – Comment signaler<http://druid/savoirfaire/sec-suseml-f.asp>

On Mon, May 25, 2020 at 9:45 AM Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com<mailto:khushboo(dot)vashi(at)enterprisedb(dot)com>> wrote:
Hi,

On Fri, May 22, 2020 at 8:48 PM Potvin, Jérémi <Jeremi(dot)Potvin(at)cra-arc(dot)gc(dot)ca<mailto:Jeremi(dot)Potvin(at)cra-arc(dot)gc(dot)ca>> wrote:
Hello,

I currently have two factor authentication set up on my PG database going to a Radius server.

I can connect to the database using Pgadmin4 v4.2 just fine, but as soon as I try to open a Query Tool window, I get an authentication error.
That’s because pgAdmin is trying to pass the credentials of my initial connection to the Query Tool for it to connect to the database. I cannot reuse my initial credentials more than once.

In another tool (Data Studio) that I use to connect to DB2 databases, there’s an option to prevent this:

[cid:image001(dot)png(at)01D63268(dot)28D9D380]

Does anyone know if there’s a parameter in pgadmin or the config files that can fix my issue?
Would it be possible in later versions?

Not supported by pgAdmin 4 right now.
Please create a feature request @ https://redmine.postgresql.org/projects/pgadmin4 for the same.
The feature request is there. We will consider it for future release - https://redmine.postgresql.org/issues/5403

Thanks,
Khushboo

Thank you in advance for your help,
Jeremi

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"