You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "debimishra89 (via GitHub)" <gi...@apache.org> on 2023/02/03 09:21:58 UTC

[GitHub] [superset] debimishra89 opened a new issue, #22978: superset not able to connect to Trino with SSL+Keycloak

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

   A clear and concise description of what the bug is.
   
   #### How to reproduce the bug
   
   1. Go to superset UI
   2. Click on 'Data'. then "+" database
   3. choose Trino conection, put trino connection string, then click on 'test connection'
   4. See error: 'unauthorized'
   
   ### Expected results
   
   connection should be successful
   
   ### Actual results
   
   throwing error: 'unauthorized'
   
   #### Screenshots
   
   If applicable, add screenshots to help explain your problem.
   
   
   ### Environment
   
   (please complete the following information):
   
   - browser type and version: chrome
   - superset version: 1.4.2
   - python version: 3.8.10
   - node.js version: not installed
   
   ### Checklist
   
   
   Error logs from Superset:
   `[SupersetError(message="error 401: b'Unauthorized'", 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.'}]})]
   2023-02-03 17:17:48,221:WARNING:superset.views.base:[SupersetError(message="error 401: b'Unauthorized'", 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.'}]})]
   2023-02-03 17:17:48,223:INFO:werkzeug:10.10.1.26 - - [03/Feb/2023 17:17:48] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
   `
   Trino conection string used in superset:
   `trino://test124:xxxxxx@dasec-trino.dastc.stee.com:8081/postgresql`
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
   - [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
   
   ### Additional context
   
   FYI, I am able to access trino UI and query using trino CLI
   


-- 
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


Re: [I] superset not able to connect to Trino with SSL+Keycloak [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #22978: superset not able to connect to Trino with SSL+Keycloak
URL: https://github.com/apache/superset/issues/22978


-- 
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


Re: [I] superset not able to connect to Trino with SSL+Keycloak [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #22978:
URL: https://github.com/apache/superset/issues/22978#issuecomment-1947457861

   Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please re-open this issue, open a new Issue with updated context, or raise a PR to address the problem. 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

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