Re: Enable HTTPS on pgAdmin in Server Mode

Поиск
Список
Период
Сортировка
От Yogesh Mahajan
Тема Re: Enable HTTPS on pgAdmin in Server Mode
Дата
Msg-id CAMa=N=Mqm-u-Eq=AesaxBs_iX10S8wstB6vbvaNm3n6yrdEtcA@mail.gmail.com
обсуждение исходный текст
Ответ на Enable HTTPS on pgAdmin in Server Mode  (Morten Bonnerup Rasmussen <morten.rasmussen@bestseller.com>)
Ответы Re: Enable HTTPS on pgAdmin in Server Mode
Список pgadmin-support
Дерево обсуждения
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 <morten.rasmussen@bestseller.com> 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

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

 


Вложения

В списке pgadmin-support по дате отправления: