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/02/17 14:43:46 UTC
[GitHub] [superset] aryeh98 opened a new issue #18785: cannot view Dashboards or Charts After Overriding SECRET_KEY with new value.
aryeh98 opened a new issue #18785:
URL: https://github.com/apache/superset/issues/18785
After updating my SECRET_KEY value and changing it from its default value,When I try to navigate to see the a dashboard or a chart,I get an error. It seems like superset isnt fetching any of the data
#### How to reproduce the bug
1)Update SECRET_KEY value
2) Run superset in DEV mode
### Expected results
Superset will fetch all the charts and dashboards, and Once I click on one of the dashboards or charts ,It will route me to them
### Actual results
When I click on a dashboard, it routes me to the dashboard page but it just shows an error message: ***Unexpected error***
When I click on a chart it takes me to a blank page with an error message:
```
{"errors": [{"message": "(sqlite3.OperationalError) no such column: slices.is_managed_externally\n[SQL: SELECT slices.uuid AS slices_uuid, slices.created_on AS slices_created_on, slices.changed_on AS slices_changed_on, slices.id AS slices_id, slices.slice_name AS slices_slice_name, slices.datasource_id AS slices_datasource_id, slices.datasource_type AS slices_datasource_type, slices.datasource_name AS slices_datasource_name, slices.viz_type AS slices_viz_type, slices.params AS slices_params, slices.query_context AS slices_query_context, slices.description AS slices_description, slices.cache_timeout AS slices_cache_timeout, slices.perm AS slices_perm, slices.schema_perm AS slices_schema_perm, slices.last_saved_at AS slices_last_saved_at, slices.last_saved_by_fk AS slices_last_saved_by_fk, slices.certified_by AS slices_certified_by, slices.certification_details AS slices_certification_details, slices.is_managed_externally AS slices_is_managed_externally, slices.external_url AS slice
s_external_url, slices.created_by_fk AS slices_created_by_fk, slices.changed_by_fk AS slices_changed_by_fk \nFROM slices \nWHERE slices.id = ?]\n[parameters: (130,)]\n(Background on this error at: http://sqlalche.me/e/13/e3q8)", "error_type": "GENERIC_BACKEND_ERROR", "level": "error", "extra": {"issue_codes": [{"code": 1011, "message": "Issue 1011 - Superset encountered an unexpected error."}]}}]}
```
#### Screenshots
### Environment
(please complete the following information):
- browser type and version:
- superset version: `Superset 0.0.0dev`
- python version: `Python 3.8.10`
- node.js version: `v16.13.1`
- any feature flags active:
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] 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.
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] villebro edited a comment on issue #18785: cannot view Dashboards or Charts After Overriding SECRET_KEY with new value.
Posted by GitBox <gi...@apache.org>.
villebro edited a comment on issue #18785:
URL: https://github.com/apache/superset/issues/18785#issuecomment-1047637465
Did you migrate the `SECRET_KEY` as instructed in `UPDATING.md` as per #17984?
> Default Flask SECRET_KEY has changed for security reasons. You should always override with your own secret. Set PREVIOUS_SECRET_KEY (ex: `PREVIOUS_SECRET_KEY = "\2\1thisismyscretkey\1\2\e\y\y\h"`) with your previous key and use superset re-encrypt-secrets to rotate you current secrets
In other words, adding this to your `superset_config.py (the `PREVIOUS_SECRET_KEY` really is a literal string, _not_ an example!):
```python
PREVIOUS_SECRET_KEY = "\2\1thisismyscretkey\1\2\e\y\y\h"
SECRET_KEY = "<my new secret key>"
```
and then running `superset re-encrypt-secrets`?
--
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] villebro edited a comment on issue #18785: cannot view Dashboards or Charts After Overriding SECRET_KEY with new value.
Posted by GitBox <gi...@apache.org>.
villebro edited a comment on issue #18785:
URL: https://github.com/apache/superset/issues/18785#issuecomment-1047637465
Did you migrate the `SECRET_KEY` as instructed in `UPDATING.md` as per #17984?
> Default Flask SECRET_KEY has changed for security reasons. You should always override with your own secret. Set PREVIOUS_SECRET_KEY (ex: `PREVIOUS_SECRET_KEY = "\2\1thisismyscretkey\1\2\e\y\y\h"`) with your previous key and use superset re-encrypt-secrets to rotate you current secrets
In other words, adding this to your `superset_config.py` (the `PREVIOUS_SECRET_KEY` really is a literal string, _not_ an example!):
```python
PREVIOUS_SECRET_KEY = "\2\1thisismyscretkey\1\2\e\y\y\h"
SECRET_KEY = "<my new secret key>"
```
and then running `superset re-encrypt-secrets`?
--
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] villebro commented on issue #18785: cannot view Dashboards or Charts After Overriding SECRET_KEY with new value.
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #18785:
URL: https://github.com/apache/superset/issues/18785#issuecomment-1047637465
Did you migrate the `SECRET_KEY` as instructed in `UPDATING.md` as per #17984?
> Default Flask SECRET_KEY has changed for security reasons. You should always override with your own secret. Set PREVIOUS_SECRET_KEY (ex: `PREVIOUS_SECRET_KEY = "\2\1thisismyscretkey\1\2\e\y\y\h"`) with your previous key and use superset re-encrypt-secrets to rotate you current secrets
In other words, adding this to your `superset_config.py:
```python
PREVIOUS_SECRET_KEY = "\2\1thisismyscretkey\1\2\e\y\y\h"
SECRET_KEY = "<my new secret key>"
```
and then running `superset re-encrypt-secrets`?
--
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] villebro closed issue #18785: cannot view Dashboards or Charts After Overriding SECRET_KEY with new value.
Posted by GitBox <gi...@apache.org>.
villebro closed issue #18785:
URL: https://github.com/apache/superset/issues/18785
--
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