You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "Sdreamery (via GitHub)" <gi...@apache.org> on 2024/08/07 08:35:09 UTC
[I] The default URL generated by Dashboard has security risks! [superset]
Sdreamery opened a new issue, #29879:
URL: https://github.com/apache/superset/issues/29879
When Superset sets password free, there is a significant security risk in the default URL generated by Dashboard, as I found that when I reset the URL in Dashboard properties, the original default generated URL (number) can still be used. If someone who understands superset obtains an external address in this way, they may be able to test the dashboard address, such as xxx.com:/superset/dashboard/5/

--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2272930109
![Uploading 222.png…]()
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2274862039
> The dashboards are still accessible via their numeric ID because the `DashboardDAO` class includes a method `get_by_id_or_slug` that allows access by either the numeric ID or the custom URL slug. This method is used in various places to fetch dashboards, which means both IDs and slugs are supported for accessing dashboards.
>
> To ensure that only the custom URL slugs are used for accessing dashboards, you need to modify the `get_by_id_or_slug` method to only use the slug. Here is how you can do it:
>
> 1. **Modify the `get_by_id_or_slug` method**:
> ```python
> @classmethod
> def get_by_slug(cls, slug: str) -> Dashboard:
> query = (
> db.session.query(Dashboard)
> .filter(Dashboard.slug == slug)
> .outerjoin(Dashboard.owners)
> .outerjoin(Dashboard.roles)
> )
> # Apply dashboard base filters
> query = cls.base_filter("id", SQLAInterface(Dashboard, db.session)).apply(
> query, None
> )
> dashboard = query.one_or_none()
> if not dashboard:
> raise DashboardNotFoundError()
>
> # make sure we still have basic access check from security manager
> try:
> dashboard.raise_for_access()
> except SupersetSecurityException as ex:
> raise DashboardAccessDeniedError() from ex
>
> return dashboard
> ```
> 2. **Update all references to `get_by_id_or_slug`**:
> Replace all calls to `DashboardDAO.get_by_id_or_slug` with `DashboardDAO.get_by_slug` in the codebase to ensure that dashboards are only accessed via their custom URL slugs.
> 3. **Update tests to ensure compliance**:
> Modify the test cases to ensure that dashboards are accessed only via slugs. For example, in the `tests/integration_tests/dashboards/api_tests.py` file, update the test cases to use slugs instead of numeric IDs:
> ```python
> @pytest.mark.usefixtures("create_dashboards")
> def test_get_dashboard_charts_by_slug(self):
> """
> Dashboard API: Test getting charts belonging to a dashboard
> """
> self.login(ADMIN_USERNAME)
> dashboard = self.dashboards[0]
> uri = f"api/v1/dashboard/{dashboard.slug}/charts"
> response = self.get_assert_metric(uri, "get_charts")
> self.assertEqual(response.status_code, 200)
> data = json.loads(response.data.decode("utf-8"))
> self.assertEqual(len(data["result"]), 1)
> self.assertEqual(
> data["result"][0]["slice_name"], dashboard.slices[0].slice_name
> )
> ```
>
> By making these changes, you ensure that dashboards can only be accessed via their custom URL slugs and not by their numeric IDs [[1]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)[[2]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)[[3]](https://github.com/apache/superset/blob/master/tests/integration_tests/dashboards/api_tests.py).
>
> _To continue talking to [Dosu](https://dosu.dev), mention @dosu._
Through the method you provided, I found that the method that controls URL access is the DashboardDAO.get-by_id_or_slug method in the file dashboards/api.py

Following your instructions to modify it to Dashboard DAO.get-by_slug did indeed solve the problem of prohibiting Dashboard ID access, but it also resulted in two bugs.
The first newly created dashboard opens with an error because the ID was used by default when creating the dashboard, as shown in the figure:

The second dashboard that has already set slug will encounter an error when opening the property settings, as shown in the figure:

So I think the UBG here is either Superset or the default ID used. If we can modify it to use UUID, wouldn't that solve this problem? UUID is a 16 bit random code that is unique like ID. If Superset can default to using UUID as the URL for accessing the dashboard, security can also be guaranteed.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-3073178609
The PR is awaiting a rebase, but I'm optimistic we can ge that through finally and close this one out!
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275066899
After only performing the first and second steps, there are still two issues. The first is that although the URL displayed when opening the created Dashboard is uuid, clicking on Dashboard properties will result in an error, as shown in the figure:

The second issue is that there is an error when creating a new dashboard, and checking the URL shows that the new dashboard will still use the ID as the URL, as shown in the figure:

--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "sadpandajoe (via GitHub)" <gi...@apache.org>.
sadpandajoe commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-3202241499
PR is merged.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2274568894
> It's true that the "slug" is effectively an alias for the dashboard. All dashboards have a numeric ID in their URL by default. I'm not sure if being able to access a dashboard using Superset's default URL scheme is a security risk.
>
> That said, there are proposals floating around to move from these numeric IDs to UUIDs for the default dashboard paths. I assume the "slug" would still effectively be an alias to the UUID, so I'm not sure if that solves your problem.
>
> If you do see this (or anything else) as a true security vulnerability, it should be reported to [security@superset.apache.org](mailto:security@superset.apache.org) rather than posted as a public issue.
>
> I'll CC @dpgaspar for context on the security point, as well as @villebro and @michael-s-molina who have quite a bit of context in permalinks/aliases in Superset.
Yes, I have already reported it to the security@superset.apache.org @superset.apache.org
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275225027
> To ensure that Apache Superset uses UUIDs as the default for dashboard URLs instead of numeric IDs, you need to make sure that the UUIDs are correctly utilized in the URL generation and access logic. Since the `uuid` field already exists in the `dashboards` table, you can focus on updating the URL handling and access methods.
>
> Here’s a step-by-step guide to achieve this:
>
> 1. **Update the URL Generation Logic**:
> Modify the `Dashboard` model to use the UUID for generating URLs.
> 2. **Modify the Access Methods**:
> Update the `DashboardDAO` class to prioritize UUIDs when accessing dashboards.
> 3. **Ensure UUIDs are Used in the Frontend**:
> Update the frontend components to use UUIDs in the URLs.
>
> ### Step 1: Update the URL Generation Logic
> Modify the `Dashboard` model in `superset/models/dashboard.py` to use the UUID for generating URLs:
>
> ```python
> from sqlalchemy_utils import UUIDType
> from uuid import uuid4
>
> class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
> __tablename__ = "dashboards"
> id = Column(Integer, primary_key=True)
> uuid = Column(UUIDType(binary=True), unique=True, default=uuid4)
> dashboard_title = Column(String(500))
> # other fields...
>
> def __repr__(self) -> str:
> return f"Dashboard<{self.uuid}>"
>
> @property
> def url(self) -> str:
> return f"/superset/dashboard/{self.uuid}/"
>
> @staticmethod
> def get_url(uuid_: str) -> str:
> return f"/superset/dashboard/{uuid_}/"
> ```
>
> ### Step 2: Modify the Access Methods
> Update the `DashboardDAO` class in `superset/daos/dashboard.py` to prioritize UUIDs:
>
> ```python
> from superset.models.dashboard import Dashboard
> from superset.exceptions import DashboardNotFoundError, DashboardAccessDeniedError
> from superset.security import SupersetSecurityException
> from superset import db, security_manager
> from sqlalchemy.orm import joinedload
> import uuid
>
> class DashboardDAO(BaseDAO[Dashboard]):
> base_filter = DashboardAccessFilter
>
> @classmethod
> def get_by_id_or_slug(cls, id_or_slug: str) -> Dashboard:
> if cls.is_uuid(id_or_slug):
> dashboard = db.session.query(Dashboard).filter_by(uuid=id_or_slug).one_or_none()
> else:
> dashboard = db.session.query(Dashboard).filter_by(slug=id_or_slug).one_or_none()
>
> if not dashboard:
> raise DashboardNotFoundError()
>
> try:
> dashboard.raise_for_access()
> except SupersetSecurityException as ex:
> raise DashboardAccessDeniedError() from ex
>
> return dashboard
>
> @staticmethod
> def is_uuid(value: str) -> bool:
> try:
> uuid.UUID(str(value))
> return True
> except ValueError:
> return False
> ```
>
> ### Step 3: Ensure UUIDs are Used in the Frontend
> Update the frontend components to use UUIDs in the URLs. For example, in the `DashboardPage` component, ensure that the URLs are generated using UUIDs:
>
> ```tsx
> import React, { useEffect } from 'react';
> import { useHistory } from 'react-router-dom';
> import { useDashboard } from 'src/hooks/apiResources';
>
> const DashboardPage: React.FC<{ idOrSlug: string }> = ({ idOrSlug }) => {
> const history = useHistory();
> const { result: dashboard } = useDashboard(idOrSlug);
> const { uuid } = dashboard || {};
>
> useEffect(() => {
> if (uuid && window.location.pathname !== `/superset/dashboard/${uuid}/`) {
> history.replace(`/superset/dashboard/${uuid}/`);
> }
> }, [history, uuid]);
>
> // ... rest of the component code
> };
> ```
>
> ### Additional Considerations
> * **Database Schema**: Ensure that the `uuid` field in the `dashboards` table is indexed and unique.
> * **Migration Scripts**: If necessary, create migration scripts to add the `uuid` field to existing dashboards and populate it with values.
>
> By following these steps, you can ensure that Apache Superset uses UUIDs as the default for dashboard URLs, enhancing security and avoiding the use of predictable numeric IDs [[1]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)[[2]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)[[3]](https://github.com/apache/superset/blob/master/superset/commands/dashboard/importers/v1/utils.py).
>
> _To continue talking to [Dosu](https://dosu.dev), mention @dosu._
After following the first two steps to modify the source code, there are several serious issues;
Firstly, an exception is displayed when creating a new dashboard. From the URL of the dashboard page, it can be seen that Superset actually used the ID field instead of uuid.

Secondly, an error message pops up when opening Dashboard properties.

Thirdly, URLs composed of uuids cannot be accessed.

--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2274574923
> > It should not still be accessible. At this point, only custom new links can be accessed.
>
> @Sdreamery I don't think this is correct. The slug is just an alias, it does not mean that users can't access the dashboard using its ID if an alias is defined.
Yes, but this ID has patterns to follow. Using this ID as a URL for public access does not pass the company's network security audit.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275008513
<!-- Answer -->
To ensure that Apache Superset uses UUIDs as the default for dashboard URLs instead of numeric IDs, you need to make sure that the UUIDs are correctly utilized in the URL generation and access logic. Since the `uuid` field already exists in the `dashboards` table, you can focus on updating the URL handling and access methods.
Here’s a step-by-step guide to achieve this:
1. **Update the URL Generation Logic**:
Modify the `Dashboard` model to use the UUID for generating URLs.
2. **Modify the Access Methods**:
Update the `DashboardDAO` class to prioritize UUIDs when accessing dashboards.
3. **Ensure UUIDs are Used in the Frontend**:
Update the frontend components to use UUIDs in the URLs.
### Step 1: Update the URL Generation Logic
Modify the `Dashboard` model in `superset/models/dashboard.py` to use the UUID for generating URLs:
```python
from sqlalchemy_utils import UUIDType
from uuid import uuid4
class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
__tablename__ = "dashboards"
id = Column(Integer, primary_key=True)
uuid = Column(UUIDType(binary=True), unique=True, default=uuid4)
dashboard_title = Column(String(500))
# other fields...
def __repr__(self) -> str:
return f"Dashboard<{self.uuid}>"
@property
def url(self) -> str:
return f"/superset/dashboard/{self.uuid}/"
@staticmethod
def get_url(uuid_: str) -> str:
return f"/superset/dashboard/{uuid_}/"
```
### Step 2: Modify the Access Methods
Update the `DashboardDAO` class in `superset/daos/dashboard.py` to prioritize UUIDs:
```python
from superset.models.dashboard import Dashboard
from superset.exceptions import DashboardNotFoundError, DashboardAccessDeniedError
from superset.security import SupersetSecurityException
from superset import db, security_manager
from sqlalchemy.orm import joinedload
import uuid
class DashboardDAO(BaseDAO[Dashboard]):
base_filter = DashboardAccessFilter
@classmethod
def get_by_id_or_slug(cls, id_or_slug: str) -> Dashboard:
if cls.is_uuid(id_or_slug):
dashboard = db.session.query(Dashboard).filter_by(uuid=id_or_slug).one_or_none()
else:
dashboard = db.session.query(Dashboard).filter_by(slug=id_or_slug).one_or_none()
if not dashboard:
raise DashboardNotFoundError()
try:
dashboard.raise_for_access()
except SupersetSecurityException as ex:
raise DashboardAccessDeniedError() from ex
return dashboard
@staticmethod
def is_uuid(value: str) -> bool:
try:
uuid.UUID(str(value))
return True
except ValueError:
return False
```
### Step 3: Ensure UUIDs are Used in the Frontend
Update the frontend components to use UUIDs in the URLs. For example, in the `DashboardPage` component, ensure that the URLs are generated using UUIDs:
```tsx
import React, { useEffect } from 'react';
import { useHistory } from 'react-router-dom';
import { useDashboard } from 'src/hooks/apiResources';
const DashboardPage: React.FC<{ idOrSlug: string }> = ({ idOrSlug }) => {
const history = useHistory();
const { result: dashboard } = useDashboard(idOrSlug);
const { uuid } = dashboard || {};
useEffect(() => {
if (uuid && window.location.pathname !== `/superset/dashboard/${uuid}/`) {
history.replace(`/superset/dashboard/${uuid}/`);
}
}, [history, uuid]);
// ... rest of the component code
};
```
### Additional Considerations
- **Database Schema**: Ensure that the `uuid` field in the `dashboards` table is indexed and unique.
- **Migration Scripts**: If necessary, create migration scripts to add the `uuid` field to existing dashboards and populate it with values.
By following these steps, you can ensure that Apache Superset uses UUIDs as the default for dashboard URLs, enhancing security and avoiding the use of predictable numeric IDs <sup>[[1]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/commands/dashboard/importers/v1/utils.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2272978388
I feel like you didn't understand what I meant. What I meant was that when I redefine the Dashboard URL slug, for example, when I define a new URL slug, the Dashboard access link becomes: https://xxx.xx.com/superset/dashboard/new_url/ . The link that was originally generated by default and concatenated with numbers: https://xxx.xx.com/superset/dashboard/5/ It should not still be accessible. This matter should only be accessible through custom new links.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275005112
> To modify Apache Superset to use UUIDs as the default for dashboard URLs instead of numeric IDs, you need to adjust the class to handle UUIDs. Here is a step-by-step guide to achieve this:`DashboardDAO`
>
> 1. **Generate UUIDs for Dashboards**: Ensure that each dashboard has a UUID. Modify the dashboard creation logic to generate a UUID if it doesn't already exist.
> 2. **Modify URL Handling**: Update the method to prioritize UUIDs.`get_by_id_or_slug`
> 3. **Update the Database Schema**: Ensure that the database schema supports UUIDs for dashboards. You can refer to the migration script for adding UUID columns to the necessary tables.`add_uuid_column_to_import_mixin.py`
>
> Here is the modified class with the necessary changes:`DashboardDAO`
>
> ```python
> import uuid
> from superset.models.dashboard import Dashboard
>
> class DashboardDAO(BaseDAO[Dashboard]):
> base_filter = DashboardAccessFilter
>
> @classmethod
> def get_by_id_or_slug(cls, id_or_slug: int | str) -> Dashboard:
> if is_uuid(id_or_slug):
> # just get dashboard if it's uuid
> dashboard = Dashboard.get(id_or_slug)
> else:
> query = (
> db.session.query(Dashboard)
> .filter(id_or_slug_filter(id_or_slug))
> .outerjoin(Dashboard.owners)
> .outerjoin(Dashboard.roles)
> )
> # Apply dashboard base filters
> query = cls.base_filter("id", SQLAInterface(Dashboard, db.session)).apply(
> query, None
> )
> dashboard = query.one_or_none()
> if not dashboard:
> raise DashboardNotFoundError()
>
> # make sure we still have basic access check from security manager
> try:
> dashboard.raise_for_access()
> except SupersetSecurityException as ex:
> raise DashboardAccessDeniedError() from ex
>
> return dashboard
>
> @classmethod
> def create_dashboard(cls, data: dict[str, Any]) -> Dashboard:
> dashboard = Dashboard()
> dashboard.uuid = str(uuid.uuid4()) # Generate a new UUID for the dashboard
> dashboard.dashboard_title = data["dashboard_title"]
> dashboard.owners = [g.user] if g.user else []
> dashboard.css = data.get("css")
> metadata = json.loads(data["json_metadata"])
> cls.set_dash_metadata(dashboard, metadata)
> db.session.add(dashboard)
> db.session.commit()
> return dashboard
>
> @staticmethod
> def set_dash_metadata(
> dashboard: Dashboard,
> data: dict[Any, Any],
> old_to_new_slice_ids: dict[int, int] | None = None,
> ) -> None:
> new_filter_scopes = {}
> md = dashboard.params_dict
>
> if (positions := data.get("positions")) is not None:
> # find slices in the position data
> slice_ids = [
> value.get("meta", {}).get("chartId")
> for value in positions.values()
> if isinstance(value, dict)
> ]
>
> current_slices = (
> db.session.query(Slice).filter(Slice.id.in_(slice_ids)).all()
> )
>
> dashboard.slices = current_slices
> # add UUID to positions
> uuid_map = {slice.id: str(slice.uuid) for slice in current_slices}
> for obj in positions.values():
> if (
> isinstance(obj, dict)
> and obj["type"] == "CHART"
> and obj["meta"]["chartId"]
> ):
> chart_id = obj["meta"]["chartId"]
> obj["meta"]["uuid"] = uuid_map.get(chart_id)
>
> # remove leading and trailing white spaces in the dumped json
> dashboard.position_json = json.dumps(
> positions, indent=None, separators=(",", ":"), sort_keys=True
> )
>
> if "filter_scopes" in data:
> # replace filter_id and immune ids from old slice id to new slice id:
> # and remove slice ids that are not in dash anymore
> slc_id_dict: dict[int, int] = {}
> if old_to_new_slice_ids:
> slc_id_dict = {
> old: new
> for old, new in old_to_new_slice_ids.items()
> if new in slice_ids
> }
> else:
> slc_id_dict = {sid: sid for sid in slice_ids}
> new_filter_scopes = copy_filter_scopes(
> old_to_new_slc_id_dict=slc_id_dict,
> old_filter_scopes=json.loads(data["filter_scopes"] or "{}")
> if isinstance(data["filter_scopes"], str)
> else data["filter_scopes"],
> )
>
> default_filters_data = json.loads(data.get("default_filters", "{}"))
> applicable_filters = {
> key: v
> for key, v in default_filters_data.items()
> if int(key) in slice_ids
> }
> md["default_filters"] = json.dumps(applicable_filters)
>
> # positions have its own column, no need to store it in metadata
> md.pop("positions", None)
> if new_filter_scopes:
> md["filter_scopes"] = new_filter_scopes
> else:
> md.pop("filter_scopes", None)
>
> md.setdefault("timed_refresh_immune_slices", [])
>
> if data.get("color_namespace") is None:
> md.pop("color_namespace", None)
> else:
> md["color_namespace"] = data.get("color_namespace")
>
> md["expanded_slices"] = data.get("expanded_slices", {})
> md["refresh_frequency"] = data.get("refresh_frequency", 0)
> md["color_scheme"] = data.get("color_scheme", "")
> md["label_colors"] = data.get("label_colors", {})
> md["shared_label_colors"] = data.get("shared_label_colors", {})
> md["color_scheme_domain"] = data.get("color_scheme_domain", [])
> md["cross_filters_enabled"] = data.get("cross_filters_enabled", True)
> dashboard.json_metadata = json.dumps(md)
> ```
>
> Additionally, ensure that the model in includes a UUID field and that the URL generation logic uses this UUID:`Dashboard``superset/models/dashboard.py`
>
> ```python
> class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
> """The dashboard object!"""
>
> __tablename__ = "dashboards"
> id = Column(Integer, primary_key=True)
> uuid = Column(UUIDType(binary=True), unique=True, default=uuid4)
> dashboard_title = Column(String(500))
> position_json = Column(utils.MediumText())
> description = Column(Text)
> css = Column(utils.MediumText())
> certified_by = Column(Text)
> certification_details = Column(Text)
> json_metadata = Column(utils.MediumText())
> slug = Column(String(255), unique=True)
> slices: list[Slice] = relationship(
> Slice, secondary=dashboard_slices, backref="dashboards"
> )
> owners = relationship(
> security_manager.user_model,
> secondary=dashboard_user,
> passive_deletes=True,
> )
> tags = relationship(
> "Tag",
> overlaps="objects,tag,tags",
> secondary="tagged_object",
> primaryjoin="and_(Dashboard.id == TaggedObject.object_id, "
> "TaggedObject.object_type == 'dashboard')",
> secondaryjoin="TaggedObject.tag_id == Tag.id",
> viewonly=True, # cascading deletion already handled by superset.tags.models.ObjectUpdater.after_delete
> )
> published = Column(Boolean, default=False)
> is_managed_externally = Column(Boolean, nullable=False, default=False)
> external_url = Column(Text, nullable=True)
> roles = relationship(security_manager.role_model, secondary=DashboardRoles)
> embedded = relationship(
> "EmbeddedDashboard",
> back_populates="dashboard",
> cascade="all, delete-orphan",
> )
> export_fields = [
> "dashboard_title",
> "position_json",
> "json_metadata",
> "description",
> "css",
> "slug",
> "certified_by",
> "certification_details",
> "published",
> ]
> extra_import_fields = ["is_managed_externally", "external_url"]
>
> def __repr__(self) -> str:
> return f"Dashboard<{self.id or self.slug}>"
>
> @property
> def url(self) -> str:
> return f"/superset/dashboard/{self.uuid or self.id}/"
>
> @staticmethod
> def get_url(id_: int, slug: str | None = None) -> str:
> # To be able to generate URL's without instantiating a Dashboard object
> return f"/superset/dashboard/{slug or id_}/"
> ```
>
> This code ensures that UUIDs are generated for new dashboards and used in URLs. The method is updated to handle UUIDs properly. Make sure to update your database schema to include a UUID column for dashboards if it doesn't already exist. You can refer to the migration script for adding UUID columns to the necessary tables `get_by_id_or_slug``add_uuid_column_to_import_mixin.py`[[1]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)[[2]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)[[3]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2020-09-28_17-57_b56500de1855_add_uuid_column_to_import_mixin.py).
>
> _To continue talking to [Dosu](https://dosu.dev), mention @dosu._
I don't quite understand what you mean. In the Superset meta database, the uuid field already exists in the table dashboards and has a value.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2276925488
I am not sure if this migration script is reliable. Could the relevant developers please help me check it.
@rusackas @dpgaspar @michael-s-molina @bgreenlee
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2273825496
It's true that the "slug" is effectively an alias for the dashboard. All dashboards have a numeric ID in their URL by default. I'm not sure if being able to access a dashboard using Superset's default URL scheme is a security risk.
That said, there are proposals floating around to move from these numeric IDs to UUIDs for the default dashboard paths. I assume the "slug" would still effectively be an alias to the UUID, so I'm not sure if that solves your problem.
If you do see this (or anything else) as a true security vulnerability, it should be reported to security@superset.apache.org rather than posted as a public issue.
I'll CC @dpgaspar for context on the security point, as well as @villebro and @michael-s-molina who have quite a bit of context in permalinks/aliases in Superset.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "michael-s-molina (via GitHub)" <gi...@apache.org>.
michael-s-molina commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2273939455
> It should not still be accessible. At this point, only custom new links can be accessed.
@Sdreamery I don't think this is correct. The slug is just an alias, it does not mean that users can't access the dashboard using its ID if an alias is defiened.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2274865209
<!-- Answer -->
To modify Apache Superset to use UUIDs as the default for dashboard URLs instead of numeric IDs, you need to adjust the `DashboardDAO` class to handle UUIDs. Here is a step-by-step guide to achieve this:
1. **Generate UUIDs for Dashboards**: Ensure that each dashboard has a UUID. Modify the dashboard creation logic to generate a UUID if it doesn't already exist.
2. **Modify URL Handling**: Update the `get_by_id_or_slug` method to prioritize UUIDs.
3. **Update the Database Schema**: Ensure that the database schema supports UUIDs for dashboards. You can refer to the migration script `add_uuid_column_to_import_mixin.py` for adding UUID columns to the necessary tables.
Here is the modified `DashboardDAO` class with the necessary changes:
```python
import uuid
from superset.models.dashboard import Dashboard
class DashboardDAO(BaseDAO[Dashboard]):
base_filter = DashboardAccessFilter
@classmethod
def get_by_id_or_slug(cls, id_or_slug: int | str) -> Dashboard:
if is_uuid(id_or_slug):
# just get dashboard if it's uuid
dashboard = Dashboard.get(id_or_slug)
else:
query = (
db.session.query(Dashboard)
.filter(id_or_slug_filter(id_or_slug))
.outerjoin(Dashboard.owners)
.outerjoin(Dashboard.roles)
)
# Apply dashboard base filters
query = cls.base_filter("id", SQLAInterface(Dashboard, db.session)).apply(
query, None
)
dashboard = query.one_or_none()
if not dashboard:
raise DashboardNotFoundError()
# make sure we still have basic access check from security manager
try:
dashboard.raise_for_access()
except SupersetSecurityException as ex:
raise DashboardAccessDeniedError() from ex
return dashboard
@classmethod
def create_dashboard(cls, data: dict[str, Any]) -> Dashboard:
dashboard = Dashboard()
dashboard.uuid = str(uuid.uuid4()) # Generate a new UUID for the dashboard
dashboard.dashboard_title = data["dashboard_title"]
dashboard.owners = [g.user] if g.user else []
dashboard.css = data.get("css")
metadata = json.loads(data["json_metadata"])
cls.set_dash_metadata(dashboard, metadata)
db.session.add(dashboard)
db.session.commit()
return dashboard
@staticmethod
def set_dash_metadata(
dashboard: Dashboard,
data: dict[Any, Any],
old_to_new_slice_ids: dict[int, int] | None = None,
) -> None:
new_filter_scopes = {}
md = dashboard.params_dict
if (positions := data.get("positions")) is not None:
# find slices in the position data
slice_ids = [
value.get("meta", {}).get("chartId")
for value in positions.values()
if isinstance(value, dict)
]
current_slices = (
db.session.query(Slice).filter(Slice.id.in_(slice_ids)).all()
)
dashboard.slices = current_slices
# add UUID to positions
uuid_map = {slice.id: str(slice.uuid) for slice in current_slices}
for obj in positions.values():
if (
isinstance(obj, dict)
and obj["type"] == "CHART"
and obj["meta"]["chartId"]
):
chart_id = obj["meta"]["chartId"]
obj["meta"]["uuid"] = uuid_map.get(chart_id)
# remove leading and trailing white spaces in the dumped json
dashboard.position_json = json.dumps(
positions, indent=None, separators=(",", ":"), sort_keys=True
)
if "filter_scopes" in data:
# replace filter_id and immune ids from old slice id to new slice id:
# and remove slice ids that are not in dash anymore
slc_id_dict: dict[int, int] = {}
if old_to_new_slice_ids:
slc_id_dict = {
old: new
for old, new in old_to_new_slice_ids.items()
if new in slice_ids
}
else:
slc_id_dict = {sid: sid for sid in slice_ids}
new_filter_scopes = copy_filter_scopes(
old_to_new_slc_id_dict=slc_id_dict,
old_filter_scopes=json.loads(data["filter_scopes"] or "{}")
if isinstance(data["filter_scopes"], str)
else data["filter_scopes"],
)
default_filters_data = json.loads(data.get("default_filters", "{}"))
applicable_filters = {
key: v
for key, v in default_filters_data.items()
if int(key) in slice_ids
}
md["default_filters"] = json.dumps(applicable_filters)
# positions have its own column, no need to store it in metadata
md.pop("positions", None)
if new_filter_scopes:
md["filter_scopes"] = new_filter_scopes
else:
md.pop("filter_scopes", None)
md.setdefault("timed_refresh_immune_slices", [])
if data.get("color_namespace") is None:
md.pop("color_namespace", None)
else:
md["color_namespace"] = data.get("color_namespace")
md["expanded_slices"] = data.get("expanded_slices", {})
md["refresh_frequency"] = data.get("refresh_frequency", 0)
md["color_scheme"] = data.get("color_scheme", "")
md["label_colors"] = data.get("label_colors", {})
md["shared_label_colors"] = data.get("shared_label_colors", {})
md["color_scheme_domain"] = data.get("color_scheme_domain", [])
md["cross_filters_enabled"] = data.get("cross_filters_enabled", True)
dashboard.json_metadata = json.dumps(md)
```
Additionally, ensure that the `Dashboard` model in `superset/models/dashboard.py` includes a UUID field and that the URL generation logic uses this UUID:
```python
class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
"""The dashboard object!"""
__tablename__ = "dashboards"
id = Column(Integer, primary_key=True)
uuid = Column(UUIDType(binary=True), unique=True, default=uuid4)
dashboard_title = Column(String(500))
position_json = Column(utils.MediumText())
description = Column(Text)
css = Column(utils.MediumText())
certified_by = Column(Text)
certification_details = Column(Text)
json_metadata = Column(utils.MediumText())
slug = Column(String(255), unique=True)
slices: list[Slice] = relationship(
Slice, secondary=dashboard_slices, backref="dashboards"
)
owners = relationship(
security_manager.user_model,
secondary=dashboard_user,
passive_deletes=True,
)
tags = relationship(
"Tag",
overlaps="objects,tag,tags",
secondary="tagged_object",
primaryjoin="and_(Dashboard.id == TaggedObject.object_id, "
"TaggedObject.object_type == 'dashboard')",
secondaryjoin="TaggedObject.tag_id == Tag.id",
viewonly=True, # cascading deletion already handled by superset.tags.models.ObjectUpdater.after_delete
)
published = Column(Boolean, default=False)
is_managed_externally = Column(Boolean, nullable=False, default=False)
external_url = Column(Text, nullable=True)
roles = relationship(security_manager.role_model, secondary=DashboardRoles)
embedded = relationship(
"EmbeddedDashboard",
back_populates="dashboard",
cascade="all, delete-orphan",
)
export_fields = [
"dashboard_title",
"position_json",
"json_metadata",
"description",
"css",
"slug",
"certified_by",
"certification_details",
"published",
]
extra_import_fields = ["is_managed_externally", "external_url"]
def __repr__(self) -> str:
return f"Dashboard<{self.id or self.slug}>"
@property
def url(self) -> str:
return f"/superset/dashboard/{self.uuid or self.id}/"
@staticmethod
def get_url(id_: int, slug: str | None = None) -> str:
# To be able to generate URL's without instantiating a Dashboard object
return f"/superset/dashboard/{slug or id_}/"
```
This code ensures that UUIDs are generated for new dashboards and used in URLs. The `get_by_id_or_slug` method is updated to handle UUIDs properly. Make sure to update your database schema to include a UUID column for dashboards if it doesn't already exist. You can refer to the migration script `add_uuid_column_to_import_mixin.py` for adding UUID columns to the necessary tables <sup>[[1]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2020-09-28_17-57_b56500de1855_add_uuid_column_to_import_mixin.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275058266
<!-- Answer -->
The third step (updating the frontend components) should be added in the `upgrade` function after the UUIDs have been assigned to the models and the uniqueness constraints have been created. Specifically, it should be added after the call to `update_dashboards(session, slice_uuid_map)`.
Here is the relevant section of the code with the third step added:
```python
def upgrade():
bind = op.get_bind()
session = db.Session(bind=bind)
for table_name, model in models.items():
with op.batch_alter_table(table_name) as batch_op:
batch_op.add_column(
sa.Column(
"uuid",
UUIDType(binary=True),
primary_key=False,
default=uuid4,
),
)
assign_uuids(model, session)
# add uniqueness constraint
with op.batch_alter_table(table_name) as batch_op:
# batch mode is required for sqlite
batch_op.create_unique_constraint(f"uq_{table_name}_uuid", ["uuid"])
# add UUID to Dashboard.position_json
slice_uuid_map = {
slc.id: slc.uuid
for slc in session.query(models["slices"])
.options(load_only("id", "uuid"))
.all()
}
update_dashboards(session, slice_uuid_map)
# Third step: Update frontend components to use UUIDs in URLs
update_frontend_components_with_uuids()
def update_frontend_components_with_uuids():
# Implementation for updating the frontend components to use UUIDs in URLs
pass
```
You will need to implement the `update_frontend_components_with_uuids` function to handle the actual updating of the frontend components <sup>[[1]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2020-09-28_17-57_b56500de1855_add_uuid_column_to_import_mixin.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2272936027
<!-- Greeting -->
Hello @Sdreamery! I'm here to help you with any issues you're experiencing in the repository. Let me know how I can assist you!
<!-- Answer -->
To address the security risk of the old default URL still being accessible after resetting the URL in the Dashboard properties, you can implement a redirection mechanism to ensure the old URL is disabled or redirected. Here’s how you can do it using the `useHistory` hook from `react-router-dom`:
1. **Modify the `DashboardPage` component**:
Update the `DashboardPage` component to check if the current URL is the old one and redirect to the new URL if necessary.
```tsx
import { useEffect } from 'react';
import { useHistory } from 'react-router-dom';
// Inside the DashboardPage component
const DashboardPage: FC<PageProps> = ({ idOrSlug }: PageProps) => {
const history = useHistory();
const { result: dashboard } = useDashboard(idOrSlug);
const { dashboard_title, id = 0 } = dashboard || {};
useEffect(() => {
// Assuming `newDashboardUrl` is the new URL you want to redirect to
const newDashboardUrl = `/new-dashboard-url/${id}`;
// Check if the current URL is the old one and redirect if necessary
if (window.location.pathname === `/old-dashboard-url/${id}`) {
history.replace(newDashboardUrl);
}
}, [history, id]);
// ... rest of the component code
};
```
Replace `/old-dashboard-url/${id}` with the actual old URL pattern and `/new-dashboard-url/${id}` with the new URL pattern. This ensures that any access to the old URL will be redirected to the new URL, preventing unauthorized access to the old URL <sup>[[1]](https://github.com/apache/superset/blob/master/superset-frontend/src/dashboard/containers/DashboardPage.tsx)</sup>.
2. **Backend URL Handling**:
Additionally, you can programmatically update or invalidate old URLs in the backend using a migration script. This script can parse the query string, update the URL format, and commit the changes to the database.
Here’s an example of a migration script:
```py
from urllib import parse
import sqlalchemy as sa
from alembic import op
from sqlalchemy.ext.declarative import declarative_base
from superset import db
from superset.utils import json
Base = declarative_base()
def parse_querystring(qs):
d = {}
for k, v in parse.parse_qsl(qs):
if k not in d:
d[k] = v
else:
if isinstance(d[k], list):
d[k].append(v)
else:
d[k] = [d[k], v]
return d
class Url(Base):
"""Used for the short url feature"""
__tablename__ = "url"
id = sa.Column(sa.Integer, primary_key=True)
url = sa.Column(sa.Text)
def upgrade():
bind = op.get_bind()
session = db.Session(bind=bind)
urls = session.query(Url).all()
urls_len = len(urls)
for i, url in enumerate(urls):
if (
"?form_data" not in url.url
and "?" in url.url
and "dbid" not in url.url
and url.url.startswith("//superset/explore")
):
d = parse_querystring(url.url.split("?")[1])
split = url.url.split("/")
d["datasource"] = split[5] + "__" + split[4]
newurl = (
"/".join(split[:-1]) + "/?form_data=" + parse.quote_plus(json.dumps(d))
)
url.url = newurl
session.commit()
print(f"Updating url ({i}/{urls_len})")
session.close()
def downgrade():
pass
```
This script updates old URLs to a new format programmatically, ensuring that old URLs are invalidated or updated as needed <sup>[[2]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2017-02-08_14-16_a99f2f7c195a_rewriting_url_from_shortner_with_new_.py)</sup>.
By implementing these changes, you can mitigate the security risks associated with the old default URLs in Superset.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2272986489
<!-- Answer -->
To ensure that a Superset dashboard is only accessible through a custom new URL slug and that the old default URL is no longer accessible, you can update the URL slug in the dashboard properties. Here is how you can do it:
1. Open the dashboard properties modal.
2. Update the "URL slug" field with the new custom slug.
3. Save the changes.
Here is the relevant code snippet from the `PropertiesModal` component that shows how to update the URL slug:
```tsx
<StyledFormItem label={t('URL slug')} name="slug">
<Input type="text" disabled={isLoading} />
</StyledFormItem>
<p className="help-block">
{t('A readable URL for your dashboard')}
</p>
```
By updating the "URL slug" field, the dashboard will be accessible through the new custom URL, and the old default URL will no longer be valid.
Additionally, the `Dashboard` model in `superset/models/dashboard.py` ensures that the dashboard URL is generated based on the slug if it exists, otherwise it defaults to the dashboard ID:
```py
class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
...
@property
def url(self) -> str:
return f"/superset/dashboard/{self.slug or self.id}/"
@staticmethod
def get_url(id_: int, slug: str | None = None) -> str:
return f"/superset/dashboard/{slug or id_}/"
...
```
This ensures that once the slug is updated, the old URL (based on the dashboard ID) will no longer be valid.
Furthermore, the `Dashboard` view in `superset/views/dashboard/views.py` handles the routing and ensures that the dashboard can be accessed via the new slug:
```py
class Dashboard(BaseSupersetView):
...
@expose("/<dashboard_id_or_slug>/embedded")
@event_logger.log_this_with_extra_payload
def embedded(
self,
dashboard_id_or_slug: str,
add_extra_log_payload: Callable[..., None] = lambda **kwargs: None,
) -> FlaskResponse:
...
add_extra_log_payload(
dashboard_id=dashboard_id_or_slug,
dashboard_version="v2",
)
...
return self.render_template(
"superset/spa.html",
entry="embedded",
bootstrap_data=json.dumps(
bootstrap_data, default=json.pessimistic_json_iso_dttm_ser
),
)
```
This ensures that the dashboard is accessible via the new slug and the old URL is no longer valid <sup>[[1]](https://github.com/apache/superset/blob/master/superset-frontend/src/dashboard/components/PropertiesModal/index.tsx)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/views/dashboard/views.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2274761212
> To ensure that a Superset dashboard is only accessible through a custom new URL slug and that the old default URL is no longer accessible, you can update the URL slug in the dashboard properties. Here is how you can do it:
>
> 1. Open the dashboard properties modal.
> 2. Update the "URL slug" field with the new custom slug.
> 3. Save the changes.
>
> Here is the relevant code snippet from the `PropertiesModal` component that shows how to update the URL slug:
>
> ```tsx
> <StyledFormItem label={t('URL slug')} name="slug">
> <Input type="text" disabled={isLoading} />
> </StyledFormItem>
> <p className="help-block">
> {t('A readable URL for your dashboard')}
> </p>
> ```
>
> By updating the "URL slug" field, the dashboard will be accessible through the new custom URL, and the old default URL will no longer be valid.
>
> Additionally, the `Dashboard` model in `superset/models/dashboard.py` ensures that the dashboard URL is generated based on the slug if it exists, otherwise it defaults to the dashboard ID:
>
> ```python
> class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
> ...
> @property
> def url(self) -> str:
> return f"/superset/dashboard/{self.slug or self.id}/"
>
> @staticmethod
> def get_url(id_: int, slug: str | None = None) -> str:
> return f"/superset/dashboard/{slug or id_}/"
> ...
> ```
>
> This ensures that once the slug is updated, the old URL (based on the dashboard ID) will no longer be valid.
>
> Furthermore, the `Dashboard` view in `superset/views/dashboard/views.py` handles the routing and ensures that the dashboard can be accessed via the new slug:
>
> ```python
> class Dashboard(BaseSupersetView):
> ...
> @expose("/<dashboard_id_or_slug>/embedded")
> @event_logger.log_this_with_extra_payload
> def embedded(
> self,
> dashboard_id_or_slug: str,
> add_extra_log_payload: Callable[..., None] = lambda **kwargs: None,
> ) -> FlaskResponse:
> ...
> add_extra_log_payload(
> dashboard_id=dashboard_id_or_slug,
> dashboard_version="v2",
> )
> ...
> return self.render_template(
> "superset/spa.html",
> entry="embedded",
> bootstrap_data=json.dumps(
> bootstrap_data, default=json.pessimistic_json_iso_dttm_ser
> ),
> )
> ```
>
> This ensures that the dashboard is accessible via the new slug and the old URL is no longer valid [[1]](https://github.com/apache/superset/blob/master/superset-frontend/src/dashboard/components/PropertiesModal/index.tsx)[[2]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)[[3]](https://github.com/apache/superset/blob/master/superset/views/dashboard/views.py).
>
> _To continue talking to [Dosu](https://dosu.dev), mention @dosu._
After modifying the source code of the dashboard module superset/models/dashboard. py, restarting it with gunicorn did not take effect. The ID can still be accessed as a URL. Why is this? Here are the changes I made:
`class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
...
def __repr__(self) -> str:
return f"Dashboard<{self.slug}>"
# return f"Dashboard<{self.id or self.slug}>"
@property
def url(self) -> str:
return f"/superset/dashboard/{self.slug}/"
# return f"/superset/dashboard/{self.slug or self.id}/"
@staticmethod
def get_url(id_: int, slug: str | None = None) -> str:
# To be able to generate URL's without instantiating a Dashboard object
return f"/superset/dashboard/{slug}/"
# return f"/superset/dashboard/{slug or id_}/"
...`
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2274646378
I think Superset should default to using randomly generated UUID as access links instead of using regular ID, and I found in the Superset metadata table dashboard that it already has a UUID field.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275317728
> To address the issues you're encountering after modifying the source code to use UUIDs for dashboard URLs in Apache Superset, let's go through the necessary steps to ensure that the UUIDs are correctly utilized in the URL generation, access logic, and frontend components.
>
> ### Step 1: Update the URL Generation Logic
> Ensure that the model uses the UUID for generating URLs:`Dashboard`
>
> ```python
> from sqlalchemy_utils import UUIDType
> from uuid import uuid4
>
> class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
> __tablename__ = "dashboards"
> id = Column(Integer, primary_key=True)
> uuid = Column(UUIDType(binary=True), unique=True, default=uuid4)
> dashboard_title = Column(String(500))
> # other fields...
>
> def __repr__(self) -> str:
> return f"Dashboard<{self.uuid}>"
>
> @property
> def url(self) -> str:
> return f"/superset/dashboard/{self.uuid}/"
>
> @staticmethod
> def get_url(uuid_: str) -> str:
> return f"/superset/dashboard/{uuid_}/"
> ```
>
> ### Step 2: Modify the Access Methods
> Update the class to prioritize UUIDs:`DashboardDAO`
>
> ```python
> from superset.models.dashboard import Dashboard
> from superset.exceptions import DashboardNotFoundError, DashboardAccessDeniedError
> from superset.security import SupersetSecurityException
> from superset import db, security_manager
> import uuid
>
> class DashboardDAO(BaseDAO[Dashboard]):
> base_filter = DashboardAccessFilter
>
> @classmethod
> def get_by_id_or_slug(cls, id_or_slug: str) -> Dashboard:
> if cls.is_uuid(id_or_slug):
> dashboard = db.session.query(Dashboard).filter_by(uuid=id_or_slug).one_or_none()
> else:
> dashboard = db.session.query(Dashboard).filter_by(slug=id_or_slug).one_or_none()
>
> if not dashboard:
> raise DashboardNotFoundError()
>
> try:
> dashboard.raise_for_access()
> except SupersetSecurityException as ex:
> raise DashboardAccessDeniedError() from ex
>
> return dashboard
>
> @staticmethod
> def is_uuid(value: str) -> bool:
> try:
> uuid.UUID(str(value))
> return True
> except ValueError:
> return False
> ```
>
> ### Step 3: Ensure UUIDs are Used in the Frontend
> Update the frontend components to use UUIDs in the URLs. For example, in the component, ensure that the URLs are generated using UUIDs:`DashboardPage`
>
> ```tsx
> import React, { useEffect } from 'react';
> import { useHistory } from 'react-router-dom';
> import { useDashboard } from 'src/hooks/apiResources';
>
> const DashboardPage: React.FC<{ idOrSlug: string }> = ({ idOrSlug }) => {
> const history = useHistory();
> const { result: dashboard } = useDashboard(idOrSlug);
> const { uuid } = dashboard || {};
>
> useEffect(() => {
> if (uuid && window.location.pathname !== `/superset/dashboard/${uuid}/`) {
> history.replace(`/superset/dashboard/${uuid}/`);
> }
> }, [history, uuid]);
>
> // ... rest of the component code
> };
> ```
>
> ### Additional Considerations
> 1. **Database Schema**: Ensure that the field in the table is indexed and unique.`uuid``dashboards`
> 2. **Migration Scripts**: If necessary, create migration scripts to add the field to existing dashboards and populate it with values.`uuid`
>
> ### Troubleshooting the Issues
> 1. **Exception When Creating a New Dashboard**:
>
> * Ensure that the method in correctly assigns a UUID to new dashboards.`create_dashboard``DashboardDAO`
> * Verify that the frontend is correctly handling the UUID in the URL.
> 2. **Error When Opening Dashboard Properties**:
>
> * Ensure that the method is correctly fetching the dashboard by UUID.`get_by_id_or_slug`
> * Verify that the frontend components are correctly using the UUID in API calls.
> 3. **UUID-based URLs Cannot Be Accessed**:
>
> * Ensure that the routing configuration in the frontend supports UUIDs.
> * Verify that the backend is correctly handling UUIDs in the URL.
>
> ### Example Migration Script
> Here is an example migration script to add the field to existing dashboards and populate it with values:`uuid`
>
> ```python
> import os
> from uuid import uuid4
> import sqlalchemy as sa
> from alembic import op
> from sqlalchemy.ext.declarative import declarative_base
> from sqlalchemy.orm import load_only
> from sqlalchemy_utils import UUIDType
> from superset import db
> from superset.utils import core as utils, json
>
> # revision identifiers, used by Alembic.
> revision = "b56500de1855"
> down_revision = "18532d70ab98"
>
> Base = declarative_base()
>
> class ImportMixin:
> id = sa.Column(sa.Integer, primary_key=True)
> uuid = sa.Column(UUIDType(binary=True), primary_key=False, default=uuid4)
>
> table_names = ["dashboards"]
> models = {
> table_name: type(table_name, (ImportMixin, Base), {"__tablename__": table_name})
> for table_name in table_names
> }
>
> def upgrade():
> bind = op.get_bind()
> session = db.Session(bind=bind)
>
> for table_name, model in models.items():
> with op.batch_alter_table(table_name) as batch_op:
> batch_op.add_column(
> sa.Column(
> "uuid",
> UUIDType(binary=True),
> primary_key=False,
> default=uuid4,
> ),
> )
>
> assign_uuids(model, session)
>
> with op.batch_alter_table(table_name) as batch_op:
> batch_op.create_unique_constraint(f"uq_{table_name}_uuid", ["uuid"])
>
> def assign_uuids(model, session):
> for instance in session.query(model).all():
> if not instance.uuid:
> instance.uuid = uuid4()
> session.commit()
>
> def downgrade():
> bind = op.get_bind()
> session = db.Session(bind=bind)
>
> for table_name in models:
> with op.batch_alter_table(table_name) as batch_op:
> batch_op.drop_constraint(f"uq_{table_name}_uuid", type_="unique")
> batch_op.drop_column("uuid")
> ```
>
> By following these steps and ensuring that all parts of the system (backend, frontend, and database) are correctly updated to use UUIDs, you should be able to resolve the issues and enhance the security of your dashboard URLs [[1]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2020-09-28_17-57_b56500de1855_add_uuid_column_to_import_mixin.py)[[2]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)[[3]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)[[4]](https://github.com/apache/superset/blob/master/superset/commands/dashboard/importers/v1/utils.py).
>
> _To continue talking to [Dosu](https://dosu.dev), mention @dosu._
Is the third step necessary? If so, how should this script be executed? Edit the script into a Python file ending in py and use the command: python xxx. py. Do you want to do this?
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "sadpandajoe (via GitHub)" <gi...@apache.org>.
sadpandajoe closed issue #29879: The default URL generated by Dashboard has security risks!
URL: https://github.com/apache/superset/issues/29879
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2776925050
Looks like this PR may close this issue (finally): https://github.com/apache/superset/pull/29573
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2274771332
<!-- Answer -->
The dashboards are still accessible via their numeric ID because the `DashboardDAO` class includes a method `get_by_id_or_slug` that allows access by either the numeric ID or the custom URL slug. This method is used in various places to fetch dashboards, which means both IDs and slugs are supported for accessing dashboards.
To ensure that only the custom URL slugs are used for accessing dashboards, you need to modify the `get_by_id_or_slug` method to only use the slug. Here is how you can do it:
1. **Modify the `get_by_id_or_slug` method**:
```python
@classmethod
def get_by_slug(cls, slug: str) -> Dashboard:
query = (
db.session.query(Dashboard)
.filter(Dashboard.slug == slug)
.outerjoin(Dashboard.owners)
.outerjoin(Dashboard.roles)
)
# Apply dashboard base filters
query = cls.base_filter("id", SQLAInterface(Dashboard, db.session)).apply(
query, None
)
dashboard = query.one_or_none()
if not dashboard:
raise DashboardNotFoundError()
# make sure we still have basic access check from security manager
try:
dashboard.raise_for_access()
except SupersetSecurityException as ex:
raise DashboardAccessDeniedError() from ex
return dashboard
```
2. **Update all references to `get_by_id_or_slug`**:
Replace all calls to `DashboardDAO.get_by_id_or_slug` with `DashboardDAO.get_by_slug` in the codebase to ensure that dashboards are only accessed via their custom URL slugs.
3. **Update tests to ensure compliance**:
Modify the test cases to ensure that dashboards are accessed only via slugs. For example, in the `tests/integration_tests/dashboards/api_tests.py` file, update the test cases to use slugs instead of numeric IDs:
```python
@pytest.mark.usefixtures("create_dashboards")
def test_get_dashboard_charts_by_slug(self):
"""
Dashboard API: Test getting charts belonging to a dashboard
"""
self.login(ADMIN_USERNAME)
dashboard = self.dashboards[0]
uri = f"api/v1/dashboard/{dashboard.slug}/charts"
response = self.get_assert_metric(uri, "get_charts")
self.assertEqual(response.status_code, 200)
data = json.loads(response.data.decode("utf-8"))
self.assertEqual(len(data["result"]), 1)
self.assertEqual(
data["result"][0]["slice_name"], dashboard.slices[0].slice_name
)
```
By making these changes, you ensure that dashboards can only be accessed via their custom URL slugs and not by their numeric IDs <sup>[[1]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/tests/integration_tests/dashboards/api_tests.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275054643
> To ensure that Apache Superset uses UUIDs as the default for dashboard URLs instead of numeric IDs, you need to make sure that the UUIDs are correctly utilized in the URL generation and access logic. Since the `uuid` field already exists in the `dashboards` table, you can focus on updating the URL handling and access methods.
>
> Here’s a step-by-step guide to achieve this:
>
> 1. **Update the URL Generation Logic**:
> Modify the `Dashboard` model to use the UUID for generating URLs.
> 2. **Modify the Access Methods**:
> Update the `DashboardDAO` class to prioritize UUIDs when accessing dashboards.
> 3. **Ensure UUIDs are Used in the Frontend**:
> Update the frontend components to use UUIDs in the URLs.
>
> ### Step 1: Update the URL Generation Logic
> Modify the `Dashboard` model in `superset/models/dashboard.py` to use the UUID for generating URLs:
>
> ```python
> from sqlalchemy_utils import UUIDType
> from uuid import uuid4
>
> class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
> __tablename__ = "dashboards"
> id = Column(Integer, primary_key=True)
> uuid = Column(UUIDType(binary=True), unique=True, default=uuid4)
> dashboard_title = Column(String(500))
> # other fields...
>
> def __repr__(self) -> str:
> return f"Dashboard<{self.uuid}>"
>
> @property
> def url(self) -> str:
> return f"/superset/dashboard/{self.uuid}/"
>
> @staticmethod
> def get_url(uuid_: str) -> str:
> return f"/superset/dashboard/{uuid_}/"
> ```
>
> ### Step 2: Modify the Access Methods
> Update the `DashboardDAO` class in `superset/daos/dashboard.py` to prioritize UUIDs:
>
> ```python
> from superset.models.dashboard import Dashboard
> from superset.exceptions import DashboardNotFoundError, DashboardAccessDeniedError
> from superset.security import SupersetSecurityException
> from superset import db, security_manager
> from sqlalchemy.orm import joinedload
> import uuid
>
> class DashboardDAO(BaseDAO[Dashboard]):
> base_filter = DashboardAccessFilter
>
> @classmethod
> def get_by_id_or_slug(cls, id_or_slug: str) -> Dashboard:
> if cls.is_uuid(id_or_slug):
> dashboard = db.session.query(Dashboard).filter_by(uuid=id_or_slug).one_or_none()
> else:
> dashboard = db.session.query(Dashboard).filter_by(slug=id_or_slug).one_or_none()
>
> if not dashboard:
> raise DashboardNotFoundError()
>
> try:
> dashboard.raise_for_access()
> except SupersetSecurityException as ex:
> raise DashboardAccessDeniedError() from ex
>
> return dashboard
>
> @staticmethod
> def is_uuid(value: str) -> bool:
> try:
> uuid.UUID(str(value))
> return True
> except ValueError:
> return False
> ```
>
> ### Step 3: Ensure UUIDs are Used in the Frontend
> Update the frontend components to use UUIDs in the URLs. For example, in the `DashboardPage` component, ensure that the URLs are generated using UUIDs:
>
> ```tsx
> import React, { useEffect } from 'react';
> import { useHistory } from 'react-router-dom';
> import { useDashboard } from 'src/hooks/apiResources';
>
> const DashboardPage: React.FC<{ idOrSlug: string }> = ({ idOrSlug }) => {
> const history = useHistory();
> const { result: dashboard } = useDashboard(idOrSlug);
> const { uuid } = dashboard || {};
>
> useEffect(() => {
> if (uuid && window.location.pathname !== `/superset/dashboard/${uuid}/`) {
> history.replace(`/superset/dashboard/${uuid}/`);
> }
> }, [history, uuid]);
>
> // ... rest of the component code
> };
> ```
>
> ### Additional Considerations
> * **Database Schema**: Ensure that the `uuid` field in the `dashboards` table is indexed and unique.
> * **Migration Scripts**: If necessary, create migration scripts to add the `uuid` field to existing dashboards and populate it with values.
>
> By following these steps, you can ensure that Apache Superset uses UUIDs as the default for dashboard URLs, enhancing security and avoiding the use of predictable numeric IDs [[1]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)[[2]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)[[3]](https://github.com/apache/superset/blob/master/superset/commands/dashboard/importers/v1/utils.py).
>
> _To continue talking to [Dosu](https://dosu.dev), mention @dosu._
Where exactly is the third step added? I couldn't find it in the source code of version 4.0.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275236910
<!-- Answer -->
To address the issues you're encountering after modifying the source code to use UUIDs for dashboard URLs in Apache Superset, let's go through the necessary steps to ensure that the UUIDs are correctly utilized in the URL generation, access logic, and frontend components.
### Step 1: Update the URL Generation Logic
Ensure that the `Dashboard` model uses the UUID for generating URLs:
```python
from sqlalchemy_utils import UUIDType
from uuid import uuid4
class Dashboard(AuditMixinNullable, ImportExportMixin, Model):
__tablename__ = "dashboards"
id = Column(Integer, primary_key=True)
uuid = Column(UUIDType(binary=True), unique=True, default=uuid4)
dashboard_title = Column(String(500))
# other fields...
def __repr__(self) -> str:
return f"Dashboard<{self.uuid}>"
@property
def url(self) -> str:
return f"/superset/dashboard/{self.uuid}/"
@staticmethod
def get_url(uuid_: str) -> str:
return f"/superset/dashboard/{uuid_}/"
```
### Step 2: Modify the Access Methods
Update the `DashboardDAO` class to prioritize UUIDs:
```python
from superset.models.dashboard import Dashboard
from superset.exceptions import DashboardNotFoundError, DashboardAccessDeniedError
from superset.security import SupersetSecurityException
from superset import db, security_manager
import uuid
class DashboardDAO(BaseDAO[Dashboard]):
base_filter = DashboardAccessFilter
@classmethod
def get_by_id_or_slug(cls, id_or_slug: str) -> Dashboard:
if cls.is_uuid(id_or_slug):
dashboard = db.session.query(Dashboard).filter_by(uuid=id_or_slug).one_or_none()
else:
dashboard = db.session.query(Dashboard).filter_by(slug=id_or_slug).one_or_none()
if not dashboard:
raise DashboardNotFoundError()
try:
dashboard.raise_for_access()
except SupersetSecurityException as ex:
raise DashboardAccessDeniedError() from ex
return dashboard
@staticmethod
def is_uuid(value: str) -> bool:
try:
uuid.UUID(str(value))
return True
except ValueError:
return False
```
### Step 3: Ensure UUIDs are Used in the Frontend
Update the frontend components to use UUIDs in the URLs. For example, in the `DashboardPage` component, ensure that the URLs are generated using UUIDs:
```tsx
import React, { useEffect } from 'react';
import { useHistory } from 'react-router-dom';
import { useDashboard } from 'src/hooks/apiResources';
const DashboardPage: React.FC<{ idOrSlug: string }> = ({ idOrSlug }) => {
const history = useHistory();
const { result: dashboard } = useDashboard(idOrSlug);
const { uuid } = dashboard || {};
useEffect(() => {
if (uuid && window.location.pathname !== `/superset/dashboard/${uuid}/`) {
history.replace(`/superset/dashboard/${uuid}/`);
}
}, [history, uuid]);
// ... rest of the component code
};
```
### Additional Considerations
1. **Database Schema**: Ensure that the `uuid` field in the `dashboards` table is indexed and unique.
2. **Migration Scripts**: If necessary, create migration scripts to add the `uuid` field to existing dashboards and populate it with values.
### Troubleshooting the Issues
1. **Exception When Creating a New Dashboard**:
- Ensure that the `create_dashboard` method in `DashboardDAO` correctly assigns a UUID to new dashboards.
- Verify that the frontend is correctly handling the UUID in the URL.
2. **Error When Opening Dashboard Properties**:
- Ensure that the `get_by_id_or_slug` method is correctly fetching the dashboard by UUID.
- Verify that the frontend components are correctly using the UUID in API calls.
3. **UUID-based URLs Cannot Be Accessed**:
- Ensure that the routing configuration in the frontend supports UUIDs.
- Verify that the backend is correctly handling UUIDs in the URL.
### Example Migration Script
Here is an example migration script to add the `uuid` field to existing dashboards and populate it with values:
```python
import os
from uuid import uuid4
import sqlalchemy as sa
from alembic import op
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import load_only
from sqlalchemy_utils import UUIDType
from superset import db
from superset.utils import core as utils, json
# revision identifiers, used by Alembic.
revision = "b56500de1855"
down_revision = "18532d70ab98"
Base = declarative_base()
class ImportMixin:
id = sa.Column(sa.Integer, primary_key=True)
uuid = sa.Column(UUIDType(binary=True), primary_key=False, default=uuid4)
table_names = ["dashboards"]
models = {
table_name: type(table_name, (ImportMixin, Base), {"__tablename__": table_name})
for table_name in table_names
}
def upgrade():
bind = op.get_bind()
session = db.Session(bind=bind)
for table_name, model in models.items():
with op.batch_alter_table(table_name) as batch_op:
batch_op.add_column(
sa.Column(
"uuid",
UUIDType(binary=True),
primary_key=False,
default=uuid4,
),
)
assign_uuids(model, session)
with op.batch_alter_table(table_name) as batch_op:
batch_op.create_unique_constraint(f"uq_{table_name}_uuid", ["uuid"])
def assign_uuids(model, session):
for instance in session.query(model).all():
if not instance.uuid:
instance.uuid = uuid4()
session.commit()
def downgrade():
bind = op.get_bind()
session = db.Session(bind=bind)
for table_name in models:
with op.batch_alter_table(table_name) as batch_op:
batch_op.drop_constraint(f"uq_{table_name}_uuid", type_="unique")
batch_op.drop_column("uuid")
```
By following these steps and ensuring that all parts of the system (backend, frontend, and database) are correctly updated to use UUIDs, you should be able to resolve the issues and enhance the security of your dashboard URLs <sup>[[1]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2020-09-28_17-57_b56500de1855_add_uuid_column_to_import_mixin.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)</sup><sup>[[4]](https://github.com/apache/superset/blob/master/superset/commands/dashboard/importers/v1/utils.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2275326705
<!-- Answer -->
Yes, the third step is necessary to ensure that the frontend components correctly use UUIDs in the URLs. This step involves updating the frontend routing and components to handle UUIDs properly.
### Step 3: Ensure UUIDs are Used in the Frontend
To update the frontend components to use UUIDs in the URLs, you need to modify the routing configuration and relevant components. Here’s how you can do it:
1. **Update the Routing Configuration**:
Modify the routes configuration to handle UUIDs. For example, in `superset-frontend/src/views/routes.tsx`:
```tsx
{
path: '/superset/dashboard/:idOrSlug([0-9a-fA-F-]{36})/',
Component: Dashboard,
}
```
This ensures that the `idOrSlug` parameter can handle UUIDs.
2. **Update the `DashboardPage` Component**:
Ensure that the `DashboardPage` component uses UUIDs in the URLs. For example:
```tsx
import React, { useEffect } from 'react';
import { useHistory } from 'react-router-dom';
import { useDashboard } from 'src/hooks/apiResources';
const DashboardPage: React.FC<{ idOrSlug: string }> = ({ idOrSlug }) => {
const history = useHistory();
const { result: dashboard } = useDashboard(idOrSlug);
const { uuid } = dashboard || {};
useEffect(() => {
if (uuid && window.location.pathname !== `/superset/dashboard/${uuid}/`) {
history.replace(`/superset/dashboard/${uuid}/`);
}
}, [history, uuid]);
// ... rest of the component code
};
```
### Executing the Migration Script
To execute the migration script, you need to create a Python file with the script and run it using Alembic, which is the database migration tool used by Superset. Here’s how you can do it:
1. **Create the Migration Script**:
Save the migration script as a Python file, for example, `add_uuid_to_dashboards.py`.
2. **Run the Migration Script**:
Use Alembic to run the migration script. Here’s how you can do it:
```sh
alembic upgrade head
```
Ensure that your Alembic environment is correctly set up and configured to point to your Superset database.
### Example Migration Script
Here’s the complete migration script:
```python
import os
from uuid import uuid4
import sqlalchemy as sa
from alembic import op
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import load_only
from sqlalchemy_utils import UUIDType
from superset import db
from superset.utils import core as utils, json
# revision identifiers, used by Alembic.
revision = "b56500de1855"
down_revision = "18532d70ab98"
Base = declarative_base()
class ImportMixin:
id = sa.Column(sa.Integer, primary_key=True)
uuid = sa.Column(UUIDType(binary=True), primary_key=False, default=uuid4)
table_names = ["dashboards"]
models = {
table_name: type(table_name, (ImportMixin, Base), {"__tablename__": table_name})
for table_name in table_names
}
def upgrade():
bind = op.get_bind()
session = db.Session(bind=bind)
for table_name, model in models.items():
with op.batch_alter_table(table_name) as batch_op:
batch_op.add_column(
sa.Column(
"uuid",
UUIDType(binary=True),
primary_key=False,
default=uuid4,
),
)
assign_uuids(model, session)
with op.batch_alter_table(table_name) as batch_op:
batch_op.create_unique_constraint(f"uq_{table_name}_uuid", ["uuid"])
def assign_uuids(model, session):
for instance in session.query(model).all():
if not instance.uuid:
instance.uuid = uuid4()
session.commit()
def downgrade():
bind = op.get_bind()
session = db.Session(bind=bind)
for table_name in models:
with op.batch_alter_table(table_name) as batch_op:
batch_op.drop_constraint(f"uq_{table_name}_uuid", type_="unique")
batch_op.drop_column("uuid")
```
By following these steps and ensuring that all parts of the system (backend, frontend, and database) are correctly updated to use UUIDs, you should be able to resolve the issues and enhance the security of your dashboard URLs <sup>[[1]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2020-09-28_17-57_b56500de1855_add_uuid_column_to_import_mixin.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/daos/dashboard.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "Sdreamery (via GitHub)" <gi...@apache.org>.
Sdreamery commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2304025284
Okay, I'm looking forward to it.
--
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] The default URL generated by Dashboard has security risks! [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #29879:
URL: https://github.com/apache/superset/issues/29879#issuecomment-2291623290
Sorry, I'm having a hard time following all this. I'm removing the SIP label, since this is not a SIP. I'd also say it's not a bug, so I'm tempted to close it for that reason. I could move it to a Github Discussion in the "Ideas" category, but the bot conversation will not do well in that format. There are many other discussions about Superset using UUIDs, but as I just mentioned in a comment [here](https://github.com/apache/superset/pull/29573), someone needs to formulate a holistic plan around Superset's UUID use and volunteer to spearhead the effort.
--
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