Re: Cannot login to pgAdmin4 Web

2021-06-28 Thread Dave Page
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

2021-06-28 Thread O'Connor, Joseph
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: ERD diagrams

2021-06-28 Thread Aditya Toshniwal
Hi James,

The feature request is already logged here -
https://redmine.postgresql.org/issues/6166 and will be considered in a
future release.

On Sat, Jun 26, 2021 at 1:55 AM James B. Byrne 
wrote:

> PGAdmin4-4.5.3
>
> I am experimenting with the beta ERD tool.
>
> Is it possible to move the connector points from the right-hand side of the
> table columns to the left-hand side.  Having connectors only on the right
> hand
> side makes for confusing diagram layouts.
>
> I am unable to find if the right-hand only connectors is a limitation or
> simply
> a lack of knowledge on my part.
>
> Thanks,
>
> --
> ***  e-Mail is NOT a SECURE channel  ***
> Do NOT transmit sensitive data via e-Mail
>Unencrypted messages have no legal claim to privacy
>  Do NOT open attachments nor follow links sent by e-Mail
>
> James B. Byrnemailto:byrn...@harte-lyne.ca
> Harte & Lyne Limited  http://www.harte-lyne.ca
> 9 Brockley Drive  vox: +1 905 561 1241
> Hamilton, Ontario fax: +1 905 561 0757
> Canada  L8E 3C3
>
>
>
>

-- 
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"


Re: Cannot login to pgAdmin4 Web

2021-06-28 Thread Dave Page
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