stderr: /var/lib/ambari-agent/data/errors-419.txt Traceback (most recent call last): File "/var/lib/ambari-agent/cache/common-services/RANGER/0.4.0/package/scripts/ranger_admin.py", line 124, in RangerAdmin().execute() File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 219, in execute method(env) File "/var/lib/ambari-agent/cache/common-services/RANGER/0.4.0/package/scripts/ranger_admin.py", line 43, in install setup_ranger_db() File "/var/lib/ambari-agent/cache/common-services/RANGER/0.4.0/package/scripts/setup_ranger_xml.py", line 221, in setup_ranger_db user=params.unix_user, File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 154, in __init__ self.env.run() File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 158, in run self.run_action(resource, action) File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 121, in run_action provider_action() File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 238, in action_run tries=self.resource.tries, try_sleep=self.resource.try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 70, in inner result = function(command, **kwargs) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 92, in checked_call tries=tries, try_sleep=try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 140, in _call_wrapper result = _call(command, **kwargs_copy) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 291, in _call raise Fail(err_msg) resource_management.core.exceptions.Fail: Execution of 'python /usr/hdp/current/ranger-admin/db_setup.py' returned 1. 2016-09-16 14:15:24,498 [I] DB FLAVOR :MYSQL 2016-09-16 14:15:24,498 [I] --------- Verifying Ranger DB connection --------- 2016-09-16 14:15:24,498 [I] Checking connection.. 2016-09-16 14:15:24,498 [JISQL] /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.71-2.b15.el7_2.x86_64/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://hostname/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "SELECT version();" SQLException : SQL state: 28000 java.sql.SQLException: Access denied for user 'rangeradmin'@'host' (using password: YES) ErrorCode: 1045 2016-09-16 14:15:24,811 [E] Can't establish connection!! Exiting.. 2016-09-16 14:15:24,811 [I] Please run DB setup first or contact Administrator.. stdout: /var/lib/ambari-agent/data/output-419.txt 2016-09-16 14:15:23,577 - The hadoop conf dir /usr/hdp/current/hadoop-client/conf exists, will call conf-select on it for version 2.4.0.0-169 2016-09-16 14:15:23,577 - Checking if need to create versioned conf dir /etc/hadoop/2.4.0.0-169/0 2016-09-16 14:15:23,577 - call['conf-select create-conf-dir --package hadoop --stack-version 2.4.0.0-169 --conf-version 0'] {'logoutput': False, 'sudo': True, 'quiet': False, 'stderr': -1} 2016-09-16 14:15:23,601 - call returned (1, '/etc/hadoop/2.4.0.0-169/0 exist already', '') 2016-09-16 14:15:23,601 - checked_call['conf-select set-conf-dir --package hadoop --stack-version 2.4.0.0-169 --conf-version 0'] {'logoutput': False, 'sudo': True, 'quiet': False} 2016-09-16 14:15:23,624 - checked_call returned (0, '/usr/hdp/2.4.0.0-169/hadoop/conf -> /etc/hadoop/2.4.0.0-169/0') 2016-09-16 14:15:23,624 - Ensuring that hadoop has the correct symlink structure 2016-09-16 14:15:23,624 - Using hadoop conf dir: /usr/hdp/current/hadoop-client/conf 2016-09-16 14:15:23,626 - Group['spark'] {} 2016-09-16 14:15:23,627 - Group['ranger'] {} 2016-09-16 14:15:23,627 - Group['hadoop'] {} 2016-09-16 14:15:23,628 - Group['users'] {} 2016-09-16 14:15:23,628 - Group['knox'] {} 2016-09-16 14:15:23,628 - User['hive'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,629 - User['storm'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,629 - User['zookeeper'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,630 - User['oozie'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'users']} 2016-09-16 14:15:23,630 - User['atlas'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,631 - User['ams'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,631 - User['falcon'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'users']} 2016-09-16 14:15:23,632 - User['ranger'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'ranger']} 2016-09-16 14:15:23,633 - User['tez'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'users']} 2016-09-16 14:15:23,634 - User['spark'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,634 - User['ambari-qa'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'users']} 2016-09-16 14:15:23,635 - User['flume'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,635 - User['kafka'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,636 - User['hdfs'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,636 - User['sqoop'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,637 - User['yarn'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,637 - User['mapred'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,638 - User['hbase'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,639 - User['knox'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,639 - User['hcat'] {'gid': 'hadoop', 'fetch_nonlocal_groups': True, 'groups': [u'hadoop']} 2016-09-16 14:15:23,640 - File['/var/lib/ambari-agent/tmp/changeUid.sh'] {'content': StaticFile('changeToSecureUid.sh'), 'mode': 0555} 2016-09-16 14:15:23,641 - Execute['/var/lib/ambari-agent/tmp/changeUid.sh ambari-qa /tmp/hadoop-ambari-qa,/tmp/hsperfdata_ambari-qa,/home/ambari-qa,/tmp/ambari-qa,/tmp/sqoop-ambari-qa'] {'not_if': '(test $(id -u ambari-qa) -gt 1000) || (false)'} 2016-09-16 14:15:23,646 - Skipping Execute['/var/lib/ambari-agent/tmp/changeUid.sh ambari-qa /tmp/hadoop-ambari-qa,/tmp/hsperfdata_ambari-qa,/home/ambari-qa,/tmp/ambari-qa,/tmp/sqoop-ambari-qa'] due to not_if 2016-09-16 14:15:23,647 - Directory['/tmp/hbase-hbase'] {'owner': 'hbase', 'recursive': True, 'mode': 0775, 'cd_access': 'a'} 2016-09-16 14:15:23,647 - File['/var/lib/ambari-agent/tmp/changeUid.sh'] {'content': StaticFile('changeToSecureUid.sh'), 'mode': 0555} 2016-09-16 14:15:23,648 - Execute['/var/lib/ambari-agent/tmp/changeUid.sh hbase /home/hbase,/tmp/hbase,/usr/bin/hbase,/var/log/hbase,/tmp/hbase-hbase'] {'not_if': '(test $(id -u hbase) -gt 1000) || (false)'} 2016-09-16 14:15:23,653 - Skipping Execute['/var/lib/ambari-agent/tmp/changeUid.sh hbase /home/hbase,/tmp/hbase,/usr/bin/hbase,/var/log/hbase,/tmp/hbase-hbase'] due to not_if 2016-09-16 14:15:23,653 - Group['hdfs'] {} 2016-09-16 14:15:23,654 - User['hdfs'] {'fetch_nonlocal_groups': True, 'groups': [u'hadoop', u'hdfs']} 2016-09-16 14:15:23,654 - Directory['/etc/hadoop'] {'mode': 0755} 2016-09-16 14:15:23,667 - File['/usr/hdp/current/hadoop-client/conf/hadoop-env.sh'] {'content': InlineTemplate(...), 'owner': 'hdfs', 'group': 'hadoop'} 2016-09-16 14:15:23,668 - Directory['/var/lib/ambari-agent/tmp/hadoop_java_io_tmpdir'] {'owner': 'hdfs', 'group': 'hadoop', 'mode': 0777} 2016-09-16 14:15:23,680 - Repository['HDP-2.4'] {'base_url': 'http://public-repo-1.hortonworks.com/HDP/centos7/2.x/updates/2.4.2.0', 'action': ['create'], 'components': [u'HDP', 'main'], 'repo_template': '[{{repo_id}}]\nname={{repo_id}}\n{% if mirror_list %}mirrorlist={{mirror_list}}{% else %}baseurl={{base_url}}{% endif %}\n\npath=/\nenabled=1\ngpgcheck=0', 'repo_file_name': 'HDP', 'mirror_list': None} 2016-09-16 14:15:23,687 - File['/etc/yum.repos.d/HDP.repo'] {'content': '[HDP-2.4]\nname=HDP-2.4\nbaseurl=http://public-repo-1.hortonworks.com/HDP/centos7/2.x/updates/2.4.2.0\n\npath=/\nenabled=1\ngpgcheck=0'} 2016-09-16 14:15:23,688 - Repository['HDP-UTILS-1.1.0.20'] {'base_url': 'http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos7', 'action': ['create'], 'components': [u'HDP-UTILS', 'main'], 'repo_template': '[{{repo_id}}]\nname={{repo_id}}\n{% if mirror_list %}mirrorlist={{mirror_list}}{% else %}baseurl={{base_url}}{% endif %}\n\npath=/\nenabled=1\ngpgcheck=0', 'repo_file_name': 'HDP-UTILS', 'mirror_list': None} 2016-09-16 14:15:23,690 - File['/etc/yum.repos.d/HDP-UTILS.repo'] {'content': '[HDP-UTILS-1.1.0.20]\nname=HDP-UTILS-1.1.0.20\nbaseurl=http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos7\n\npath=/\nenabled=1\ngpgcheck=0'} 2016-09-16 14:15:23,690 - Package['unzip'] {} 2016-09-16 14:15:23,830 - Skipping installation of existing package unzip 2016-09-16 14:15:23,830 - Package['curl'] {} 2016-09-16 14:15:23,899 - Skipping installation of existing package curl 2016-09-16 14:15:23,900 - Package['hdp-select'] {} 2016-09-16 14:15:23,970 - Skipping installation of existing package hdp-select 2016-09-16 14:15:24,163 - Package['ranger_2_4_*-admin'] {} 2016-09-16 14:15:24,299 - Skipping installation of existing package ranger_2_4_*-admin 2016-09-16 14:15:24,299 - Package['ranger_2_4_*-usersync'] {} 2016-09-16 14:15:24,366 - Skipping installation of existing package ranger_2_4_*-usersync 2016-09-16 14:15:24,369 - File['/var/lib/ambari-agent/tmp/mysql-connector-java.jar'] {'content': DownloadSource('http://master1.ad3nmgw0eliepgx3vzyz5joe3c.cx.internal.cloudapp.net:8080/resources//mysql-jdbc-driver.jar'), 'mode': 0644} 2016-09-16 14:15:24,370 - Not downloading the file from http://master1.ad3nmgw0eliepgx3vzyz5joe3c.cx.internal.cloudapp.net:8080/resources//mysql-jdbc-driver.jar, because /var/lib/ambari-agent/tmp/mysql-jdbc-driver.jar already exists 2016-09-16 14:15:24,371 - Directory['/usr/share/java'] {'recursive': True, 'mode': 0755, 'cd_access': 'a'} 2016-09-16 14:15:24,372 - Execute[('cp', '--remove-destination', '/var/lib/ambari-agent/tmp/mysql-connector-java.jar', '/usr/share/java/mysql-connector-java.jar')] {'path': ['/bin', '/usr/bin/'], 'sudo': True} 2016-09-16 14:15:24,379 - File['/usr/share/java/mysql-connector-java.jar'] {'mode': 0644} 2016-09-16 14:15:24,379 - Execute[('cp', '--remove-destination', '/var/lib/ambari-agent/tmp/mysql-connector-java.jar', '/usr/hdp/current/ranger-admin/ews/lib')] {'path': ['/bin', '/usr/bin/'], 'sudo': True} 2016-09-16 14:15:24,386 - File['/usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar'] {'mode': 0644} 2016-09-16 14:15:24,387 - ModifyPropertiesFile['/usr/hdp/current/ranger-admin/install.properties'] {'owner': 'ranger', 'properties': ...} 2016-09-16 14:15:24,387 - Modifying existing properties file: /usr/hdp/current/ranger-admin/install.properties 2016-09-16 14:15:24,397 - File['/usr/hdp/current/ranger-admin/install.properties'] {'owner': 'ranger', 'content': ..., 'group': None, 'mode': None, 'encoding': 'utf-8'} 2016-09-16 14:15:24,398 - Writing File['/usr/hdp/current/ranger-admin/install.properties'] because contents don't match 2016-09-16 14:15:24,398 - Separate DBA property not set. Assuming Ranger DB and DB User exists! 2016-09-16 14:15:24,398 - Execute['python /usr/hdp/current/ranger-admin/db_setup.py'] {'logoutput': True, 'environment': {'RANGER_ADMIN_HOME': '/usr/hdp/current/ranger-admin', 'JAVA_HOME': u'/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.71-2.b15.el7_2.x86_64'}, 'user': 'ranger'} 2016-09-16 14:15:24,498 [I] DB FLAVOR :MYSQL 2016-09-16 14:15:24,498 [I] --------- Verifying Ranger DB connection --------- 2016-09-16 14:15:24,498 [I] Checking connection.. 2016-09-16 14:15:24,498 [JISQL] /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.71-2.b15.el7_2.x86_64/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://hostname/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "SELECT version();" SQLException : SQL state: 28000 java.sql.SQLException: Access denied for user 'rangeradmin'@'hostname' (using password: YES) ErrorCode: 1045 2016-09-16 14:15:24,811 [E] Can't establish connection!! Exiting.. 2016-09-16 14:15:24,811 [I] Please run DB setup first or contact Administrator..