Postgres Pro
Downloads
Home   >   mailing lists

Thread: Configure pgAdmin for OAuth 2.0

Configure pgAdmin for OAuth 2.0

From
Suntharavadivu SManiyam
Date:
Hi pgadmin team
I have deployed pgadmin in an openshift azure cluster
Not thru operator. I am doing this as a POC for my Org
I have deployed this in a separate namespace pgadmin and trying to deploy a single instance 

I want to enable oauth2 authentication 
Using azure ad 
I have followed your documentation 
But I am not able to see oauth login button 

I am using configmap yaml to edit config_local.py
I could see this file present in /etc/pgadmin 
But in oc logs I didn’t see  any logs to if this taken or not
In pod etc/pgadmin I did not see any configfile

Please guide me to verify my configuration 

Thanks
Sunthari 

--
Thanks
Sunthari

Re: Configure pgAdmin for OAuth 2.0

From
Khushboo Vashi
Date:
Hi,

The configurations are only set correctly if you see the Oauth2 login button.
Could you provide your config_local.py file and a ConfigMap yaml file, so we can check whether the settings are correctly set?

Thanks,
Khushboo

On Wed, Apr 26, 2023 at 1:29 AM Suntharavadivu SManiyam <sundaravadivu@gmail.com> wrote:
Hi pgadmin team
I have deployed pgadmin in an openshift azure cluster
Not thru operator. I am doing this as a POC for my Org
I have deployed this in a separate namespace pgadmin and trying to deploy a single instance 

I want to enable oauth2 authentication 
Using azure ad 
I have followed your documentation 
But I am not able to see oauth login button 

I am using configmap yaml to edit config_local.py
I could see this file present in /etc/pgadmin 
But in oc logs I didn’t see  any logs to if this taken or not
In pod etc/pgadmin I did not see any configfile

Please guide me to verify my configuration 

Thanks
Sunthari 

--
Thanks
Sunthari

Fwd: Configure pgAdmin for OAuth 2.0

From
Khushboo Vashi
Date:
... [Looping pgAdmin support group]

---------- Forwarded message ---------
From: Suntharavadivu SManiyam <sundaravadivu@gmail.com>
Date: Wed, Apr 26, 2023 at 11:36 AM
Subject: Re: Configure pgAdmin for OAuth 2.0
To: Khushboo Vashi <khushboo.vashi@enterprisedb.com>


Hi Khushboo
Please find the files in the attachment 
Thank you 

On Wed, 26 Apr 2023 at 5:36 AM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:
Hi,

The configurations are only set correctly if you see the Oauth2 login button.
Could you provide your config_local.py file and a ConfigMap yaml file, so we can check whether the settings are correctly set?

Thanks,
Khushboo

On Wed, Apr 26, 2023 at 1:29 AM Suntharavadivu SManiyam <sundaravadivu@gmail.com> wrote:
Hi pgadmin team
I have deployed pgadmin in an openshift azure cluster
Not thru operator. I am doing this as a POC for my Org
I have deployed this in a separate namespace pgadmin and trying to deploy a single instance 

I want to enable oauth2 authentication 
Using azure ad 
I have followed your documentation 
But I am not able to see oauth login button 

I am using configmap yaml to edit config_local.py
I could see this file present in /etc/pgadmin 
But in oc logs I didn’t see  any logs to if this taken or not
In pod etc/pgadmin I did not see any configfile

Please guide me to verify my configuration 

Thanks
Sunthari 

--
Thanks
Sunthari
--
Thanks
Sunthari
Attachment

Re: Configure pgAdmin for OAuth 2.0

From
Suntharavadivu SManiyam
Date:
A gentle reminder 



On Tue, 25 Apr 2023, 20:58 Suntharavadivu SManiyam, <sundaravadivu@gmail.com> wrote:
Hi pgadmin team
I have deployed pgadmin in an openshift azure cluster
Not thru operator. I am doing this as a POC for my Org
I have deployed this in a separate namespace pgadmin and trying to deploy a single instance 

I want to enable oauth2 authentication 
Using azure ad 
I have followed your documentation 
But I am not able to see oauth login button 

I am using configmap yaml to edit config_local.py
I could see this file present in /etc/pgadmin 
But in oc logs I didn’t see  any logs to if this taken or not
In pod etc/pgadmin I did not see any configfile

Please guide me to verify my configuration 

Thanks
Sunthari 

--
Thanks
Sunthari

Re: Configure pgAdmin for OAuth 2.0

From
Yogesh Mahajan
Date:
Hi,

Please add below parameters in OAuth2 config - 

# Font-awesome icon, ex: fa-github
'OAUTH2_ICON':<add icon for you Oauth provider>,
# UI button colour, ex: #0000ff
'OAUTH2_BUTTON_COLOR':<add color of your choice>,
Thanks,
Yogesh Mahajan
EnterpriseDB


On Thu, Apr 27, 2023 at 1:28 PM Suntharavadivu SManiyam <sundaravadivu@gmail.com> wrote:
A gentle reminder 



On Tue, 25 Apr 2023, 20:58 Suntharavadivu SManiyam, <sundaravadivu@gmail.com> wrote:
Hi pgadmin team
I have deployed pgadmin in an openshift azure cluster
Not thru operator. I am doing this as a POC for my Org
I have deployed this in a separate namespace pgadmin and trying to deploy a single instance 

I want to enable oauth2 authentication 
Using azure ad 
I have followed your documentation 
But I am not able to see oauth login button 

I am using configmap yaml to edit config_local.py
I could see this file present in /etc/pgadmin 
But in oc logs I didn’t see  any logs to if this taken or not
In pod etc/pgadmin I did not see any configfile

Please guide me to verify my configuration 

Thanks
Sunthari 

--
Thanks
Sunthari

Re: Configure pgAdmin for OAuth 2.0

From
Suntharavadivu SManiyam
Date:
This did not help all configuration are supposed to give as per official documents 

On Fri, 28 Apr 2023, 11:26 Yogesh Mahajan, <yogesh.mahajan@enterprisedb.com> wrote:
Hi,

Please add below parameters in OAuth2 config - 

# Font-awesome icon, ex: fa-github
'OAUTH2_ICON':<add icon for you Oauth provider>,
# UI button colour, ex: #0000ff
'OAUTH2_BUTTON_COLOR':<add color of your choice>,
Thanks,
Yogesh Mahajan
EnterpriseDB


On Thu, Apr 27, 2023 at 1:28 PM Suntharavadivu SManiyam <sundaravadivu@gmail.com> wrote:
A gentle reminder 



On Tue, 25 Apr 2023, 20:58 Suntharavadivu SManiyam, <sundaravadivu@gmail.com> wrote:
Hi pgadmin team
I have deployed pgadmin in an openshift azure cluster
Not thru operator. I am doing this as a POC for my Org
I have deployed this in a separate namespace pgadmin and trying to deploy a single instance 

I want to enable oauth2 authentication 
Using azure ad 
I have followed your documentation 
But I am not able to see oauth login button 

I am using configmap yaml to edit config_local.py
I could see this file present in /etc/pgadmin 
But in oc logs I didn’t see  any logs to if this taken or not
In pod etc/pgadmin I did not see any configfile

Please guide me to verify my configuration 

Thanks
Sunthari 

--
Thanks
Sunthari

Re: Configure pgAdmin for OAuth 2.0

From
Yogesh Mahajan
Date:
Hi,

Can you please share a screenshot of the login screen and pod logs?
Thanks,
Yogesh Mahajan
EnterpriseDB


On Fri, Apr 28, 2023 at 3:58 PM Suntharavadivu SManiyam <sundaravadivu@gmail.com> wrote:
This did not help all configuration are supposed to give as per official documents 

On Fri, 28 Apr 2023, 11:26 Yogesh Mahajan, <yogesh.mahajan@enterprisedb.com> wrote:
Hi,

Please add below parameters in OAuth2 config - 

# Font-awesome icon, ex: fa-github
'OAUTH2_ICON':<add icon for you Oauth provider>,
# UI button colour, ex: #0000ff
'OAUTH2_BUTTON_COLOR':<add color of your choice>,
Thanks,
Yogesh Mahajan
EnterpriseDB


On Thu, Apr 27, 2023 at 1:28 PM Suntharavadivu SManiyam <sundaravadivu@gmail.com> wrote:
A gentle reminder 



On Tue, 25 Apr 2023, 20:58 Suntharavadivu SManiyam, <sundaravadivu@gmail.com> wrote:
Hi pgadmin team
I have deployed pgadmin in an openshift azure cluster
Not thru operator. I am doing this as a POC for my Org
I have deployed this in a separate namespace pgadmin and trying to deploy a single instance 

I want to enable oauth2 authentication 
Using azure ad 
I have followed your documentation 
But I am not able to see oauth login button 

I am using configmap yaml to edit config_local.py
I could see this file present in /etc/pgadmin 
But in oc logs I didn’t see  any logs to if this taken or not
In pod etc/pgadmin I did not see any configfile

Please guide me to verify my configuration 

Thanks
Sunthari 

--
Thanks
Sunthari

Re: Configure pgAdmin for OAuth 2.0

From
Yogesh Mahajan
Date:
Hi,

Could you please try config_system.py instead of config_local.py for the mountpath

Thanks,
Yogesh Mahajan
EnterpriseDB


On Fri, Apr 28, 2023 at 4:05 PM Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:
Hi,

Can you please share a screenshot of the login screen and pod logs?
Thanks,
Yogesh Mahajan
EnterpriseDB


On Fri, Apr 28, 2023 at 3:58 PM Suntharavadivu SManiyam <sundaravadivu@gmail.com> wrote:
This did not help all configuration are supposed to give as per official documents 

On Fri, 28 Apr 2023, 11:26 Yogesh Mahajan, <yogesh.mahajan@enterprisedb.com> wrote:
Hi,

Please add below parameters in OAuth2 config - 

# Font-awesome icon, ex: fa-github
'OAUTH2_ICON':<add icon for you Oauth provider>,
# UI button colour, ex: #0000ff
'OAUTH2_BUTTON_COLOR':<add color of your choice>,
Thanks,
Yogesh Mahajan
EnterpriseDB


On Thu, Apr 27, 2023 at 1:28 PM Suntharavadivu SManiyam <sundaravadivu@gmail.com> wrote:
A gentle reminder 



On Tue, 25 Apr 2023, 20:58 Suntharavadivu SManiyam, <sundaravadivu@gmail.com> wrote:
Hi pgadmin team
I have deployed pgadmin in an openshift azure cluster
Not thru operator. I am doing this as a POC for my Org
I have deployed this in a separate namespace pgadmin and trying to deploy a single instance 

I want to enable oauth2 authentication 
Using azure ad 
I have followed your documentation 
But I am not able to see oauth login button 

I am using configmap yaml to edit config_local.py
I could see this file present in /etc/pgadmin 
But in oc logs I didn’t see  any logs to if this taken or not
In pod etc/pgadmin I did not see any configfile

Please guide me to verify my configuration 

Thanks
Sunthari 

--
Thanks
Sunthari