Обсуждение: Cannot login to pgAdmin4 Web
When attempting to login to pgadmin server I get the message "Incorrect username or password". At first I figured I just forgot my password so I deleted the pgadmin directories and packages and reran the setup-web.sh and reentered credentials but I still get the same "Incorrect username or password"
I've looked in /var/log/messages, /var/log/pgadmin4/pgadmin4.log, and /var/log/httpd/error_log for any indication of what might me wrong but I don't see any related messaged logged. I've also tried disabling selinux just to verify that that wasn't causing issue with the same result.
Attached are the various files I've used to configure the server. In the past this was working but now something must have changed.
The current environment is CentOS 7.8.2009 (3.10.0-1160.31.1.el7.x86_64 #1 SMP Thu Jun 10 13:32:12 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux) and the following pgadmin packages are installed:
pgadmin4.noarch 5.4-1.el7 @pgAdmin4
pgadmin4-desktop.x86_64 5.4-1.el7 @pgAdmin4
pgadmin4-python3-mod_wsgi.x86_64 4.7.1-2.el7 @pgAdmin4
pgadmin4-redhat-repo.noarch 2-1 installed
pgadmin4-server.x86_64 5.4-1.el7 @pgAdmin4
pgadmin4-web.noarch 5.4-1.el7 @pgAdmin4
Thanks,
Joe
I've looked in /var/log/messages, /var/log/pgadmin4/pgadmin4.log, and /var/log/httpd/error_log for any indication of what might me wrong but I don't see any related messaged logged. I've also tried disabling selinux just to verify that that wasn't causing issue with the same result.
Attached are the various files I've used to configure the server. In the past this was working but now something must have changed.
The current environment is CentOS 7.8.2009 (3.10.0-1160.31.1.el7.x86_64 #1 SMP Thu Jun 10 13:32:12 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux) and the following pgadmin packages are installed:
pgadmin4.noarch 5.4-1.el7 @pgAdmin4
pgadmin4-desktop.x86_64 5.4-1.el7 @pgAdmin4
pgadmin4-python3-mod_wsgi.x86_64 4.7.1-2.el7 @pgAdmin4
pgadmin4-redhat-repo.noarch 2-1 installed
pgadmin4-server.x86_64 5.4-1.el7 @pgAdmin4
pgadmin4-web.noarch 5.4-1.el7 @pgAdmin4
Thanks,
Joe
Вложения
Hi,
I could not reproduce the issue with default apache configuration.
Could you please try with default apache configuration & see if it works you?
Thanks,
Yogesh Mahajan
EnterpriseDB
On Wed, Jun 23, 2021 at 11:21 PM O'Connor, Joseph <joseph.oconnor@mecinc.com> wrote:
When attempting to login to pgadmin server I get the message "Incorrect username or password". At first I figured I just forgot my password so I deleted the pgadmin directories and packages and reran the setup-web.sh and reentered credentials but I still get the same "Incorrect username or password"
I've looked in /var/log/messages, /var/log/pgadmin4/pgadmin4.log, and /var/log/httpd/error_log for any indication of what might me wrong but I don't see any related messaged logged. I've also tried disabling selinux just to verify that that wasn't causing issue with the same result.
Attached are the various files I've used to configure the server. In the past this was working but now something must have changed.
The current environment is CentOS 7.8.2009 (3.10.0-1160.31.1.el7.x86_64 #1 SMP Thu Jun 10 13:32:12 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux) and the following pgadmin packages are installed:
pgadmin4.noarch 5.4-1.el7 @pgAdmin4
pgadmin4-desktop.x86_64 5.4-1.el7 @pgAdmin4
pgadmin4-python3-mod_wsgi.x86_64 4.7.1-2.el7 @pgAdmin4
pgadmin4-redhat-repo.noarch 2-1 installed
pgadmin4-server.x86_64 5.4-1.el7 @pgAdmin4
pgadmin4-web.noarch 5.4-1.el7 @pgAdmin4
Thanks,
Joe
I have a similar problem using the Docker image. With a docker compose containing
pgadmin:
# See https://hub.docker.com/r/dpage/pgadmin4/tags
# for other versions available.
image: dpage/pgadmin4:5.3
environment:
PGADMIN_DEFAULT_EMAIL: pgadmin@example.com
PGADMIN_DEFAULT_PASSWORD: password I can log in successfully. The moment I change to the 5.4 image, with no other alteration, I am unable to log in.
From: Yogesh Mahajan <yogesh.mahajan@enterprisedb.com>
Sent: 24 June 2021 10:11
To: O'Connor, Joseph <joseph.oconnor@mecinc.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: Cannot login to pgAdmin4 Web
Sent: 24 June 2021 10:11
To: O'Connor, Joseph <joseph.oconnor@mecinc.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: Cannot login to pgAdmin4 Web
Hi,
I could not reproduce the issue with default apache configuration.
Could you please try with default apache configuration & see if it works you?
Thanks,
Yogesh Mahajan
EnterpriseDB
On Wed, Jun 23, 2021 at 11:21 PM O'Connor, Joseph <joseph.oconnor@mecinc.com> wrote:
When attempting to login to pgadmin server I get the message "Incorrect username or password". At first I figured I just forgot my password so I deleted the pgadmin directories and packages and reran the setup-web.sh and reentered credentials but I still get the same "Incorrect username or password"
I've looked in /var/log/messages, /var/log/pgadmin4/pgadmin4.log, and /var/log/httpd/error_log for any indication of what might me wrong but I don't see any related messaged logged. I've also tried disabling selinux just to verify that that wasn't causing issue with the same result.
Attached are the various files I've used to configure the server. In the past this was working but now something must have changed.
The current environment is CentOS 7.8.2009 (3.10.0-1160.31.1.el7.x86_64 #1 SMP Thu Jun 10 13:32:12 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux) and the following pgadmin packages are installed:
pgadmin4.noarch 5.4-1.el7 @pgAdmin4
pgadmin4-desktop.x86_64 5.4-1.el7 @pgAdmin4
pgadmin4-python3-mod_wsgi.x86_64 4.7.1-2.el7 @pgAdmin4
pgadmin4-redhat-repo.noarch 2-1 installed
pgadmin4-server.x86_64 5.4-1.el7 @pgAdmin4
pgadmin4-web.noarch 5.4-1.el7 @pgAdmin4
Thanks,
Joe
Hi
On Fri, Jun 25, 2021 at 10:41 AM Jim Bacon <jamesvincentbacon@hotmail.com> wrote:
I have a similar problem using the Docker image. With a docker compose containingpgadmin:# for other versions available.image: dpage/pgadmin4:5.3environment:PGADMIN_DEFAULT_EMAIL: pgadmin@example.comPGADMIN_DEFAULT_PASSWORD: passwordI can log in successfully. The moment I change to the 5.4 image, with no other alteration, I am unable to log in.
Does it work if you use a real, deliverable email address?
We think the problem might be that the flask-security-too module that we use is now checking to ensure that the address given is actually deliverable.
Yes!
If I use my genuine email address I can then log in.
Thank you for looking into this.
This is not a change that helps me but I can probably work around it.
Regards,
Jim Bacon.
From: Dave Page <dpage@pgadmin.org>
Sent: 25 June 2021 11:17
To: Jim Bacon <jamesvincentbacon@hotmail.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: Cannot login to pgAdmin4 Web
Sent: 25 June 2021 11:17
To: Jim Bacon <jamesvincentbacon@hotmail.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: Cannot login to pgAdmin4 Web
Hi
On Fri, Jun 25, 2021 at 10:41 AM Jim Bacon <jamesvincentbacon@hotmail.com> wrote:
I have a similar problem using the Docker image. With a docker compose containingpgadmin:# for other versions available.image: dpage/pgadmin4:5.3environment:PGADMIN_DEFAULT_EMAIL: pgadmin@example.comPGADMIN_DEFAULT_PASSWORD: passwordI can log in successfully. The moment I change to the 5.4 image, with no other alteration, I am unable to log in.
Does it work if you use a real, deliverable email address?
We think the problem might be that the flask-security-too module that we use is now checking to ensure that the address given is actually deliverable.
Hi
On Fri, Jun 25, 2021 at 11:43 AM Jim Bacon <jamesvincentbacon@hotmail.com> wrote:
Yes!If I use my genuine email address I can then log in.Thank you for looking into this.This is not a change that helps me but I can probably work around it.
Please see https://redmine.postgresql.org/issues/6550#note-27 - whilst I haven't yet tested it myself, it seems you can disable the new behaviour.
Regards,Jim Bacon.From: Dave Page <dpage@pgadmin.org>
Sent: 25 June 2021 11:17
To: Jim Bacon <jamesvincentbacon@hotmail.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: Cannot login to pgAdmin4 WebHiOn Fri, Jun 25, 2021 at 10:41 AM Jim Bacon <jamesvincentbacon@hotmail.com> wrote:I have a similar problem using the Docker image. With a docker compose containingpgadmin:# for other versions available.image: dpage/pgadmin4:5.3environment:PGADMIN_DEFAULT_EMAIL: pgadmin@example.comPGADMIN_DEFAULT_PASSWORD: passwordI can log in successfully. The moment I change to the 5.4 image, with no other alteration, I am unable to log in.Does it work if you use a real, deliverable email address?We think the problem might be that the flask-security-too module that we use is now checking to ensure that the address given is actually deliverable.--
I reconfigured the httpd config and re-setup pgadmin but received the same result.
<VirtualHost *:80>
LoadModule wsgi_module modules/mod_wsgi.so WSGIDaemonProcess pgadmin processes=1 threads=25 python-home=/usr/pgadmin4/venv WSGIScriptAlias /pgadmin4 /usr/pgadmin4/web/pgAdmin4.wsgi
<Directory /usr/pgadmin4/web/>
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
<IfModule mod_authz_core.c>
# Apache 2.4
Require all granted
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Allow from All
</IfModule>
</Directory>
</VirtualHost>
Here is a list of the directories related to pgadmim if you could verify that the security is setup correctly:
/var/lib:
drwx------. 4 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 56 Jun 24 13:29 pgadmin4
/var/lib/pgadmin4:
total 56
-rw-------. 1 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 56320 Jun 24 13:29 pgadmin4.db
drwx------. 2 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 50 Jun 24 13:29 sessions
drwxr-xr-x. 2 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 6 Jun 24 13:24 storage
/var/lib/pgadmin4/sessions:
total 4
-rw-r--r--. 1 system_u:object_r:httpd_sys_rw_content_t:s0 apache apache 368 Jun 24 13:29 2c9742c7-3526-412a-8bcb-65cf6ad2c441
/var/lib/pgadmin4/storage:
total 0
/var/log:
drwxr-xr-x. 2 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 26 Jun 24 13:24 pgadmin4
/var/log/pgadmin4:
total 0
-rw-r--r--. 1 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 0 Jun 24 13:24 pgadmin4.log
<VirtualHost *:80>
LoadModule wsgi_module modules/mod_wsgi.so WSGIDaemonProcess pgadmin processes=1 threads=25 python-home=/usr/pgadmin4/venv WSGIScriptAlias /pgadmin4 /usr/pgadmin4/web/pgAdmin4.wsgi
<Directory /usr/pgadmin4/web/>
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
<IfModule mod_authz_core.c>
# Apache 2.4
Require all granted
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Allow from All
</IfModule>
</Directory>
</VirtualHost>
Here is a list of the directories related to pgadmim if you could verify that the security is setup correctly:
/var/lib:
drwx------. 4 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 56 Jun 24 13:29 pgadmin4
/var/lib/pgadmin4:
total 56
-rw-------. 1 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 56320 Jun 24 13:29 pgadmin4.db
drwx------. 2 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 50 Jun 24 13:29 sessions
drwxr-xr-x. 2 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 6 Jun 24 13:24 storage
/var/lib/pgadmin4/sessions:
total 4
-rw-r--r--. 1 system_u:object_r:httpd_sys_rw_content_t:s0 apache apache 368 Jun 24 13:29 2c9742c7-3526-412a-8bcb-65cf6ad2c441
/var/lib/pgadmin4/storage:
total 0
/var/log:
drwxr-xr-x. 2 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 26 Jun 24 13:24 pgadmin4
/var/log/pgadmin4:
total 0
-rw-r--r--. 1 unconfined_u:object_r:httpd_sys_rw_content_t:s0 apache apache 0 Jun 24 13:24 pgadmin4.log
Hi
On Fri, Jun 25, 2021 at 4:59 PM O'Connor, Joseph <joseph.oconnor@mecinc.com> wrote:
I reconfigured the httpd config and re-setup pgadmin but received the same result.
<VirtualHost *:80>
LoadModule wsgi_module modules/mod_wsgi.so WSGIDaemonProcess pgadmin processes=1 threads=25 python-home=/usr/pgadmin4/venv WSGIScriptAlias /pgadmin4 /usr/pgadmin4/web/pgAdmin4.wsgi
<Directory /usr/pgadmin4/web/>
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
<IfModule mod_authz_core.c>
# Apache 2.4
Require all granted
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Allow from All
</IfModule>
</Directory>
</VirtualHost>
Did you reply to the wrong thread? This one has nothing to do with httpd or directory permissions.
The original problem you reported here seems (from our testing, and that of other users) to be resolved by adding the config option to config_local.py (or config_system.py) as noted in the link I shared:
I'm pretty sure I'm responding to the correct thread since it's the only pgadmin thread I'm currently involved in.
I was asked to revert back to the default pgadmin httpd config to see if that fixed the issue, which it didn't. I posted the config I used and included some additional info in the event that it would assist in solving the issue.
I added the additional config option to the config_local.py and I’m able to login to pgadmin again.
SECURITY_EMAIL_VALIDATOR_ARGS={"check_deliverability": False}
Thanks for your assistance.
Joe
I was asked to revert back to the default pgadmin httpd config to see if that fixed the issue, which it didn't. I posted the config I used and included some additional info in the event that it would assist in solving the issue.
I added the additional config option to the config_local.py and I’m able to login to pgadmin again.
SECURITY_EMAIL_VALIDATOR_ARGS={"check_deliverability": False}
Thanks for your assistance.
Joe
Hi
On Mon, Jun 28, 2021 at 1:12 PM O'Connor, Joseph <joseph.oconnor@mecinc.com> wrote:
I'm pretty sure I'm responding to the correct thread since it's the only pgadmin thread I'm currently involved in.
Apologies - I missed that earlier message.
I was asked to revert back to the default pgadmin httpd config to see if that fixed the issue, which it didn't. I posted the config I used and included some additional info in the event that it would assist in solving the issue.
I added the additional config option to the config_local.py and I’m able to login to pgadmin again.
SECURITY_EMAIL_VALIDATOR_ARGS={"check_deliverability": False}
Thanks for your assistance.
Glad it's working for you now!
Which version(s) of Pgadmin4 supports Greenplum database V6.x ? We have both Greenplum 5.x and 6.x installed in our org.
Regards
Sachchida (Sachi) N Ojha
Sachchida (Sachi) N Ojha
This is a PRIVATE message. This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery.
On Mon, Jun 28, 2021 at 11:11 AM Dave Page <dpage@pgadmin.org> wrote:
Hi--On Mon, Jun 28, 2021 at 1:12 PM O'Connor, Joseph <joseph.oconnor@mecinc.com> wrote:I'm pretty sure I'm responding to the correct thread since it's the only pgadmin thread I'm currently involved in.Apologies - I missed that earlier message.
I was asked to revert back to the default pgadmin httpd config to see if that fixed the issue, which it didn't. I posted the config I used and included some additional info in the event that it would assist in solving the issue.
I added the additional config option to the config_local.py and I’m able to login to pgadmin again.
SECURITY_EMAIL_VALIDATOR_ARGS={"check_deliverability": False}
Thanks for your assistance.Glad it's working for you now!
Hi Sachchida,
pgAdmin latest version has removed GPDB support - https://www.pgadmin.org/docs/pgadmin4/6.0/release_notes_6_0.html#housekeeping.
On Mon, Oct 18, 2021 at 7:20 PM Sachchida Ojha <snojha@gmail.com> wrote:
Which version(s) of Pgadmin4 supports Greenplum database V6.x ? We have both Greenplum 5.x and 6.x installed in our org.Regards
Sachchida (Sachi) N OjhaThis is a PRIVATE message. This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery.On Mon, Jun 28, 2021 at 11:11 AM Dave Page <dpage@pgadmin.org> wrote:Hi--On Mon, Jun 28, 2021 at 1:12 PM O'Connor, Joseph <joseph.oconnor@mecinc.com> wrote:I'm pretty sure I'm responding to the correct thread since it's the only pgadmin thread I'm currently involved in.Apologies - I missed that earlier message.
I was asked to revert back to the default pgadmin httpd config to see if that fixed the issue, which it didn't. I posted the config I used and included some additional info in the event that it would assist in solving the issue.
I added the additional config option to the config_local.py and I’m able to login to pgadmin again.
SECURITY_EMAIL_VALIDATOR_ARGS={"check_deliverability": False}
Thanks for your assistance.Glad it's working for you now!
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"