Two Factor Authentication and the Query Tool

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Two Factor Authentication and the Query Tool

Potvin, Jérémi

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:

 

 

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?

 

 

 

Thank you in advance for your help,

Jeremi

 

 

Reply | Threaded
Open this post in threaded view
|

Re: Two Factor Authentication and the Query Tool

Khushboo Vashi
Hi,

On Fri, May 22, 2020 at 8:48 PM Potvin, Jérémi <[hidden email]> 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:

 

 

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.

Thanks,
Khushboo 

 

 

Thank you in advance for your help,

Jeremi

 

 

Reply | Threaded
Open this post in threaded view
|

Re: Two Factor Authentication and the Query Tool

Aditya Toshniwal


On Mon, May 25, 2020 at 9:45 AM Khushboo Vashi <[hidden email]> wrote:
Hi,

On Fri, May 22, 2020 at 8:48 PM Potvin, Jérémi <[hidden email]> 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:

 

 

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"
Reply | Threaded
Open this post in threaded view
|

RE: Two Factor Authentication and the Query Tool

Potvin, Jérémi

Great, thank you!

 

Jeremi

 

From: Aditya Toshniwal <[hidden email]>
Sent: May 25, 2020 1:08 AM
To: Potvin, Jérémi <[hidden email]>
Cc: PgAdmin Support List <[hidden email]>; Khushboo Vashi <[hidden email]>
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

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

 

 

 

On Mon, May 25, 2020 at 9:45 AM Khushboo Vashi <[hidden email]> wrote:

Hi,

 

On Fri, May 22, 2020 at 8:48 PM Potvin, Jérémi <[hidden email]> 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:

 

 

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"