octonary opened a new issue #14377: URL: https://github.com/apache/superset/issues/14377
I am getting the following error when I try to enable impersonation for a Presto database... An error occurred while fetching databases: "Connection failed, please check your connection settings" Impersonation was previously working before authentication was added to the Presto UI. I found a few other issues related to impersonation but they all appear to be closed or merged so I upgraded to the latest apache-superset version in hopes that these issues were all resolved. I am able to successfully add a database connection if the service account is using the same credentials as the currently logged in user so I thought this may be a similar issue to #7170. However, that issue yielded a 401 response whereas this issue clearly returns a 200 from Presto but then fails when trying to save the details to the superset metadata db. I am able to successfully add a database connection when impersonation is not enabled. I am also able to successfully test the connection with impersonation enabled but when I try and save, I get the error. The logs just show a 422 response... DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): presto_host:8443 DEBUG:urllib3.connectionpool:https://presto_host:8443 "POST /v1/statement HTTP/1.1" 200 606 DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): presto_host:8443 DEBUG:urllib3.connectionpool:https://presto_host:8443 "GET /v1/statement/queued/20210427_160205_00092_pvzh9/ya51b2c3a79a6fd2fb82589fdb1a4a5be888e1571/1 HTTP/1.1" 200 806 DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.put.error DEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.put.time | 98.71059656143188 INFO:werkzeug:10.90.0.229 - - [27/Apr/2021 10:02:05] "PUT /api/v1/database/3 HTTP/1.1" 422 - How to reproduce the bug: 1. Login to superset UI 2. Add a new database or modify an existing one 3. Check the "Impersonate Logged In User (Presto & Hive)" checkbox found in the EXTRA tab 4. Click the SAVE button 5. See the "Connection failed, please check your connection settings" error pop-up on the bottom right of the page Environment: * CentOS Linux release 7.6.1810 (Core) * Python 3.8.6 * apache-superset==1.1.0 * Starburst Presto 345-e.3 -- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
