You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Bolke de Bruin (JIRA)" <ji...@apache.org> on 2019/03/31 19:18:00 UTC
[jira] [Commented] (RANGER-2352) Ranger installation is failing for
Oracle and Postgres DB
[ https://issues.apache.org/jira/browse/RANGER-2352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16806245#comment-16806245 ]
Bolke de Bruin commented on RANGER-2352:
----------------------------------------
Is this really resolved [~pradeep.agrawal]? Trying to install Ranger from master gives me an endless loop on Postgres:
{code:java}
2019-03-31 21:16:32,390 [I] Importing DB schema to database ranger from file: xa_core_db_postgres.sql
2019-03-31 21:16:32,390 [JISQL] /Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/Home/bin/java -cp /tmp/postgresql-42.2.1.jar:/private/tmp/ranger-2.0.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://localhost/ranger -u ranger -p '********' -noheader -trim -c \; -input /private/tmp/ranger-2.0.0-SNAPSHOT-admin/db/postgres/xa_core_db_postgres.sql
2019-03-31 21:16:33,197 [I] xa_core_db_postgres.sql file imported successfully
2019-03-31 21:16:33,197 [JISQL] /Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/Home/bin/java -cp /tmp/postgresql-42.2.1.jar:/private/tmp/ranger-2.0.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://localhost/ranger -u ranger -p '********' -noheader -trim -c \; -query "update x_db_version_h set inst_by='Ranger 2.0.0-SNAPSHOT' where active='Y' and updated_by='localhost';"
2019-03-31 21:16:33,488 [I] Patches status entries updated from base ranger version to current installed ranger version:Ranger 2.0.0-SNAPSHOT
2019-03-31 21:16:33,488 [JISQL] /Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/Home/bin/java -cp /tmp/postgresql-42.2.1.jar:/private/tmp/ranger-2.0.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://localhost/ranger -u ranger -p '********' -noheader -trim -c \; -query "select * from (select table_name from information_schema.tables where table_catalog='ranger' and table_name = 'x_portal_user') as temp;"
2019-03-31 21:16:33,739 [I] Table x_portal_user already exists in database 'ranger'
2019-03-31 21:16:33,740 [JISQL] /Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/Home/bin/java -cp /tmp/postgresql-42.2.1.jar:/private/tmp/ranger-2.0.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://localhost/ranger -u ranger -p '********' -noheader -trim -c \; -query "select * from (select table_name from information_schema.tables where table_catalog='ranger' and table_name = 'x_policy_ref_group') as temp;"
2019-03-31 21:16:34,022 [I] Table x_policy_ref_group does not exist in database ranger
2019-03-31 21:16:34,023 [JISQL] /Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/Home/bin/java -cp /tmp/postgresql-42.2.1.jar:/private/tmp/ranger-2.0.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://localhost/ranger -u ranger -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DB_PATCHES' and active = 'Y';"
2019-03-31 21:16:34,296 [JISQL] /Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/Home/bin/java -cp /tmp/postgresql-42.2.1.jar:/private/tmp/ranger-2.0.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://localhost/ranger -u ranger -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and active = 'Y';"
2019-03-31 21:16:34,611 [I] Importing DB schema to database ranger from file: xa_core_db_postgres.sql
2019-03-31 21:16:34,612 [JISQL] /Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/Home/bin/java -cp /tmp/postgresql-42.2.1.jar:/private/tmp/ranger-2.0.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://localhost/ranger -u ranger -p '********' -noheader -trim -c \; -input /private/tmp/ranger-2.0.0-SNAPSHOT-admin/db/postgres/xa_core_db_postgres.sql
2019-03-31 21:16:35,530 [I] xa_core_db_postgres.sql file imported successfully{code}
> Ranger installation is failing for Oracle and Postgres DB
> ---------------------------------------------------------
>
> Key: RANGER-2352
> URL: https://issues.apache.org/jira/browse/RANGER-2352
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Affects Versions: 2.0.0
> Reporter: Pradeep Agrawal
> Assignee: Pradeep Agrawal
> Priority: Blocker
> Fix For: 2.0.0
>
> Attachments: 0002-RANGER-2352-Ranger-installation-is-failing-for-Oracl.patch
>
>
> Ranger installation is failing for Oracle and Postgres DB after RANGER-2341 [commit|https://github.com/apache/ranger/commit/0f229b01e23b12d0c9e0c4ee3de817ce80d68a17#diff-efb49ec629fa12d2e5c69d37527d2984]
> It seems RANGER-2327 commits are reverted by mistake while merging code of RANGER-2341.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)