Return-Path: X-Original-To: apmail-ambari-dev-archive@www.apache.org Delivered-To: apmail-ambari-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6D05618630 for ; Tue, 22 Sep 2015 01:18:07 +0000 (UTC) Received: (qmail 65343 invoked by uid 500); 22 Sep 2015 01:18:04 -0000 Delivered-To: apmail-ambari-dev-archive@ambari.apache.org Received: (qmail 65309 invoked by uid 500); 22 Sep 2015 01:18:04 -0000 Mailing-List: contact dev-help@ambari.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ambari.apache.org Delivered-To: mailing list dev@ambari.apache.org Received: (qmail 65296 invoked by uid 99); 22 Sep 2015 01:18:04 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Sep 2015 01:18:04 +0000 Date: Tue, 22 Sep 2015 01:18:04 +0000 (UTC) From: "Jaimin D Jetly (JIRA)" To: dev@ambari.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (AMBARI-13175) Ranger Database related property values should be recommended by stack advisor MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/AMBARI-13175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jaimin D Jetly updated AMBARI-13175: ------------------------------------ Attachment: AMBARI-13175_2.patch > 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 > > Attachments: AMBARI-13175.patch, AMBARI-13175_2.patch > > > 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)