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 1ml4Qc-0002B4-P0 for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 07:23:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ml4Qb-00061F-7N for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 07:23:21 +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 1ml4Qa-000616-Tq for pgadmin-hackers@lists.postgresql.org; Thu, 11 Nov 2021 07:23:21 +0000 Received: from mail-ua1-x92b.google.com ([2607:f8b0:4864:20::92b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ml4QY-0007Dz-TZ for pgadmin-hackers@postgresql.org; Thu, 11 Nov 2021 07:23:20 +0000 Received: by mail-ua1-x92b.google.com with SMTP id b3so10109882uam.1 for ; Wed, 10 Nov 2021 23:23:18 -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=uQdWgp/5GP5b/IItVaDyQM7zztJqxpt255mGtRctdEU=; b=iopjGTK/QQGK1rknpH7YDt5A3pCnDCLMS0h/DLT8MeztNGMtOxw85RkkF65kOYhFpF +Ow5LQnizZjsPxKoroHfKCDnZk0eP4Z3l9S3qLJnlTkncy4BfwbQPZ0DQwaDnQlugzc2 OKTBJb+ivPnUpoldRQpcU9Ll0VVdrvtDlvIbSTZekYX0IE4h+smwpGoRgt/NSZyjX7jG L5MJ/ioWlyFKKZN4iyyqxk+hHo3QG+2Zbe7O0Xztgl0VHwpxzKSlY8engMKPHXRa76VQ 1Uo7xL1C376PY41sHROGIoi3tBxsMy91Z9KDC+vmON9kwxISfULE9nRYbfVF1wTlzW3s XYzA== 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=uQdWgp/5GP5b/IItVaDyQM7zztJqxpt255mGtRctdEU=; b=zeCyKNTo3tF1oFEkCddNFAJonrjWaPU7WmNMTKN1kgcio2E3ZHsqa854Fr17PCYaV9 7bEht8y1YWC1FGF73BOC7TDSRFmFAUXjOGOa6kL0lugjaZ3y8oDWeV1HaZnZH6kcr6cW +1hoLgxMlIkn6PQOROil6uLv954NIrJp9ScXkfgR6e4JRhUCjw0U7FmvyWf4Unae97Yq Pj/vf/d15esKclpbzvrV6pX/RRIMBJkLfTHbNXs5qrI/BHEYb7GNqHLs1K3uNorXBFUK IGjRbshaP6Ouj+5oTfeFB/K8qMGR96Q8bQbW8b0Ovb+hOvZZ07uTM1UwVaY7nIgxku0f DZzA== X-Gm-Message-State: AOAM533ZWBT/me3XxcIbsIHpktTiztKcStlsZb6vrIKKd5dMPbTczpvk K6hD19m6U6jWQcUEHPAIetJH54hrBczmX5035R9vQTJozrQfAjhD4VocmHW0PCKTi1DLXsiTZ3M /a/iaDjE5eUVf6igUGqeggC/oc+/L24WE6h4UjepZKNQKU+Jni6FqrIcTWRNkAFK4m21Jn/5j+q zajf1ePn42BM8ZlQHVONY/7HtQbjY/jcfMbuuZPptOJHoixNJEVJIREuVkkw== X-Google-Smtp-Source: ABdhPJwWHECXOWyHSm4rID7Vrua28OSjeSmyQWJLaG7BjpgexGp+oQ/cyIogej4wbC/jnIp+1//3GKguU99bJPvYhfQ= X-Received: by 2002:a05:6102:5109:: with SMTP id bm9mr8176122vsb.10.1636615396398; Wed, 10 Nov 2021 23:23:16 -0800 (PST) MIME-Version: 1.0 References: <5eedf5ae2452446eacd74d7af5847d44@stil.dk> <675de169aff445b58827cd060c7af03d@stil.dk> In-Reply-To: From: Aditya Toshniwal Date: Thu, 11 Nov 2021 12:52:40 +0530 Message-ID: Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases To: Khushboo Vashi Cc: Ayad Mohamed , "pgadmin-hackers@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000005654ab05d07e378d" 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 --0000000000005654ab05d07e378d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Khushboo/Ayad, Maybe you can try on the nightly build - https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2021-11-11/ Please make sure to replace the repo URL back to the stable release URL. On Thu, Nov 11, 2021 at 12:48 PM Khushboo Vashi < khushboo.vashi@enterprisedb.com> wrote: > > > 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 database= s >> >> 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 >>> 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 >>> 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 >>> > >>>> *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 loa= d >>>> 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 >>>> >>>> --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --0000000000005654ab05d07e378d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Khushboo/Ayad,

Maybe you can try on the nightly b= uild -=C2=A0https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshot= s/2021-11-11/
Please make sure to replace the repo URL back to the stab= le release URL.

On Thu, Nov 11, 2021 at 12:48 PM Khushboo Vashi <khushboo.vashi@enterprised= b.com> wrote:


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'


Probably your yarn is not installe= d properly.
=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


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 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 Vash= i <= 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


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Software A= rchitect=C2=A0| edbpostgres.com
"Don't Complain about Heat, Plant a TREE&qu= ot;
--0000000000005654ab05d07e378d--