Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases

Hi Khushboo

Many thanks for your mail.

I am in /usr/pgadmin4/web the step yarn install says

yarn install
00h00m00s 0/0: : ERROR: [Errno 2] No such file or directory: 'install'

??

Med venlig hilsen
Ayad Mohamed
Seniorkonsulent

[https://www.uvm.dk/-/media/Billeder/Mailsignatur/UVM_STIL_DK.png]

Børne- og Undervisningsministeriet
Styrelsen for It og Læring
Kontor for It-drift
Vester Voldgade 123
1552 København V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: Ayad(dot)Mohamed(at)stil(dot)dk

________________________________
From: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Sent: 11 November 2021 05:32
To: Ayad Mohamed
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases

Hi Ayad,

On Wed, Nov 10, 2021 at 6:18 PM Ayad Mohamed <Ayad(dot)Mohamed(at)stil(dot)dk<mailto:Ayad(dot)Mohamed(at)stil(dot)dk>> wrote:

Hi Khushboo

I have pgadmin4 on ubuntu server and installed via the official postgresql repos .

and so I patched the file tree_nodes.ts with your patch file.

Kindely tell me if I should do more.

To test this patch, you need to do following:

- Install yarn and nodejs on the ubuntu machine
- Run below commands to activate virtual environment and do yarn bundle

* source /usr/pgadmin4/venv/bin/activate
* cd /usr/pgadmin4/web
* yarn install
* yarn run bundle

Now, clear the browser cache, browse the pgAdmin4 and check.

Thanks,
Khushboo

Med venlig hilsen
Ayad Mohamed
Seniorkonsulent

[https://www.uvm.dk/-/media/Billeder/Mailsignatur/UVM_STIL_DK.png]

Børne- og Undervisningsministeriet
Styrelsen for It og Læring
Kontor for It-drift
Vester Voldgade 123
1552 København V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: Ayad(dot)Mohamed(at)stil(dot)dk<mailto:Ayad(dot)Mohamed(at)stil(dot)dk>
tree_nodes.ts

________________________________
From: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com<mailto:khushboo(dot)vashi(at)enterprisedb(dot)com>>
Sent: 10 November 2021 13:01
To: Ayad Mohamed
Cc: pgadmin-hackers(at)postgresql(dot)org<mailto:pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases

Hi,

The change is in the typescript file, so yarn bundle will be required. Have you done that?

Thanks,
Khushboo

On Wed, Nov 10, 2021 at 5:00 PM Ayad Mohamed <Ayad(dot)Mohamed(at)stil(dot)dk<mailto:Ayad(dot)Mohamed(at)stil(dot)dk>> wrote:

Hi Khushboo

I patched our pgadmin4 6.1 with your patch but we still have the problem.

regards

Ayad Mohamed

________________________________

-------- Videresendt brev --------
Fra: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com<mailto:Khushboo%20Vashi%20%3ckhushboo(dot)vashi(at)enterprisedb(dot)com%3e>>
Til: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org<mailto:pgadmin-hackers%20%3cpgadmin-hackers(at)postgresql(dot)org%3e>>
Emne: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
Dato: Wed, 10 Nov 2021 11:06:00 +0530

Hi,

Please find the attached patch to fix the RM #6905 - Impossible to load databases.

The database nodes are not getting loaded behind reverse proxy with SSL. This issue has been fixed in this patch.

Note: Yogesh helped me to setup the apache server with reverse proxy with SSL and to reproduce the issue.

Thanks,
Khushboo