Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ml4Ly-0001ty-6U for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 07:18:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ml4Lw-0007ka-Uk for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 07:18:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ml4Lw-0007kQ-AI for pgadmin-hackers@lists.postgresql.org; Thu, 11 Nov 2021 07:18:32 +0000 Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ml4Lr-00078A-LO for pgadmin-hackers@postgresql.org; Thu, 11 Nov 2021 07:18:31 +0000 Received: by mail-lf1-x133.google.com with SMTP id bi37so7083865lfb.5 for ; Wed, 10 Nov 2021 23:18:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=712jZHkaq8/9BQdOQzd0qaY0P6dzegRZq0/JqoKtso8=; b=jOBNzEL6gqFSZ+dG+npKs2NUUioMd5XsBPqy9BGG85pZmux9MjcLKQ9CnAvrPSmiOA lzg9rdU8DF/QUJL3PCoHCGjdUbBk6Ijl54tlg0PWAI8UkH5plN9+v5LCGewxmdooxfW4 Jgeo93+lot+EeLYaGCkAmlruMm1levNXPGwQJOU1QW+c8wGnt/EcVoaMmQcQI9nk/POt donHzfJ0sXz93JGAABl8JVz+6tzKgAv20ZzkwEYqIe9LuGr+V9pLL5aJC/2FtOUsXViy 7ZMqcj2Sgasj8GyDQeitPC8PkmXkO016uGrczzqGqlHSry6EpBZdH2HN7OjH1F76aN03 xF+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=712jZHkaq8/9BQdOQzd0qaY0P6dzegRZq0/JqoKtso8=; b=Yy7l2eEt51nwOoT9Dnd8sQnhmvSP5asdfymPTd1kWJsMne3a2QnpXei0HF/HBcZmui O4+kMAienVqjF+xLQ/C5SmfMPmxQFWhVDlpl+eb7W/Itk750L2D71/i0XrAz4f92LxQ2 iewpDiwAvioznY4dI/UsqIzSXeXC4mJttnMsKv1n6nOwhIlWkD+OHYpyh+cuvvr1Xprd izb7VcWNJQjBFnprfLOj54PfeLCPGuKg1pxvjKcqM8xBVkGgx20ZQbfvCoeEXkrYpPBh 7TMMqSK+UAKdab/kKVodNobpYWjjAFHjXiXiA2NbIKUMu1yDAqTUFJh8ry6lowAvctPw /Lfg== X-Gm-Message-State: AOAM531Ll1Rxg1Uhd5gHEjZoi3RmZelUqck0nbCv2jmcJhDJ50mGbsLZ uH2tAkfaT8X6aFt0H1lxxXNSJkfZenHkM/oFtjkyG8ciM448eoOTbXk7OxNZ93UFt0ZaAZQMFJv gqyQ1u2s5VLITbNpTmllElgyT8vsx300Yy3pS4Mnn+fkOt3BQzIzCc6rr67y3VJ+B833gK3Zb7z e861jg5IXzDA4WodVaVyQfqR24iMAu1mid5uI9E3C1n7c47h7RYFOPBLTlvA== X-Google-Smtp-Source: ABdhPJx690i9pwpcoBKu7K/LLQ8N9sCstF1UWUbwlaSVXFPpXIPahdTHj9w0ZujuWpDBEZLnDnvSWUCuEk9VpxpzA4o= X-Received: by 2002:a19:770a:: with SMTP id s10mr5120292lfc.234.1636615105110; Wed, 10 Nov 2021 23:18:25 -0800 (PST) MIME-Version: 1.0 References: <5eedf5ae2452446eacd74d7af5847d44@stil.dk> <675de169aff445b58827cd060c7af03d@stil.dk> In-Reply-To: <675de169aff445b58827cd060c7af03d@stil.dk> From: Khushboo Vashi Date: Thu, 11 Nov 2021 12:48:14 +0530 Message-ID: Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases To: Ayad Mohamed Cc: "pgadmin-hackers@postgresql.org" Content-Type: multipart/alternative; boundary="000000000000f97db305d07e258e" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f97db305d07e258e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Nov 11, 2021 at 12:15 PM Ayad Mohamed 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=C3=B8rne- og Undervisningsministeriet > Styrelsen for It og L=C3=A6ring > Kontor for It-drift > Vester Voldgade 123 > 1552 K=C3=B8benhavn V > Tlf.: 3587 8889 > > Direkte tlf.: +45 4172 7259 > E-mail: Ayad.Mohamed@stil.dk > > > ------------------------------ > *From:* Khushboo Vashi > *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 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=C3=B8rne- og Undervisningsministeriet >> Styrelsen for It og L=C3=A6ring >> Kontor for It-drift >> Vester Voldgade 123 >> 1552 K=C3=B8benhavn V >> Tlf.: 3587 8889 >> >> Direkte tlf.: +45 4172 7259 >> E-mail: Ayad.Mohamed@stil.dk tree_nodes.ts >> >> >> ------------------------------ >> *From:* Khushboo Vashi >> *Sent:* 10 November 2021 13:01 >> *To:* Ayad Mohamed >> *Cc:* pgadmin-hackers@postgresql.org >> *Subject:* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load database= s >> >> 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 >> wrote: >> >>> >>> Hi Khushboo >>> >>> >>> I patched our pgadmin4 6.1 with your patch but we still have the proble= m. >>> >>> >>> regards >>> >>> Ayad Mohamed >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> ------------------------------ >>> >>> >>> -------- Videresendt brev -------- >>> *Fra*: Khushboo Vashi >> > >>> *Til*: pgadmin-hackers >> > >>> *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 >>> >>> --000000000000f97db305d07e258e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


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

Hi Khushboo


Many=C2=A0thanks 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: 'inst= all'


=C2=A0

=C2=A0??



=C2=A0







Med venlig hilsen
Ayad=C2=A0Mohamed
Seniorkonsulent



=C2=A0 		B=C3=B8rne- og Undervisningsministeriet
Styrelsen for It og L=C3=A6ring
Kontor for It-drift
Vester Voldgade 123
1552=C2=A0K=C3=B8benhavn V
Tlf.:=C2=A03587 8889

Direkte tlf.: +45 4172 7259
E-mail: Ayad.Moha= med@stil.dk


Fro= m: 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 databa= ses
=C2=A0
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 postgres= ql repos .

and so I patched the file=C2=A0tree_nodes= .ts with your patch file.


Kindely tell me if I should do more.


=C2=A0
To test this patch, you need to do following:

- Install yarn and nodejs on the ubuntu machine=C2=A0
- Run below commands to activate virtual environment and do yarn bundl= e
  • =C2=A0source /usr/pgadmin4/venv/bin/activate
  • =C2=A0cd /usr/pgad= min4/web
  • =C2=A0yarn install
  • =C2=A0yarn run bundle
Now, clear the browser cache,=C2=A0browse the pgAdmin4 and check.

Thanks,
Khushboo







Med venlig hilsen
Ayad=C2=A0Mohamed
Seniorkonsulent



=C2=A0 		B=C3=B8rne- og Undervisningsministeriet
Styrelsen for It og L=C3=A6ring
Kontor for It-drift
Vester Voldgade 123
1552=C2=A0K=C3=B8benhavn V
Tlf.:=C2=A03587 8889

Direkte tlf.: +45 4172 7259
E-mail: Ayad.Moha= med@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 databa= ses
=C2=A0
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


=C2=A0










=C2=A0
-------- Videresendt brev --------
Fra: Khushboo Vashi <khushboo.vashi@enter= prisedb.com>
Til: pgadmin-hackers <pgadmin-hackers@postg= resql.org>
Emne: [pgAdmin4][Patch] - RM 6905 - Impossible to load database= s
Dato: Wed, 10 Nov 2021 11:06:00 +0530

Hi,

Please find the att= ached patch to fix the RM #6905 -=C2=A0Impossible to load databases.=

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

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

Thanks,
Khushboo
--000000000000f97db305d07e258e--