Hi Morten,
You need to adjust settings with your webserver configuration to setup SSL
enabled pgadmin. Here is configuration for apache webserver with SSL.
<VirtualHost *:443>
WSGIDaemonProcess pgadmin processes=1 threads=25
python-home=/usr/pgadmin4/venv
WSGIScriptAlias / /usr/pgadmin4/web/pgAdmin4.wsgi
<Directory /usr/pgadmin4/web/>
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
Require all granted
</Directory>
ServerName pgadmin.yourdomain.com
SSLEngine on
SSLCertificateFile /etc/apache2/certificate/apache-certificate.crt
SSLCertificateKeyFile /etc/apache2/certificate/apache.key
</VirtualHost>
You can mention the redirect url <https://pgadmin.yourdomain.com> for
configuration above.
Thanks,
Yogesh Mahajan
EnterpriseDB
On Mon, Dec 18, 2023 at 5:43 PM Morten Bonnerup Rasmussen <
[email protected]> wrote:
> Hi
>
> I am working on deployment of pgAdmin 4 as part of a postgreSQL package in
> our enterprise environment.
>
> I have currently installed pgAdmin in server mode on a Windows Server, but
> running into problems configuring OAUTH2 authentication. I have enabled
> Azure AD/Entra ID authentication based on the following guide by Asmita
> How to Configure OAuth 2.0 with Azure AD in pgAdmin4 | by Asmita Thapliyal
> | Medium
> <https://medium.com/@asmita.thapliyal/how-to-configure-oauth-2-0-with-azure-ad-in-pgadmin4-2c1500d52d9d>
>
> But redirect URI in Azure app registration requires a HTTPS link and I
> have not found a way to specify a server certificate (currently selfsigned
> for testing purposes).
> I have not been able to find anything on config file and only references I
> have found online involves NGINX or similar, but I would prefer not
> introducing further complications if possible.
> Know of any way to natively enabling HTTPS connection to pgAdmin?
>
>
> *Morten Bonnerup Rasmussen*
>
> TECH Reliability Services / Specialist
>
> BESTSELLER A/S
>
> FREDSKOVVEJ 1, 7330 BRANDE
>
> DENMARK
>
>
>
>
>
