Re: PGAdmin with Postgres backend and web auth

Hi,

Have you tried using a private window? Also can you please share your HTTPD
conf?

Thanks,
Yogesh Mahajan
EnterpriseDB

On Thu, Jul 18, 2024 at 1:13 AM Scot Kreienkamp <
Scot(dot)Kreienkamp(at)la-z-boy(dot)com> wrote:

> Hi list, I’m trying to setup two versions of PGAdmin, 6.12 and latest,
> using dockerhub images running on RH9. I’m fronting this with HTTPD as a
> reverse proxy and authentication layer.
>
>
>
> Here’s the commandline I’m using to run both versions:
>
>
>
> /usr/bin/podman run \
>
> -e PGADMIN_DEFAULT_EMAIL=$MYEMAIL \
>
> -e "PGADMIN_DEFAULT_PASSWORD=$PASSWORD" \
>
> -e "PGADMIN_CONFIG_AUTHENTICATION_SOURCES=['webserver']" \
>
> -e PGADMIN_CONFIG_WEBSERVER_AUTO_CREATE_USER=True \
>
> -e PGADMIN_CONFIG_MASTER_PASSWORD_REQUIRED=False \
>
> -e
> "PGADMIN_CONFIG_CONFIG_DATABASE_URI='postgresql://$PGUSER:$PGPASS(at)$PGHOST:5432/$PGDB"
> \
>
> -e 'PGADMIN_CONFIG_CONSOLE_LOG_LEVEL=10' \
>
> --conmon-pidfile %t/%n-pid \
>
> --cidfile %t/%n-cid \
>
> --privileged \
>
> -p 127.0.0.1:8081:80 \
>
> -v /var/lib/pgadmin/%N:/var/lib/pgadmin \
>
> --name %N \
>
> docker.io/dpage/pgadmin4:$VERSION
>
>
>
>
>
> This works perfectly with 6.12. I can connect with the web browser and go
> to PGAdmin, and I’m logged in as I expected to be.
>
>
>
> With latest I keep getting the messages “webserver authenticate failed”
> from PGAdmin, and I keep landing at the PGAdmin login screen despite having
> internal authentication disabled.
>
>
>
> I’m seeing these syslog messages:
> Jul 17 15:06:11 pgadmin.na.lzb.hq pgadmin[452429]: 2024-07-17
> 19:06:11,292: DEBUG pgadmin: Authentication initiated via
> source: webserver
>
> Jul 17 15:06:11 pgadmin.na.lzb.hq pgadmin.service[452271]: 2024-07-17
> 19:06:11,292: DEBUG pgadmin: Authentication initiated via
> source: webserver
>
> Jul 17 15:06:11 pgadmin.na.lzb.hq pgadmin[452429]: 2024-07-17
> 19:06:11,293: DEBUG pgadmin: Authentication initiated via
> source: webserver is failed.
>
> Jul 17 15:06:11 pgadmin.na.lzb.hq pgadmin.service[452271]: 2024-07-17
> 19:06:11,293: DEBUG pgadmin: Authentication initiated via
> source: webserver is failed.
>
>
>
>
>
> I thought maybe it wasn’t picking up the default email and password so I
> tried every combination I could think of for quoting default email and
> password, with no improvement. The default email and password don’t work
> on the login screen and I never get into PGAdmin. I can’t figure out why
> it works on the old version but not the new version. I know I don’t need
> the mount on /var/lib/pgadmin with the database, that’s just there because
> I haven’t taken it out yet. With the database config that directory is
> empty anyway.
>
>
>
> Any ideas?
>
>
>
>
>
> *Scot Kreienkamp | Applications Infrastructure Architect | La-Z-Boy
> Corporate*
> One La-Z-Boy Drive | Monroe, Michigan 48162 | ( (734) 384-6403 | | )
> 1-734-915-1444 | * Scot(dot)Kreienkamp(at)la-z-boy(dot)com
> www.la-z-boy.com | facebook.com/lazboy | twitter.com/lazboy |
> youtube.com/lazboy
> [image: Smaller LZB Only Logo for Sign.png]
>
> This message is intended only for the individual or entity to which it is
> addressed. It may contain privileged, confidential information which is
> exempt from disclosure under applicable laws. If you are not the intended
> recipient, you are strictly prohibited from disseminating or distributing
> this information (other than to the intended recipient) or copying this
> information. If you have received this communication in error, please
> notify us immediately by e-mail or by telephone at the above number. Thank
> you.
>