Re: import upload file to pgadmin get CSRF error

Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar(dot)abbas(at)enterprisedb(dot)com>
wrote:

> Hi Avin,
>
> Please replay on Ashesh question: Is it running in 'web' or 'desktop'
> mode?
>

Ashesh asked Wh isere that question, not Avin.

>
> Also adding Dave Page for his further inputs about shutdown pgadmin4
> server process.
>

If there's no GUI on the server, then the pgAdmin desktop server almost
certainly isn't running. Asking someone to install a GUI to check that is
not reasonable.

My first guess would be that although the RPMs have been updated, Apache
HTTPD/Nginx/Gunicorn/uWSGI/whatever is hosting pgAdmin has not been
restarted.

My second guess is that config.py has been directly edited on the server so
when the RPMs were upgraded, the original config.py wasn't replaced, thus
pgAdmin is reporting the version number from the previous version (the
version number is defined in config.py).

Wh isere, please check both of those possible causes.

> Kind Regards,
>
>
> On Tue, Aug 6, 2019 at 12:06 PM Avin Kavish <avinkavish(at)gmail(dot)com> wrote:
>
>> You can use any one of ps, top, htop, or systemctl to view running
>> services/processes and kill them
>>
>> On Tue, Aug 6, 2019 at 12:21 PM Ashesh Vashi <
>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>> On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <
>>> fahar(dot)abbas(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi,
>>>>
>>>> On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere(at)gmail(dot)com> wrote:
>>>>
>>>>> Thank you! I am running pgadmin on a remote server, so there is not
>>>>> Gui interface, is there command to shut down pgadmin4 server?
>>>>> I also run yum upgrade pgadmin4*, but it said yum: No match.
>>>>>
>>>> Kindly first install GUI on remote machine and shut down pgadmin4
>>>> server.
>>>>
>>> Before doing that - how did you setup the pgAdmin 4?
>>> Is it running in 'web' or 'desktop' mode?
>>>
>>> -- Thanks, Ashesh
>>>
>>>> I don't think so we have any command to shutdown the server.
>>>>
>>>> When you will shutdown the pgadmin4 server properly and follow the
>>>> steps mentioned in the previous replay properly you will not able to see
>>>> older pgadmin4 4.8 version.
>>>>
>>>>> Thanks.
>>>>>
>>>>> On Tue, Aug 6, 2019 at 4:25 PM Fahar Abbas <
>>>>> fahar(dot)abbas(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> Please find attached the snapshot for pgadmin4 shutdown the server.
>>>>>>
>>>>>> On Tue, Aug 6, 2019 at 11:21 AM Fahar Abbas <
>>>>>> fahar(dot)abbas(at)enterprisedb(dot)com> wrote:
>>>>>>
>>>>>>> Yes it's due to pgadmin4 is not properly upgrade on your system.
>>>>>>>
>>>>>>> Why not you try yum upgrade pgadmin4* include (*)
>>>>>>>
>>>>>>> Can you do following steps.
>>>>>>>
>>>>>>> 1. Clear you cache
>>>>>>> 2. Please shutdown the pgadmin4 server through elephant icon
>>>>>>> 3. then try yum upgrade pgadmin4*
>>>>>>>
>>>>>>>
>>>>>>> If you are still getting any error message and kindly do following:
>>>>>>>
>>>>>>> 1. yum erase pgadmin4*
>>>>>>> 2. yum clean all
>>>>>>> 3. yum erase pgadmin4*
>>>>>>> 4. try yum make cache
>>>>>>> 5. yum makecache
>>>>>>> 6. Now install pgadmin4 through yum install pgadmin4*
>>>>>>>
>>>>>>> Kindly let us know if your issue is resolve or not?
>>>>>>>
>>>>>>> Kind Regards?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Aug 6, 2019 at 11:07 AM Wh isere <whisere(at)gmail(dot)com> wrote:
>>>>>>>
>>>>>>>> Thanks, I have tried yum upgrade pgadmin4, it is still the same.
>>>>>>>>
>>>>>>>> here is the output from previous yum update pgadmin4, and screen
>>>>>>>> shot of pgadmin4 attached.:
>>>>>>>>
>>>>>>>> sudo yum update pgadmin4
>>>>>>>> Loaded plugins: enabled_repos_upload, package_upload, product-id,
>>>>>>>> search-
>>>>>>>> : disabled-repos, subscription-manager, tracer_upload
>>>>>>>> rhel-7-server-rpms | 2.0
>>>>>>>> kB 00:00
>>>>>>>> rhel-7-server-satellite-tools-6.5-rpms | 2.1
>>>>>>>> kB 00:00
>>>>>>>> Resolving Dependencies
>>>>>>>> --> Running transaction check
>>>>>>>> ---> Package pgadmin4.x86_64 0:4.8-1.rhel7 will be updated
>>>>>>>> ---> Package pgadmin4.x86_64 0:4.11-1.rhel7 will be an update
>>>>>>>> --> Finished Dependency Resolution
>>>>>>>>
>>>>>>>> Dependencies Resolved
>>>>>>>>
>>>>>>>>
>>>>>>>> ================================================================================
>>>>>>>> Package Arch Version
>>>>>>>> Repository Size
>>>>>>>>
>>>>>>>> ================================================================================
>>>>>>>> Updating:
>>>>>>>> pgadmin4 x86_64 4.11-1.rhel7
>>>>>>>> pgdg10 11 k
>>>>>>>>
>>>>>>>> Transaction Summary
>>>>>>>>
>>>>>>>> ================================================================================
>>>>>>>> Upgrade 1 Package
>>>>>>>>
>>>>>>>> Total download size: 11 k
>>>>>>>> Is this ok [y/d/N]: y
>>>>>>>> Downloading packages:
>>>>>>>> No Presto metadata available for pgdg10
>>>>>>>> pgadmin4-4.11-1.rhel7.x86_64.rpm | 11
>>>>>>>> kB 00:01
>>>>>>>> Running transaction check
>>>>>>>> Running transaction test
>>>>>>>> Transaction test succeeded
>>>>>>>> Running transaction
>>>>>>>> Updating :
>>>>>>>> pgadmin4-4.11-1.rhel7.x86_64 1/2
>>>>>>>> Cleanup :
>>>>>>>> pgadmin4-4.8-1.rhel7.x86_64 2/2
>>>>>>>> Uploading Package Profile
>>>>>>>> Uploading Tracer Profile
>>>>>>>> Verifying :
>>>>>>>> pgadmin4-4.11-1.rhel7.x86_64 1/2
>>>>>>>> Verifying :
>>>>>>>> pgadmin4-4.8-1.rhel7.x86_64 2/2
>>>>>>>>
>>>>>>>> Updated:
>>>>>>>> pgadmin4.x86_64
>>>>>>>> 0:4.11-1.rhel7
>>>>>>>>
>>>>>>>> Complete!
>>>>>>>> Uploading Enabled Repositories Report
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Aug 6, 2019 at 3:49 PM Fahar Abbas <
>>>>>>>> fahar(dot)abbas(at)enterprisedb(dot)com> wrote:
>>>>>>>>
>>>>>>>>> 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
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> 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
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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
>>>>>>
>>>>>
>>>>
>>>> --
>>>> 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
>>>>
>>>
>
> --
> 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
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company