[
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)
