public inbox for [email protected]  
help / color / mirror / Atom feed
[pgAdmin4][Patch] - RM #6905 - Impossible to load databases
13+ messages / 4 participants
[nested] [flat]

* [pgAdmin4][Patch] - RM #6905 - Impossible to load databases
@ 2021-10-14 04:56 Khushboo Vashi <[email protected]>
  2021-10-14 06:16 ` Re: [pgAdmin4][Patch] - RM #6905 - Impossible to load databases Akshay Joshi <[email protected]>
  0 siblings, 1 reply; 13+ messages in thread

From: Khushboo Vashi @ 2021-10-14 04:56 UTC (permalink / raw)
  To: pgadmin-hackers

Hi,

Please find the attached patch to fix the RM #6905 - Impossible to load
databases.

Thanks,
Khushboo


Attachments:

  [application/octet-stream] RM_6905.patch (4.9K, 3-RM_6905.patch)
  download | inline diff:
diff --git a/web/package.json b/web/package.json
index 82dcc8e22..11f21aaf1 100644
--- a/web/package.json
+++ b/web/package.json
@@ -136,7 +136,7 @@
     "path-fx": "^2.0.0",
     "pathfinding": "^0.4.18",
     "paths-js": "^0.4.9",
-    "pgadmin4-tree": "git+https://github.com/EnterpriseDB/pgadmin4-treeview/#bc66dff13c17f256355d4f2bf79e3458007868bc",
+    "pgadmin4-tree": "git+https://github.com/EnterpriseDB/pgadmin4-treeview/#ccf3327caaaeaf06e5e683b07330ba2555d79867",
     "postcss": "^8.2.15",
     "raf": "^3.4.1",
     "react": "^17.0.1",
diff --git a/web/pgadmin/static/js/tree/tree.js b/web/pgadmin/static/js/tree/tree.js
index 41835b3bf..175320b31 100644
--- a/web/pgadmin/static/js/tree/tree.js
+++ b/web/pgadmin/static/js/tree/tree.js
@@ -225,6 +225,10 @@ export class Tree {
     return this.tree.getItemFromDOM(domElem[0]);
   }
 
+  DOMFrom(item) {
+    return this.tree.getDOMFromItem(item);
+  }
+
   path(item) {
     if (item) return item.path;
   }
diff --git a/web/pgadmin/static/js/tree/tree_init.tsx b/web/pgadmin/static/js/tree/tree_init.tsx
index d7d015288..a9a6892e3 100644
--- a/web/pgadmin/static/js/tree/tree_init.tsx
+++ b/web/pgadmin/static/js/tree/tree_init.tsx
@@ -89,10 +89,9 @@ var initBrowserTree = async (pgBrowser) => {
 
   // Render Browser Tree
   await render(
-    <div>
       <FileTreeX model={treeModelX}
         onReady={itemHandle} create={create} remove={remove} update={update}/>
-     </div>, document.getElementById('tree'));
+     , document.getElementById('tree'));
 }
 
 module.exports = {
diff --git a/web/pgadmin/static/js/tree/tree_nodes.ts b/web/pgadmin/static/js/tree/tree_nodes.ts
index b8d5350f3..3d75067dd 100644
--- a/web/pgadmin/static/js/tree/tree_nodes.ts
+++ b/web/pgadmin/static/js/tree/tree_nodes.ts
@@ -72,39 +72,42 @@ export class ManageTreeNodes {
   })
 
   public readNode = (_path: string) => new Promise<string[]>((res, rej) => {
-      let temp_tree_path = _path;
-      let node = this.findNode(_path);
+    let temp_tree_path = _path,
+      node = this.findNode(_path),
+      base_url = pgAdmin.Browser.URL;
 
-      if (node && node.children.length > 0) {
-        if (!node.type === FileType.File) {
-          rej("It's a leaf node")
-        }
-        else {
-          if (node.children.length != 0) res(node.children)
-        }
+    if (node && node.children.length > 0) {
+      if (!node.type === FileType.File) {
+        rej("It's a leaf node")
+      }
+      else {
+        if (node.children.length != 0) res(node.children)
       }
+    }
 
-      var self = this;
+    var self = this;
 
-      async function loadData() {
-        let url = '';
-        if (_path == '/browser') {
-          url = url_for('browser.nodes');
-        } else {
-          let _parent_url = self.generate_url(_path);
-          if (node.metadata.data._pid == null ) {
-            url = node.metadata.data._type + '/children/' + node.metadata.data._id;
+    async function loadData() {
+      let url = '';
+      if (_path == '/browser') {
+        url = url_for('browser.nodes');
+      } else {
+        let _parent_url = self.generate_url(_path);
+        if (node.metadata.data._pid == null ) {
+          url = node.metadata.data._type + '/children/' + node.metadata.data._id;
+        }
+        else {
+          if (node.metadata.data._type.includes("coll-")) {
+            let _type = node.metadata.data._type.replace("coll-", "")
+            url = _type + '/nodes/' + _parent_url;
           }
           else {
-            if (node.metadata.data._type.includes("coll-")) {
-              let _type = node.metadata.data._type.replace("coll-", "")
-              url = _type + '/nodes/' + _parent_url;
-            }
-            else {
-              url = node.metadata.data._type + '/children/' + _parent_url + '/' + node.metadata.data._id;
-            }
+            url = node.metadata.data._type + '/children/' + _parent_url + '/' + node.metadata.data._id;
+          }
         }
 
+        url = base_url + url;
+
         temp_tree_path = node.path;
 
         if (node.metadata.data._type == 'server' && !node.metadata.data.connected) {
diff --git a/web/yarn.lock b/web/yarn.lock
index d5a455530..555bd27fa 100644
--- a/web/yarn.lock
+++ b/web/yarn.lock
@@ -7582,9 +7582,9 @@ performance-now@^2.1.0:
   resolved "https://registry.yarnpkg.com/performance-now/-/performance-now-2.1.0.tgz#6309f4e0e5fa913ec1c69307ae364b4b377c9e7b"
   integrity sha1-Ywn04OX6kT7BxpMHrjZLSzd8nns=
 
-"pgadmin4-tree@git+https://github.com/EnterpriseDB/pgadmin4-treeview/#bc66dff13c17f256355d4f2bf79e3458007868bc":
+"pgadmin4-tree@git+https://github.com/EnterpriseDB/pgadmin4-treeview/#ccf3327caaaeaf06e5e683b07330ba2555d79867":
   version "1.0.0"
-  resolved "git+https://github.com/EnterpriseDB/pgadmin4-treeview/#bc66dff13c17f256355d4f2bf79e3458007868bc"
+  resolved "git+https://github.com/EnterpriseDB/pgadmin4-treeview/#ccf3327caaaeaf06e5e683b07330ba2555d79867"
   dependencies:
     "@types/classnames" "^2.2.6"
     "@types/react" "^16.7.18"


^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM #6905 - Impossible to load databases
  2021-10-14 04:56 [pgAdmin4][Patch] - RM #6905 - Impossible to load databases Khushboo Vashi <[email protected]>
@ 2021-10-14 06:16 ` Akshay Joshi <[email protected]>
  0 siblings, 0 replies; 13+ messages in thread

From: Akshay Joshi @ 2021-10-14 06:16 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: pgadmin-hackers

Thanks, the patch applied.

On Thu, Oct 14, 2021 at 10:26 AM Khushboo Vashi <
[email protected]> wrote:

> Hi,
>
> Please find the attached patch to fix the RM #6905 - Impossible to load
> databases.
>
> Thanks,
> Khushboo
>
>

-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*


^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
@ 2021-11-10 05:36 Khushboo Vashi <[email protected]>
  2021-11-10 06:28 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Akshay Joshi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  0 siblings, 2 replies; 13+ messages in thread

From: Khushboo Vashi @ 2021-11-10 05:36 UTC (permalink / raw)
  To: pgadmin-hackers

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


Attachments:

  [application/octet-stream] RM_6905.patch (668B, 3-RM_6905.patch)
  download | inline diff:
diff --git a/web/pgadmin/static/js/tree/tree_nodes.ts b/web/pgadmin/static/js/tree/tree_nodes.ts
index 3d75067dd..55587a1df 100644
--- a/web/pgadmin/static/js/tree/tree_nodes.ts
+++ b/web/pgadmin/static/js/tree/tree_nodes.ts
@@ -99,7 +99,7 @@ export class ManageTreeNodes {
         else {
           if (node.metadata.data._type.includes("coll-")) {
             let _type = node.metadata.data._type.replace("coll-", "")
-            url = _type + '/nodes/' + _parent_url;
+            url = _type + '/nodes/' + _parent_url + '/';
           }
           else {
             url = node.metadata.data._type + '/children/' + _parent_url + '/' + node.metadata.data._id;


^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
@ 2021-11-10 06:28 ` Akshay Joshi <[email protected]>
  1 sibling, 0 replies; 13+ messages in thread

From: Akshay Joshi @ 2021-11-10 06:28 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: pgadmin-hackers

Thanks, the patch applied.

On Wed, Nov 10, 2021 at 11:06 AM Khushboo Vashi <
[email protected]> wrote:

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

-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*


^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
@ 2021-11-10 11:29 ` Ayad Mohamed <[email protected]>
  2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  1 sibling, 1 reply; 13+ messages in thread

From: Ayad Mohamed @ 2021-11-10 11:29 UTC (permalink / raw)
  To: pgadmin-hackers


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 <[email protected]<mailto:Khushboo%20Vashi%20%[email protected]%3e>>
Til: pgadmin-hackers <[email protected]<mailto:pgadmin-hackers%20%[email protected]%3e>>
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



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
@ 2021-11-10 12:01   ` Khushboo Vashi <[email protected]>
  2021-11-10 12:48     ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  0 siblings, 1 reply; 13+ messages in thread

From: Khushboo Vashi @ 2021-11-10 12:01 UTC (permalink / raw)
  To: Ayad Mohamed <[email protected]>; +Cc: pgadmin-hackers

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 <[email protected]> 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 <[email protected]
> <Khushboo%20Vashi%20%[email protected]%3e>>
> *Til*: pgadmin-hackers <[email protected]
> <pgadmin-hackers%20%[email protected]%3e>>
> *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
>
>


^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
@ 2021-11-10 12:48     ` Ayad Mohamed <[email protected]>
  2021-11-11 04:32       ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  0 siblings, 1 reply; 13+ messages in thread

From: Ayad Mohamed @ 2021-11-10 12:48 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: pgadmin-hackers

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.










Med venlig hilsen
Ayad Mohamed
Seniorkonsulent



[https://www.uvm.dk/-/media/Billeder/Mailsignatur/UVM_STIL_DK.png]



        Børne- og Undervisningsministeriet
Styrelsen for It og Læring
Kontor for It-drift
Vester Voldgade 123
1552 København V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: [email protected]
tree_nodes.ts


________________________________
From: Khushboo Vashi <[email protected]>
Sent: 10 November 2021 13:01
To: Ayad Mohamed
Cc: [email protected]
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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:Khushboo%20Vashi%20%[email protected]%3e>>
Til: pgadmin-hackers <[email protected]<mailto:pgadmin-hackers%20%[email protected]%3e>>
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



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 12:48     ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
@ 2021-11-11 04:32       ` Khushboo Vashi <[email protected]>
  2021-11-11 06:45         ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  0 siblings, 1 reply; 13+ messages in thread

From: Khushboo Vashi @ 2021-11-11 04:32 UTC (permalink / raw)
  To: Ayad Mohamed <[email protected]>; +Cc: pgadmin-hackers

Hi Ayad,

On Wed, Nov 10, 2021 at 6:18 PM Ayad Mohamed <[email protected]> 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ørne- og Undervisningsministeriet
> Styrelsen for It og Læring
> Kontor for It-drift
> Vester Voldgade 123
> 1552 København V
> Tlf.: 3587 8889
>
> Direkte tlf.: +45 4172 7259
> E-mail: [email protected] tree_nodes.ts
>
>
> ------------------------------
> *From:* Khushboo Vashi <[email protected]>
> *Sent:* 10 November 2021 13:01
> *To:* Ayad Mohamed
> *Cc:* [email protected]
> *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 <[email protected]> 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 <[email protected]
>> <Khushboo%20Vashi%20%[email protected]%3e>>
>> *Til*: pgadmin-hackers <[email protected]
>> <pgadmin-hackers%20%[email protected]%3e>>
>> *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
>>
>>


^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 12:48     ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-11 04:32       ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
@ 2021-11-11 06:45         ` Ayad Mohamed <[email protected]>
  2021-11-11 07:18           ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  0 siblings, 1 reply; 13+ messages in thread

From: Ayad Mohamed @ 2021-11-11 06:45 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: pgadmin-hackers

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ørne- og Undervisningsministeriet
Styrelsen for It og Læring
Kontor for It-drift
Vester Voldgade 123
1552 København V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: [email protected]


________________________________
From: Khushboo Vashi <[email protected]>
Sent: 11 November 2021 05:32
To: Ayad Mohamed
Cc: [email protected]
Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases

Hi Ayad,

On Wed, Nov 10, 2021 at 6:18 PM Ayad Mohamed <[email protected]<mailto:[email protected]>> 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ørne- og Undervisningsministeriet
Styrelsen for It og Læring
Kontor for It-drift
Vester Voldgade 123
1552 København V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: [email protected]<mailto:[email protected]>
tree_nodes.ts


________________________________
From: Khushboo Vashi <[email protected]<mailto:[email protected]>>
Sent: 10 November 2021 13:01
To: Ayad Mohamed
Cc: [email protected]<mailto:[email protected]>
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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:Khushboo%20Vashi%20%[email protected]%3e>>
Til: pgadmin-hackers <[email protected]<mailto:pgadmin-hackers%20%[email protected]%3e>>
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



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 12:48     ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-11 04:32       ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-11 06:45         ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
@ 2021-11-11 07:18           ` Khushboo Vashi <[email protected]>
  2021-11-11 07:22             ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Aditya Toshniwal <[email protected]>
  2021-11-11 07:26             ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  0 siblings, 2 replies; 13+ messages in thread

From: Khushboo Vashi @ 2021-11-11 07:18 UTC (permalink / raw)
  To: Ayad Mohamed <[email protected]>; +Cc: pgadmin-hackers

On Thu, Nov 11, 2021 at 12:15 PM Ayad Mohamed <[email protected]> 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ørne- og Undervisningsministeriet
> Styrelsen for It og Læring
> Kontor for It-drift
> Vester Voldgade 123
> 1552 København V
> Tlf.: 3587 8889
>
> Direkte tlf.: +45 4172 7259
> E-mail: [email protected]
>
>
> ------------------------------
> *From:* Khushboo Vashi <[email protected]>
> *Sent:* 11 November 2021 05:32
> *To:* Ayad Mohamed
> *Cc:* [email protected]
> *Subject:* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
>
> Hi Ayad,
>
> On Wed, Nov 10, 2021 at 6:18 PM Ayad Mohamed <[email protected]> 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ørne- og Undervisningsministeriet
>> Styrelsen for It og Læring
>> Kontor for It-drift
>> Vester Voldgade 123
>> 1552 København V
>> Tlf.: 3587 8889
>>
>> Direkte tlf.: +45 4172 7259
>> E-mail: [email protected] tree_nodes.ts
>>
>>
>> ------------------------------
>> *From:* Khushboo Vashi <[email protected]>
>> *Sent:* 10 November 2021 13:01
>> *To:* Ayad Mohamed
>> *Cc:* [email protected]
>> *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 <[email protected]>
>> 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 <[email protected]
>>> <Khushboo%20Vashi%20%[email protected]%3e>>
>>> *Til*: pgadmin-hackers <[email protected]
>>> <pgadmin-hackers%20%[email protected]%3e>>
>>> *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
>>>
>>>


^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 12:48     ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-11 04:32       ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-11 06:45         ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-11 07:18           ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
@ 2021-11-11 07:22             ` Aditya Toshniwal <[email protected]>
  1 sibling, 0 replies; 13+ messages in thread

From: Aditya Toshniwal @ 2021-11-11 07:22 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: Ayad Mohamed <[email protected]>; pgadmin-hackers

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 <
[email protected]> wrote:

>
>
> On Thu, Nov 11, 2021 at 12:15 PM Ayad Mohamed <[email protected]>
> 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ørne- og Undervisningsministeriet
>> Styrelsen for It og Læring
>> Kontor for It-drift
>> Vester Voldgade 123
>> 1552 København V
>> Tlf.: 3587 8889
>>
>> Direkte tlf.: +45 4172 7259
>> E-mail: [email protected]
>>
>>
>> ------------------------------
>> *From:* Khushboo Vashi <[email protected]>
>> *Sent:* 11 November 2021 05:32
>> *To:* Ayad Mohamed
>> *Cc:* [email protected]
>> *Subject:* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
>>
>> Hi Ayad,
>>
>> On Wed, Nov 10, 2021 at 6:18 PM Ayad Mohamed <[email protected]>
>> 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ørne- og Undervisningsministeriet
>>> Styrelsen for It og Læring
>>> Kontor for It-drift
>>> Vester Voldgade 123
>>> 1552 København V
>>> Tlf.: 3587 8889
>>>
>>> Direkte tlf.: +45 4172 7259
>>> E-mail: [email protected] tree_nodes.ts
>>>
>>>
>>> ------------------------------
>>> *From:* Khushboo Vashi <[email protected]>
>>> *Sent:* 10 November 2021 13:01
>>> *To:* Ayad Mohamed
>>> *Cc:* [email protected]
>>> *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 <[email protected]>
>>> 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 <[email protected]
>>>> <Khushboo%20Vashi%20%[email protected]%3e>>
>>>> *Til*: pgadmin-hackers <[email protected]
>>>> <pgadmin-hackers%20%[email protected]%3e>>
>>>> *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
>>>>
>>>>

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com;
"Don't Complain about Heat, Plant a TREE"


^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 12:48     ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-11 04:32       ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-11 06:45         ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-11 07:18           ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
@ 2021-11-11 07:26             ` Ayad Mohamed <[email protected]>
  2021-11-11 09:44               ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  1 sibling, 1 reply; 13+ messages in thread

From: Ayad Mohamed @ 2021-11-11 07:26 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: pgadmin-hackers

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ørne- og Undervisningsministeriet
Styrelsen for It og Læring
Kontor for It-drift
Vester Voldgade 123
1552 København V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: [email protected]


________________________________
From: Khushboo Vashi <[email protected]>
Sent: 11 November 2021 08:18
To: Ayad Mohamed
Cc: [email protected]
Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases



On Thu, Nov 11, 2021 at 12:15 PM Ayad Mohamed <[email protected]<mailto:[email protected]>> 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ørne- og Undervisningsministeriet
Styrelsen for It og Læring
Kontor for It-drift
Vester Voldgade 123
1552 København V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: [email protected]<mailto:[email protected]>


________________________________
From: Khushboo Vashi <[email protected]<mailto:[email protected]>>
Sent: 11 November 2021 05:32
To: Ayad Mohamed
Cc: [email protected]<mailto:[email protected]>
Subject: Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases

Hi Ayad,

On Wed, Nov 10, 2021 at 6:18 PM Ayad Mohamed <[email protected]<mailto:[email protected]>> 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ørne- og Undervisningsministeriet
Styrelsen for It og Læring
Kontor for It-drift
Vester Voldgade 123
1552 København V
Tlf.: 3587 8889

Direkte tlf.: +45 4172 7259
E-mail: [email protected]<mailto:[email protected]>
tree_nodes.ts


________________________________
From: Khushboo Vashi <[email protected]<mailto:[email protected]>>
Sent: 10 November 2021 13:01
To: Ayad Mohamed
Cc: [email protected]<mailto:[email protected]>
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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:Khushboo%20Vashi%20%[email protected]%3e>>
Til: pgadmin-hackers <[email protected]<mailto:pgadmin-hackers%20%[email protected]%3e>>
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



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
  2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-10 12:48     ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-11 04:32       ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-11 06:45         ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
  2021-11-11 07:18           ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
  2021-11-11 07:26             ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
@ 2021-11-11 09:44               ` Khushboo Vashi <[email protected]>
  0 siblings, 0 replies; 13+ messages in thread

From: Khushboo Vashi @ 2021-11-11 09:44 UTC (permalink / raw)
  To: Ayad Mohamed <[email protected]>; +Cc: pgadmin-hackers

Hi Ayad,


On Thu, Nov 11, 2021 at 12:56 PM Ayad Mohamed <[email protected]> wrote:

> 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.
>
> We don't ship package.json file as the pgadmin4 package is not intended to
support in-line patching, but if you still want to do it, I have attached
the package.json file.
Place it at /usr/pgadmin4/web and do yarn install and yarn run bundle.
Also, if you come across the node js version error, please upgrade your
nodejs version.

Thanks,
Khushboo




>
>
>
>
>
>
>
>
>
>
> Med venlig hilsen
> Ayad Mohamed
> Seniorkonsulent
>
>
>
>
>
>   Børne- og Undervisningsministeriet
> Styrelsen for It og Læring
> Kontor for It-drift
> Vester Voldgade 123
> 1552 København V
> Tlf.: 3587 8889
>
> Direkte tlf.: +45 4172 7259
> E-mail: [email protected]
>
>
> ------------------------------
> *From:* Khushboo Vashi <[email protected]>
> *Sent:* 11 November 2021 08:18
> *To:* Ayad Mohamed
> *Cc:* [email protected]
> *Subject:* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
>
>
>
> On Thu, Nov 11, 2021 at 12:15 PM Ayad Mohamed <[email protected]>
> 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ørne- og Undervisningsministeriet
>> Styrelsen for It og Læring
>> Kontor for It-drift
>> Vester Voldgade 123
>> 1552 København V
>> Tlf.: 3587 8889
>>
>> Direkte tlf.: +45 4172 7259
>> E-mail: [email protected]
>>
>>
>> ------------------------------
>> *From:* Khushboo Vashi <[email protected]>
>> *Sent:* 11 November 2021 05:32
>> *To:* Ayad Mohamed
>> *Cc:* [email protected]
>> *Subject:* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
>>
>> Hi Ayad,
>>
>> On Wed, Nov 10, 2021 at 6:18 PM Ayad Mohamed <[email protected]>
>> 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ørne- og Undervisningsministeriet
>>> Styrelsen for It og Læring
>>> Kontor for It-drift
>>> Vester Voldgade 123
>>> 1552 København V
>>> Tlf.: 3587 8889
>>>
>>> Direkte tlf.: +45 4172 7259
>>> E-mail: [email protected] tree_nodes.ts
>>>
>>>
>>> ------------------------------
>>> *From:* Khushboo Vashi <[email protected]>
>>> *Sent:* 10 November 2021 13:01
>>> *To:* Ayad Mohamed
>>> *Cc:* [email protected]
>>> *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 <[email protected]>
>>> 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 <[email protected]
>>>> <Khushboo%20Vashi%20%[email protected]%3e>>
>>>> *Til*: pgadmin-hackers <[email protected]
>>>> <pgadmin-hackers%20%[email protected]%3e>>
>>>> *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
>>>>
>>>>


Attachments:

  [application/json] package.json (6.9K, 3-package.json)
  download

^ permalink  raw  reply  [nested|flat] 13+ messages in thread


end of thread, other threads:[~2021-11-11 09:44 UTC | newest]

Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-14 04:56 [pgAdmin4][Patch] - RM #6905 - Impossible to load databases Khushboo Vashi <[email protected]>
2021-10-14 06:16 ` Akshay Joshi <[email protected]>
2021-11-10 05:36 [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
2021-11-10 06:28 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Akshay Joshi <[email protected]>
2021-11-10 11:29 ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
2021-11-10 12:01   ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
2021-11-10 12:48     ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
2021-11-11 04:32       ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
2021-11-11 06:45         ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
2021-11-11 07:18           ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>
2021-11-11 07:22             ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Aditya Toshniwal <[email protected]>
2021-11-11 07:26             ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Ayad Mohamed <[email protected]>
2021-11-11 09:44               ` Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases Khushboo Vashi <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox