Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases

Hi Ayad,

On Thu, Nov 11, 2021 at 12:56 PM Ayad Mohamed <Ayad(dot)Mohamed(at)stil(dot)dk> 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: Ayad(dot)Mohamed(at)stil(dot)dk
>
>
> ------------------------------
> *From:* Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
> *Sent:* 11 November 2021 08:18
> *To:* Ayad Mohamed
> *Cc:* pgadmin-hackers(at)postgresql(dot)org
> *Subject:* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
>
>
>
> On Thu, Nov 11, 2021 at 12:15 PM Ayad Mohamed <Ayad(dot)Mohamed(at)stil(dot)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.
> 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: Ayad(dot)Mohamed(at)stil(dot)dk
>>
>>
>> ------------------------------
>> *From:* Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
>> *Sent:* 11 November 2021 05:32
>> *To:* Ayad Mohamed
>> *Cc:* pgadmin-hackers(at)postgresql(dot)org
>> *Subject:* Re: [pgAdmin4][Patch] - RM 6905 - Impossible to load databases
>>
>> Hi Ayad,
>>
>> On Wed, Nov 10, 2021 at 6:18 PM Ayad Mohamed <Ayad(dot)Mohamed(at)stil(dot)dk>
>> 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: Ayad(dot)Mohamed(at)stil(dot)dk tree_nodes.ts
>>>
>>>
>>> ------------------------------
>>> *From:* Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
>>> *Sent:* 10 November 2021 13:01
>>> *To:* Ayad Mohamed
>>> *Cc:* pgadmin-hackers(at)postgresql(dot)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 <Ayad(dot)Mohamed(at)stil(dot)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(dot)vashi(at)enterprisedb(dot)com
>>>> <Khushboo%20Vashi%20%3ckhushboo(dot)vashi(at)enterprisedb(dot)com%3e>>
>>>> *Til*: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org
>>>> <pgadmin-hackers%20%3cpgadmin-hackers(at)postgresql(dot)org%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
>>>>
>>>>