Ranger Ambari Installation
Also available as:
PDF

Database Settings

In the Ranger Admin console, update the following properties shown in the figure and table below.

The table below describes each of the Ranger database settings fields that you can complete, Note that the fields designated in red are required fields.

Table 3.1. Ranger Database Settings

Configuration Property NameDescriptionDefault ValueExample ValueRequired?
SQL Command Invoker    
Ranger DB hostThe fully qualified hostname of the Ranger database server. localhostYes
Ranger DB root userThe Ranger database user that has administrative privileges to create database schemas and users.rootrootYes
Ranger DB root passwordThe root password for the Ranger database user (db_root_user). rootPassWORdYes
Ranger DB nameThe name of the Ranger Policy databaserangerrangerYes
Ranger DB usernameThe username for the Policy database.rangeradminrangeradminYes
Ranger DB passwordThe password for the Ranger Policy database user 

RangerAdmin

PassWORd

Yes
Ranger Audit DB nameThe name of the Ranger Audit database. This can be a different database in the same database.ranger_auditranger_auditYes
Ranger Audit DB usernameThe username for the Ranger Audit database. This username performs all audit logging operatins.rangerloggerrangerloggerYes
Ranger Audit DB passwordThe password for the Ranger Audit Audit database. 

RangerLogger

PassWORd

Yes

If you are using Oracle, make sure you also update the following properties:

Table 3.2. Oracle Database Settings

Configuration Property NameDescriptionDefault ValueExample ValueRequired?
DB FLAVORThe database you want to use. Options are MySQL and Oracle.MYSQLMYSQLYes
SQL Command InvokerThe command used to invoke the SQL database.  No
SQL_CONNECTOR_JARThe path to the Oracle JDBC driver. The database driver location for MySQL. If the Oracle database is used, copy the Oracle JDBC driver to /usr/share/java/ojdbc6.jar. In Windows, only MySQL is supported./usr/share/java/mysql-connector-java.jar/usr/share/java/mysql-connector-java.jarYes
ORACLE_HOMEThe path to the folder for SQLPLUS