Can't get ALERTS & REPORTS working. Error: Failed taking a screenshot Message: 'geckodriver' executable needs to be in PATH. about superset HOT 4 CLOSED

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:

   FEATURE_FLAGS = {
       "ALERT_REPORTS": True
   }

2. Update Celery Beat Schedule: Ensure you have a schedule for reports.scheduler in your Celery configuration:

   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:

   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:

     SLACK_API_TOKEN = "xoxb-your-slack-token"

   • Email:

     SMTP_HOST = "smtp.sendgrid.net"
     SMTP_PORT = 2525
     SMTP_USER = "your_user"
     SMTP_PASSWORD = "your_password"
     SMTP_MAIL_FROM = "[email protected]"

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:

   const updateAlertState = (name: string, value: any) => {
     setCurrentAlert(currentAlertData => ({
       ...currentAlertData,
       [name]: value,
     }));
   };
   
   const onPathChange = (event: React.ChangeEvent<HTMLInputElement>) => {
     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 ^[1][2][3].

To continue the conversation, mention @dosu.

from superset.

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. 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

from superset.

@mujohiddin what does your celery status say?

from superset.

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. #23057. It has also been addressed in the Slack chat that is open to the public.

from superset.