Re: Cannot login to pgAdmin4 Web
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 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 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 wrote:
>
>> Hi
>>
>> On Mon, Jun 28, 2021 at 1:12 PM O'Connor, Joseph <
>> joseph.ocon...@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!
>>
>> --
>> Dave Page
>> Blog: https://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EDB: https://www.enterprisedb.com
>>
>>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
"Don't Complain about Heat, Plant a TREE"
Re: Cannot login to pgAdmin4 Web
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
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 wrote:
> Hi
>
> On Mon, Jun 28, 2021 at 1:12 PM O'Connor, Joseph <
> joseph.ocon...@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!
>
> --
> Dave Page
> Blog: https://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: https://www.enterprisedb.com
>
>
Re: Cannot login to pgAdmin4 Web
Hi
On Mon, Jun 28, 2021 at 1:12 PM O'Connor, Joseph
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!
--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake
EDB: https://www.enterprisedb.com
RE: Cannot login to pgAdmin4 Web
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
Re: Cannot login to pgAdmin4 Web
Hi
On Fri, Jun 25, 2021 at 4:59 PM O'Connor, Joseph
wrote:
> I reconfigured the httpd config and re-setup pgadmin but received the same
> result.
>
>
> 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
>
>
> WSGIProcessGroup pgadmin
> WSGIApplicationGroup %{GLOBAL}
>
> # Apache 2.4
> Require all granted
>
>
> # Apache 2.2
> Order Deny,Allow
> Allow from All
>
>
>
>
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:
https://redmine.postgresql.org/issues/6550#note-27
--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake
EDB: https://www.enterprisedb.com
RE: Cannot login to pgAdmin4 Web
I reconfigured the httpd config and re-setup pgadmin but received the same
result.
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
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
# Apache 2.4
Require all granted
# Apache 2.2
Order Deny,Allow
Allow from All
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
Re: Cannot login to pgAdmin4 Web
Hi On Fri, Jun 25, 2021 at 11:43 AM Jim Bacon 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 > *Sent:* 25 June 2021 11:17 > *To:* Jim Bacon > *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 > wrote: > > 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: pgad...@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. > > > 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. > > -- > Dave Page > Blog: https://pgsnake.blogspot.com > Twitter: @pgsnake > > EDB: https://www.enterprisedb.com > > -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com
Re: Cannot login to pgAdmin4 Web
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 Sent: 25 June 2021 11:17 To: Jim Bacon Cc: pgadmin-support@lists.postgresql.org Subject: Re: Cannot login to pgAdmin4 Web Hi On Fri, Jun 25, 2021 at 10:41 AM Jim Bacon mailto:jamesvincentba...@hotmail.com>> wrote: 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: pgad...@example.com<mailto:pgad...@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. 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. -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com
Re: Cannot login to pgAdmin4 Web
Hi On Fri, Jun 25, 2021 at 10:41 AM Jim Bacon wrote: > 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: pgad...@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. > 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. -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com
Re: Cannot login to pgAdmin4 Web
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: pgad...@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 Sent: 24 June 2021 10:11 To: O'Connor, Joseph Cc: 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 mailto:joseph.ocon...@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
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 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 >
