Re: portion of pgadmin page not allowed to display

Dave,

 

Here is a screenshot of headers from Dev Tools, ( I thought you were referring to pgadmin dev tools – sorry!).

 

 

It appears I have 2 settings that contradict each other, and a set of duplicate X-Content-Type-Options. I assume that means 2 different apache2 conf files are being referenced?

 

Thomas Plancon

CAD/IT Manager

 

BKA / Architects

Main Office | 508.583.5603

142 Crescent Street | Brockton, MA  02302

LinkedIn | Facebook | Instagram

 

 

 

From: Dave Page <dpage@pgadmin.org>
Sent: Friday, May 5, 2023 4:25 AM
To: Tom Plancon <tplancon@bkaarchs.com>
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: portion of pgadmin page not allowed to display

 

Hi

 

On Fri, 5 May 2023 at 02:36, Tom Plancon <tplancon@bkaarchs.com> wrote:

Hi Dave,

 

Thank you for your response.

 

In the apache2 security.conf, the “Header set X-Frame-Options “sameorigin” ” line was commented out. I uncommented it, restarted apache2 and postgresql, no change in pgadmin4 behavior.

 

I added the line directly to the apache2.conf, restarted everything again, no change.

 

I don’t seem to have the developers tools you mentioned. Again, I installed pgadmin4 from the Ubuntu apt repository.

 

The developer tools are built into Firefox - see https://firefox-source-docs.mozilla.org/devtools-user/.

 

Please check the response headers (and post them here) for the initial request to the server, and for any that have been blocked (they normally get displayed in red).

 

 

I’m running this Ubuntu server on the Azure cloud. I’m wondering if that is putting some restrictions on server behavior.

 

It shouldn't make any difference. People run in the cloud all the time.

 

 

BTW, how do you stop, restart pgadmin4, by restarting postgresql?

 

 

No - the PostgreSQL server often isn't even on the same VM. Assuming you're running pgAdmin in web mode using a standard setup done by our setup-web.sh (i.e. mod_wsgi, not uwsgi or gunicorn), to restart the pgAdmin server you simply restart the Apache server that it's hosted by.

 

--

Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com