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 <dp...@pgadmin.org> wrote: > Hi > > On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.ab...@enterprisedb.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 <avinkav...@gmail.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.va...@enterprisedb.com> wrote: >>> >>>> On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas < >>>> fahar.ab...@enterprisedb.com> wrote: >>>> >>>>> Hi, >>>>> >>>>> On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whis...@gmail.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.ab...@enterprisedb.com> wrote: >>>>>> >>>>>>> Please find attached the snapshot for pgadmin4 shutdown the server. >>>>>>> >>>>>>> On Tue, Aug 6, 2019 at 11:21 AM Fahar Abbas < >>>>>>> fahar.ab...@enterprisedb.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 <whis...@gmail.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.ab...@enterprisedb.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 <whis...@gmail.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 <whis...@gmail.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.va...@enterprisedb.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 <whis...@gmail.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 <whis...@gmail.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.zabuaw...@enterprisedb.com> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On Fri, Jun 28, 2019 at 10:18 AM Where is Where < >>>>>>>>>>>>>>>> whis...@gmail.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.zabuaw...@enterprisedb.com> wrote: >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> On Fri, Jun 28, 2019 at 6:31 AM Where is Where < >>>>>>>>>>>>>>>>>> whis...@gmail.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 < >>>>>>>>>>>>>>>>>>> whis...@gmail.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.va...@enterprisedb.com> wrote: >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> On Mon, Jun 24, 2019 at 11:42 AM Where is Where < >>>>>>>>>>>>>>>>>>>>> whis...@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.va...@enterprisedb.com> wrote: >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> On Mon, Jun 24, 2019 at 11:13 AM Where is Where < >>>>>>>>>>>>>>>>>>>>>>> whis...@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 >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> 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 >
