1524623 - Allow bugzilla to track email bounces and multiple addresses per account natively

Status: NEW

(bugzilla.mozilla.org :: Email Notifications, enhancement, P2)

Description

[Dylan Hardison [:dylan] (he/him)]

Big picture: I want to associate multiple email addresses with bugzilla accounts. By default everyone's login_name is added to this.

When we get bounces, we mark that against the email and we stop sending email to that address, but we let the user continue to login and do stuff, including attempt to unblock their email address.

This also gets us close to a world where a bugzilla login_name is not an email address

Plan for this:

• new table profile_emails, with fields:
  • user_id references profile (userid)
  • email_address varchar(255) not null
  • bounces INT NOT NULL DEFAULT 0
  • is_default BOOLEAN NOT NULL DEFAULT FALSE
  • is_verified BOOLEAN DEFAULT FALSE
  • is_bouncing BOOLEAN DEFAULT FALSE
• When sending email to a bugzilla account, we check if they have any profile_emails. If none, we use the profiles.login_name (as we currently do)
• But when sending an email, if there is a default entry in profile_emails we use that. If it is_bouncing, we don't send the email.
• When a user is browsing bugzilla, and their default email address is bouncing, we display a notification that allows them to fix the situation.

Comment 1

[David Lawrence [:dkl]]

(In reply to Dylan Hardison [:dylan] (he/him) from comment #0)

Big picture: I want to associate multiple email addresses with bugzilla accounts. By default everyone's login_name is added to this.

When we get bounces, we mark that against the email and we stop sending email to that address, but we let the user continue to login and do stuff, including attempt to unblock their email address.

This also gets us close to a world where a bugzilla login_name is not an email address

Plan for this:

• new table profile_emails, with fields:
  • user_id references profile (userid)
  • email_address varchar(255) not null
  • bounces INT NOT NULL DEFAULT 0
  • is_default BOOLEAN NOT NULL DEFAULT FALSE
  • is_verified BOOLEAN DEFAULT FALSE
  • is_bouncing BOOLEAN DEFAULT FALSE
• When sending email to a bugzilla account, we check if they have any profile_emails. If none, we use the profiles.login_name (as we currently do)
• But when sending an email, if there is a default entry in profile_emails we use that. If it is_bouncing, we don't send the email.
• When a user is browsing bugzilla, and their default email address is bouncing, we display a notification that allows them to fix the situation.

If a user has more than one email, and one of them is bouncing, do we pick another and try the email again? or do we just always stop if the default one is set to bouncing? Another option, if the primary is bouncing but a secondary one is not, do we make it the new primary?

dkl