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 >