Ranger Ambari Installation
Also available as:
PDF

Configuring PostgreSQL for Ranger

  1. On the PostgreSQL host, install the applicable PostgreSQL connector.

    RHEL/CentOS/Oracle Linux

    yum install postgresql-jdbc*

    SLES

    zypper install -y postgresql-jdbc
  2. Confirm that the .jar file is in the Java share directory.

    ls /usr/share/java/postgresql-jdbc.jar
  3. Change the access mode of the .jar file to 644.

    chmod 644 /usr/share/java/postgresql-jdbc.jar
  4. The PostgreSQL database administrator should be used to create the Ranger databases.

    The following series of commands could be used to create the rangerdba user and grant it adequate privileges.

    echo "CREATE DATABASE $dbname;" | sudo -u $postgres psql -U postgres
    echo "CREATE USER $rangerdba WITH PASSWORD '$passwd';" | sudo -u $postgres psql -U postgres
    echo "GRANT ALL PRIVILEGES ON DATABASE $dbname TO $rangerdba;" | sudo -u postgres psql -U $postgres 

    Where:

    • $postgres is the postgres user

    • $dbname is the name of your PostgreSQL database

  5. Use the following command format to set the jdbc/driver/path based on the location of the PostgreSQL JDBC driver .jar file. This command must be run on the server where Ambari server is installed.

    ambari-server setup --jdbc-db={database-type} --jdbc-driver={/jdbc/driver/path}

    For example:

    ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql.jar
  6. Run the following command:

    export HADOOP_CLASSPATH=${HADOOP_CLASSPATH}:${JAVA_JDBC_LIBS}:/connector jar path
  7. Add allow access details for Ranger users:

    • change listen_addresses='localhost' to listen_addresses='*' ('*' = any) to listen from all IPs in postgresql.conf.

    • Make the following changes to the Ranger db user and Ranger audit db user in pg_hba.conf.