cloudera.exe.prereq_query_processor_database role – Set up database and user accounts for Query Processor

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_query_processor_database.

Entry point `main` – Set up database and user accounts for Query Processor 

New in cloudera.exe 3.0.0

Set up the Hue Query Processor database and its associated user accounts, ensuring proper configuration for Query Processor operations.
Default values are used for the username, password, and database name, but these can be overwritten by setting the query_processor_username, query_processor_password, and query_processor_database variables.

Parameter	Comments
database_admin_password string / required	The password for the database administrative user.
database_admin_user string / required	The username with administrative privileges to manage the database.
database_host string / required	The hostname or IP address of the database server to establish the connection.
database_type string / required	Specifies the type of database to connect to (e.g., PostgreSQL, MySQL, Oracle). Choices: `"postgresql"` `"mysql"` `"oracle"`
query_processor_database string	The name of the database to be created for Query Processor. Default: `"queryprocessor"`
query_processor_password string	The password for the Query Processor database user. Default: `"queryprocessor"`
query_processor_username string	The username for the Query Processor database user and owner of the database. Default: `"queryprocessor"`