Adminer
Overview
| Field | Value |
|---|---|
| Purpose | Web-based database administration |
| Business function | Support controlled database inspection and maintenance |
| Owner | IT Operations |
| Criticality | Medium |
| Image | adminer:4.8.1 |
| Route | dbgui.kh3group.com |
Architecture
Adminer is exposed through Traefik on aproxy and reaches PostgreSQL and MariaDB on backend.
Installation
Docker Compose at /root/adminer/docker-compose.yml.
Configuration
- Networks:
aproxy,backend - Container port:
8080 - Restart policy:
always - Persistent mounts: none
Operational Procedures
cd /root/adminer
docker compose logs --tail=100 adminer
docker compose restart adminer
docker compose pull
docker compose up -d
Use named database accounts with least privilege. Do not save credentials in the browser.
Troubleshooting
- Login failure: test the same credentials from a database-native client.
- Timeout: confirm database health and
backendmembership. - Public exposure concern: verify Traefik authentication and pfSense policy.