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 2020/04/15 13:14:17 UTC
[GitHub] [incubator-superset] elukey opened a new issue #9543: Unknown error
returned when a Alpha user tries to use Sqllab
elukey opened a new issue #9543: Unknown error returned when a Alpha user tries to use Sqllab
URL: https://github.com/apache/incubator-superset/issues/9543
Hi!
I have recently tried to debug why users where not able to use Presto (configured as database via sql alchemy) in Sqllab. They reported an "Unknown error" reported as big red box when accessing the Sqllab. I discovered later on that this was due to the absence of the sqllab role, but I think that the error message should be more clear (like "you don't have permissions to do this etc..".
Also, I see that Alpha has a lot of permissions for the Sqllab (listed in the role definition), but the most important ones are missing to allow users to query data. I get why one would want to selectively allow access to sqllab and not grant it by default, but wouldn't it be better all or nothing?
For example, the sqllab role in my Superset allows:
can search queries on Superset,
can sql json on Superset,
can csv on Superset,
menu access on SQL Lab,
can sqllab on Superset,
can sqllab viz on Superset,
menu access on SQL Editor,
menu access on Query Search,
menu access on Saved Queries,
can list on UserDBModelView,
can list on UserRemoteUserModelView
And only the following are not in Alpha:
can sql json on Superset
menu access on SQL Lab
can list on UserDBModelView
can list on UserRemoteUserModelView
### Expected results
A clear error about permissions, that leads an admin to the proper debugging.
### Actual results
A general "Unknown error" is displayed, without any trace of it in the logs (to gather further info).
#### Screenshots
If applicable, add screenshots to help explain your problem.
#### How to reproduce the bug
1. Alpha user goes to the Sqllab
2. Alpha user tries to use any database, getting Unknown Error
### Environment
(please complete the following information):
- superset version: latest
### Checklist
Make sure these boxes are checked before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] elukey edited a comment on issue #9543:
Unknown error returned when a Alpha user tries to use Sqllab
Posted by GitBox <gi...@apache.org>.
elukey edited a comment on issue #9543: Unknown error returned when a Alpha user tries to use Sqllab
URL: https://github.com/apache/incubator-superset/issues/9543#issuecomment-614056984
In the JS console I see the following:
```
Failed to load resource: the server responded with a status of 401 (UNAUTHORIZED)
```
from sql_json/:1
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] elukey commented on issue #9543: Unknown error
returned when a Alpha user tries to use Sqllab
Posted by GitBox <gi...@apache.org>.
elukey commented on issue #9543: Unknown error returned when a Alpha user tries to use Sqllab
URL: https://github.com/apache/incubator-superset/issues/9543#issuecomment-614056984
In the JS console I see the following:
```
Failed to load resource: the server responded with a status of 401 (UNAUTHORIZED)
```
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] elukey commented on issue #9543: Unknown error returned when a Alpha user tries to use Sqllab
Posted by GitBox <gi...@apache.org>.
elukey commented on issue #9543:
URL: https://github.com/apache/incubator-superset/issues/9543#issuecomment-697334398
For me the issue was fixed simply adding `menu access on SQL Lab` and `menu access on SQL Lab` to the Alpha permssions.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] commented on issue #9543: Unknown error returned when a Alpha user tries to use Sqllab
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9543:
URL: https://github.com/apache/incubator-superset/issues/9543#issuecomment-643785272
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] gauravencoded commented on issue #9543: Unknown error returned when a Alpha user tries to use Sqllab
Posted by GitBox <gi...@apache.org>.
gauravencoded commented on issue #9543:
URL: https://github.com/apache/incubator-superset/issues/9543#issuecomment-697303531
I am facing similar issues I need urgent help
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] closed issue #9543: Unknown error returned when a Alpha user tries to use Sqllab
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #9543:
URL: https://github.com/apache/incubator-superset/issues/9543
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] DRavikanth commented on issue #9543: Unknown error returned when a Alpha user tries to use Sqllab
Posted by GitBox <gi...@apache.org>.
DRavikanth commented on issue #9543:
URL: https://github.com/apache/incubator-superset/issues/9543#issuecomment-701717241
So, you need to select all the needed database actions for Alpha role to avoid running into this problem. In my case, `can sql json on Superset` is not included for Alpha role, once added its all good.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org