You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by Jonathan Hurley <jh...@hortonworks.com> on 2015/11/16 20:58:24 UTC
Review Request 40363: Ranger Audit Store Configured With Postgres
Prevents NameNode From Starting
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/40363/
-----------------------------------------------------------
Review request for Ambari, Alejandro Fernandez and Nate Cole.
Bugs: AMBARI-13912
https://issues.apache.org/jira/browse/AMBARI-13912
Repository: ambari
Description
-------
When Ranger is configured to use PostgresSQL, the HDFS NameNode will not startup correctly, complaining about missing class drivers. The root of the problem is that {{hadoop-env.sh}} adds JDBC drivers for Oracle and MySQL only.
{code}
# Add libraries required by oracle connector
for jarFile in `ls /usr/share/java/*ojdbc* 2>/dev/null`
do
JAVA_JDBC_LIBS=${JAVA_JDBC_LIBS}:$jarFile
done
{code}
Ranger needs the following driver support:
||DB Type||JDBC Driver JAR Name||Minimum Supported Version||Driver Reference Link
|Mysql|mysql-connector-java.jar|MySQL 5.6|[Link|http://dev.mysql.com/doc/connector-j/en/connector-j-versions.html]
|Oracle|ojdbc6.jar or ojdbc7.jar|Oracle 11g|[Link|http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html]
|Postgres|postgresql.jar|Postgres 8.4|[Link|https://jdbc.postgresql.org/documentation/84/setup.html#build]
|MS-SQLServer|sqljdbc4.jar|SQL Server 12|[Link|https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx]
Diffs
-----
ambari-server/src/main/resources/common-services/HDFS/2.1.0.2.0/configuration/hadoop-env.xml 4bee818
ambari-server/src/main/resources/stacks/HDP/2.2/services/HDFS/configuration/hadoop-env.xml 060d651
ambari-server/src/main/resources/stacks/HDP/2.3/services/HDFS/configuration/hadoop-env.xml 989dee5
ambari-server/src/main/resources/stacks/HDP/2.3/upgrades/config-upgrade.xml ecfa031
Diff: https://reviews.apache.org/r/40363/diff/
Testing
-------
Verified that matching JARs for SQL Server and PostgreSQL were added to the classpath.
Thanks,
Jonathan Hurley