phpMyAdmin

Description / name	Input element
Your domain name

Overview

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

Manual

Releases

Community

---

Deployment

sb install sandbox-phpmyadmin

Usage

Visit https://phpmyadmin.iYOUR_DOMAIN_NAMEi.

Role Defaults

Use the Inventory to customize variables. (1)

1. Example override

   phpmyadmin_name: "custom_value"
   

   Avoid overriding variables ending in _default

   When overriding variables that end in _default (like phpmyadmin_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 phpmyadmin_docker_envs_custom) to add your changes. Custom values are merged with defaults, ensuring you receive updates.

BasicsWebDNSTraefikDockerDocker+Global Override Options

phpmyadmin_name

# Type: string
phpmyadmin_name: phpmyadmin

phpmyadmin_role_web_subdomain

# Type: string
phpmyadmin_role_web_subdomain: "{{ phpmyadmin_name }}"

phpmyadmin_role_web_domain

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

phpmyadmin_role_web_port

# Type: string
phpmyadmin_role_web_port: "80"

phpmyadmin_role_web_url

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

phpmyadmin_role_dns_record

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

phpmyadmin_role_dns_zone

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

phpmyadmin_role_dns_proxy

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

phpmyadmin_role_traefik_sso_middleware

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

phpmyadmin_role_traefik_middleware_default

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

phpmyadmin_role_traefik_middleware_custom

# Type: string
phpmyadmin_role_traefik_middleware_custom: ""

phpmyadmin_role_traefik_certresolver

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

phpmyadmin_role_traefik_enabled

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

phpmyadmin_role_traefik_api_enabled

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

phpmyadmin_role_traefik_api_endpoint

# Type: string
phpmyadmin_role_traefik_api_endpoint: ""

Container

phpmyadmin_role_docker_container

# Type: string
phpmyadmin_role_docker_container: "{{ phpmyadmin_name }}"

Image

phpmyadmin_role_docker_image_pull

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

phpmyadmin_role_docker_image_tag

# Type: string
phpmyadmin_role_docker_image_tag: "latest"

phpmyadmin_role_docker_image_repo

# Type: string
phpmyadmin_role_docker_image_repo: "phpmyadmin"

phpmyadmin_role_docker_image

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

Envs

phpmyadmin_role_docker_envs_default

# Type: dict
phpmyadmin_role_docker_envs_default:
  TZ: "{{ tz }}"
  PMA_ARBITRARY: "1"
  PMA_ABSOLUTE_URI: "{{ lookup('role_var', '_web_url', role='phpmyadmin') }}"
  PMA_VERBOSE: "Saltbox"
  PMA_PORT: "3306"
  HIDE_PHP_VERSION: "true"

phpmyadmin_role_docker_envs_custom

# Type: dict
phpmyadmin_role_docker_envs_custom: {}

Hostname

phpmyadmin_role_docker_hostname

# Type: string
phpmyadmin_role_docker_hostname: "{{ phpmyadmin_name }}"

Networks

phpmyadmin_role_docker_networks_alias

# Type: string
phpmyadmin_role_docker_networks_alias: "{{ phpmyadmin_name }}"

phpmyadmin_role_docker_networks_default

# Type: list
phpmyadmin_role_docker_networks_default: []

phpmyadmin_role_docker_networks_custom

# Type: list
phpmyadmin_role_docker_networks_custom: []

Restart Policy

phpmyadmin_role_docker_restart_policy

# Type: string
phpmyadmin_role_docker_restart_policy: unless-stopped

State

phpmyadmin_role_docker_state

# Type: string
phpmyadmin_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

phpmyadmin_role_docker_blkio_weight

# Type: int
phpmyadmin_role_docker_blkio_weight:

phpmyadmin_role_docker_cpu_period

# Type: int
phpmyadmin_role_docker_cpu_period:

phpmyadmin_role_docker_cpu_quota

# Type: int
phpmyadmin_role_docker_cpu_quota:

phpmyadmin_role_docker_cpu_shares

# Type: int
phpmyadmin_role_docker_cpu_shares:

phpmyadmin_role_docker_cpus

# Type: string
phpmyadmin_role_docker_cpus:

phpmyadmin_role_docker_cpuset_cpus

# Type: string
phpmyadmin_role_docker_cpuset_cpus:

phpmyadmin_role_docker_cpuset_mems

# Type: string
phpmyadmin_role_docker_cpuset_mems:

phpmyadmin_role_docker_kernel_memory

# Type: string
phpmyadmin_role_docker_kernel_memory:

phpmyadmin_role_docker_memory

# Type: string
phpmyadmin_role_docker_memory:

phpmyadmin_role_docker_memory_reservation

# Type: string
phpmyadmin_role_docker_memory_reservation:

phpmyadmin_role_docker_memory_swap

# Type: string
phpmyadmin_role_docker_memory_swap:

phpmyadmin_role_docker_memory_swappiness

# Type: int
phpmyadmin_role_docker_memory_swappiness:

phpmyadmin_role_docker_shm_size

# Type: string
phpmyadmin_role_docker_shm_size:

Security & Devices

phpmyadmin_role_docker_cap_drop

# Type: list
phpmyadmin_role_docker_cap_drop:

phpmyadmin_role_docker_cgroupns_mode

# Type: string
phpmyadmin_role_docker_cgroupns_mode:

phpmyadmin_role_docker_device_cgroup_rules

# Type: list
phpmyadmin_role_docker_device_cgroup_rules:

phpmyadmin_role_docker_device_read_bps

# Type: list
phpmyadmin_role_docker_device_read_bps:

phpmyadmin_role_docker_device_read_iops

# Type: list
phpmyadmin_role_docker_device_read_iops:

phpmyadmin_role_docker_device_requests

# Type: list
phpmyadmin_role_docker_device_requests:

phpmyadmin_role_docker_device_write_bps

# Type: list
phpmyadmin_role_docker_device_write_bps:

phpmyadmin_role_docker_device_write_iops

# Type: list
phpmyadmin_role_docker_device_write_iops:

phpmyadmin_role_docker_devices

# Type: list
phpmyadmin_role_docker_devices:

phpmyadmin_role_docker_devices_default

# Type: string
phpmyadmin_role_docker_devices_default:

phpmyadmin_role_docker_groups

# Type: list
phpmyadmin_role_docker_groups:

phpmyadmin_role_docker_privileged

# Type: bool (true/false)
phpmyadmin_role_docker_privileged:

phpmyadmin_role_docker_security_opts

# Type: list
phpmyadmin_role_docker_security_opts:

phpmyadmin_role_docker_user

# Type: string
phpmyadmin_role_docker_user:

phpmyadmin_role_docker_userns_mode

# Type: string
phpmyadmin_role_docker_userns_mode:

Networking

phpmyadmin_role_docker_dns_opts

# Type: list
phpmyadmin_role_docker_dns_opts:

phpmyadmin_role_docker_dns_search_domains

# Type: list
phpmyadmin_role_docker_dns_search_domains:

phpmyadmin_role_docker_dns_servers

# Type: list
phpmyadmin_role_docker_dns_servers:

phpmyadmin_role_docker_domainname

# Type: string
phpmyadmin_role_docker_domainname:

phpmyadmin_role_docker_exposed_ports

# Type: list
phpmyadmin_role_docker_exposed_ports:

phpmyadmin_role_docker_hosts

# Type: dict
phpmyadmin_role_docker_hosts:

phpmyadmin_role_docker_hosts_use_common

# Type: bool (true/false)
phpmyadmin_role_docker_hosts_use_common:

phpmyadmin_role_docker_ipc_mode

# Type: string
phpmyadmin_role_docker_ipc_mode:

phpmyadmin_role_docker_links

# Type: list
phpmyadmin_role_docker_links:

phpmyadmin_role_docker_network_mode

# Type: string
phpmyadmin_role_docker_network_mode:

phpmyadmin_role_docker_pid_mode

# Type: string
phpmyadmin_role_docker_pid_mode:

phpmyadmin_role_docker_ports

# Type: list
phpmyadmin_role_docker_ports:

phpmyadmin_role_docker_uts

# Type: string
phpmyadmin_role_docker_uts:

Storage

phpmyadmin_role_docker_keep_volumes

# Type: bool (true/false)
phpmyadmin_role_docker_keep_volumes:

phpmyadmin_role_docker_mounts

# Type: list
phpmyadmin_role_docker_mounts:

phpmyadmin_role_docker_storage_opts

# Type: dict
phpmyadmin_role_docker_storage_opts:

phpmyadmin_role_docker_tmpfs

# Type: list
phpmyadmin_role_docker_tmpfs:

phpmyadmin_role_docker_volume_driver

# Type: string
phpmyadmin_role_docker_volume_driver:

phpmyadmin_role_docker_volumes

# Type: list
phpmyadmin_role_docker_volumes:

phpmyadmin_role_docker_volumes_from

# Type: list
phpmyadmin_role_docker_volumes_from:

phpmyadmin_role_docker_volumes_global

# Type: bool (true/false)
phpmyadmin_role_docker_volumes_global:

phpmyadmin_role_docker_working_dir

# Type: string
phpmyadmin_role_docker_working_dir:

Monitoring & Lifecycle

phpmyadmin_role_docker_auto_remove

# Type: bool (true/false)
phpmyadmin_role_docker_auto_remove:

phpmyadmin_role_docker_cleanup

# Type: bool (true/false)
phpmyadmin_role_docker_cleanup:

phpmyadmin_role_docker_force_kill

# Type: string
phpmyadmin_role_docker_force_kill:

phpmyadmin_role_docker_healthcheck

# Type: dict
phpmyadmin_role_docker_healthcheck:

phpmyadmin_role_docker_healthy_wait_timeout

# Type: int
phpmyadmin_role_docker_healthy_wait_timeout:

phpmyadmin_role_docker_init

# Type: bool (true/false)
phpmyadmin_role_docker_init:

phpmyadmin_role_docker_kill_signal

# Type: string
phpmyadmin_role_docker_kill_signal:

phpmyadmin_role_docker_log_driver

# Type: string
phpmyadmin_role_docker_log_driver:

phpmyadmin_role_docker_log_options

# Type: dict
phpmyadmin_role_docker_log_options:

phpmyadmin_role_docker_oom_killer

# Type: bool (true/false)
phpmyadmin_role_docker_oom_killer:

phpmyadmin_role_docker_oom_score_adj

# Type: int
phpmyadmin_role_docker_oom_score_adj:

phpmyadmin_role_docker_output_logs

# Type: bool (true/false)
phpmyadmin_role_docker_output_logs:

phpmyadmin_role_docker_paused

# Type: bool (true/false)
phpmyadmin_role_docker_paused:

phpmyadmin_role_docker_recreate

# Type: bool (true/false)
phpmyadmin_role_docker_recreate:

phpmyadmin_role_docker_restart_retries

# Type: int
phpmyadmin_role_docker_restart_retries:

phpmyadmin_role_docker_stop_timeout

# Type: int
phpmyadmin_role_docker_stop_timeout:

Other Options

phpmyadmin_role_docker_capabilities

# Type: list
phpmyadmin_role_docker_capabilities:

phpmyadmin_role_docker_cgroup_parent

# Type: string
phpmyadmin_role_docker_cgroup_parent:

phpmyadmin_role_docker_commands

# Type: list
phpmyadmin_role_docker_commands:

phpmyadmin_role_docker_create_timeout

# Type: int
phpmyadmin_role_docker_create_timeout:

phpmyadmin_role_docker_entrypoint

# Type: string
phpmyadmin_role_docker_entrypoint:

phpmyadmin_role_docker_env_file

# Type: string
phpmyadmin_role_docker_env_file:

phpmyadmin_role_docker_labels

# Type: dict
phpmyadmin_role_docker_labels:

phpmyadmin_role_docker_labels_use_common

# Type: bool (true/false)
phpmyadmin_role_docker_labels_use_common:

phpmyadmin_role_docker_read_only

# Type: bool (true/false)
phpmyadmin_role_docker_read_only:

phpmyadmin_role_docker_runtime

# Type: string
phpmyadmin_role_docker_runtime:

phpmyadmin_role_docker_sysctls

# Type: list
phpmyadmin_role_docker_sysctls:

phpmyadmin_role_docker_ulimits

# Type: list
phpmyadmin_role_docker_ulimits:

phpmyadmin_role_autoheal_enabled

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

phpmyadmin_role_depends_on

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

phpmyadmin_role_depends_on_delay

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

phpmyadmin_role_depends_on_healthchecks

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

phpmyadmin_role_diun_enabled

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

phpmyadmin_role_dns_enabled

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

phpmyadmin_role_docker_controller

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

phpmyadmin_role_docker_image_repo

# Type: string
phpmyadmin_role_docker_image_repo:

phpmyadmin_role_docker_image_tag

# Type: string
phpmyadmin_role_docker_image_tag:

phpmyadmin_role_docker_volumes_download

# Type: bool (true/false)
phpmyadmin_role_docker_volumes_download:

phpmyadmin_role_themepark_addons

# Type: string
phpmyadmin_role_themepark_addons:

phpmyadmin_role_themepark_app

# Type: string
phpmyadmin_role_themepark_app:

phpmyadmin_role_themepark_theme

# Type: string
phpmyadmin_role_themepark_theme:

phpmyadmin_role_traefik_api_endpoint

# Type: dict/omit
phpmyadmin_role_traefik_api_endpoint:

phpmyadmin_role_traefik_api_middleware

# Type: string
phpmyadmin_role_traefik_api_middleware:

phpmyadmin_role_traefik_api_middleware_http

# Type: string
phpmyadmin_role_traefik_api_middleware_http:

phpmyadmin_role_traefik_autodetect_enabled

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

phpmyadmin_role_traefik_certresolver

# Type: string
phpmyadmin_role_traefik_certresolver:

phpmyadmin_role_traefik_crowdsec_enabled

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

phpmyadmin_role_traefik_error_pages_enabled

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

phpmyadmin_role_traefik_gzip_enabled

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

phpmyadmin_role_traefik_middleware_http

# Type: string
phpmyadmin_role_traefik_middleware_http:

phpmyadmin_role_traefik_middleware_http_api_insecure

# Type: bool (true/false)
phpmyadmin_role_traefik_middleware_http_api_insecure:

phpmyadmin_role_traefik_middleware_http_insecure

# Type: bool (true/false)
phpmyadmin_role_traefik_middleware_http_insecure:

phpmyadmin_role_traefik_priority

# Type: string
phpmyadmin_role_traefik_priority:

phpmyadmin_role_traefik_robot_enabled

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

phpmyadmin_role_traefik_tailscale_enabled

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

phpmyadmin_role_traefik_wildcard_enabled

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

phpmyadmin_role_web_domain

# Type: string
phpmyadmin_role_web_domain:

phpmyadmin_role_web_fqdn_override

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

Example Override

phpmyadmin_role_web_fqdn_override:
  - "{{ traefik_host }}"
  - "phpmyadmin2.{{ user.domain }}"
  - "phpmyadmin.otherdomain.tld"

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

phpmyadmin_role_web_host_override

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

Example Override

phpmyadmin_role_web_host_override: "Host(`{{ traefik_host }}`) || Host(`{{ 'phpmyadmin2.' + user.domain }}`)"

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

phpmyadmin_role_web_http_port

# Type: string (quoted number)
phpmyadmin_role_web_http_port:

phpmyadmin_role_web_http_scheme

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

phpmyadmin_role_web_http_serverstransport

# Type: dict/omit
phpmyadmin_role_web_http_serverstransport:

phpmyadmin_role_web_scheme

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

phpmyadmin_role_web_serverstransport

# Type: dict/omit
phpmyadmin_role_web_serverstransport:

phpmyadmin_role_web_subdomain

# Type: string
phpmyadmin_role_web_subdomain:

phpmyadmin_role_web_url

# Type: string
phpmyadmin_role_web_url: