Обсуждение: import upload file to pgadmin get CSRF error

Поиск
Список
Период
Сортировка

import upload file to pgadmin get CSRF error

От
Where is Where
Дата:
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.

Re: import upload file to pgadmin get CSRF error

От
Khushboo Vashi
Дата:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Where is Where
Дата:
But it doesn't seem to fix the problem.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Khushboo Vashi
Дата:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Where is Where
Дата:
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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Where is Where
Дата:
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!

On Tue, Jun 25, 2019 at 9:30 AM Where is Where <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Murtuza Zabuawala
Дата:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Where is Where
Дата:
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!

On Fri, Jun 28, 2019 at 1:55 PM Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Murtuza Zabuawala
Дата:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
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@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Ashesh Vashi
Дата:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
Thanks. I cleaned the cache, but it is still the same.

On Tue, Aug 6, 2019 at 3:18 PM Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
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@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Fahar Abbas
Дата:
Hi,

Can you please try yum upgrade pgadmin4* and check the pgadmin4?


On Tue, Aug 6, 2019 at 10:39 AM Wh isere <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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
Вложения

Re: import upload file to pgadmin get CSRF error

От
Fahar Abbas
Дата:
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@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Fahar Abbas
Дата:
Please find attached the snapshot for pgadmin4 shutdown the server.

On Tue, Aug 6, 2019 at 11:21 AM Fahar Abbas <fahar.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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
Вложения

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
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.
Thanks.

On Tue, Aug 6, 2019 at 4:25 PM Fahar Abbas <fahar.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Fahar Abbas
Дата:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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. 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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Ashesh Vashi
Дата:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Avin Kavish
Дата:
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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Avin Kavish
Дата:
You can't just randomly install GUIs every time a process needs to be terminated.

On Tue, Aug 6, 2019 at 12:19 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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. 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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Fahar Abbas
Дата:
Hi Avin,

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

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

Kind Regards,


On Tue, Aug 6, 2019 at 12:06 PM Avin Kavish <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Dave Page
Дата:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
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 <dpage@pgadmin.org> wrote:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
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 <whisere@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 <dpage@pgadmin.org> wrote:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
I have tried remove and reinstall pgadmin4 but nothing changed.
I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and /usr/pgadmin4/ were untouched by the re-installation and update. I have also tried rename these folders but no new folders were created after re-installation. For some reason the folders related to web mode seem unaffected by any pgadmin4 change after they are installed. Any idea? Thanks! 

On Wed, Aug 7, 2019 at 9:26 AM Wh isere <whisere@gmail.com> wrote:
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 <whisere@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 <dpage@pgadmin.org> wrote:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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

Re: import upload file to pgadmin get CSRF error

От
Dave Page
Дата:
Hi

On Wed, Aug 7, 2019 at 1:24 AM Wh isere <whisere@gmail.com> wrote:
I have tried remove and reinstall pgadmin4 but nothing changed.
I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and /usr/pgadmin4/ were untouched by the re-installation and update. I have also tried rename these folders but no new folders were created after re-installation. For some reason the folders related to web mode seem unaffected by any pgadmin4 change after they are installed. Any idea? Thanks! 

That sounds like your package management tools on your system (RPM/Yum) are seriously broken. There's no way for pgAdmin to prevent you removing it from the system.

What OS are your running exactly?
 

On Wed, Aug 7, 2019 at 9:26 AM Wh isere <whisere@gmail.com> wrote:
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 <whisere@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 <dpage@pgadmin.org> wrote:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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


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

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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
I can remove pgadmin with yum erase without problem but the web folders mentioned before were not changed, even after yum  erase pgadmin4 and then
 yum install pgadmin4 again. The os is redhat 7. Thanks!


On Wednesday, August 7, 2019, Dave Page <dpage@pgadmin.org> wrote:
Hi

On Wed, Aug 7, 2019 at 1:24 AM Wh isere <whisere@gmail.com> wrote:
I have tried remove and reinstall pgadmin4 but nothing changed.
I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and /usr/pgadmin4/ were untouched by the re-installation and update. I have also tried rename these folders but no new folders were created after re-installation. For some reason the folders related to web mode seem unaffected by any pgadmin4 change after they are installed. Any idea? Thanks! 

That sounds like your package management tools on your system (RPM/Yum) are seriously broken. There's no way for pgAdmin to prevent you removing it from the system.

What OS are your running exactly?
 

On Wed, Aug 7, 2019 at 9:26 AM Wh isere <whisere@gmail.com> wrote:
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 <whisere@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 <dpage@pgadmin.org> wrote:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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


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

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

Re: import upload file to pgadmin get CSRF error

От
Dave Page
Дата:


On Wed, Aug 7, 2019 at 11:05 AM Wh isere <whisere@gmail.com> wrote:
I can remove pgadmin with yum erase without problem but the web folders mentioned before were not changed, even after yum  erase pgadmin4 and then
 yum install pgadmin4 again. The os is redhat 7. Thanks!

Is there anything left in the folders when you've removed the package, or is it just an empty folder?
 


On Wednesday, August 7, 2019, Dave Page <dpage@pgadmin.org> wrote:
Hi

On Wed, Aug 7, 2019 at 1:24 AM Wh isere <whisere@gmail.com> wrote:
I have tried remove and reinstall pgadmin4 but nothing changed.
I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and /usr/pgadmin4/ were untouched by the re-installation and update. I have also tried rename these folders but no new folders were created after re-installation. For some reason the folders related to web mode seem unaffected by any pgadmin4 change after they are installed. Any idea? Thanks! 

That sounds like your package management tools on your system (RPM/Yum) are seriously broken. There's no way for pgAdmin to prevent you removing it from the system.

What OS are your running exactly?
 

On Wed, Aug 7, 2019 at 9:26 AM Wh isere <whisere@gmail.com> wrote:
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 <whisere@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 <dpage@pgadmin.org> wrote:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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


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

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


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

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

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
They seem the same, all files are still there, the date of the files inside were showing created/modified long ago not today.   I also tried rename the folders but the install process didn't create new folders.
 

On Wednesday, August 7, 2019, Dave Page <dpage@pgadmin.org> wrote:


On Wed, Aug 7, 2019 at 11:05 AM Wh isere <whisere@gmail.com> wrote:
I can remove pgadmin with yum erase without problem but the web folders mentioned before were not changed, even after yum  erase pgadmin4 and then
 yum install pgadmin4 again. The os is redhat 7. Thanks!

Is there anything left in the folders when you've removed the package, or is it just an empty folder?
 


On Wednesday, August 7, 2019, Dave Page <dpage@pgadmin.org> wrote:
Hi

On Wed, Aug 7, 2019 at 1:24 AM Wh isere <whisere@gmail.com> wrote:
I have tried remove and reinstall pgadmin4 but nothing changed.
I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and /usr/pgadmin4/ were untouched by the re-installation and update. I have also tried rename these folders but no new folders were created after re-installation. For some reason the folders related to web mode seem unaffected by any pgadmin4 change after they are installed. Any idea? Thanks! 

That sounds like your package management tools on your system (RPM/Yum) are seriously broken. There's no way for pgAdmin to prevent you removing it from the system.

What OS are your running exactly?
 

On Wed, Aug 7, 2019 at 9:26 AM Wh isere <whisere@gmail.com> wrote:
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 <whisere@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 <dpage@pgadmin.org> wrote:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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


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

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


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

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

Re: import upload file to pgadmin get CSRF error

От
Dave Page
Дата:
Hi

On Wed, Aug 7, 2019 at 12:01 PM Wh isere <whisere@gmail.com> wrote:
They seem the same, all files are still there, the date of the files inside were showing created/modified long ago not today.   I also tried rename the folders but the install process didn't create new folders.

I don't know then. I'm not familiar enough with the inner workings of RPM/Yum to know how or why that might happen. 

Devrim, do you have any ideas?
 
 

On Wednesday, August 7, 2019, Dave Page <dpage@pgadmin.org> wrote:


On Wed, Aug 7, 2019 at 11:05 AM Wh isere <whisere@gmail.com> wrote:
I can remove pgadmin with yum erase without problem but the web folders mentioned before were not changed, even after yum  erase pgadmin4 and then
 yum install pgadmin4 again. The os is redhat 7. Thanks!

Is there anything left in the folders when you've removed the package, or is it just an empty folder?
 


On Wednesday, August 7, 2019, Dave Page <dpage@pgadmin.org> wrote:
Hi

On Wed, Aug 7, 2019 at 1:24 AM Wh isere <whisere@gmail.com> wrote:
I have tried remove and reinstall pgadmin4 but nothing changed.
I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and /usr/pgadmin4/ were untouched by the re-installation and update. I have also tried rename these folders but no new folders were created after re-installation. For some reason the folders related to web mode seem unaffected by any pgadmin4 change after they are installed. Any idea? Thanks! 

That sounds like your package management tools on your system (RPM/Yum) are seriously broken. There's no way for pgAdmin to prevent you removing it from the system.

What OS are your running exactly?
 

On Wed, Aug 7, 2019 at 9:26 AM Wh isere <whisere@gmail.com> wrote:
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 <whisere@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 <dpage@pgadmin.org> wrote:
Hi

On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas <fahar.abbas@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 <avinkavish@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.vashi@enterprisedb.com> wrote:
On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
Hi,

On Tue, Aug 6, 2019 at 11:36 AM Wh isere <whisere@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.abbas@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.abbas@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 <whisere@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.abbas@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 <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:
Would please try to clear the cache?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 10:47 AM Wh isere <whisere@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 <whisere@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.zabuawala@enterprisedb.com> wrote:

On Fri, Jun 28, 2019 at 10:18 AM Where is Where <whisere@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.zabuawala@enterprisedb.com> wrote:
On Fri, Jun 28, 2019 at 6:31 AM Where is Where <whisere@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 <whisere@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.vashi@enterprisedb.com> wrote:


On Mon, Jun 24, 2019 at 11:42 AM Where is Where <whisere@gmail.com> wrote:
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.

          // 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.vashi@enterprisedb.com> wrote:

On Mon, Jun 24, 2019 at 11:13 AM Where is Where <whisere@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


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

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


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

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


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

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

Re: import upload file to pgadmin get CSRF error

От
Devrim Gündüz
Дата:
Hi,

On Tue, 2019-08-06 at 16:36 +1000, Wh isere wrote:
> I also run yum upgrade pgadmin4*, but it said yum: No match.

Are you sure you got this message? No match is thrown if there are no such
packages in the repo. You already have pgadmin4 stuff. The message should be
"Nothing to do."

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Вложения

Re: import upload file to pgadmin get CSRF error

От
Devrim Gündüz
Дата:
Hi,

On Tue, 2019-08-06 at 09:02 +0100, Dave Page wrote:
> 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).

This cannot happen -- I did not mark config.py as a "configuration file" in the
spec file.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Вложения

Re: import upload file to pgadmin get CSRF error

От
Devrim Gündüz
Дата:
Hi,

On Wed, 2019-08-07 at 10:23 +1000, Wh isere wrote:
> I have tried remove and reinstall pgadmin4 but nothing changed.

What is the output of

rpm -qa|grep pgadmin

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Вложения

Re: import upload file to pgadmin get CSRF error

От
Devrim Gündüz
Дата:
Hi,

On Wed, 2019-08-07 at 10:23 +1000, Wh isere wrote:
> I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and
> /usr/pgadmin4/ were untouched by the re-installation and update. I have
> also tried rename these folders but no new folders were created after
> re-installation. For some reason the folders related to web mode seem
> unaffected by any pgadmin4 change after they are installed. Any idea?

I need to see the exact commands you ran. What you wrote is almost impossible.
I'd say impossible, but leaving a window for an RPM bug that was not discovered
in last 20 years.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Вложения

Re: import upload file to pgadmin get CSRF error

От
Wh isere
Дата:
Thank you very much Devrim for the replies.

I can run yum upgrade pgadmin4 without problem just pgadmin4* or pgadmin* were not accepted.

The output of rpm -qa|grep pgadmin is
sudo rpm -qa|grep pgadmin
pgadmin4-python-flask-wtf-0.14.2-1.rhel7.noarch
pgadmin4-python-pyrsistent-0.14.2-1.rhel7.1.x86_64
pgadmin4-python-jinja2-2.8-9.rhel7.1.noarch
pgadmin4-python-flask-1.0.2-1.rhel7.noarch
pgadmin4-python-dateutil-2.7.2-1.rhel7.1.noarch
pgadmin4-python-six-1.12.0-3.rhel7.noarch
pgadmin4-python-sshtunnel-0.1.4-1.rhel7.noarch
pgadmin4-python-alembic-0.9.7-3.rhel7.1.noarch
pgadmin4-python-pbr-3.1.1-1.rhel7.1.noarch
pgadmin4-python-flask-babel-0.11.1-4.rhel7.1.noarch
pgadmin4-python-sqlalchemy-1.2.18-1.rhel7.x86_64
pgadmin4-python-sqlparse-0.2.4-1.rhel7.1.noarch
pgadmin4-python-mimeparse-1.6.0-1.rhel7.1.noarch
pgadmin4-python-markupsafe-0.23-13.rhel7.1.x86_64
pgadmin4-python-simplejson-3.16.0-1.rhel7.x86_64
pgadmin4-python-flask-sqlalchemy-2.3.2-1.rhel7.noarch
pgadmin4-python-babel-2.3.4-2.rhel7.1.noarch
pgadmin4-4.11-1.rhel7.x86_64
pgadmin4-web-4.8-1.rhel7.noarch
pgadmin4-python-fixtures-3.0.0-5.rhel7.1.noarch
pgadmin4-pytz-2018.9-1.rhel7.noarch
pgadmin4-python-flask-gravatar-0.5.0-1.rhel7.1.noarch
pgadmin4-python-flask-principal-0.4.0-14.rhel7.1.noarch
pgadmin4-python-wtforms-2.2.1-1.rhel7.noarch
pgadmin4-python-passlib-1.7.1-1.rhel7.1.noarch
pgadmin4-python-flask-paranoid-0.2-1.rhel7.1.noarch
pgadmin4-python-flask-security-3.0.0-1.rhel7.1.noarch
pgadmin4-python-flask-login-0.4.1-1.rhel7.noarch
pgadmin4-python-extras-1.0.0-2.rhel7.1.noarch
pgadmin4-python-werkzeug-0.15.4-1.rhel7.noarch
pgadmin4-python-flask-babelex-0.9.3-1.rhel7.1.noarch
pgadmin4-python-flask-htmlmin-1.5.0-1.rhel7.noarch
pgadmin4-python-Flask-Mail-0.9.1-4.rhel7.1.noarch
pgadmin4-python-backports.csv-1.0.5-3.rhel7.1.noarch
pgadmin4-python-blinker-1.4-3.rhel7.1.noarch
pgadmin4-docs-4.8-1.rhel7.noarch
pgadmin4-python-html5lib-1.0.1-1.rhel7.1.noarch
pgadmin4-python-itsdangerous-0.24-10.rhel7.1.noarch
pgadmin4-python-flask-migrate-2.4.0-1.rhel7.noarch
pgadmin4-python-htmlmin-0.1.12-1.rhel7.1.noarch
pgadmin4-python-psutil-5.5.1-1.rhel7.x86_64
pgadmin4-python-beautifulsoup4-4.5.1-3.rhel7.1.noarch

The command I used are:

sudo yum upgrade pgadmin4
sudo service httpd restart
no change to the version on web mode,

sudo yum clean all
sudo yum erase pgadmin4


ls -all /usr/pgadmin4/bin
ls /usr/lib/python2.7/site-packages/pgadmin4-web/ -all

folders still there


sudo mv /usr/lib/python2.7/site-packages/pgadmin4-web/ /usr/lib/python2.7/site-packages/pgadmin4-web0
sudo mv /usr/pgadmin4 /usr/pgadmin4_0

sudo yum install pgadmin4
sudo service httpd restart

no new folders

I have installed a new version of pgadmin4 on a different VM and connect to the postgres on the VM with pgadmin4 can't be updated to solve this problem temporarily.

Thank you.


On Fri, Aug 9, 2019 at 8:09 PM Devrim Gündüz <devrim@gunduz.org> wrote:

Hi,

On Wed, 2019-08-07 at 10:23 +1000, Wh isere wrote:
> I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and
> /usr/pgadmin4/ were untouched by the re-installation and update. I have
> also tried rename these folders but no new folders were created after
> re-installation. For some reason the folders related to web mode seem
> unaffected by any pgadmin4 change after they are installed. Any idea?

I need to see the exact commands you ran. What you wrote is almost impossible.
I'd say impossible, but leaving a window for an RPM bug that was not discovered
in last 20 years.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR