You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/04/10 08:59:44 UTC
[GitHub] [superset] DwijadasDey opened a new issue, #19639: Unable to connect Trino coordinator using SSL/LDAP
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:password123@application.mydomain.net:8443/example/
Advanced-> Security->Secure extra
{
"connect_args":{
"auth": "ldap",
"verify": "/u01/venv/lib/python3.8/site-packages/superset/trino.pem"
}
}
I am getting following error:
ERROR: (builtins.AttributeError) 'str' object has no attribute 'set_http_session'
[SQL: SELECT version()]
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:password123@application.mydomain.net: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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] Dwijad commented on issue #19639: Unable to connect Trino coordinator using SSL/LDAP
Posted by "Dwijad (via GitHub)" <gi...@apache.org>.
Dwijad commented on issue #19639:
URL: https://github.com/apache/superset/issues/19639#issuecomment-1668831227
Hi, I donot have Apache Superset > 2.1.0 running in my dev environment at this moment ! What i can suggest, Try to connect Trino using SSL from CLI using curl and if it succeeds then try to connect it from Superset. While connecting from Superset, get as much debug information from superset logs to pinpoint the issues.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] istiyaksiddiquee commented on issue #19639: Unable to connect Trino coordinator using SSL/LDAP
Posted by "istiyaksiddiquee (via GitHub)" <gi...@apache.org>.
istiyaksiddiquee commented on issue #19639:
URL: https://github.com/apache/superset/issues/19639#issuecomment-1668499812
Hi, I am getting the same issue with latest version of trino (>2.1.0). Any resolution?
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] DwijadasDey closed issue #19639: Unable to connect Trino coordinator using SSL/LDAP
Posted by GitBox <gi...@apache.org>.
DwijadasDey closed issue #19639: Unable to connect Trino coordinator using SSL/LDAP
URL: https://github.com/apache/superset/issues/19639
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] DwijadasDey commented on issue #19639: Unable to connect Trino coordinator using SSL/LDAP
Posted by GitBox <gi...@apache.org>.
DwijadasDey commented on issue #19639:
URL: https://github.com/apache/superset/issues/19639#issuecomment-1094829034
I need to add "http_scheme": "https" in connect_args parameter in the secure extra section to make it work!
```
{
"connect_args":{
"http_scheme": "https",
"port": "8443",
"verify": "/u01/venv/lib/python3.8/site-packages/superset/trino.pem"
}
}
```
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] lipan1024 commented on issue #19639: Unable to connect Trino coordinator using SSL/LDAP
Posted by GitBox <gi...@apache.org>.
lipan1024 commented on issue #19639:
URL: https://github.com/apache/superset/issues/19639#issuecomment-1168126238
`{
"connect_args":{
"http_scheme": "https",
"verify": false
}
}`
It worked fine when I used version 1.4.1.
When I upgraded superset to version 1.5.1, the same configuration error was reported...
`ERROR: HTTPSConnectionPool(host='xxx', port=xxx): Max retries exceeded with url: /v1/statement (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:1131)')))`
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org