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 1ml4TZ-0002Ku-Ro for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 07:26:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ml4TY-0000Li-SF for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 07:26:24 +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 1ml4TY-0000LX-Bp for pgadmin-hackers@lists.postgresql.org; Thu, 11 Nov 2021 07:26:24 +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 1ml4TT-0007Fu-RW for pgadmin-hackers@postgresql.org; Thu, 11 Nov 2021 07:26:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=stil.dk; i=@stil.dk; q=dns/txt; s=sit1; t=1636615579; x=1668151579; h=from:to:cc:subject:date:message-id:references: in-reply-to:mime-version; bh=l4GAfMbLfwagsG38q3Ysl1um8dcKTRAcmCzcK7mhn28=; b=ennP8+lTd/84/FCCyOEMELCsBndp4eK6qs17LiiByddaDsH5gq3IL+hH FFqdvH+fyFPDOwpaouMNFfF9DcypzMvRfe6MihVcVyW5loCVHQiXHQV0e PiDfwJxDXwlETdRiqLaSd607z8yqQZi5HN1kG8/M/WT3RV8pH0a/AdqqW x6xnytKTTvT113/9Lv0MwIVrGvD5UVLjmXT6/LFlfrRkL+f3xrYYHZt57 S9aPbpL2hTBrCK2ORL3HRTIG8r2DJyZ3e+lTWYCFZORihycdsBTZRdSYq relEGaWjYZrrTTSaQtMNsokpz8kIguKv0MI3293WmwmKTniV7pBOaf15b A==; Received: from 10.33.64.139 ([10.33.64.139]) by localhost (JAMES SMTP Server 2.3.2-1) with SMTP ID 929; Thu, 11 Nov 2021 08:26:13 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=stil.dk; i=@stil.dk; q=dns/txt; s=sit1; t=1636615573; x=1668151573; h=from:to:cc:subject:date:message-id:references: in-reply-to:mime-version; bh=l4GAfMbLfwagsG38q3Ysl1um8dcKTRAcmCzcK7mhn28=; b=6Vkhf54ZYYI4PUojbC/cvo90TfXXQLQ6K2BCs52cFH6KDWoGVi/p7fd/ PbUUPDjWn38EzkgghxQs9QndGh1tLnmSipBbu9LmiOrDUuk208veej1P3 Ou+B8KyK6Zo9si0TbVqpQ0oAvsqUinTgFJruyrqLNgc9I4SHrItg1Fx1Y cAEqZpo/kIU3WSUnfbRRY/IPQBi1UW2VF2M4g2DlQ/0RCzwCaZ8w/AqCf k1mlCOHOcJDufpeejWuX6u9tmwXoHrMGaq9adClf43IoHbgrgw5VRHjju FrxmLC85Nj/TyoJY+SauR908GIV7r4mYD2MlDKI3aEH1kWvqOJOF0tja4 g==; IronPort-Data: A9a23:LxxoWKjrJc6B1WJgIuEEFYlyX161LxEKZh0ujC45NGQN5FlHY01je htvXz2DMq6PMGr2f4oiOo/n8xsFvpWAm4I2TlNsqy1kQy0W8JqUDtmndUqhZCn6wu8v7a5EA 2fyTvGacajYm1eB/n9BFJC/9yEkvU2vbuOkUbCYUsxJbVY4Dn9n0HqPosZh6mJSqYHR7zil5 JWi/KUzBHf/g2QtaztNs/rewP9SlK+aVA0w7wVWic9j7Ae2e0k9VPrz8onochMU6qENdgKLb 76rIIORpws1zD90Yj+RqYsXR2VRKlLkFVPX1icJAfjKbi9q/UTe2o5jXBYVhNw+Zz+hx7idw /0V3XC8pJtA0gQhV43xXjEBexySM5Gq95ffMSCAqpPL/nbaUETo3eRPElAtYtcHr7Mf7WFmr ZT0KRg2TyzGqtKd4OriE69UvOMPavLKAKoz/F1Dpd3bJa9+B8uYBfuWo4YDgV/chegXdRraT +MIYDYpSRPAahhCNn8MFJM62uur7pX6W2IF9AvF/vFri4TV5A91zJO0GtOMRtiTZvwF2WSDv VyXr2usV3n2M/Tak1Jp6EmEnuDGkSb6XscSHba7++RxqEWU3XAcEhANTF/9puO24ma9W89EK 0YT/WwwpLMy9WSmSMXwRQWioWWJshRaUN1Ve9DW8ynUkuyPuEDHWi5dFWMphMEaifLajAcCj jeh9+4FzxQ12FFJYRpxLoupkA4= IronPort-HdrOrdr: A9a23:fcNYla0A7WfCOXvj2k04mAqjBDokLtp133Aq2lEZdPUMSL36qy ncpoV46faUskdsZJhOo7G90cW7K080lqQFnrX5X43DYOCOggLBR72KhrGP/9SUIUPDH5lmup uIHZISNDS6NykesS+z2njdL/8p3MSA+LujhOfAw3dxQQUCUdAY0y51DAyGFkFwWQFcD5s4C5 b03LshmxOsf34Kasi9G3MMQuTMocba/aiWGyIuChgs9A2Dii625KX7HnGjr2wjejdC3L8u+X XMggj9j5/T1c2T0RPX0Gm71eUvpDLO8Ko/OPCx Received: from SIT-EXCH011.PROD.SITAD.DK (10.34.10.195) by SIT-EXCH011.PROD.SITAD.DK (10.34.10.195) 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 08:26:08 +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 08:26:08 +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///4zgCAAB0QkoAA98mAgAA1jff///jdAIAAEuAO Date: Thu, 11 Nov 2021 07:26:08 +0000 Message-ID: <70862f623f994b00bb8fb726db250c40@stil.dk> References: <5eedf5ae2452446eacd74d7af5847d44@stil.dk> <675de169aff445b58827cd060c7af03d@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_70862f623f994b00bb8fb726db250c40stildk_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_70862f623f994b00bb8fb726db250c40stildk_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 [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 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 > 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 [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_70862f623f994b00bb8fb726db250c40stildk_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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&quo= t;
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about= this command.



 







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 08:18
To: Ayad Mohamed
Cc: pgadmin-hackers@postgresql.org
Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databa= ses
 


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.
 

 ??



 







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


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
 
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_70862f623f994b00bb8fb726db250c40stildk_--