Hue with Impala "Enable LDAP Authentication" - TSocket read 0 bytes

[#1]

Hello guys,



1. When I enable the authentication on impala service 

2. I try to connect with impyla and I'm able to see data : 

from impala.dbapi import connect
conn = connect(host='w1.host.lan', database='db_grp1', port=21050, auth_mechanism="LDAP",user='user1', password="password1")

cursor = conn.cursor()
cursor.execute('select * from table1 ;')
results = cursor.fetchall()
print (results)

$ python3 test.py 
[(1, 'one'), (2, 'two'), (3, 'three')]

3. But on HUE I'm not able to retreieve data, if I disable the authentication, I can see again my table. (I have configured HUE to authenticate through LDAP and I'm able to authenticated successfully) 

Here is the error : 

Is that possible on HUE to "authenticate again" to impala to retrieve data ? 

Kind Regards

[#2]

Hi,

After you enabled LDAP for Impala, have you tried to do the same in Hue's configuration for Impala?

See below doc:
https://www.cloudera.com/documentation/enterprise/latest/topics/impala_ldap.html#ldap_impala_hue

Enabling LDAP for Impala in Hue
1. Go to the Hue service.
2. Click the Configuration tab.
3. Select Scope > Hue Server.
4. Select Category > Advanced.
5. Add the following properties to the Hue Server Advanced Configuration Snippet (Safety Valve) for hue_safety_valve_server.ini property.

[impala]
auth_username=<LDAP username of Hue user to be authenticated>
auth_password=<LDAP password of Hue user to be authenticated>

6. Click Save Changes.

Cheers
Eric