Bug #87976 MySQL Enterprise Monitor Email over SSL
Submitted: 4 Oct 2017 15:50 Modified: 5 Oct 2017 13:08
Reporter: Jason Miele Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor Severity:S4 (Feature request)
Version: OS:Linux
Assigned to: Edward Gilmore CPU Architecture:Any

[4 Oct 2017 15:50] Jason Miele
Description:
We have an alerts in MySQL Enterprise Monitor to send out an email.  However, the email can not connect to our SMTP server because our SMTP server requires email over SSL.  Please update the MySQL Enterprise Monitor to send email over SSL to an SMTP server.  

How to repeat:
We have an alerts in MySQL Enterprise Monitor to send out an email.  However, the email can not connect to our SMTP server because our SMTP server requires email over SSL.  Please update the MySQL Enterprise Monitor to send email over SSL to an SMTP server.  

Suggested fix:
Please update the MySQL Enterprise Monitor to send email to an SMTP server over SSL.
[5 Oct 2017 6:17] Mark Leith
MySQL Enterprise Monitor only sends email over SSL by default - you have to explicitly disable it, via the "Disable JavaMail TLS/SSL" option:

https://dev.mysql.com/doc/mysql-monitor/3.4/en/mem-event-handling-email-settings.html

If this is not enabled on your system you should open a Support issue, as there's something else that's an issue which they can help you track down.
[5 Oct 2017 12:30] Jason Miele
Ah, yes, it is correctly using SSL, however we get an error (and the MySQL Monitor Error message is vague).  Is there a way we can specify the port of the SMTP server.
[5 Oct 2017 12:39] Mark Leith
Just specify it in the "SMTP server" field as "hostname:port", i.e:

foo.oracle.com:4456

I'll get this clarified in the docs.
[5 Oct 2017 13:08] Edward Gilmore
Doc bug. Fixed. 
Thanks.