I would like to set up Ambari SSO in an automated way, but it seems the 'ambari-server setup-sso' does not support it. If I switch on the silent mode then I got a not supported error message, without silent mode it is quite hard to automate since it asks quite a few questions. # Silent mode $> ambari-server setup-sso --silent Using python /usr/bin/python Setting up SSO authentication properties... WARNING: setup-sso is not enabled in silent mode. Ambari Server 'setup-sso' completed with warnings. # Interactive mode $> ambari-server setup-sso Using python /usr/bin/python Setting up SSO authentication properties... Do you want to configure SSO authentication [y/n] (y)? Provider URL [URL] (http://example.com):https://somehost:8443/gw-os06/knoxsso/api/v1/websso Public Certificate pem (empty) (empty line to finish input): MIICnTCCAYWgAwIBAgIBATANBgkqhkiG9w0BAQsFADASMRAwDgYDVQQDDAdzaWdu aW5nMB4XDTE3MTIwNTE3NDUwMloXDTI3MTIwNTE3NDUwMlowEjEQMA4GA1UEAxMH ... 60v5bHlGkAKgdziCm1DZbxmTjcjLdxZAU7NrOlhSicZl17Yym1nmT8Cq2PkSDRaZ rA== Do you want to configure advanced properties [y/n] (n) ? Ambari Server 'setup-sso' completed successfully. Is there a simple/elegant way to automate it? Thanks, Attila ... View more

Hi, In my test environment Ranger install with Ambari Blueprint fails with with DB access error. I have added RANGER_ADMIN, HIVE_SERVER, HIVE_METASTORE and MYSQL_SERVER components to the blueprints. The MySQL server has been correctly installed/configured by Ambari and it seems that Hive is able to use it without any problem, but Ranger setup fails with the following error: 17 15:40:00,148 [I] Running DBA setup script. QuiteMode:True 2017-11-17 15:40:00,149 [I] Using Java:/usr/lib/jvm/java/bin/java 2017-11-17 15:40:00,149 [I] DB FLAVOR:MYSQL 2017-11-17 15:40:00,149 [I] DB Host: 2017-11-17 15:40:00,149 [I] ---------- Verifying DB root password ---------- 2017-11-17 15:40:00,150 [I] DBA root user password validated 2017-11-17 15:40:00,150 [I] ---------- Verifying Ranger Admin db user password ---------- 2017-11-17 15:40:00,150 [I] admin user password validated 2017-11-17 15:40:00,150 [I] ---------- Creating Ranger Admin db user ---------- 2017-11-17 15:40:00,150 [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java-5.1.39-bin.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql:///mysql -u root -p '********' -noheader -trim -c \; -query "SELECT version();" SQLException : SQL state: 28000 java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) ErrorCode: 1045 2017-11-17 15:40:00,714 [E] Can't establish db connection.. Exiting.. Traceback (most recent call last): Please note that logging in to the machine and changing password is not really an option since I want to automate the installation of Hive, Ranger and MySQL from Blueprint . My blueprint: blueprint.txt Attila ... View more