[ https://issues.apache.org/jira/browse/AMBARI-13175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14901717#comment-14901717 ]
Jaimin D Jetly commented on AMBARI-13175: ----------------------------------------- Also verified that ambari-server python unit tests are passing successfully: ---------------------------------------------------------------------- Ran 231 tests in 6.860s OK ---------------------------------------------------------------------- Total run:795 Total errors:0 Total failures:0 OK Process finished with exit code 0 > 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 > > > 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)