Re: [I] Superset ALERT & REPORTS not working [superset]
sfirke commented on issue #28686: URL: https://github.com/apache/superset/issues/28686#issuecomment-2129588834 Yes please see the docs that @gaful linked. I'm going to convert this to a Discussion, as it is not a bug report of a problem with Superset but instead a request for help getting the configuration set up. Try searching GitHub Discussions and Issues for that error message, it has come up before, e.g. https://github.com/apache/superset/issues/23057. It has also been addressed in the Slack chat that is open to the public. -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
gaful commented on issue #28686: URL: https://github.com/apache/superset/issues/28686#issuecomment-2129180668 Hello, It seems that you have 2 issue : 1. issue with sending email : what does your system logs says ? they are usually quite usefull. 2. issue with capturing image : from the documentation https://superset.apache.org/docs/configuration/alerts-reports/ > You must install a headless browser, for taking screenshots of the charts and dashboards. Only Firefox and Chrome are currently supported. > If you choose Chrome, you must also change the value of WEBDRIVER_TYPE to "chrome" in your superset_config.py. > > Note: All the components required (Firefox headless browser, Redis, Postgres db, celery worker and celery beat) are present in the dev docker image if you are following [Installing Superset Locally](https://superset.apache.org/docs/installation/docker-compose/). All you need to do is add the required config variables described in this guide (See Detailed Config). By the way I would recommend to make it works for csv or txt first and then moove to image -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
fzhan commented on issue #28686: URL: https://github.com/apache/superset/issues/28686#issuecomment-2128671264 @mujohiddin what does your celery status say? -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
dosubot[bot] commented on issue #28686:
URL: https://github.com/apache/superset/issues/28686#issuecomment-2128525374
To address the issue with the ALERT & REPORTS feature in your Superset
project, follow these steps:
1. **Check the `"ALERT_REPORTS"` Feature Flag**: Ensure it's enabled in your
`superset_config.py`:
```python
FEATURE_FLAGS = {
"ALERT_REPORTS": True
}
```
2. **Update Celery Beat Schedule**: Ensure you have a schedule for
`reports.scheduler` in your Celery configuration:
```python
from celery.schedules import crontab
class CeleryConfig:
beat_schedule = {
"reports.scheduler": {
"task": "reports.scheduler",
"schedule": crontab(minute="*", hour="*"),
},
"reports.prune_log": {
"task": "reports.prune_log",
"schedule": crontab(minute=0, hour=0),
},
}
CELERY_CONFIG = CeleryConfig
```
3. **Ensure Browser Installation for Screenshots**: Confirm a headless
browser is installed. For Chrome:
```python
WEBDRIVER_TYPE = "chrome"
WEBDRIVER_OPTION_ARGS = [
"--force-device-scale-factor=2.0",
"--high-dpi-support=2.0",
"--headless",
"--disable-gpu",
"--disable-dev-shm-usage",
"--no-sandbox",
"--disable-setuid-sandbox",
"--disable-extensions",
]
```
4. **SMTP or Slack Configuration**: Ensure your SMTP settings or
`SLACK_API_TOKEN` are correctly configured:
- **Slack**:
```python
SLACK_API_TOKEN = "xoxb-your-slack-token"
```
- **Email**:
```python
SMTP_HOST = "smtp.sendgrid.net"
SMTP_PORT = 2525
SMTP_USER = "your_user"
SMTP_PASSWORD = "your_password"
SMTP_MAIL_FROM = "nore...@youremail.com"
```
5. **Review Celery Worker and Beat Logs**: Examine the logs of your Celery
worker and beat for additional insights.
6. **Fix the "Failed to assign to property 'Path'" Error**: Ensure that the
properties being assigned are correctly defined and used. For example:
```tsx
const updateAlertState = (name: string, value: any) => {
setCurrentAlert(currentAlertData => ({
...currentAlertData,
[name]: value,
}));
};
const onPathChange = (event: React.ChangeEvent) => {
const { value } = event.target;
updateAlertState('path', value);
};
```
Ensure all configurations, especially those related to Celery, the headless
browser, and notification settings, are correct. For more detailed guidance,
refer to the [Superset
documentation](https://github.com/apache/superset/blob/master/docs/docs/configuration/alerts-reports.mdx)
[[1]](https://github.com/apache/superset/issues/28381)[[2]](https://github.com/apache/superset/issues/12794)[[3]](https://github.com/apache/superset/blob/master/docs/docs/configuration/alerts-reports.mdx).
Details
**About Dosu**
This response is meant to be useful and save you time. It is **not meant to
be a precise solution**, but rather a starting point for your own research.
Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is
irrelevant.
*To continue the conversation, 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-unsubscr...@superset.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
[I] Superset ALERT & REPORTS not working [superset]
mujohiddin opened a new issue, #28686: URL: https://github.com/apache/superset/issues/28686 ### Bug description Hello there. my project is last september version but i have problem with ALERT & REPORTS how to fix it. I don't know how to fix it. help me ### How to reproduce the bug 1 ### Screenshots/recordings  Could this be the cause of the problem? ### Superset version master / latest-dev ### Python version 3.9 ### Node version 16 ### Browser Chrome ### Additional context 1 ### Checklist - [ ] I have searched Superset docs and Slack and didn't find a solution to my problem. - [ ] I have searched the GitHub issue tracker and didn't find a similar bug report. - [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- 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-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mistercrunch commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2103870567 [mujohiddin](https://github.com/mujohiddin) ple -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mistercrunch closed issue #28381: Superset ALERT & REPORTS not working URL: https://github.com/apache/superset/issues/28381 -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
dpgaspar commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2100580042 seems like it's a `geckodriver` installation issue, take a look at: https://superset.apache.org/docs/configuration/alerts-reports#using-firefox -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2100183065 Hello sir, can you help me? @mistercrunch,@villebro,@michael-s-molina,@betodealmeida,@john-bodley @rusackas -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2100180552 @dpgaspar ![Uploading photo_2024-05-08_14-41-01.jpg…]() -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2100179965 ![Uploading photo_2024-05-08_14-41-01.jpg…]() -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2100178312 @dpgaspar  -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2100152421 > 2\. reports.scheduler where is<< reports.scheduler file -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
dosubot[bot] commented on issue #28381:
URL: https://github.com/apache/superset/issues/28381#issuecomment-2100022930
To address the issue with the ALERT manager not working in your 6-month-old
Superset installation, here are some targeted steps to help resolve the problem:
1. **Check the `"ALERT_REPORTS"` Feature Flag**: Make sure it's enabled in
your `superset_config.py`. This is essential for alert and report functionality.
```python
FEATURE_FLAGS = {
"ALERT_REPORTS": True
}
```
2. **Update Celery Beat Schedule**: Ensure you have a schedule for
`reports.scheduler` in your Celery configuration to enable alert and report
scheduling.
```python
beat_schedule = {
"reports.scheduler": {
"task": "reports.scheduler",
"schedule": crontab(minute="*", hour="*"),
},
"reports.prune_log": {
"task": "reports.prune_log",
"schedule": crontab(minute=0, hour=0),
},
}
```
3. **Ensure Browser Installation for Screenshots**: If not using a dev
docker image, confirm a headless browser is installed for screenshot
functionality. For Firefox, install `firefox-esr` and `geckodriver`; for
Chrome, `google-chrome-stable` and `chromedriver`.
4. **SMTP or Slack Configuration**: For notifications, ensure your SMTP
settings or `SLACK_API_TOKEN` are correctly configured.
- **Slack**:
```python
SLACK_API_TOKEN = "xoxb-your-slack-token"
```
- **Email**:
```python
SMTP_HOST = "smtp.sendgrid.net"
SMTP_PORT = 2525
SMTP_USER = "your_user"
SMTP_PASSWORD = "your_password"
SMTP_MAIL_FROM = "nore...@youremail.com"
```
5. **Review Celery Worker and Beat Logs**: For further troubleshooting,
examining the logs of your Celery worker and beat can provide additional
insights into any errors or issues.
Ensure all configurations, especially those related to Celery, the headless
browser, and notification settings, are correct. For more detailed guidance,
refer to the [Superset
documentation](https://github.com/apache/superset/blob/master/docs/docs/configuration/alerts-reports.mdx).
If after following these steps you're still facing issues, providing more
specific details about the errors or problems you're encountering, including
any error messages, would be helpful for further diagnosis.
Details
**Sources**
- [Issue with Alerts and Reports on
3.0.x](https://github.com/apache/superset/discussions/25858)
-
[docs/docs/configuration/alerts-reports.mdx](https://github.com/apache/superset/blob/master/docs/docs/configuration/alerts-reports.mdx)
-
[RELEASING/release-notes-0-38/README.md](https://github.com/apache/superset/blob/master/RELEASING/release-notes-0-38/README.md)
-
[CHANGELOG/3.0.0.md](https://github.com/apache/superset/blob/master/CHANGELOG/3.0.0.md)
-
[superset/commands/report/exceptions.py](https://github.com/apache/superset/blob/master/superset/commands/report/exceptions.py)
-
[RELEASING/release-notes-1-0/README.md](https://github.com/apache/superset/blob/master/RELEASING/release-notes-1-0/README.md)
**About Dosu**
This response is meant to be useful and save you time. It is **not meant to
be a precise solution**, but rather a starting point for your own research.
Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is
irrelevant.
*To continue the conversation, 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-unsubscr...@superset.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-200960 ![Uploading photo_2024-05-08_11-47-36.jpg…]() -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-200434  -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2099989964 ![Uploading photo_2024-05-08_11-48-01.jpg…]() -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2099985878 @dpgaspar Hi I have ALERT manager not working superset 6 months old version installed, is there any way to fix this? need to add more parameters? @mistercrunch,@villebro,@michael-s-molina,@betodealmeida,@john-bodley @rusackas -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
dpgaspar commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2099970702 @mujohiddin we use english as a common language on this repo, please add a detailed description for your issue and add server logs showing the alert and reports error(s) -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2099871217 Menda ALERT menejeri ishlamaydi superset 6 oy oldingi versiyasi o'rnatilgan, buni tuzatishning biron bir usuli bormi? qo'shimcha parametrlarni qo'shish kerakmi? @mistercrunch,@villebro,@michael-s-molina,@betodealmeida,@john-bodley @rusackas -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2099870078 ![Uploading photo_2024-05-08_11-48-01.jpg…]() -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2099867328 hi -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
mujohiddin commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2099866575 ![Uploading photo_2024-05-08_11-48-01.jpg…]() -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Superset ALERT & REPORTS not working [superset]
dosubot[bot] commented on issue #28381: URL: https://github.com/apache/superset/issues/28381#issuecomment-2099866670 Hey there @mujohiddin, long time no see! 😄 Your issue feels like a bit of deja vu, but in the best way possible. I'm diving into your alert and reports conundrum as we speak and will have some insights for you shortly. Hang tight! -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
[I] Superset ALERT & REPORTS not working [superset]
mujohiddin opened a new issue, #28381: URL: https://github.com/apache/superset/issues/28381 ### Bug description   ### How to reproduce the bug a ### Screenshots/recordings hi ### Superset version master / latest-dev ### Python version 3.9 ### Node version 16 ### Browser Chrome ### Additional context I have ALERT manager not working superset 6 months ago version installed, is there any way to fix this? need to add more parameters? @mistercrunch, @villebro, @michael-s-molina, @betodealmeida, @john-bodley @rusackas ### Checklist - [X] I have searched Superset docs and Slack and didn't find a solution to my problem. - [ ] I have searched the GitHub issue tracker and didn't find a similar bug report. - [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- 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-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
