DwijadasDey opened a new issue, #19639:
URL: https://github.com/apache/superset/issues/19639

   Hi
   I am unable to connect Trino coordinator using SSL/LDAP by using following 
configuration parameters.
   
   Basic->SQLALCHEMY URI*
   trino://trinouser1:[email protected]:8443/example/
   
   Advanced-> Security->Secure extra
   {
   "connect_args":{
   "auth": "ldap",
   "verify": "/u01/venv/lib/python3.8/site-packages/superset/trino.pem"
   }
   }
   ![Screenshot from 2022-04-10 
14-13-04](https://user-images.githubusercontent.com/12824049/162610146-25be1892-5c96-479f-9284-2961b5e71703.png)
   
   I am getting following error:
   ERROR: (builtins.AttributeError) 'str' object has no attribute 
'set_http_session'
   [SQL: SELECT version()]
   
   ![Screenshot from 2022-04-10 
14-14-33](https://user-images.githubusercontent.com/12824049/162610237-5f89cfcc-0f21-4436-ab7f-3f186d39a318.png)
   
   The debug logs contains following errors:
   
   ```
   [SupersetError(message="(builtins.AttributeError) 'str' object has no 
attribute 'set_http_session'\n[SQL: SELECT version()]", 
error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 
'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, 
extra={'engine_name': 'Trino', 'issue_codes': [{'code': 1002, 'message': 'Issue 
1002 - The database returned an unexpected error.'}]})]
   2022-04-10 
03:45:06,494:WARNING:superset.views.base:[SupersetError(message="(builtins.AttributeError)
 'str' object has no attribute 'set_http_session'\n[SQL: SELECT version()]", 
error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 
'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, 
extra={'engine_name': 'Trino', 'issue_codes': [{'code': 1002, 'message': 'Issue 
1002 - The database returned an unexpected error.'}]})]
   2022-04-10 03:45:06,496:INFO:werkzeug:172.16.10.87 - - [10/Apr/2022 
03:45:06] "POST /api/v1/database/test_connection HTTP/1.0" 422 -
   ```
   I have installed pyhive library for trino:
   `pip3 install 'pyhive[trino]'
   `
   There is no issue while connecting Trino coordinator in SSL mode.
   `curl -v --cacert trino.pem  
https://trinouser1:[email protected]:8443
   `
   Shall i need to pass some other parameters in Other->ENGINE PARAMETERS in 
connection settings ?
   
   Thanks
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to