Re: import upload file to pgadmin get CSRF error

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere(at)gmail(dot)com> wrote:

> Thanks for the clarification Murtuza. Any idea about when it might be, eg
> the packages in here:
> https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7Server-x86_64/
> . Thanks!
>

Not sure, that is something handled by Postgres packaging community and not
by pgAdmin4 team.

-- Murtuza

>
> On Fri, Jun 28, 2019 at 1:55 PM Murtuza Zabuawala <
> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>
>> On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere(at)gmail(dot)com> wrote:
>>
>>> Is there a way to apply this bug fix on a installation on redhat?The 4.9
>>> redhat yum package is not available yet. Thanks!
>>>
>>
>> No, Release version of JS files are bundled by webpacker, so it is not
>> feasible to patch them.
>> You have to wait until the yum repo gets the updated version.
>>
>>
>> -- Murtuza
>>
>>>
>>> On Tue, Jun 25, 2019 at 9:30 AM Where is Where <whisere(at)gmail(dot)com>
>>> wrote:
>>>
>>>> Thank you! I will wait for the release on Thursday. Will the redhat yum
>>>> package be updated too? Or can I download the tar file and use some file
>>>> from it to replace the file on the server?
>>>>
>>>> Thanks.
>>>>
>>>> On Mon, Jun 24, 2019 at 4:25 PM Khushboo Vashi <
>>>> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>>
>>>>>
>>>>>
>>>>> On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere(at)gmail(dot)com>
>>>>> wrote:
>>>>>
>>>>>> Thank you! I just saw that too. I tried to apply that diff only:
>>>>>> https://redmine.postgresql.org/projects/pgadmin4/repository/revisions/08b78fb6a11283731cdf59d2a29fdc75e459582e/diff/web/pgadmin/misc/file_manager/static/js/utility.js
>>>>>> But it doesn't seem to fix the problem.
>>>>>>
>>>>>> It will require bundling of the static files after applying the patch.
>>>>> Instead, you can install the pgAdmin from the nightly builds having
>>>>> the latest code.
>>>>> https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-06-24/
>>>>>
>>>>> * // We need to append our csrf token with dropzone's ajax request header
>>>>>> *
>>>>>>
>>>>>> * let csrfToken = {};
>>>>>> *
>>>>>>
>>>>>> * csrfToken[pgAdmin.csrf_token_header] = pgAdmin.csrf_token;
>>>>>> *
>>>>>>
>>>>>>
>>>>>> $('div#multiple-uploads').dropzone({
>>>>>>
>>>>>> paramName: 'newfile',
>>>>>>
>>>>>> url: pgAdmin.FileUtils.fileConnector,
>>>>>>
>>>>>> *headers: csrfToken,*
>>>>>>
>>>>>>
>>>>>> Thanks, Junran
>>>>>>
>>>>>> On Mon, Jun 24, 2019 at 3:47 PM Khushboo Vashi <
>>>>>> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>>>>
>>>>>>>
>>>>>>> On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere(at)gmail(dot)com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hello, we are trying to import csv file to database from pgadmin,
>>>>>>>> but when uploading file it reports '
>>>>>>>> 400 Bad Request <h1>Bad Request</h1> <p>The CSRF token is
>>>>>>>> missing.</p> '
>>>>>>>> I looked at config.py but can't find any related setting.
>>>>>>>> Any idea is much appreciated.
>>>>>>>>
>>>>>>>> This issue has already been reported and fixed. (Ref:
>>>>>>> https://redmine.postgresql.org/issues/4350)
>>>>>>> You will get the fix in the upcoming release which is scheduled on
>>>>>>> coming Thursday.
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Khushboo
>>>>>>>
>>>>>>