Connection refused while trying to send an email.

[cptalpdeniz]

While trying to send an email, I see that worker is throwing the following error:

[2023-11-29 07:24:29,748][PID:140][ERROR][rq.job.redash.tasks.general] job.func_name=redash.tasks.general.send_mail job.id=9c51922a-4d7b-48d2-8d3a-aa6bb0e48dd1 Failed sending message: admin invited you to join Redash
Traceback (most recent call last):
  File "/app/redash/tasks/general.py", line 60, in send_mail
    mail.send(message)
  File "/usr/local/lib/python3.7/site-packages/flask_mail.py", line 491, in send
    with self.connect() as connection:
  File "/usr/local/lib/python3.7/site-packages/flask_mail.py", line 144, in __enter__
    self.host = self.configure_host()
  File "/usr/local/lib/python3.7/site-packages/flask_mail.py", line 158, in configure_host
    host = smtplib.SMTP(self.mail.server, self.mail.port)
  File "/usr/local/lib/python3.7/smtplib.py", line 251, in __init__
    (code, msg) = self.connect(host, port)
  File "/usr/local/lib/python3.7/smtplib.py", line 336, in connect
    self.sock = self._get_socket(host, port, self.timeout)
  File "/usr/local/lib/python3.7/smtplib.py", line 307, in _get_socket
    self.source_address)
  File "/usr/local/lib/python3.7/socket.py", line 728, in create_connection
    raise err
  File "/usr/local/lib/python3.7/socket.py", line 716, in create_connection
    sock.connect(sa)
ConnectionRefusedError: [Errno 111] Connection refused

[masayuki038]

Hi @cptalpdeniz
Please check your mail settings (REDASH_MAIL_*) . https://redash.io/help/open-source/admin-guide/env-vars-settings

[cptalpdeniz]

Hello, I already had those settings in the .env file that is located in the /app folder and /app/redash before I built the image.

[masayuki038]

@cptalpdeniz If you still got ConnectionRefusedError even though you configured the mail settings, please check your network settings. I believe Redash raises this error when network packets don't reach your mail server.

[cptalpdeniz]

It was indeed an issue with the nginx missing from the docker-compose file. It did work after that. Thank you very much masayuki038