Configuring a Database Instance for Ranger

A database instance must be running and available to be used by Ranger. You can configure MySQL, Oracle, PostgreSQL, or Amazon RDS for this purpose.

• A MySQL, Oracle, PostgreSQL, or Amazon RDS database instance must be running and available to be used by Ranger.

  The Ranger installation will create two new users (default names: rangeradmin and rangerlogger) and two new databases (default names: ranger and ranger_audit).

• Configuration of the database instance for Ranger is described in the following sections for some of the databases supported by Ranger.

  • MySQL

  • PostgreSQL

  • Oracle

  • AmazonRDS

• If you choose not to provide system Database Administrator (DBA) account details to the Ambari Ranger installer, you can use the dba_script.py Python script to create Ranger DB database users without exposing DBA account information to the Ambari Ranger installer. You can then run the normal Ambari Ranger installation without specifying a DBA user name and password. For more information see “Set up Database Users Without Sharing DBA Credentials”.