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 1ml3q7-0000Kg-3U for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 06:45:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ml3q6-0004vC-19 for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 06:45:38 +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 1ml3q5-0004v0-GF for pgadmin-hackers@lists.postgresql.org; Thu, 11 Nov 2021 06:45:37 +0000 Received: from mx6.sitnet.dk ([188.64.157.6]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ml3q1-0006uv-UR for pgadmin-hackers@postgresql.org; Thu, 11 Nov 2021 06:45:36 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=stil.dk; i=@stil.dk; q=dns/txt; s=sit1; t=1636613133; x=1668149133; h=from:to:cc:subject:date:message-id:references: in-reply-to:mime-version; bh=Gg0fVVzw2yv3hVlkAaJTXPG72/XIHVr6UKXc7RLzflk=; b=0qTTriuLb8E0+jGfPSZCJEKaUg4FGVVvivc/yblZ4CiqemYs/gpNbwfu +Vf7+RoxcarIIsBkkSCX1Qy46oWWx81PJm+ZO6qt34hTAe+oDRmasTArJ AU9yMACQOe+8oTsq/K6FLxvX59GTTyQv0ZmWKiKF7Ils0d2wL6u0445qL djummZ98OHsqFIk9mzKzR7+NLx9b80i79ulaS/gsokrwoK0xPA39XHX6e aL01OVn5OFsPS2xKeJwglcaR3m5l5UE4iWXgEBCmhjBdXydvRxvaqUfum p9Rcfiac3VjANicLI0h4IWxxRudjNCvwgOlLQ2GAARxK8pIpExr1Dp1xs Q==; Received: from 10.33.64.139 ([10.33.64.139]) by localhost (JAMES SMTP Server 2.3.2-1) with SMTP ID 2; Thu, 11 Nov 2021 07:45:32 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=stil.dk; i=@stil.dk; q=dns/txt; s=sit1; t=1636613132; x=1668149132; h=from:to:cc:subject:date:message-id:references: in-reply-to:mime-version; bh=Gg0fVVzw2yv3hVlkAaJTXPG72/XIHVr6UKXc7RLzflk=; b=ubLqWD9lxFurSw0QnGGPsQYBGBjsv6oGEp0R9jWDkDGDW84eje+PS9jJ GDyihGkaWPrD/r3u9vvBF58VtVI+mtnxi6JUN4InqsIUECfqnyNtg4vGP pnOYsAMy7v0lqq1+AqA08FNzp4fzOLi36iiTlLoJ5xML8OSWjSO0IBVVM IdcJ8wTl/lcahTKcK98eFEHVwvGusfsn7dom8IjQBRiYknhWbpQrKOOr3 wnr9fXLo2Vm9eOm8VLh7rN6QabcPqI4D9JwVaZ3goTaxzOCLZV2Tm2fTp L94iEbps170KOpPKhasM3Z2hDn1tVximgOMCA3JHx884irL9LjEe2c586 g==; IronPort-Data: A9a23:aC6cmaNZPsYWQyvvrR3qlsFynXyQoLVcMsEvi/4bfWQNrUorg2YHm mAaCDzUaamJajP0ettxao6/9xgFv5fczYcxSAZtpSBmQkwRpJueD7x1DKtR0wB+jCHnZBg6h ynLQoSYRCwSZiGG/k/F3p/J9CEli/3gqoLUUbKCYmYoLeNdYH9JZShLwobVuaY1x4jma++xk Ymq+ZSGYQb9g2Mc3l88sMpvljs+5ZwehxtI5jTSVdgT1LMJvyBIZH63DfjZw0rQGuG4LMbjL wrw5OjRElfiwvsYIojNfoDTKRRWH+GIbWBivVINM0SqqkAqSiXfSc/XPtJEAatco23hc9ycV LyhHHF/IOskFvSkpQgTb/VXOyUuGq9M/p2cGF2m68OT/lzASULz/Nw7WSnaPaVAkgp2KVpvy bk1GBstNknZwdqM5579cchQr+hlAOqD0IE34ykmlmqfU6pgGMueK0nJzYYwMDMYr9FHEbD7Y MoQbDdjRA/cYhkJNlR/5JcWw7r03yCvK2cwRFS9nYAIv3aDxiFK8pPjMvr6W/KtbsllkRPNz o7B1yGjav0AD/SHxjOJ93Oqw+/GliD2Qpk6DLqj6vFwjUaKwioUEhJ+fVi7vOK5gEm5HcxWM EwV0icosaUo7FaqVdTxVVuzp3vsg/IHc4MIVbZhrl/RjPOPvm51G1Q5c9KIU/R+3OdeeNDg/ gbhcw/BbdC3jICodA== IronPort-HdrOrdr: A9a23:3BYrvqOvezG418BcTu2jsMiBIKoaSvp037By7TEUdfRUGvb1qy ncpoV96faUskdrZJhOo7C90cW7K080sKQFhLX5Xo3SJjUO2lHYT72KhLGKq1bd8m/Fh4xgPM xbHJSWfeeQMbEMt6jHCWeDfurIi+P3lpxAzd2utkuFYzsaE51d0w== Received: from SIT-EXCH011.PROD.SITAD.DK (10.34.10.195) by SIT-EXCH012.PROD.SITAD.DK (10.34.10.196) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.2375.12; Thu, 11 Nov 2021 07:45:27 +0100 Received: from SIT-EXCH011.PROD.SITAD.DK ([fe80::d0a4:335c:2f49:b77d]) by SIT-EXCH011.PROD.SITAD.DK ([fe80::d0a4:335c:2f49:b77d%16]) with mapi id 15.01.2375.012; Thu, 11 Nov 2021 07:45:27 +0100 From: Ayad Mohamed To: Khushboo Vashi CC: "pgadmin-hackers@postgresql.org" Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Thread-Topic: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Thread-Index: AQHX1fZbvqLUSDbWZEuM5vFCnKZD6av8n9M3///4zgCAAB0QkoAA98mAgAA1jfc= Date: Thu, 11 Nov 2021 06:45:27 +0000 Message-ID: <675de169aff445b58827cd060c7af03d@stil.dk> References: <5eedf5ae2452446eacd74d7af5847d44@stil.dk>, In-Reply-To: Accept-Language: en-GB, da-DK, en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.34.10.245] Content-Type: multipart/alternative; boundary="_000_675de169aff445b58827cd060c7af03dstildk_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_675de169aff445b58827cd060c7af03dstildk_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=F8rne- og Undervisningsministeriet Styrelsen for It og L=E6ring Kontor for It-drift Vester Voldgade 123 1552 K=F8benhavn 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 [https://www.uvm.dk/-/media/Billeder/Mailsignatur/UVM_STIL_DK.png] B=F8rne- og Undervisningsministeriet Styrelsen for It og L=E6ring Kontor for It-drift Vester Voldgade 123 1552 K=F8benhavn 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 load dat= abases. The database nodes are not getting loaded behind reverse proxy with SSL. Th= is issue has been fixed in this patch. Note: Yogesh helped me to setup the apache server with reverse proxy with S= SL and to reproduce the issue. Thanks, Khushboo --_000_675de169aff445b58827cd060c7af03dstildk_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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



  		B=F8rne- og Undervisningsministeriet
Styrelsen for It og L=E6ring
Kontor for It-drift
Vester Voldgade 123
1552 K=F8benhavn V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: Ayad.Mohamed@stil.dk


From: Khushboo Vashi <kh= ushboo.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
 
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 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 bundl= e
  •  source /usr/pgadmin4/venv/bin/activate
  •  cd /usr/pgad= min4/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=F8rne- og Undervisningsministeriet
Styrelsen for It og L=E6ring
Kontor for It-drift
Vester Voldgade 123
1552 K=F8benhavn V
Tlf.: 3587 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
 
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@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 - Impossible 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
--_000_675de169aff445b58827cd060c7af03dstildk_--