Re.
I tried to debug a little bit and find the command which was launched :
###
java -cp
/usr/share/java/postgresql.jar:/usr/hdp/2.3.2.0-2950/ranger-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://
inbdfrg01.rouen.francetelecom.fr/audit -u ranger_audit -p <MDP> -noheader
-trim -c \; -input
/usr/hdp/current/ranger-admin/db/postgres/xa_audit_db_postgres.sql
###
And when I launched it manually by using the ranger_audit user (the owner
of the audit database), it worked fine.
But then by beginning again the installation of ranger admin, a new error
appears :
###
2016-05-10 11:08:00,381 [I] --------- Check table ---------
2016-05-10 11:08:00,381 [I] Verifying table xa_access_audit in database audit
2016-05-10 11:08:00,633 [I] Table xa_access_audit already exists in
database audit
2016-05-10 11:08:00,633 [I] Granting permission to ranger_audit
2016-05-10 11:08:00,633 [I] Granting select and usage privileges to
Postgres audit user 'ranger_audit' on XA_ACCESS_AUDIT_SEQ
SQLException : SQL state: 42P01 org.postgresql.util.PSQLException:
ERROR: relation "xa_access_audit_seq" does not exist ErrorCode: 0
SQLException : SQL state: 42P01 org.postgresql.util.PSQLException:
ERROR: relation "xa_access_audit_seq" does not exist ErrorCode: 0
2016-05-10 11:08:00,871 [E] Granting select privileges to Postgres
user 'ranger_audit' failed
###
And when I check if this sequence exists, it exists indeed in the audit db :
###
audit=# \dp
Access privileges
Schema | Name | Type | Access privileges |
Column access privileges
--------+---------------------+----------+-------------------------------+--------------------------
public | pg_stat_statements | view | postgres=arwdDxt/postgres +|
| | | ranger_audit=arwdDxt/postgres +|
| | | =r/postgres |
public | xa_access_audit | table |
ranger_audit=arwdDxt/ranger_audit+|
public | xa_access_audit_seq | sequence | ranger_audit=rwU/ranger_audit
+|
###
I'm wondering, which user does ranger used perform this query ? The
ranger_admin user or the ranger_audit user ?
Maybe I should make the ranger_admin the owner of the audit database ?
Maybe I should use only one user for both databases ?
Best regards.
Lune
On Tue, May 10, 2016 at 10:36 AM, Lune Silver <[email protected]>
wrote:
> Hello !
>
> I'm trying to install Ranger Admin with Ambari 2.2.1 and I got the
> following exception during the installation :
> ###
>
> 2016-05-10 10:25:47,952 - Execute['python
> /usr/hdp/current/ranger-admin/db_setup.py'] {'logoutput': True,
> 'environment': {'RANGER_ADMIN_HOME': '/usr/hdp/current/ranger-admin',
> 'JAVA_HOME': '/usr/lib/jvm/jre-1.7.0-openjdk.x86_64'}, 'user': 'ranger'}
> 2016-05-10 10:25:48,081 [I] DB FLAVOR :POSTGRES
> 2016-05-10 10:25:48,081 [I] --------- Verifying Ranger DB connection
> ---------
> 2016-05-10 10:25:48,081 [I] Checking connection
> 2016-05-10 10:25:48,332 [I] connection success
> 2016-05-10 10:25:48,332 [I] --------- Verifying Ranger DB tables ---------
> 2016-05-10 10:25:48,332 [I] Verifying table x_portal_user in database ranger
> 2016-05-10 10:25:48,583 [I] Table x_portal_user already exists in database
> ranger
> 2016-05-10 10:25:48,583 [I] --------- Verifying upgrade history table
> ---------
> 2016-05-10 10:25:48,583 [I] Verifying table x_db_version_h in database ranger
> 2016-05-10 10:25:48,834 [I] Table x_db_version_h already exists in database
> ranger
> 2016-05-10 10:25:48,834 [I] --------- Applying Ranger DB patches ---------
> 2016-05-10 10:25:48,834 [I] No patches to apply!
> 2016-05-10 10:25:48,835 [I] --------- Starting Audit Operation ---------
> 2016-05-10 10:25:48,835 [I] --------- Check admin user connection ---------
> 2016-05-10 10:25:48,835 [I] Checking connection
> 2016-05-10 10:25:49,080 [I] connection success
> 2016-05-10 10:25:49,081 [I] --------- Check audit user connection ---------
> 2016-05-10 10:25:49,081 [I] Checking connection
> 2016-05-10 10:25:49,327 [I] connection success
> 2016-05-10 10:25:49,327 [I] --------- Check table ---------
> 2016-05-10 10:25:49,327 [I] Verifying table xa_access_audit in database audit
> 2016-05-10 10:25:49,575 [I] Table xa_access_audit does not exist in database
> audit
> 2016-05-10 10:25:49,576 [I] Importing db schema to database audit from file:
> xa_audit_db_postgres.sql
> SQLException : SQL state: 3F000 org.postgresql.util.PSQLException: ERROR: no
> schema has been selected to create in ErrorCode: 0
> SQLException : SQL state: 3F000 org.postgresql.util.PSQLException: ERROR: no
> schema has been selected to create in ErrorCode: 0
> 2016-05-10 10:25:49,813 [E] xa_audit_db_postgres.sql DB schema import failed!
>
> ###
>
> I tried to find the file xa_audit_db_postgres.sql on the future ranger
> host and on the ambari-server without success.
>
> Concerning my configuration, I specified to create DB and users to ranger.
> I set up the following parameter to No.
>
> Setup Database and Database User
>
> No
>
> Because I already created the database and the database users and properly
> configured the connection of the users through the pg_hba.conf.
>
> Do you know what is the problem here ?
>
> Best regards.
>
> Lune.
>
