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 1ml1lA-0002P7-GJ for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 04:32:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ml1l9-0003Ut-60 for pgadmin-hackers@arkaria.postgresql.org; Thu, 11 Nov 2021 04:32:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ml1l8-0003Uk-EL for pgadmin-hackers@lists.postgresql.org; Thu, 11 Nov 2021 04:32:22 +0000 Received: from mail-lf1-x12e.google.com ([2a00:1450:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ml1l5-0003fy-Hc for pgadmin-hackers@postgresql.org; Thu, 11 Nov 2021 04:32:21 +0000 Received: by mail-lf1-x12e.google.com with SMTP id f3so11088488lfu.12 for ; Wed, 10 Nov 2021 20:32:19 -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=mzFRCGF6/RWy+Gbu3TafFIO4AX7Mc9rNoXW/nqmVuyc=; b=MiZVphrYhdVF9zlYH9lSJ3WUTs0P++cpLMg1kkwDsfpQNxsq3HJ50UNrfh8fLftScd oHPnhWZi2U+9C1wp1bATYmtqUOFTV0+Civ7IJK3B/NjqnekhuvfeOgQHjJLv/YtsheUN 3dncWonYLHCTy43GKUpQxPEplJMIE+zwuTZqe6x4Hw7qRPbI5qW3gYvwCV4amPBpRTU2 B0sMRIFZ9qJImUliosRBseLswgfn0YnRr/MM7zE/t2TwYLv3vuI+xHZzwkMJj3ZHkp9H /6JYAahAkS71Gdiwh3+CqS1x/qKVqjbKCB4LEcIUtw8qV9dASjquUwQFEJiFPbsf+/9z Hvlw== 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=mzFRCGF6/RWy+Gbu3TafFIO4AX7Mc9rNoXW/nqmVuyc=; b=CHDa+0U/VXRTaXXmJ8usW0p/vOCbZYrVrYa6wMgPhKunZUBYZHS9IuW6KJOrqX65ZZ ZcOI7m9/WE3pME0cqnWErCZQuXFvIx80iahcbtVmQ9CtKNdFgwQet6zYKvDKT60Odbf6 cWF5Ki9PaEn607+hSfAm8uqu9HN/pksV2hmxt7HU0Q24mAC2hmcOpdp2JCLZULMsdiu0 pZqe27XOz3QxLHsnFhLO5pcyLoWNGGcNuBmA54CJFUHCGNVvP8wnFg0eCYL+9Iiqhaen ebunaspsm3EnFOWKVpdLaPi/wsnnoDRzqTTRv3yC4YnirMql2Vc1H6Zk1F7gBBws+AGA yKAQ== X-Gm-Message-State: AOAM5306pOIOFyLBXh+BT4jeyKPLXj0tIJJ98P1z0ZMACvd4ywz6OkET cIsiMEbEcb9MAZLpRGg2SV64tj1P/wGyc5+eODt3mtXjQf8pvxVXMLp0IgQGkztu3dmaky8yRXZ 8DR91QkpmcG7AIp4bmIe9DCK+rD5o/x0Q20H6/kqhJan8dk+2of82vQ500z/dKDmHQBotnUkp+j PrTM5cSf4/hEF8ghUHcs4sZYjj9jXfZUpAr5CHPW5Rgdx2U27ub7DnrDnGDvQ4aBI4mQ== X-Google-Smtp-Source: ABdhPJzcnSXq/zQOLy9hipD2fKLqKxjqVDO/L1OIFW2AnEAgj7ot7/oBRWXSFwIy9fLADHcEiA6bPz7yldr8RrvROC4= X-Received: by 2002:a05:6512:b84:: with SMTP id b4mr570852lfv.472.1636605137990; Wed, 10 Nov 2021 20:32:17 -0800 (PST) MIME-Version: 1.0 References: <5eedf5ae2452446eacd74d7af5847d44@stil.dk> In-Reply-To: <5eedf5ae2452446eacd74d7af5847d44@stil.dk> From: Khushboo Vashi Date: Thu, 11 Nov 2021 10:02:07 +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="000000000000e34e1a05d07bd3cf" 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 --000000000000e34e1a05d07bd3cf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 postgresq= l > 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 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 wit= h >> SSL and to reproduce the issue. >> >> Thanks, >> Khushboo >> >> --000000000000e34e1a05d07bd3cf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Ayad,

On Wed, Nov 10, 2021 at 6:18 PM A= yad Mohamed <Ayad.Mohamed@stil.d= k> 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:

- Insta= ll yarn and nodejs on the ubuntu machine=C2=A0
- Run below comman= ds to activate virtual environment and do yarn bundle
  • = =C2=A0source /usr/pgadmin4/venv/bin/activate
  • =C2=A0cd /usr/pgadmin4= /web
  • =C2=A0yarn install
  • =C2=A0yarn run bundle
Now, clear the browser cache,=C2=A0browse the p= gAdmin4 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
--000000000000e34e1a05d07bd3cf--