Re: import upload file to pgadmin get CSRF error

Hi,

Can you please try yum upgrade pgadmin4* and check the pgadmin4?

On Tue, Aug 6, 2019 at 10:39 AM Wh isere <whisere(at)gmail(dot)com> wrote:

> It is web browser cache we need to clean or other cache? Thanks.
>
> On Tue, Aug 6, 2019 at 3:27 PM Wh isere <whisere(at)gmail(dot)com> wrote:
>
>> Thanks. I cleaned the cache, but it is still the same.
>>
>> On Tue, Aug 6, 2019 at 3:18 PM Ashesh Vashi <
>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>> Would please try to clear the cache?
>>>
>>> --
>>>
>>> Thanks & Regards,
>>>
>>> Ashesh Vashi
>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>>> <http://www.enterprisedb.com>
>>>
>>>
>>> *http://www.linkedin.com/in/asheshvashi*
>>> <http://www.linkedin.com/in/asheshvashi>
>>>
>>>
>>> On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere(at)gmail(dot)com> wrote:
>>>
>>>> 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 <whisere(at)gmail(dot)com> 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 <
>>>>> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>>
>>>>>> 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
>>>>>>>>>>>>>
>>>>>>>>>>>>

--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com