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 <whis...@gmail.com> 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 <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 >> >
