Re: Enable HTTPS on pgAdmin in Server Mode
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:
HiI 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 AsmitaBut 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 по дате отправления: