Re: import upload file to pgadmin get CSRF error

On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@gmail.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