Re: import upload file to pgadmin get CSRF error

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