Re: import upload file to pgadmin get CSRF error

I run 'yum update pgadmin4' it appears pgadmin4 already 4.11, but on the
web interface under about it still shows 4.8. Any idea? Thanks.

On Tue, Aug 6, 2019 at 3:08 PM Wh isere <[email protected]> wrote:

> Hello, we have updated pgadmin4 to 4.11 but this problem is still there.
> Thanks.
>
> On Fri, Jun 28, 2019 at 3:09 PM Murtuza Zabuawala <
> [email protected]> wrote:
>
>>
>> On Fri, Jun 28, 2019 at 10:18 AM Where is Where <[email protected]>
>> 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 <
>>> [email protected]> wrote:
>>>
>>>> On Fri, Jun 28, 2019 at 6:31 AM Where is Where <[email protected]>
>>>> 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 <[email protected]>
>>>>> 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 <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Mon, Jun 24, 2019 at 11:42 AM Where is Where <[email protected]>
>>>>>>> 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 <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Mon, Jun 24, 2019 at 11:13 AM Where is Where <[email protected]>
>>>>>>>>> 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
>>>>>>>>>
>>>>>>>>