TSL/SSL Mail Settings for Notifications
Problem Description
This article explains the option to setup SMTP email notifications for Dbvisit Replicate.
Solution
There are two options to set SMTP email notifications in Dbvisit Replicate:
Non encrypted SMTP using port 25If the non-encrypted SMTP option (MAILCFG_USE_SSL = NO
) is chosen, then ensure the port (MAILCFG_PORT
) is set to 25.SSL/TLS encrypted SMTP using port 465If SSL/TLS SMTP option (MAILCFG_USE_SSL = YES
) is chosen, then ensure the port (MAILCFG_PORT
) is set to 465.
The following settings are relevant to SMTP email notifications:
*.MAILCFG_SMTP_SERVER = smtp.gmail.com
*.MAILCFG_AUTH_USER = emaillogin@yourcompany.com
*.MAILCFG_PORT = 465
*.NOTIFY_ALL_EMAIL = dba@yourcompany.com
*.MAILCFG_FROM = replicate@dbvisit.com
*.NOTIFY_SUCCESS_EMAIL = dba@yourcompany.com
*.MAILCFG_AUTH_PASSWD = plaintextpassword
*.NOTIFY_ALERT_EMAIL = OFF
*.MAILCFG_USE_SSL = YES
Notes:
Gmail uses TSL/SSL, so for gmail set
MAILCFG_USE_SSL = YES
andMAILCFG_PORT = 465
If
MAILCFG_USE_SSL = YES
, thenMAILCFG_PORT
must be set to 465. Setting this to port 25 will result in an error.
Arjen Visser March 31, 2015 16:50