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. >