Abhijeetsinghjat commented on issue #23861: URL: https://github.com/apache/superset/issues/23861#issuecomment-1532948494
> > We haven't found any Content Security Policy (CSP) > > I don't see any error, CSP is a warning, you can understand it more by reading [https://superset.apache.org/docs/security/#content-security-policy-csp](url) > > Regarding Caching, it's another warning that you didn't configure any caching, I use redis on my ubuntu, setting it up is easy and on the official documentation you can configure it [https://superset.apache.org/docs/installation/cache](url) > > Anyway, your Superset works even with ignoring those two warnings, but it's preferable to setup a caching system, and it might be preferable to setup CSP in case your Superset will get public access. If I am ignoring the warning and running superset and adding any dataset I am getting below error: **for prop in class_mapper(obj).iterate_properties: Syncing role definition 2023-05-03 17:54:34,467:INFO:superset.security.manager:Syncing role definition Syncing Admin perms 2023-05-03 17:54:34,478:INFO:superset.security.manager:Syncing Admin perms Syncing Alpha perms 2023-05-03 17:54:34,582:INFO:superset.security.manager:Syncing Alpha perms Syncing Gamma perms 2023-05-03 17:54:34,713:INFO:superset.security.manager:Syncing Gamma perms Syncing granter perms 2023-05-03 17:54:34,854:INFO:superset.security.manager:Syncing granter perms Syncing sql_lab perms 2023-05-03 17:54:34,964:INFO:superset.security.manager:Syncing sql_lab perms Fetching a set of all perms to lookup which ones are missing 2023-05-03 17:54:35,059:INFO:superset.security.manager:Fetching a set of all perms to lookup which ones are missing Creating missing datasource permissions. 2023-05-03 17:54:35,173:INFO:superset.security.manager:Creating missing datasource permissions. Traceback (most recent call last): File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py", line 126, in decrypt decrypted = decrypted.decode('utf-8') UnicodeDecodeError: 'utf-8' codec can't decode byte 0x80 in position 0: invalid start byte During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/root/supersetvenv/bin/superset", line 8, in <module> sys.exit(superset()) File "/root/supersetvenv/lib/python3.10/site-packages/click/core.py", line 1130, in __call__ return self.main(*args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/flask/cli.py", line 567, in main return super().main(*args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/click/core.py", line 1055, in main rv = self.invoke(ctx) File "/root/supersetvenv/lib/python3.10/site-packages/click/core.py", line 1657, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/root/supersetvenv/lib/python3.10/site-packages/click/core.py", line 1404, in invoke return ctx.invoke(self.callback, **ctx.params) File "/root/supersetvenv/lib/python3.10/site-packages/click/core.py", line 760, in invoke return __callback(*args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/click/decorators.py", line 26, in new_func return f(get_current_context(), *args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/flask/cli.py", line 407, in decorator return __ctx.invoke(f, *args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/click/core.py", line 760, in invoke return __callback(*args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/click/decorators.py", line 26, in new_func return f(get_current_context(), *args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/flask/cli.py", line 407, in decorator return __ctx.invoke(f, *args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/click/core.py", line 760, in invoke return __callback(*args, **kwargs) File "/root/supersetvenv/lib/python3.10/site-packages/superset/cli/main.py", line 62, in init security_manager.sync_role_definitions() File "/root/supersetvenv/lib/python3.10/site-packages/superset/security/manager.py", line 802, in sync_role_definitions self.create_missing_perms() File "/root/supersetvenv/lib/python3.10/site-packages/superset/security/manager.py", line 750, in create_missing_perms merge_pv("datasource_access", datasource.get_perm()) File "/root/supersetvenv/lib/python3.10/site-packages/superset/connectors/sqla/models.py", line 720, in get_perm if self.database is None: File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ return self.impl.get(state, dict_) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get value = self._fire_loader_callables(state, key, passive) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables return self.callable_(state, passive) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state return self._emit_lazyload( File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 996, in _emit_lazyload return loading.load_on_pk_identity( File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 541, in load_on_pk_identity return result.one() File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1522, in one return self._only_one_row( File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 559, in _only_one_row row = onerow(hard_close=True) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1386, in _fetchone_impl return self._real_result._fetchone_impl(hard_close=hard_close) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1801, in _fetchone_impl row = next(self.iterator, _NO_ROW) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 147, in chunks fetch = cursor._raw_all_rows() File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 393, in _raw_all_rows return [make_row(row) for row in rows] File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 393, in <listcomp> return [make_row(row) for row in rows] File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy/sql/type_api.py", line 1712, in process return process_value(impl_processor(value), dialect) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py", line 479, in process_result_value value = super().process_result_value(value=value, dialect=dialect) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py", line 424, in process_result_value decrypted_value = self.engine.decrypt(value) File "/root/supersetvenv/lib/python3.10/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py", line 128, in decrypt raise ValueError('Invalid decryption key') ValueError: Invalid decryption key** -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
