Re: import upload file to pgadmin get CSRF error

And I did restart httpd after running 'yum update pgadmin4' but it didn't
work.

On Wed, Aug 7, 2019 at 8:38 AM Wh isere <[email protected]> wrote:

> Thank you all! Sorry for the late reply due to timezone difference. Yes
> the pgadmin4 is on web mode. I run '/usr/pgadmin4/bin/pgadmin4-web-setup.sh'
> to set it up after installing with 'yum install pgadmin4' before. currently
> under /usr/pgadmin4/ there is only a bin folder with pgadmin4-web-setup.sh
> file in it, I am not sure where config.py is, so I don't think I have
> edited it directly. The strange thing is 'yum update pgadmin4' run
> successfully without any problem. I guess I will have to uninstall and
> reinstall pgadmin4? Thanks!
>
> On Tue, Aug 6, 2019 at 6:02 PM Dave Page <[email protected]> wrote:
>
>> Hi
>>
>> On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <[email protected]>
>> 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 <[email protected]>
>>> 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 <
>>>> [email protected]> wrote:
>>>>
>>>>> On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> On Tue, Aug 6, 2019 at 11:36 AM Wh isere <[email protected]> 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 <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>>> Please find attached the snapshot for pgadmin4 shutdown the server.
>>>>>>>>
>>>>>>>> On Tue, Aug 6, 2019 at 11:21 AM Fahar Abbas <
>>>>>>>> [email protected]> 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 <[email protected]>
>>>>>>>>> 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 <
>>>>>>>>>> [email protected]> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi,
>>>>>>>>>>>
>>>>>>>>>>> Can you please try yum upgrade pgadmin4* and check the pgadmin4?
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Tue, Aug 6, 2019 at 10:39 AM Wh isere <[email protected]>
>>>>>>>>>>> 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 <[email protected]>
>>>>>>>>>>>> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Thanks. I cleaned the cache, but it is still the same.
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Tue, Aug 6, 2019 at 3:18 PM Ashesh Vashi <
>>>>>>>>>>>>> [email protected]> 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 <[email protected]>
>>>>>>>>>>>>>> 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 <[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
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> 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
>>
>