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.

Cloudera Altus - create CM with existing postgre DB

Solved Go to solution
Highlighted

Cloudera Altus - create CM with existing postgre DB

Master Collaborator

Hi Cloudera,

 the cloudera altus director cannot create a database(s) for CM and throws this error, even if it has a root user access to the external AWS RDS posgre database:

 

 

 

org.postgresql.util.PSQLException: ERROR: must be member of role "cmadmin_dkndwlxo"

 

 

I could not find any hint in the docs what this exact role means and why the root user must be member of this role.

Postgre error log:

 

 

2019-11-25 11:07:06 UTC:10.150.1.7(43878):dbroot@postgres:[12215]:ERROR: must be member of role "cmadmin_dkndwlxo"
2019-11-25 11:07:06 UTC:10.150.1.7(43878):dbroot@postgres:[12215]:STATEMENT: create database scm_75ilop0jdikuhinujsfs7l5m1n owner cmadmin_dkndwlxo encoding 'UTF8'
2019-11-25 11:07:17 UTC:10.150.1.7(43880):dbroot@postgres:[12313]:ERROR: must be member of role "cmadmin_wrhjespw"
2019-11-25 11:07:17 UTC:10.150.1.7(43880):dbroot@postgres:[12313]:STATEMENT: create database scm_38kegs9qab7j5l6hgqo069h3am owner cmadmin_wrhjespw encoding 'UTF8'
2019-11-25 11:07:28 UTC:10.150.1.7(43882):dbroot@postgres:[12422]:ERROR: must be member of role "cmadmin_kfelwpnh"
2019-11-25 11:07:28 UTC:10.150.1.7(43882):dbroot@postgres:[12422]:STATEMENT: create database scm_5vrk2jc93r9h4nq9n87c3majfp owner cmadmin_kfelwpnh encoding 'UTF8'
2019-11-25 11:07:48 UTC:10.150.1.7(43884):dbroot@postgres:[12703]:ERROR: must be member of role "cmadmin_xxyehrrb"
2019-11-25 11:07:48 UTC:10.150.1.7(43884):dbroot@postgres:[12703]:STATEMENT: create database scm_fprfmbk5dq8n7n659594goeukg owner cmadmin_xxyehrrb encoding 'UTF8'
2019-11-25 11:08:19 UTC:10.150.1.7(43886):dbroot@postgres:[13017]:ERROR: must be member of role "cmadmin_qgathjfw"
2019-11-25 11:08:19 UTC:10.150.1.7(43886):dbroot@postgres:[13017]:STATEMENT: create database scm_fo6j4rn05hdlrid3g0l584urjs owner cmadmin_qgathjfw encoding 'UTF8'

 

 

 

Postgre users:

 

test=> \du
                                    List of roles
    Role name     |                   Attributes                   |    Member of
------------------+------------------------------------------------+-----------------
 cmadmin_dkndwlxo |                                                | {}
 cmadmin_kfelwpnh |                                                | {}
 cmadmin_qgathjfw |                                                | {}
 cmadmin_wrhjespw |                                                | {}
 cmadmin_xxyehrrb |                                                | {}
 dbroot           | Create role, Create DB                        +| {rds_superuser}
                  | Password valid until infinity                  |

 

 

Any hints?

Thanks 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Cloudera Altus - create CM with existing postgre DB

Master Collaborator

It looks like the java class com.cloudera.enterprise.dbutil.DbProvisioner expects that the user has superuser privilege on the PosgreSQL and thus the Create DB and Create Role is not enough (AWS RDS unfortunately does not provide superuser).

 

 

I had to workaround the issue by creating the databases upfront. 

 

1 REPLY 1

Re: Cloudera Altus - create CM with existing postgre DB

Master Collaborator

It looks like the java class com.cloudera.enterprise.dbutil.DbProvisioner expects that the user has superuser privilege on the PosgreSQL and thus the Create DB and Create Role is not enough (AWS RDS unfortunately does not provide superuser).

 

 

I had to workaround the issue by creating the databases upfront. 

 

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