Cannot Send Mail After Upgrading to 8.0 beta 2

[myonlylonely]

Issue Summary

After upgrading from 7.0 to 8.0 beta2, sending mail is broken.

Steps to Reproduce

After upgrading from 7.0 to 8.0 beta2, sending mail is broken. After I downgrade to 7.0, sending mail works again. Here is the result from send_test_mail command in 8.0 beta2.

[root@VMcentos redash]# docker-compose run --rm server manage send_test_mail
Starting redash_postgres_1 ... done
Starting redash_redis_1 ... done
Traceback (most recent call last):
File "/app/manage.py", line 9, in
manager()
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 716, in call
return self.main(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/flask/cli.py", line 380, in main
return AppGroup.main(self, *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 696, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 534, in invoke
return callback(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/flask/cli.py", line 257, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 534, in invoke
return callback(*args, **kwargs)
File "/app/redash/cli/init.py", line 72, in send_test_mail
body="Test message."))
File "/usr/local/lib/python2.7/site-packages/flask_mail.py", line 491, in send
with self.connect() as connection:
File "/usr/local/lib/python2.7/site-packages/flask_mail.py", line 144, in enter
self.host = self.configure_host()
File "/usr/local/lib/python2.7/site-packages/flask_mail.py", line 156, in configure_host
host = smtplib.SMTP_SSL(self.mail.server, self.mail.port)
File "/usr/local/lib/python2.7/smtplib.py", line 802, in init
SMTP.init(self, host, port, local_hostname, timeout)
File "/usr/local/lib/python2.7/smtplib.py", line 256, in init
(code, msg) = self.connect(host, port)
File "/usr/local/lib/python2.7/smtplib.py", line 317, in connect
self.sock = self._get_socket(host, port, self.timeout)
File "/usr/local/lib/python2.7/smtplib.py", line 808, in _get_socket
new_socket = ssl.wrap_socket(new_socket, self.keyfile, self.certfile)
File "/usr/local/lib/python2.7/ssl.py", line 931, in wrap_socket
ciphers=ciphers)
File "/usr/local/lib/python2.7/ssl.py", line 599, in init
self.do_handshake()
File "/usr/local/lib/python2.7/ssl.py", line 828, in do_handshake
self._sslobj.do_handshake()
ssl.SSLError: [SSL: UNSUPPORTED_PROTOCOL] unsupported protocol (_ssl.c:727)

Redash env file mail config:

REDASH_MAIL_SERVER=mail.XXXXXX.com
REDASH_MAIL_PORT=465
REDASH_MAIL_USE_TLS=false
REDASH_MAIL_USE_SSL=true
REDASH_MAIL_USERNAME=XXXX
REDASH_MAIL_PASSWORD=XXXX
REDASH_MAIL_DEFAULT_SENDER=[email protected]
REDASH_HOST=http://XXX.XXX.XXX.XXX

Technical details:

• Redash Version: 8.0 beta2
• Browser/OS: CentOS 7
• How did you install Redash: Docker