RE: portion of pgadmin page not allowed to display
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.
I’m running this Ubuntu server on the Azure cloud. I’m wondering if that is putting some restrictions on server behavior.
BTW, how do you stop, restart pgadmin4, by restarting postgresql?
Thanks again.
Thomas Plancon
CAD/IT Manager
Main Office | 508.583.5603
142 Crescent Street | Brockton, MA 02302
LinkedIn | Facebook | Instagram
From: Dave Page <dpage@pgadmin.org>
Sent: Thursday, May 4, 2023 11:34 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 Thu, 4 May 2023 at 16:15, Tom Plancon <tplancon@bkaarchs.com> wrote:
Hello,
New to pgadmin. Installed pgadmin4 web version on ubuntu 22 with apache2 using apt repository.
Installation appeared to be successful; I am able to log into the site, connect to my database and see schema list etc..
However, when I select a table and click “View data”, I see this in the right-side display area:
To protect your security, ‘mysite.myDomain.com’ will not allow Firefox to display the page if another site has embedded it. To see this page, you need to open it in a new window.
I’ve tried other browsers and get a broken page icon. I assume it’s an apache2 configuration issue, but I’m not having much luck googling it
Any help is appreciated. Thanks much.
It sounds like Apache is setting the X-Frame-Options header to DENY in its responses. You can check that on the Network tab in the developer tools (right-click, and select "Inspect", and then find the initial request in the list - probably the top one). For example, this is from www.postgresql.org:
See the third header from the bottom on the right.
pgAdmin won't work with that set (which is not the default as far as we've ever seen); you'll need to update your Apache config to either not send the header at all, or set it to SAMEORIGIN.
--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake
EDB: https://www.enterprisedb.com
Вложения
В списке pgadmin-support по дате отправления: