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 Name | Description | Default Value | Example Value | Required? |
|---|---|---|---|---|
| SQL Command Invoker | ||||
| Ranger DB host | The fully qualified hostname of the Ranger database server. | localhost | Yes | |
| Ranger DB root user | The Ranger database user that has administrative privileges to create database schemas and users. | root | root | Yes |
| Ranger DB root password | The root password for the Ranger database user (db_root_user). | rootPassWORd | Yes | |
| Ranger DB name | The name of the Ranger Policy database | ranger | ranger | Yes |
| Ranger DB username | The username for the Policy database. | rangeradmin | rangeradmin | Yes |
| Ranger DB password | The password for the Ranger Policy database user |
RangerAdmin PassWORd | Yes | |
| Ranger Audit DB name | The name of the Ranger Audit database. This can be a different database in the same database. | ranger_audit | ranger_audit | Yes |
| Ranger Audit DB username | The username for the Ranger Audit database. This username performs all audit logging operatins. | rangerlogger | rangerlogger | Yes |
| Ranger Audit DB password | The 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 Name | Description | Default Value | Example Value | Required? |
|---|---|---|---|---|
| DB FLAVOR | The database you want to use. Options are MySQL and Oracle. | MYSQL | MYSQL | Yes |
| SQL Command Invoker | The command used to invoke the SQL database. | No | ||
| SQL_CONNECTOR_JAR | The 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.jar | Yes |
| ORACLE_HOME | The path to the folder for SQLPLUS |