SMTP Server Setup for Email Alerts with MariaDB Xpand

AWS SMTP Setup

To configure the Alerter within Xpand to use AWS SES:

  1. You need valid AWS SES credentials. These are not the same as your Amazon credentials but can be derived from them.

    See Obtaining Your Amazon SES SMTP Credentials.

  2. All email addresses provided to the Alerter must be verified by AWS SES. Providing even one unauthorized email prevents the Alerter from sending any alerts.

    See Verifying Email Addresses in Amazon SES.

  3. The source email must also be verified using step 2 above. By default it is noreply@mariadb.com. Email addresses used in the verification process are case sensitive. Use lower case for this address.

  4. Configure the Alerter with these SMTP parameters.

    Parameter Name

    Provide the following

    smtp_server

    email-smtp.eu-west-1.amazonaws.com

    smtp_port

    587

    smtp_username

    Use the AWS SES credentials obtained from step 1

    smtp_password

    Use the AWS SES credentials obtained from step 1

    smtp_security

    TLS

  5. Configure alerts_subscriptions.

    Insert verified email addresses from above per this sample:

    sql> INSERT INTO system.alerts_subscriptions VALUES ('smtp_verified_email@smtp_verified_domain_name.com');

    For additional information, see "Email Alerts for MariaDB Xpand".