cloudera.exe.prereq_database role – Create and manage databases and users

Note

This role is part of the cloudera.exe collection (version 3.0.0).

It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it use: ansible-galaxy collection install cloudera.exe..

To use it in a playbook, specify: cloudera.exe.prereq_database.

Entry point main – Create and manage databases and users

New in cloudera.exe 3.0.0

Synopsis

  • Configure databases and their associated users in the specified database system.

Parameters

Parameter

Comments

database_accounts

list / elements=dictionary / required

A list of database accounts to create and manage.

db

string / required

The name of the database to create.

owner

string

The name of the database user owning the database. Defaults to database_accounts[].user.

password

string / required

The password for the database user.

user

string / required

The name of the database user.

database_admin_password

string / required

The password for the database admin login.

database_admin_user

string / required

The username for the database admin login.

database_host

string / required

The hostname or IP address of the database server.

database_port

integer

The port for connecting to the database server.

database_type

string / required

Specifies the type of database to connect to (e.g., PostgreSQL, MySQL, Oracle).

Choices:

  • "postgresql"

  • "mysql"

  • "oracle"

Authors

  • Cloudera Labs