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.kreienk...@la-z-boy.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@$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.kreienk...@la-z-boy.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.
>

Reply via email to