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.

HDP behind proxy - Ranger Admin doesn't start

Highlighted

HDP behind proxy - Ranger Admin doesn't start

Explorer

Hi,

I've installed hdp behind proxy but ranger admin fails to start.
It times out when it applies java patch number 5.
Worth to mention it uses external postgres in azure (using service endpoint).

Here's the log






p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica}



2018-08-26 08:47:46,205  [I] DB FLAVOR :POSTGRES

2018-08-26 08:47:46,205  [I] --------- Verifying Ranger DB connection ---------

2018-08-26 08:47:46,205  [I] Checking connection

2018-08-26 08:47:46,205  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/2.6.5.0-292/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "SELECT 1;"

2018-08-26 08:47:47,585  [I] connection success

2018-08-26 08:47:47,585  [I] --------- Verifying version history table ---------

2018-08-26 08:47:47,585  [I] Verifying table x_db_version_h in database ranger

2018-08-26 08:47:47,585  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/2.6.5.0-292/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select * from (select table_name from information_schema.tables where table_catalog='ranger' and table_name = 'x_db_version_h') as temp;"

2018-08-26 08:47:48,332  [I] Table x_db_version_h already exists in database ranger

2018-08-26 08:47:48,332  [I] --------- Importing Ranger Core DB Schema ---------

2018-08-26 08:47:48,332  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/2.6.5.0-292/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'CORE_DB_SCHEMA' and active = 'Y';"

2018-08-26 08:47:49,064  [I] CORE_DB_SCHEMA is already imported

2018-08-26 08:47:49,065  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/2.6.5.0-292/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DB_PATCHES' and inst_by = 'Ranger 0.7.0.2.6.5.0-292' and active = 'Y';"

2018-08-26 08:47:49,797  [I] DB_PATCHES have already been applied

2018-08-26 08:47:49,807 - Directory['/usr/hdp/current/ranger-admin/conf'] {'owner': 'ranger', 'group': 'ranger', 'create_parents': True}

2018-08-26 08:47:49,808 - File['/var/lib/ambari-agent/tmp/postgresql-jdbc3.jar'] {'content': DownloadSource('http://az3pb-p02-m1.data.some.gov.uk:8080/resources/postgresql-jdbc3.jar'), 'mode': 0644}

2018-08-26 08:47:49,808 - Not downloading the file from http://az3pb-p02-m1.data.some.gov.uk:8080/resources/postgresql-jdbc3.jar, because /var/lib/ambari-agent/tmp/postgresql-jdbc3.jar already exists

2018-08-26 08:47:49,810 - Execute[('cp', '--remove-destination', u'/var/lib/ambari-agent/tmp/postgresql-jdbc3.jar', u'/usr/hdp/current/ranger-admin/ews/lib')] {'path': ['/bin', '/usr/bin/'], 'sudo': True}

2018-08-26 08:47:49,819 - File['/usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar'] {'mode': 0644}

2018-08-26 08:47:49,820 - ModifyPropertiesFile['/usr/hdp/current/ranger-admin/install.properties'] {'owner': 'ranger', 'properties': ...}

2018-08-26 08:47:49,820 - Modifying existing properties file: /usr/hdp/current/ranger-admin/install.properties

2018-08-26 08:47:49,828 - File['/usr/hdp/current/ranger-admin/install.properties'] {'owner': 'ranger', 'content': ..., 'group': None, 'mode': None, 'encoding': 'utf-8'}

2018-08-26 08:47:49,829 - Writing File['/usr/hdp/current/ranger-admin/install.properties'] because contents don't match

2018-08-26 08:47:49,829 - ModifyPropertiesFile['/usr/hdp/current/ranger-admin/install.properties'] {'owner': 'ranger', 'properties': {'SQL_CONNECTOR_JAR': u'/usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar'}}

2018-08-26 08:47:49,830 - Modifying existing properties file: /usr/hdp/current/ranger-admin/install.properties

2018-08-26 08:47:49,831 - File['/usr/hdp/current/ranger-admin/install.properties'] {'owner': 'ranger', 'content': ..., 'group': None, 'mode': None, 'encoding': 'utf-8'}

2018-08-26 08:47:49,832 - File['/usr/lib/ambari-agent/DBConnectionVerification.jar'] {'content': DownloadSource('http://az3pb-p02-m1.data.some.gov.uk:8080/resources/DBConnectionVerification.jar'), 'mode': 0644}

2018-08-26 08:47:49,832 - Not downloading the file from http://az3pb-p02-m1.data.some.gov.uk:8080/resources/DBConnectionVerification.jar, because /var/lib/ambari-agent/tmp/DBConnectionVerification.jar already exists

2018-08-26 08:47:49,832 - Execute['/usr/lib/jvm/java/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/ews/lib/* org.apache.ambari.server.DBConnectionVerification 'jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger' someuser@some-db [PROTECTED] org.postgresql.Driver'] {'environment': {}, 'path': ['/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin'], 'tries': 5, 'try_sleep': 10}

2018-08-26 08:47:50,563 - Execute[('ln', '-sf', u'/usr/hdp/current/ranger-admin/ews/webapp/WEB-INF/classes/conf', u'/usr/hdp/current/ranger-admin/conf')] {'not_if': 'ls /usr/hdp/current/ranger-admin/conf', 'sudo': True, 'only_if': 'ls /usr/hdp/current/ranger-admin/ews/webapp/WEB-INF/classes/conf'}

2018-08-26 08:47:50,569 - Skipping Execute[('ln', '-sf', u'/usr/hdp/current/ranger-admin/ews/webapp/WEB-INF/classes/conf', u'/usr/hdp/current/ranger-admin/conf')] due to not_if

2018-08-26 08:47:50,569 - Directory['/usr/hdp/current/ranger-admin/'] {'owner': 'ranger', 'group': 'ranger', 'recursive_ownership': True}

2018-08-26 08:47:50,616 - Directory['/var/run/ranger'] {'owner': 'ranger', 'group': 'hadoop', 'create_parents': True, 'mode': 0755, 'cd_access': 'a'}

2018-08-26 08:47:50,618 - File['/usr/hdp/current/ranger-admin/conf/ranger-admin-env.sh'] {'owner': 'ranger', 'content': 'export JAVA_HOME=/usr/lib/jvm/java', 'group': 'ranger', 'mode': 0755}

2018-08-26 08:47:50,618 - File['/usr/hdp/current/ranger-admin/conf/ranger-admin-env-piddir.sh'] {'owner': 'ranger', 'content': 'export RANGER_PID_DIR_PATH=/var/run/ranger\nexport RANGER_USER=ranger', 'group': 'ranger', 'mode': 0755}

2018-08-26 08:47:50,619 - Directory['/var/log/ranger/admin'] {'owner': 'ranger', 'group': 'ranger', 'create_parents': True, 'mode': 0755, 'cd_access': 'a'}

2018-08-26 08:47:50,620 - File['/usr/hdp/current/ranger-admin/conf/ranger-admin-env-logdir.sh'] {'owner': 'ranger', 'content': 'export RANGER_ADMIN_LOG_DIR=/var/log/ranger/admin', 'group': 'ranger', 'mode': 0755}

2018-08-26 08:47:50,621 - File['/usr/hdp/current/ranger-admin/conf/ranger-admin-default-site.xml'] {'owner': 'ranger', 'group': 'ranger'}

2018-08-26 08:47:50,621 - File['/usr/hdp/current/ranger-admin/conf/security-applicationContext.xml'] {'owner': 'ranger', 'group': 'ranger'}

2018-08-26 08:47:50,622 - Execute[('ln', '-sf', u'/usr/hdp/current/ranger-admin/ews/ranger-admin-services.sh', '/usr/bin/ranger-admin')] {'not_if': 'ls /usr/bin/ranger-admin', 'sudo': True, 'only_if': 'ls /usr/hdp/current/ranger-admin/ews/ranger-admin-services.sh'}

2018-08-26 08:47:50,626 - Skipping Execute[('ln', '-sf', u'/usr/hdp/current/ranger-admin/ews/ranger-admin-services.sh', '/usr/bin/ranger-admin')] due to not_if

2018-08-26 08:47:50,626 - XmlConfig['ranger-admin-site.xml'] {'group': 'ranger', 'conf_dir': '/usr/hdp/current/ranger-admin/conf', 'mode': 0644, 'configuration_attributes': {}, 'owner': 'ranger', 'configurations': ...}

2018-08-26 08:47:50,636 - Generating config: /usr/hdp/current/ranger-admin/conf/ranger-admin-site.xml

2018-08-26 08:47:50,636 - File['/usr/hdp/current/ranger-admin/conf/ranger-admin-site.xml'] {'owner': 'ranger', 'content': InlineTemplate(...), 'group': 'ranger', 'mode': 0644, 'encoding': 'UTF-8'}

2018-08-26 08:47:50,698 - Directory['/usr/hdp/current/ranger-admin/conf/ranger_jaas'] {'owner': 'ranger', 'group': 'ranger', 'mode': 0700}

2018-08-26 08:47:50,701 - File['/usr/hdp/current/ranger-admin/ews/webapp/WEB-INF/log4j.properties'] {'content': InlineTemplate(...), 'owner': 'ranger', 'group': 'ranger', 'mode': 0644}

2018-08-26 08:47:50,702 - Execute[(u'/usr/lib/jvm/java/bin/java', '-cp', u'/usr/hdp/current/ranger-admin/cred/lib/*', 'org.apache.ranger.credentialapi.buildks', 'create', u'rangeradmin', '-value', [PROTECTED], '-provider', u'jceks://file/etc/ranger/admin/rangeradmin.jceks')] {'logoutput': True, 'environment': {'JAVA_HOME': u'/usr/lib/jvm/java'}, 'sudo': True}

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".

SLF4J: Defaulting to no-operation (NOP) logger implementation

SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.

Aug 26, 2018 8:47:51 AM org.apache.hadoop.util.NativeCodeLoader <clinit>

WARNING: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

The alias rangeradmin already exists!! Will try to delete first.

FOUND value of [interactive] field in the Class [org.apache.hadoop.security.alias.CredentialShell] = [true]

Deleting credential: rangeradmin from CredentialProvider: jceks://file/etc/ranger/admin/rangeradmin.jceks

rangeradmin has been successfully deleted.

org.apache.hadoop.security.alias.JavaKeyStoreProvider has been updated.

rangeradmin has been successfully created.

org.apache.hadoop.security.alias.JavaKeyStoreProvider has been updated.

2018-08-26 08:47:51,828 - File['/etc/ranger/admin/rangeradmin.jceks'] {'owner': 'ranger', 'group': 'ranger', 'mode': 0640}

2018-08-26 08:47:51,829 - Execute[(u'/usr/lib/jvm/java/bin/java', '-cp', u'/usr/hdp/current/ranger-admin/cred/lib/*', 'org.apache.ranger.credentialapi.buildks', 'create', u'ranger.ldap.ad.bind.password', '-value', [PROTECTED], '-provider', u'jceks://file/etc/ranger/admin/rangeradmin.jceks')] {'logoutput': True, 'environment': {'JAVA_HOME': u'/usr/lib/jvm/java'}, 'sudo': True}

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".

SLF4J: Defaulting to no-operation (NOP) logger implementation

SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.

Aug 26, 2018 8:47:52 AM org.apache.hadoop.util.NativeCodeLoader <clinit>

WARNING: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

The alias ranger.ldap.ad.bind.password already exists!! Will try to delete first.

FOUND value of [interactive] field in the Class [org.apache.hadoop.security.alias.CredentialShell] = [true]

Deleting credential: ranger.ldap.ad.bind.password from CredentialProvider: jceks://file/etc/ranger/admin/rangeradmin.jceks

ranger.ldap.ad.bind.password has been successfully deleted.

org.apache.hadoop.security.alias.JavaKeyStoreProvider has been updated.

ranger.ldap.ad.bind.password has been successfully created.

org.apache.hadoop.security.alias.JavaKeyStoreProvider has been updated.

2018-08-26 08:47:52,892 - File['/etc/ranger/admin/rangeradmin.jceks'] {'owner': 'ranger', 'group': 'ranger', 'mode': 0640}

2018-08-26 08:47:52,893 - Execute[(u'/usr/lib/jvm/java/bin/java', '-cp', u'/usr/hdp/current/ranger-admin/cred/lib/*', 'org.apache.ranger.credentialapi.buildks', 'create', u'trustStoreAlias', '-value', [PROTECTED], '-provider', u'jceks://file/etc/ranger/admin/rangeradmin.jceks')] {'logoutput': True, 'environment': {'JAVA_HOME': u'/usr/lib/jvm/java'}, 'sudo': True}

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".

SLF4J: Defaulting to no-operation (NOP) logger implementation

SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.

Aug 26, 2018 8:47:53 AM org.apache.hadoop.util.NativeCodeLoader <clinit>

WARNING: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

The alias trustStoreAlias already exists!! Will try to delete first.

FOUND value of [interactive] field in the Class [org.apache.hadoop.security.alias.CredentialShell] = [true]

Deleting credential: trustStoreAlias from CredentialProvider: jceks://file/etc/ranger/admin/rangeradmin.jceks

trustStoreAlias has been successfully deleted.

org.apache.hadoop.security.alias.JavaKeyStoreProvider has been updated.

trustStoreAlias has been successfully created.

org.apache.hadoop.security.alias.JavaKeyStoreProvider has been updated.

2018-08-26 08:47:53,974 - File['/etc/ranger/admin/rangeradmin.jceks'] {'owner': 'ranger', 'group': 'ranger', 'mode': 0640}

2018-08-26 08:47:53,975 - XmlConfig['core-site.xml'] {'group': 'ranger', 'conf_dir': '/usr/hdp/current/ranger-admin/conf', 'mode': 0644, 'configuration_attributes': {u'final': {u'fs.defaultFS': u'true'}}, 'owner': 'ranger', 'configurations': ...}

2018-08-26 08:47:53,984 - Generating config: /usr/hdp/current/ranger-admin/conf/core-site.xml

2018-08-26 08:47:53,984 - File['/usr/hdp/current/ranger-admin/conf/core-site.xml'] {'owner': 'ranger', 'content': InlineTemplate(...), 'group': 'ranger', 'mode': 0644, 'encoding': 'UTF-8'}

2018-08-26 08:47:54,034 - Execute['ambari-python-wrap /usr/hdp/current/ranger-admin/db_setup.py -javapatch'] {'logoutput': True, 'environment': {'RANGER_ADMIN_HOME': u'/usr/hdp/current/ranger-admin', 'JAVA_HOME': u'/usr/lib/jvm/java'}, 'user': 'ranger'}

2018-08-26 08:47:54,434  [I] DB FLAVOR :POSTGRES

2018-08-26 08:47:54,434  [I] --------- Verifying Ranger DB connection ---------

2018-08-26 08:47:54,434  [I] Checking connection

2018-08-26 08:47:54,435  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "SELECT 1;"

2018-08-26 08:47:55,187  [I] connection success

2018-08-26 08:47:55,187  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and inst_by = 'Ranger 0.7.0.2.6.5.0-292' and active = 'Y';"

2018-08-26 08:47:55,960  [I] ----------------- Applying java patches ------------

2018-08-26 08:47:55,961  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10001' and active = 'Y';"

2018-08-26 08:47:56,742  [I] Java patch PatchPasswordEncryption_J10001 is already applied

2018-08-26 08:47:56,742  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10002' and active = 'Y';"

2018-08-26 08:47:57,534  [I] Java patch PatchMigration_J10002 is already applied

2018-08-26 08:47:57,534  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10003' and active = 'Y';"

2018-08-26 08:47:58,304  [I] Java patch PatchPersmissionModel_J10003 is already applied

2018-08-26 08:47:58,304  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10004' and active = 'Y';"

2018-08-26 08:47:59,030  [I] Java patch PatchForServiceVersionInfo_J10004 is already applied

2018-08-26 08:47:59,030  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10005' and active = 'Y';"

2018-08-26 08:47:59,807  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10005' and active = 'N';"

2018-08-26 08:48:00,534  [I] Java patch PatchTagModulePermission_J10005 is being applied by some other process

2018-08-26 08:50:00,624  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10005' and active = 'N';"

2018-08-26 08:50:01,707  [I] Java patch PatchTagModulePermission_J10005 is being applied by some other process

2018-08-26 08:52:01,807  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10005' and active = 'N';"

2018-08-26 08:52:03,038  [I] Java patch PatchTagModulePermission_J10005 is being applied by some other process

2018-08-26 08:54:03,134  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10005' and active = 'N';"

2018-08-26 08:54:04,197  [I] Java patch PatchTagModulePermission_J10005 is being applied by some other process

2018-08-26 08:56:04,280  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'J10005' and active = 'N';"

2018-08-26 08:56:05,161  [I] Java patch PatchTagModulePermission_J10005 is being applied by some other process
3 REPLIES 3
Highlighted

Re: HDP behind proxy - Ranger Admin doesn't start

@Jakub Igla

If timing out when performing this operation:

/usr/lib/jvm/java/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/postgresql-jdbc3.jar:/usr/hdp/current/ranger-admin/jisql/lib/ org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://some-db.postgres.database.azure.com:5432/ranger -u someuser@some-db -p '***' -noheader -trim -c \; -query "SELECT 1;"

This may indicate a connectivity problem with the postgres db. Have you tried running this command from ranger admin host shell? Perhaps you get some output that helps to understand what is failing. Another option is installing a postgres client and trying to connect from ranger admin host to the database to confirm if there are any issues to connect to database.

HTH

*** If you found this answer addressed your question, please take a moment to login and click the "accept" link on the answer.

Re: HDP behind proxy - Ranger Admin doesn't start

How many ranger admin instances are there? Looks like the install was triggered from more than one which caused this situation.

I would suggest the below.

-- Remove entry for PatchTagModulePermission_J10005 from x_db_version_h table

-- Start only one ranger admin instance (at least to isolate this issue).

-- Once the install is successful, you can start the other ranger admin instances.

*** If you found this answer addressed your question, please take a moment to login and click the "accept" link on the answer.

Highlighted

Re: HDP behind proxy - Ranger Admin doesn't start

Explorer

Hi guys. Thanks for your answers. It turned out, it was a postgres issue, which I still can't explain. Moved from the managed one to IaaS deployment. Thanks again.

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