adminer

Ansible role to install Adminer database management.

Sponsor

Building and improving this Ansible role have been sponsored by my current and previous employers like Cloudpunks GmbH and Proact Deutschland GmbH.

Table of contents

• Requirements
• Default Variables
  • adminer_base_plugins
  • adminer_destination
  • adminer_download
  • adminer_extra_packages
  • adminer_general_packages
  • adminer_general_plugins
  • adminer_group
  • adminer_language
  • adminer_max_upload_size
  • adminer_memory_limit
  • adminer_mysql
  • adminer_mysql_packages
  • adminer_owner
  • adminer_php_paths
  • adminer_php_versions
  • adminer_version
• Discovered Tags
• Dependencies
• License
• Author

---

Requirements

• Minimum Ansible version: 2.10

Default Variables

adminer_base_plugins

List of required base plugins

Default value

adminer_base_plugins:
  - name: plugin
    url: https://raw.githubusercontent.com/vrana/adminer/v{{ adminer_version 
      }}/plugins/plugin.php
    class: AdminerPlugin
    state: "{{ 'present' if adminer_version is version('5.1.1', '<=') else 'absent'
      }}"

Example usage

adminer_base_plugins:
  - name: login-servers
    url: https://raw.githubusercontent.com/pematon/adminer-plugins/master/AdminerLoginServers.php
    class: AdminerLoginServers
    config: |
      [
        'mysql://database-01:3306' => 'Database 01',
        'mysql://database-02:3306' => 'Database 02',
      ]

adminer_destination

Destination path where to install

Default value

adminer_destination: /var/www/html/index.php

adminer_download

URL to download the release from

Default value

adminer_download: https://github.com/vrana/adminer/releases/download/v{{ 
  adminer_version }}/adminer-{{ adminer_version }}{{ '-mysql' if adminer_mysql 
  else '' }}{{ '' if adminer_language is none else '-' + adminer_language }}.php

adminer_extra_packages

List of extra packages to install

Default value

adminer_extra_packages: []

adminer_general_packages

List of packages for general databases

Default value

adminer_general_packages:
  - php
  - php-mysql
  - php-sqlite3
  - php-pgsql
  - php-mongodb

adminer_general_plugins

List of plugins to install

Default value

adminer_general_plugins: []

Example usage

adminer_general_plugins:
  - name: login-servers
    url: https://raw.githubusercontent.com/pematon/adminer-plugins/master/AdminerLoginServers.php
    class: AdminerLoginServers
    config: |
      [
        'mysql://database-01:3306' => 'Database 01',
        'mysql://database-02:3306' => 'Database 02',
      ]

adminer_group

Group of the destination path

Default value

adminer_group: www-data

adminer_language

Install with single translation

Default value

adminer_language:

adminer_max_upload_size

Max allowed size for uploads/imports/dumps

Default value

adminer_max_upload_size: 256M

adminer_memory_limit

Max allowed memory to allocate by PHP

Default value

adminer_memory_limit: 256M

adminer_mysql

Install with mysql support only

Default value

adminer_mysql: false

adminer_mysql_packages

List of packages for mysql databases

Default value

adminer_mysql_packages:
  - php
  - php-mysql

adminer_owner

Owner of the destination path

Default value

adminer_owner: www-data

adminer_php_paths

Paths to write the custom PHP config to

Default value

adminer_php_paths:
  - /etc/php/{{ adminer_php_versions[ansible_distribution_version] 
    }}/apache2/conf.d/99-adminer.ini
  - /etc/php/{{ adminer_php_versions[ansible_distribution_version] 
    }}/cli/conf.d/99-adminer.ini
  - /etc/php/{{ adminer_php_versions[ansible_distribution_version] 
    }}/mods-available/adminer.ini

adminer_php_versions

Mapping of the available PHP versions on Ubuntu

Default value

adminer_php_versions:
  '18.04': 7.2
  '20.04': 7.4
  '22.04': 8.1
  '24.04': 8.3

adminer_version

Version of the release to install

Default value

adminer_version: 5.4.2

Discovered Tags

adminer

Dependencies

• community.general
• rolehippie.apache

License

Apache-2.0

Author

Thomas Boerger