Re: Error while starting PgAdmin 5.0 - Mailing list pgadmin-support

From Rahul Shirsat
Subject Re: Error while starting PgAdmin 5.0
Date
Msg-id CAKtn9dO8AR26-Z4BOrNxMAfAoT_LA2Wur2Jp5nUVnczXuswTsQ@mail.gmail.com
Whole thread Raw
In response to Re: Error while starting PgAdmin 5.0  (Julien de Murcia <demurcia@ockham-solutions.fr>)
Responses Re: Error while starting PgAdmin 5.0  (Julien de Murcia <demurcia@ockham-solutions.fr>)
List pgadmin-support
Julien,

The error itself is clear that it is being blocked by the administrator. From version 5 onwards, pgAdmin4 desktop opens in a chromium based NWJS container, no browser will be needed for opening the application.

You may need to change a user access control policy which Windows provides. Currently, I don't have Windows 2019 or Windows 2012 to test, but a snapshot of Windows server 2016 having nwjs extension entry.

image.png

I tried installing and executing the application on a non-admin user, and it was successful.

Maybe chromium extensions are blacklisted on your machine. Whitelisting the extension may solve your problem. You may need to approach your IT team to get the help.

On Wed, Apr 28, 2021 at 11:33 AM Julien de Murcia <demurcia@ockham-solutions.fr> wrote:

Hi,

Here is the information I have:

1. The problem occurred with both pgAdmin4 5.0 installed from PG13.2 from Enterprise db installer, and pgAdmin4 5.2 installed from official website.

2. pgAdmin4 was not installed on these machines (they were previously running pg9.5 with pgAdmin3).

3. This is likely the issue, but I do not know what to look for exactly. I cannot make much experiments on these machines as they are production servers, admin restrictions and firewall cannot be disabled, and have no direct access to these servers anyway.

4. As far as I know, no log was generated. I will try to have a customer start pgAdmin4 5.x from console.

I understand that this is very little information, my hope is that someone with his own server will report the same problem and provide more details. It should be easy to identify with the ID of the extension being blocked (in the displayed error message ID: cmifjmkpnpkdlfachldmblngbbmojlle). I will let you know if I can get more information.

Thanks for your help.
Le 27/04/2021 à 22:13, Rahul Shirsat a écrit :

Julien,

The above information is still not enough for us to determine the cause of the failure.

You may troubleshoot what could be the problem by going through below points:

  1. What is the download source of your pgAdmin4? (Recommended to download through our official website - https://www.pgadmin.org/download/)
  2. Check whether there were any old versions of pgAdmin4 already installed, try uninstalling those first, and look for a pgAdmin4.db file in %APPDATA\pgAdmin\,
    if it exists, manually delete it as well.
  3. Look out for all the firewalls / admin restrictions which are blocking from opening up the application.
  4. Try sharing pgadmin4.startup or log files as mentioned in the above mail trace.
  5. Checkout our faq page - https://www.pgadmin.org/faq/ for any other troubleshooting.

On Tue, Apr 27, 2021 at 7:46 PM Julien de Murcia <demurcia@ockham-solutions.fr> wrote:

We had a third case today (on windows 2012 server), with no pgAdmin log generated. All the servers are running Sophos Antivirus, but it was deactivated on the first server with no effect.

Le 23/04/2021 à 14:20, Julien de Murcia a écrit :

Thanks for the info. Unfortunately, the customers did not find any pgAdmin log files on their servers, but I do not have a remote access to their machines to double check. I will see if this happens on other servers. So far, it happened on two servers, one running on windows 2019 server and the other on windows 2008 server. The workaround is to install pgAdmin 4.30. Le 23/04/2021 à 12:17, Rahul Shirsat a écrit :


Log file is generated under C:\Users\<USER>\AppData\Local\pgadmin\ with name pgadmin4.log. If the app itself is crashing, the logs inside pgadmin4.startup are useful to determine why it is crashing. You may share both if they exist.

On Fri, Apr 23, 2021 at 3:24 PM Julien de Murcia <demurcia@ockham-solutions.fr> wrote:

Hi Rahul,

Are you sure this log file is produced by PgAdmin 5.0 ? I do not have it on my own computer. It looks like a log file is generated under C:\Users\<USER>\AppData\Local\pgadmin but it is removed once PgAdmin is closed.

Julien de Murcia
Ingénieur développement Ockham Solutions
Software engineer Ockham Solutions
tel: +33 9 77 19 50 26
Le 23/04/2021 à 10:46, Rahul Shirsat a écrit :
Hi Julien,

Could you please share the log files generated at - C:\Users\<USER>\AppData\Local with name 'pgadmin4.startup' ?

On Thu, Apr 22, 2021 at 8:17 PM Julien de Murcia <demurcia@ockham-solutions.fr> wrote:
Hello,

When starting PgAdmin 5.0 as Desktop app on Windows 2019 server, some of
my customers are getting the following error message:
"L'administrateur a bloqué l'extension pgAdmin 4(ID :
cmifjmkpnpkdlfachldmblngbbmojlle)"
Sorry, the message is in French. AFAIK it comes from Chromium, which is
complaining about the extension pgAdmin 4 being blocked by the
administrator.
Unfortunately, I could not reproduce the issue on my environment.
According to our users, no log is generated under %AppData%\pgAdmin. Is
there any log file I could check to understand what is blocking the
extension ? Is this a known problem (incompatibility with security tools
or rules) ?

Best regards,

--
Julien de Murcia





--
Rahul Shirsat
Senior Software Engineer | EnterpriseDB Corporation.


--
Rahul Shirsat
Senior Software Engineer | EnterpriseDB Corporation.


--
Rahul Shirsat
Senior Software Engineer | EnterpriseDB Corporation.


--
Rahul Shirsat
Senior Software Engineer | EnterpriseDB Corporation.
Attachment

pgadmin-support by date:

Previous
From: richard coleman
Date:
Subject: Re: PGAdmin "fake freeze" on start (grey screen)
Next
From: Julien de Murcia
Date:
Subject: Re: Error while starting PgAdmin 5.0