i try to connect to a Cloudera 5.13 kerberizada from a bi tool (microstrategy) with an odbc Impala 220.127.116.119, using delegated user, and recieve this error Impala ODBC server returned error for request OpenSession.Status Code : ERROR_STATUS.Error message User xxx is not authorized to delegate to yyy.
¿does anyone know why?
This looks like IMPALA-6973, Impala is checking 'auth_to_local' for the user authentication but not for the delegated user. As per the JIRA the workaround is to use uppercase when specifying the <user allowed to delegate> for Impala.
What do you think?
it is not the problem since in both configurations (AD and Impal) the user xxx is in lowercase. another clue?
Yes , the configuration was made according to the microstrategy documentation, there is something different that you know about that??
This is the current value in the Impala Daemon's Web UI /varz page
there is more than one user configured.
In the documentation of Configuring Impala Delegation for Hue and BI Tools
found this comment :
Thank's for you'r help