-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/40363/
-----------------------------------------------------------
(Updated Nov. 17, 2015, 11:25 a.m.)
Review request for Ambari, Alejandro Fernandez, Jayush Luniya, and Nate Cole.
Changes
-------
Revised to an egrep command to condense into a single loop.
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 (updated)
-----
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
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
