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

Hi again

now it tells

yarn run bundle

yarn run v1.22.15

error Couldn't find a package.json file in "/usr/pgadmin4/web"

info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

	Med venlig hilsen Ayad Mohamed Seniorkonsulent
	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.Mohamed@stil.dk

---

From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Sent: 11 November 2021 08:18
To: Ayad Mohamed
Cc: pgadmin-hackers@postgresql.org
Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases

 

On Thu, Nov 11, 2021 at 12:15 PM Ayad Mohamed <Ayad.Mohamed@stil.dk> wrote:

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'

Probably your yarn is not installed properly.

Please refer: https://linuxize.com/post/how-to-install-yarn-on-ubuntu-20-04/

 

 ??

	Med venlig hilsen Ayad Mohamed Seniorkonsulent
	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.Mohamed@stil.dk

---

From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Sent: 11 November 2021 05:32
To: Ayad Mohamed
Cc: pgadmin-hackers@postgresql.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.Mohamed@stil.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
	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.Mohamed@stil.dk

tree_nodes.ts

---

From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Sent: 10 November 2021 13:01
To: Ayad Mohamed
Cc: pgadmin-hackers@postgresql.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.Mohamed@stil.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.vashi@enterprisedb.com>

Til: pgadmin-hackers <pgadmin-hackers@postgresql.org>

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