Issue Summary

Unable to setup email server from self hosted aws ami based redash

Technical details:

  • Redash Version: image: redash/redash:9.0.0-beta.b42121
  • Browser/OS:
  • How did you install Redash: aws ami with version 8 and then upgraded to 9.0.0 beta

My env file
PYTHONUNBUFFERED=0
REDASH_LOG_LEVEL=INFO
REDASH_REDIS_URL=redis://redis:6379/0
POSTGRES_PASSWORD=xxx
REDASH_COOKIE_SECRET=xx
REDASH_SECRET_KEY=xx
REDASH_DATABASE_URL=postgresql://postgres:xxx@postgres/postgres
REDASH_GOOGLE_CLIENT_ID=xxx
REDASH_GOOGLE_CLIENT_SECRET=xxx
REDASH_MAIL_SERVER=email-smtp.us-west-2.amazonaws.com
REDASH_MAIL_PORT=465
REDASH_MAIL_USERNAME=xxxx
REDASH_MAIL_PASSWORD=xxx
REDASH_MAIL_DEFAULT_SENDER=xxxx
REDASH_HOST=xxxxxx

I get this error
File “/usr/local/lib/python3.7/smtplib.py”, line 394, in getreply
raise SMTPServerDisconnected(“Connection unexpectedly closed”)
smtplib.SMTPServerDisconnected: Connection unexpectedly closed

I tested ses connectivity from server
openssl s_client -crlf -quiet -connect email-smtp.us-west-2.amazonaws.com:465
depth=2 C = US, O = Amazon, CN = Amazon Root CA 1
verify return:1
depth=1 C = US, O = Amazon, OU = Server CA 1B, CN = Amazon
verify return:1
depth=0 CN = email-smtp.us-west-2.amazonaws.com
verify return:1
220 email-smtp.amazonaws.com ESMTP SimpleEmailService-d-HYFW5BKG4 CO93WR41VHtFprZA1SJx
^C
Its all good
I also tried gmail smtp and see the same error

Any help will be great

thx

2 Likes