Skip to content

Presto LDAP Issue #11359

@Asturias-sam

Description

@Asturias-sam

we need to integrate Presto with our Superset. We have enable LDAP from Presto Side.

So we configured the Database with our Admin user and selected Impersonate the logged on user on database setup page.

Currently only Admin is able to view schemas and tables other users are not able to view the data source we are getting this error on Superset:

sqlalchemy.exc.OperationalError: (pyhive.exc.OperationalError) Unexpected status code 401
b'Access Denied: Invalid credentials'
[SQL: SHOW SCHEMAS]
(Background on this error at: http://sqlalche.me/e/e3q8)

And From the Presto side we are getting this error:
Password validation failed for user DN [superset@homeoffice.domain.com]: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090453, comment: AcceptSecurityContext error, data 52e, v3839]

We have observed only the user which have created the datasource is able to query and other are not ?

So will Superset is submitting the same password which is provided in datasource for connection or we are missing something ?

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions