You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Jaimin D Jetly (JIRA)" <ji...@apache.org> on 2015/09/22 02:53:04 UTC
[jira] [Updated] (AMBARI-13175) Ranger Database related property
values should be recommended by stack advisor
[ https://issues.apache.org/jira/browse/AMBARI-13175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jaimin D Jetly updated AMBARI-13175:
------------------------------------
Description:
Recommendation API should be called whenever admin-properties/DB_FLAVOR is changed.
Following properties should be changed accordingly by stack advisor:
||DB_FLAVOR value||Dependent properties values||
|MYSQL|1) admin-properties/SQL_CONNECTOR_JAR=/usr/share/java/mysql-connector-java.jar \\2) ranger-admin-site/ranger.jpa.jdbc.url=jdbc:mysql://$\{admin-properties/db_host}/$\{admin-properties/db_name\} (HDP-2.3 onwards)\\3) ranger-admin-site/ranger.jpa.jdbc.driver=com.mysql.jdbc.Driver (HDP-2.3 onwards)
|ORACLE|1) admin-properties/SQL_CONNECTOR_JAR=/usr/share/java/ojdbc6.jar \\2) ranger-admin-site/ranger.jpa.jdbc.url= jdbc:oracle:thin:@/$\{admin-properties/db_host}:1521/$\{admin-properties/db_name\} (HDP-2.3 onwards)\\3) ranger-admin-site/ranger.jpa.jdbc.driver=oracle.jdbc.driver.OracleDriver (HDP-2.3 onwards)
|POSTGRES|1) admin-properties/SQL_CONNECTOR_JAR=/usr/share/java/postgresql.jar \\2) ranger-admin-site/ranger.jpa.jdbc.url= jdbc:postgresql://$\{admin-properties/db_host}:5432/$\{admin-properties/db_name\} (HDP-2.3 onwards) \\3) ranger-admin-site/ranger.jpa.jdbc.driver=org.postgresql.Driver (HDP-2.3 onwards)
|MSSQL|1) admin-properties/SQL_CONNECTOR_JAR=/usr/share/java/sqljdbc4.jar \\2) ranger-admin-site/ranger.jpa.jdbc.url= jdbc:sqlserver://$\{admin-properties/db_host};databaseName=$\{admin-properties/db_name\} (HDP-2.3 onwards) \\3) ranger-admin-site/ranger.jpa.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver (HDP-2.3 onwards)
|SQLA|1) admin-properties/SQL_CONNECTOR_JAR=/path_to_driver/sqla-client-jdbc.tar.gz \\2) ranger-admin-site/ranger.jpa.jdbc.url= jdbc:sqlanywhere:host=$\{admin-properties/db_host};database=$\{admin-properties/db_name\} (HDP-2.3 onwards) \\3) ranger-admin-site/ranger.jpa.jdbc.driver=sap.jdbc4.sqlanywhere.IDriver (HDP-2.3 onwards)
Also changing of $\{admin-properties/db_host} and $\{admin-properties/db_name\} should change ranger-admin-site/ranger.jpa.jdbc.url for HDP-2.3 stack.
> Ranger Database related property values should be recommended by stack advisor
> ------------------------------------------------------------------------------
>
> Key: AMBARI-13175
> URL: https://issues.apache.org/jira/browse/AMBARI-13175
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server, ambari-web, stacks
> Affects Versions: 2.1.3
> Reporter: Jaimin D Jetly
> Assignee: Jaimin D Jetly
> Fix For: 2.1.3
>
>
> Recommendation API should be called whenever admin-properties/DB_FLAVOR is changed.
> Following properties should be changed accordingly by stack advisor:
> ||DB_FLAVOR value||Dependent properties values||
> |MYSQL|1) admin-properties/SQL_CONNECTOR_JAR=/usr/share/java/mysql-connector-java.jar \\2) ranger-admin-site/ranger.jpa.jdbc.url=jdbc:mysql://$\{admin-properties/db_host}/$\{admin-properties/db_name\} (HDP-2.3 onwards)\\3) ranger-admin-site/ranger.jpa.jdbc.driver=com.mysql.jdbc.Driver (HDP-2.3 onwards)
> |ORACLE|1) admin-properties/SQL_CONNECTOR_JAR=/usr/share/java/ojdbc6.jar \\2) ranger-admin-site/ranger.jpa.jdbc.url= jdbc:oracle:thin:@/$\{admin-properties/db_host}:1521/$\{admin-properties/db_name\} (HDP-2.3 onwards)\\3) ranger-admin-site/ranger.jpa.jdbc.driver=oracle.jdbc.driver.OracleDriver (HDP-2.3 onwards)
> |POSTGRES|1) admin-properties/SQL_CONNECTOR_JAR=/usr/share/java/postgresql.jar \\2) ranger-admin-site/ranger.jpa.jdbc.url= jdbc:postgresql://$\{admin-properties/db_host}:5432/$\{admin-properties/db_name\} (HDP-2.3 onwards) \\3) ranger-admin-site/ranger.jpa.jdbc.driver=org.postgresql.Driver (HDP-2.3 onwards)
> |MSSQL|1) admin-properties/SQL_CONNECTOR_JAR=/usr/share/java/sqljdbc4.jar \\2) ranger-admin-site/ranger.jpa.jdbc.url= jdbc:sqlserver://$\{admin-properties/db_host};databaseName=$\{admin-properties/db_name\} (HDP-2.3 onwards) \\3) ranger-admin-site/ranger.jpa.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver (HDP-2.3 onwards)
> |SQLA|1) admin-properties/SQL_CONNECTOR_JAR=/path_to_driver/sqla-client-jdbc.tar.gz \\2) ranger-admin-site/ranger.jpa.jdbc.url= jdbc:sqlanywhere:host=$\{admin-properties/db_host};database=$\{admin-properties/db_name\} (HDP-2.3 onwards) \\3) ranger-admin-site/ranger.jpa.jdbc.driver=sap.jdbc4.sqlanywhere.IDriver (HDP-2.3 onwards)
> Also changing of $\{admin-properties/db_host} and $\{admin-properties/db_name\} should change ranger-admin-site/ranger.jpa.jdbc.url for HDP-2.3 stack.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)