oVirt Engine Remote DB

This role create engine and DWH postgres database to be used in engine as remote connection.

• install and configure PostgreSQL server on machine (latest from repository)

• create necessary roles and databases for engine and DWH (based on variables)

• update firewalld and iptables (based on service present)

• if PostgreSQL server is already installed then create only roles and databases

Target systems

• database

Requirements

Preinstalled clean environment with configured repositories.

Role Variables

---
# vars for PostgreSQL
ovirt_engine_remote_db_port: PostgreSQL port for listening (default: 5432)
ovirt_engine_remote_db_listen_address: Listen address (default '*')

ovirt_engine_remote_db: [yes, no] Create engine database
ovirt_engine_dwh_remote_db: [yes, no] Create DWH database

# vars for databases and roles
ovirt_engine_db_name: DB name for ovirt-engine (default: 'engine')
ovirt_engine_db_user: DB user which can access ovirt-engine DB (default: 'engine')
ovirt_engine_db_password: password for user of ovirt-engine DB
ovirt_engine_dwh_db_name: DB name for ovirt-engine-dwh (default: 'ovirt_engine_history')
ovirt_engine_dwh_db_user: DB user which can access ovirt-engine-dwh DB (default: 'ovirt_engine_history')
ovirt_engine_dwh_db_password: password for user of ovirt-engine DB

ovirt_engine_remote_db_access:  # configure access to engine remote DBs
  -
    type: host / local
    address: 0.0.0.0/0   # mask for host, omitted for local
    method: md5 / trust / ident / peer

ovirt_engine_remote_db_vacuum: [True, False] True if set db configuration for
  vacuum feature (default: True)
ovirt_engine_remote_db_vacuum_config: Default postgresql cofiguration for
  vacuum feature. See default varibles in defaults/main.yml

ovirt_engine_remote_db_force: [True, False] If engine or DWH database already exists -
  True: drop them and create clean ones, False: playbook will fail with error. (default: False)

ovirt_engine_remote_db_dump: Path to .tar dump of engine database on local machine (generated with pg_dump -F t)
ovirt_engine_remote_db_dwh_dump: Path to .tar dump of DWH database on local machine (generated with pg_dump -F t)

Dependencies

• oVirt.repositories - this is only a must on ovirt > 4.1

Example Playbook

- hosts: database
  vars:
    ovirt_engine_version: '4.2'
  # vars for PostgreSQL
    ovirt_engine_remote_db_port: 5432
    ovirt_engine_remote_db_listen_address: '*'

    ovirt_engine_remote_db: yes
    ovirt_engine_dwh_remote_db: no

    # vars for databases and roles
    ovirt_engine_db_name: 'engine'
    ovirt_engine_db_user: 'engine'
    ovirt_engine_db_password: 'password'
    ovirt_engine_dwh_db_name: 'ovirt_engine_history'
    ovirt_engine_dwh_db_user: 'ovirt_engine_history'
    ovirt_engine_dwh_db_password: 'password'
    ovirt_engine_remote_db_access:
      -
        type: host
        address: XX.XX.XX.XX/32
        method: md5
    ovirt_engine_remote_db_force: True
    ovirt_engine_remote_db_dump: engine_dump/engine.tar
    ovirt_engine_remote_db_dwh_dump: engine_dump/dwh.tar
  roles:
    - ansible-role-ovirt-remote-db

Author Information

Petr Kubica pkubica@redhat.com

Lucie Leistnerova lucie.leistnerova@gmail.com