PGAdmin with Postgres backend and web auth

Поиск
Список
Период
Сортировка
От Scot Kreienkamp
Тема PGAdmin with Postgres backend and web auth
Дата
Msg-id DM6PR15MB3797A62DFCFF032C88FACA059AA32@DM6PR15MB3797.namprd15.prod.outlook.com
обсуждение исходный текст
Ответы Re: PGAdmin with Postgres backend and web auth
Список pgadmin-support

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.Kreienkamp@la-z-boy.com
www.la-z-boy.com  | facebook.com/lazboy  | twitter.com/lazboy | youtube.com/lazboy
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.

Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: Aditya Toshniwal
Дата:
Сообщение: Re: issues with cloned server, centos 9, pgadmin4 8.9
Следующее
От: Yogesh Mahajan
Дата:
Сообщение: Re: PGAdmin with Postgres backend and web auth