Adminer¶

Description / name	Input element
Your domain name

Overview¶

Adminer is a full-featured, web-based database management tool, originally developed as a lightweight alternative to phpMyAdmin.

Manual

Releases

Community

Deployment¶

sb install sandbox-adminer

Usage¶

Visit https://adminer.iYOUR_DOMAIN_NAMEi.

Basics¶

Default login for MariaDB

Adminer Mariadb Login

  System: Mysql
  Server: mariadb:3306
  Username: root
  Password: password321

Default login for Postgres

Adminer Postgres Login

  System: PostgreSQL
  Server: postgres:5432
  Username: your_saltbox_user
  Password: password4321

Adminer Plugins

Adminer has a number of plugins available to extend its functionality. You can find them here.

Role Defaults¶

Use the Inventory to customize variables. (1)

Example override
```
adminer_name: "custom_value"
```
Avoid overriding variables ending in _default

When overriding variables that end in _default (like adminer_docker_envs_default), you replace the entire default configuration. Future updates that add new default values will not be applied to your setup, potentially breaking functionality.

Instead, use the corresponding _custom variable (like adminer_docker_envs_custom) to add your changes. Custom values are merged with defaults, ensuring you receive updates.

BasicsWebDNSTraefikDockerDocker+Global Override Options

adminer_name

# Type: string
adminer_name: adminer

adminer_role_web_subdomain

# Type: string
adminer_role_web_subdomain: "{{ adminer_name }}"

adminer_role_web_domain

# Type: string
adminer_role_web_domain: "{{ user.domain }}"

adminer_role_web_port

# Type: string
adminer_role_web_port: "8080"

adminer_role_web_url

# Type: string
adminer_role_web_url: "{{ 'https://' + (lookup('role_var', '_web_subdomain', role='adminer') + '.' + lookup('role_var', '_web_domain', role='adminer')
                       if (lookup('role_var', '_web_subdomain', role='adminer') | length > 0)
                       else lookup('role_var', '_web_domain', role='adminer')) }}"

adminer_role_dns_record

# Type: string
adminer_role_dns_record: "{{ lookup('role_var', '_web_subdomain', role='adminer') }}"

adminer_role_dns_zone

# Type: string
adminer_role_dns_zone: "{{ lookup('role_var', '_web_domain', role='adminer') }}"

adminer_role_dns_proxy

# Type: bool (true/false)
adminer_role_dns_proxy: "{{ dns_proxied }}"

adminer_role_traefik_sso_middleware

# Type: string
adminer_role_traefik_sso_middleware: "{{ traefik_default_sso_middleware }}"

adminer_role_traefik_middleware_default

# Type: string
adminer_role_traefik_middleware_default: "{{ traefik_default_middleware }}"

adminer_role_traefik_middleware_custom

# Type: string
adminer_role_traefik_middleware_custom: ""

adminer_role_traefik_certresolver

# Type: string
adminer_role_traefik_certresolver: "{{ traefik_default_certresolver }}"

adminer_role_traefik_enabled

# Type: bool (true/false)
adminer_role_traefik_enabled: true

Container

adminer_role_docker_container

# Type: string
adminer_role_docker_container: "{{ adminer_name }}"

Image

adminer_role_docker_image_pull

# Type: bool (true/false)
adminer_role_docker_image_pull: true

adminer_role_docker_image_repo

# Type: string
adminer_role_docker_image_repo: "adminer"

adminer_role_docker_image_tag

# Type: string
adminer_role_docker_image_tag: "latest"

adminer_role_docker_image

# Type: string
adminer_role_docker_image: "{{ lookup('role_var', '_docker_image_repo', role='adminer') }}:{{ lookup('role_var', '_docker_image_tag', role='adminer') }}"

Envs

adminer_role_docker_envs_default

# Type: dict
adminer_role_docker_envs_default:
  ADMINER_DEFAULT_SERVER: "mysql"

adminer_role_docker_envs_custom

# Type: dict
adminer_role_docker_envs_custom: {}

Hostname

adminer_role_docker_hostname

# Type: string
adminer_role_docker_hostname: "{{ adminer_name }}"

Networks

adminer_role_docker_networks_alias

# Type: string
adminer_role_docker_networks_alias: "{{ adminer_name }}"

adminer_role_docker_networks_default

# Type: list
adminer_role_docker_networks_default: []

adminer_role_docker_networks_custom

# Type: list
adminer_role_docker_networks_custom: []

Restart Policy

adminer_role_docker_restart_policy

# Type: string
adminer_role_docker_restart_policy: unless-stopped

State

adminer_role_docker_state

# Type: string
adminer_role_docker_state: started

The following advanced options are available via create_docker_container but are not defined in the role. See: docker_container module

Resource Limits

adminer_role_docker_blkio_weight

# Type: int
adminer_role_docker_blkio_weight:

adminer_role_docker_cpu_period

# Type: int
adminer_role_docker_cpu_period:

adminer_role_docker_cpu_quota

# Type: int
adminer_role_docker_cpu_quota:

adminer_role_docker_cpu_shares

# Type: int
adminer_role_docker_cpu_shares:

adminer_role_docker_cpus

# Type: string
adminer_role_docker_cpus:

adminer_role_docker_cpuset_cpus

# Type: string
adminer_role_docker_cpuset_cpus:

adminer_role_docker_cpuset_mems

# Type: string
adminer_role_docker_cpuset_mems:

adminer_role_docker_kernel_memory

# Type: string
adminer_role_docker_kernel_memory:

adminer_role_docker_memory

# Type: string
adminer_role_docker_memory:

adminer_role_docker_memory_reservation

# Type: string
adminer_role_docker_memory_reservation:

adminer_role_docker_memory_swap

# Type: string
adminer_role_docker_memory_swap:

adminer_role_docker_memory_swappiness

# Type: int
adminer_role_docker_memory_swappiness:

adminer_role_docker_shm_size

# Type: string
adminer_role_docker_shm_size:

Security & Devices

adminer_role_docker_cap_drop

# Type: list
adminer_role_docker_cap_drop:

adminer_role_docker_cgroupns_mode

# Type: string
adminer_role_docker_cgroupns_mode:

adminer_role_docker_device_cgroup_rules

# Type: list
adminer_role_docker_device_cgroup_rules:

adminer_role_docker_device_read_bps

# Type: list
adminer_role_docker_device_read_bps:

adminer_role_docker_device_read_iops

# Type: list
adminer_role_docker_device_read_iops:

adminer_role_docker_device_requests

# Type: list
adminer_role_docker_device_requests:

adminer_role_docker_device_write_bps

# Type: list
adminer_role_docker_device_write_bps:

adminer_role_docker_device_write_iops

# Type: list
adminer_role_docker_device_write_iops:

adminer_role_docker_devices

# Type: list
adminer_role_docker_devices:

adminer_role_docker_devices_default

# Type: string
adminer_role_docker_devices_default:

adminer_role_docker_groups

# Type: list
adminer_role_docker_groups:

adminer_role_docker_privileged

# Type: bool (true/false)
adminer_role_docker_privileged:

adminer_role_docker_security_opts

# Type: list
adminer_role_docker_security_opts:

adminer_role_docker_user

# Type: string
adminer_role_docker_user:

adminer_role_docker_userns_mode

# Type: string
adminer_role_docker_userns_mode:

Networking

adminer_role_docker_dns_opts

# Type: list
adminer_role_docker_dns_opts:

adminer_role_docker_dns_search_domains

# Type: list
adminer_role_docker_dns_search_domains:

adminer_role_docker_dns_servers

# Type: list
adminer_role_docker_dns_servers:

adminer_role_docker_domainname

# Type: string
adminer_role_docker_domainname:

adminer_role_docker_exposed_ports

# Type: list
adminer_role_docker_exposed_ports:

adminer_role_docker_hosts

# Type: dict
adminer_role_docker_hosts:

adminer_role_docker_hosts_use_common

# Type: bool (true/false)
adminer_role_docker_hosts_use_common:

adminer_role_docker_ipc_mode

# Type: string
adminer_role_docker_ipc_mode:

adminer_role_docker_links

# Type: list
adminer_role_docker_links:

adminer_role_docker_network_mode

# Type: string
adminer_role_docker_network_mode:

adminer_role_docker_pid_mode

# Type: string
adminer_role_docker_pid_mode:

adminer_role_docker_ports

# Type: list
adminer_role_docker_ports:

adminer_role_docker_uts

# Type: string
adminer_role_docker_uts:

Storage

adminer_role_docker_keep_volumes

# Type: bool (true/false)
adminer_role_docker_keep_volumes:

adminer_role_docker_mounts

# Type: list
adminer_role_docker_mounts:

adminer_role_docker_storage_opts

# Type: dict
adminer_role_docker_storage_opts:

adminer_role_docker_tmpfs

# Type: list
adminer_role_docker_tmpfs:

adminer_role_docker_volume_driver

# Type: string
adminer_role_docker_volume_driver:

adminer_role_docker_volumes

# Type: list
adminer_role_docker_volumes:

adminer_role_docker_volumes_from

# Type: list
adminer_role_docker_volumes_from:

adminer_role_docker_volumes_global

# Type: bool (true/false)
adminer_role_docker_volumes_global:

adminer_role_docker_working_dir

# Type: string
adminer_role_docker_working_dir:

Monitoring & Lifecycle

adminer_role_docker_auto_remove

# Type: bool (true/false)
adminer_role_docker_auto_remove:

adminer_role_docker_cleanup

# Type: bool (true/false)
adminer_role_docker_cleanup:

adminer_role_docker_force_kill

# Type: string
adminer_role_docker_force_kill:

adminer_role_docker_healthcheck

# Type: dict
adminer_role_docker_healthcheck:

adminer_role_docker_healthy_wait_timeout

# Type: int
adminer_role_docker_healthy_wait_timeout:

adminer_role_docker_init

# Type: bool (true/false)
adminer_role_docker_init:

adminer_role_docker_kill_signal

# Type: string
adminer_role_docker_kill_signal:

adminer_role_docker_log_driver

# Type: string
adminer_role_docker_log_driver:

adminer_role_docker_log_options

# Type: dict
adminer_role_docker_log_options:

adminer_role_docker_oom_killer

# Type: bool (true/false)
adminer_role_docker_oom_killer:

adminer_role_docker_oom_score_adj

# Type: int
adminer_role_docker_oom_score_adj:

adminer_role_docker_output_logs

# Type: bool (true/false)
adminer_role_docker_output_logs:

adminer_role_docker_paused

# Type: bool (true/false)
adminer_role_docker_paused:

adminer_role_docker_recreate

# Type: bool (true/false)
adminer_role_docker_recreate:

adminer_role_docker_restart_retries

# Type: int
adminer_role_docker_restart_retries:

adminer_role_docker_stop_timeout

# Type: int
adminer_role_docker_stop_timeout:

Other Options

adminer_role_docker_capabilities

# Type: list
adminer_role_docker_capabilities:

adminer_role_docker_cgroup_parent

# Type: string
adminer_role_docker_cgroup_parent:

adminer_role_docker_commands

# Type: list
adminer_role_docker_commands:

adminer_role_docker_create_timeout

# Type: int
adminer_role_docker_create_timeout:

adminer_role_docker_entrypoint

# Type: string
adminer_role_docker_entrypoint:

adminer_role_docker_env_file

# Type: string
adminer_role_docker_env_file:

adminer_role_docker_labels

# Type: dict
adminer_role_docker_labels:

adminer_role_docker_labels_use_common

# Type: bool (true/false)
adminer_role_docker_labels_use_common:

adminer_role_docker_read_only

# Type: bool (true/false)
adminer_role_docker_read_only:

adminer_role_docker_runtime

# Type: string
adminer_role_docker_runtime:

adminer_role_docker_sysctls

# Type: list
adminer_role_docker_sysctls:

adminer_role_docker_ulimits

# Type: list
adminer_role_docker_ulimits:

adminer_role_autoheal_enabled

# Enable or disable Autoheal monitoring for the container created when deploying
# Type: bool (true/false)
adminer_role_autoheal_enabled: true

adminer_role_depends_on

# List of container dependencies that must be running before the container start
# Type: string
adminer_role_depends_on: ""

adminer_role_depends_on_delay

# Delay in seconds before starting the container after dependencies are ready
# Type: string (quoted number)
adminer_role_depends_on_delay: "0"

adminer_role_depends_on_healthchecks

# Enable healthcheck waiting for container dependencies
# Type: string ("true"/"false")
adminer_role_depends_on_healthchecks:

adminer_role_diun_enabled

# Enable or disable Diun update notifications for the container created when deploying
# Type: bool (true/false)
adminer_role_diun_enabled: true

adminer_role_dns_enabled

# Enable or disable automatic DNS record creation for the container
# Type: bool (true/false)
adminer_role_dns_enabled: true

adminer_role_docker_controller

# Enable or disable Saltbox Docker Controller management for the container
# Type: bool (true/false)
adminer_role_docker_controller: true

adminer_role_docker_image_repo

# Type: string
adminer_role_docker_image_repo:

adminer_role_docker_image_tag

# Type: string
adminer_role_docker_image_tag:

adminer_role_docker_volumes_download

# Type: bool (true/false)
adminer_role_docker_volumes_download:

adminer_role_themepark_addons

# Type: string
adminer_role_themepark_addons:

adminer_role_themepark_app

# Type: string
adminer_role_themepark_app:

adminer_role_themepark_theme

# Type: string
adminer_role_themepark_theme:

adminer_role_traefik_api_endpoint

# Type: dict/omit
adminer_role_traefik_api_endpoint:

adminer_role_traefik_api_middleware

# Type: string
adminer_role_traefik_api_middleware:

adminer_role_traefik_api_middleware_http

# Type: string
adminer_role_traefik_api_middleware_http:

adminer_role_traefik_autodetect_enabled

# Enable Traefik autodetect middleware for the container
# Type: bool (true/false)
adminer_role_traefik_autodetect_enabled: false

adminer_role_traefik_certresolver

# Type: string
adminer_role_traefik_certresolver:

adminer_role_traefik_crowdsec_enabled

# Enable CrowdSec middleware for the container
# Type: bool (true/false)
adminer_role_traefik_crowdsec_enabled: false

adminer_role_traefik_error_pages_enabled

# Enable custom error pages middleware for the container
# Type: bool (true/false)
adminer_role_traefik_error_pages_enabled: false

adminer_role_traefik_gzip_enabled

# Enable gzip compression middleware for the container
# Type: bool (true/false)
adminer_role_traefik_gzip_enabled: false

adminer_role_traefik_middleware_http

# Type: string
adminer_role_traefik_middleware_http:

adminer_role_traefik_middleware_http_api_insecure

# Type: bool (true/false)
adminer_role_traefik_middleware_http_api_insecure:

adminer_role_traefik_middleware_http_insecure

# Type: bool (true/false)
adminer_role_traefik_middleware_http_insecure:

adminer_role_traefik_priority

# Type: string
adminer_role_traefik_priority:

adminer_role_traefik_robot_enabled

# Enable robots.txt middleware for the container
# Type: bool (true/false)
adminer_role_traefik_robot_enabled: true

adminer_role_traefik_tailscale_enabled

# Enable Tailscale-specific Traefik configuration for the container
# Type: bool (true/false)
adminer_role_traefik_tailscale_enabled: false

adminer_role_traefik_wildcard_enabled

# Enable wildcard certificate for the container
# Type: bool (true/false)
adminer_role_traefik_wildcard_enabled: true

adminer_role_web_domain

# Type: string
adminer_role_web_domain:

adminer_role_web_fqdn_override

# Override the Traefik fully qualified domain name (FQDN) for the container
# Type: list
adminer_role_web_fqdn_override:

Example Override

adminer_role_web_fqdn_override:
  - "{{ traefik_host }}"
  - "adminer2.{{ user.domain }}"
  - "adminer.otherdomain.tld"

Note: Include {{ traefik_host }} to preserve the default FQDN alongside your custom entries

adminer_role_web_host_override

# Override the Traefik web host configuration for the container
# Type: string
adminer_role_web_host_override:

Example Override

adminer_role_web_host_override: "Host(`{{ traefik_host }}`) || Host(`{{ 'adminer2.' + user.domain }}`)"

Note: Use {{ traefik_host }} to include the default host configuration in your custom rule

adminer_role_web_http_port

# Type: string (quoted number)
adminer_role_web_http_port:

adminer_role_web_http_scheme

# Type: string ("http"/"https")
adminer_role_web_http_scheme:

adminer_role_web_http_serverstransport

# Type: dict/omit
adminer_role_web_http_serverstransport:

adminer_role_web_scheme

# URL scheme to use for web access to the container
# Type: string ("http"/"https")
adminer_role_web_scheme:

adminer_role_web_serverstransport

# Type: dict/omit
adminer_role_web_serverstransport:

adminer_role_web_subdomain

# Type: string
adminer_role_web_subdomain: