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.

In which mysql databases ( and table) does usersync process will store LDAP / AD username information?

Solved Go to solution

In which mysql databases ( and table) does usersync process will store LDAP / AD username information?

New Contributor

Hi ,

I am using mysql databse from Ranger .

As Standard user name / database name : ranger / ranger & rangerlogger / ranger_audit

In which databases ( and table) does usersync process will store LDAP / AD username information?

Thanks

JJ

1 ACCEPTED SOLUTION

Accepted Solutions

Re: In which mysql databases ( and table) does usersync process will store LDAP / AD username information?

Super Mentor

@Jacqualin jasmin

Are you looking out for the 'ranger' database table 'x_portal_user'

As per : https://cwiki.apache.org/confluence/display/RANGER/Ranger+0.5.0+Database+Schema

This table contains user profile and credentials of Ranger Admin users. 
It also contains users synced from external sources but credentials are 
not stored and password field contains garbage value. Important 
attributes of this table are login_id, password, email, status and 
user_src. 'user_src' field value ‘0’ represents internal user while ‘1’ 
represents external user. External users are users synced from external 
sources i.e  (UNIX / LDAP / AD).

.

1 REPLY 1

Re: In which mysql databases ( and table) does usersync process will store LDAP / AD username information?

Super Mentor

@Jacqualin jasmin

Are you looking out for the 'ranger' database table 'x_portal_user'

As per : https://cwiki.apache.org/confluence/display/RANGER/Ranger+0.5.0+Database+Schema

This table contains user profile and credentials of Ranger Admin users. 
It also contains users synced from external sources but credentials are 
not stored and password field contains garbage value. Important 
attributes of this table are login_id, password, email, status and 
user_src. 'user_src' field value ‘0’ represents internal user while ‘1’ 
represents external user. External users are users synced from external 
sources i.e  (UNIX / LDAP / AD).

.

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