Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ranger install fails

Ranger install fails

New Contributor

Ranger install fails when checking at the end with DBConnectionVerification.jar. The rest of the install and connectivity test are OK...

2017-01-31 19:34:54,250 [I] Patch 015-auditlogaggregation.sql is being applied.. 2017-01-31 19:34:54,250 [JISQL] /usr/jdk64/jdk1.7.0_45/bin/java -cp /usr/hdp/2.4.2.0-258/hive/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://namenode.localdomain/ranger_audit -u 'rangeradmin' -p '********' -noheader -trim -c \; -input /usr/hdp/current/ranger-admin/db/mysql/patches/audit/015-auditlogaggregation.sql 2017-01-31 19:34:55,112 [I] 015-auditlogaggregation.sql patch applied 2017-01-31 19:34:55,113 [JISQL] /usr/jdk64/jdk1.7.0_45/bin/java -cp /usr/hdp/2.4.2.0-258/hive/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://namenode.localdomain/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "update x_db_version_h set active='Y' where version='015' and active='N';" 2017-01-31 19:34:55,560 [I] Patch version updated 2017-01-31 19:34:55,568 - Directory['/usr/hdp/current/ranger-admin/conf'] {'owner': 'ranger', 'group': 'ranger', 'recursive': True} 2017-01-31 19:34:55,569 - File['/usr/lib/ambari-agent/DBConnectionVerification.jar'] {'content': DownloadSource('http://namenode.localdomain:8888/resources/DBConnectionVerification.jar'), 'mode': 0644} 2017-01-31 19:34:55,569 - Not downloading the file from http://namenode.localdomain:8888/resources/DBConnectionVerification.jar, because /var/lib/ambari-agent/tmp/DBConnectionVerification.jar already exists 2017-01-31 19:34:55,570 - Execute['/usr/jdk64/jdk1.7.0_45/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/share/java/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/ews/lib/* org.apache.ambari.server.DBConnectionVerification 'jdbc:mysql://namenode.localdomain/ranger' rangeradmin [PROTECTED] com.mysql.jdbc.Driver'] {'environment': {}, 'path': ['/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin'], 'tries': 5, 'try_sleep': 10} 2017-01-31 19:34:55,661 - Retrying after 10 seconds. Reason: Execution of '/usr/jdk64/jdk1.7.0_45/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/share/java/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/ews/lib/* org.apache.ambari.server.DBConnectionVerification 'jdbc:mysql://namenode.localdomain/ranger' rangeradmin [PROTECTED] com.mysql.jdbc.Driver' returned 1. ERROR: Unable to connect to the DB. Please check DB connection properties. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

1 REPLY 1

Re: Ranger install fails

Mentor

@Brad Carson make sure you run the ambari-server setup step

ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_security/content/configuring_mysql_for_r...

Don't have an account?
Coming from Hortonworks? Activate your account here