Project

Profile

Help

Story #5832

As a developer, ansible-pulp will provide me with the cool postgres WebGUI pgadmin4

Added by mdepaulo@redhat.com 5 days ago.

Status:
NEW
Priority:
Normal
Assignee:
-
Category:
-
Sprint/Milestone:
-
Start date:
Due date:
% Done:

0%

Platform Release:
Blocks Release:
Backwards Incompatible:
No
Groomed:
No
Sprint Candidate:
No
Tags:
Pulp 3 installer
QA Contact:
Complexity:
Smash Test:
Verified:
No
Verification Required:
No
Sprint:

Description

The following PoC was done. For implementation, it can be incorporated into the pulp-devel role, and pulplift.

On the host, reconnect to the pulplift VM pulp3-source-fedora31 with a new SSH tunnel (this will be added to pulplift config during implementation):

vagrant ssh pulp3-source-fedora31 -- -L 8443:127.0.0.1:8443

On the pulplift VM pulp3-source-fedora31:

Modified /var/lib/pgsql/data/pg_hba.conf to replace the 127.0.0.1 line with:

host all all 0.0.0.0/0  md5 

(Because the container has a NAT'd IP address.)

Modified /var/lib/pgsql/data/postgresql.conf to contain

listen_addresses = '*'

(Because otherwise it's localhost only; see above.)

sudo systemctl restart postgresql.service

sudo dnf install -y podman-docker

docker pull dpage/pgadmin4

# "--restart always" will be ignored for podman-docker. Only real docker/moby-engine will use it. podman will need a systemd unit to survive VM reboots.
docker run --restart always -p 8443:8443     -e 'PGADMIN_DEFAULT_EMAIL=user@domain.com'     -e 'PGADMIN_DEFAULT_PASSWORD=SuperSecret' -e 'PGADMIN_LISTEN_PORT=8443'     -d dpage/pgadmin4

Now back on your host:

Open your browser to:
http://127.0.0.1:8443/
And login with the username/email and password listed above.

Then create a new connection to:
The IP address of the pulplift VM
database: pulp
user: pulp
password: pulp
(These settings will later be set via PGADMIN_SERVER_JSON_FILE)

Rererence:
https://www.pgadmin.org/docs/pgadmin4/latest/container_deployment.html#examples

Please register to edit this issue

Also available in: Atom PDF