Bug 181990 - Committer e-mail address change in Portal needs to be propagated elsewhere
Summary: Committer e-mail address change in Portal needs to be propagated elsewhere
Status: CLOSED FIXED
Alias: None
Product: Community
Classification: Eclipse Foundation
Component: Project Management & Portal (show other bugs)
Version: unspecified   Edit
Hardware: PC Linux
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Eclipse Webmaster CLA
QA Contact:
URL:
Whiteboard:
Keywords: bugday
Depends on:
Blocks:
 
Reported: 2007-04-11 13:55 EDT by Denis Roy CLA
Modified: 2009-10-29 19:25 EDT (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Denis Roy CLA 2007-04-11 13:55:30 EDT
From 176121 

When a committer changes their email address via the Portal, there are
other areas where this email address needs to be populated.  We previously enforced this manually, as a committer needed to contact the Foundation.

The committer's foundation-registered e-mail address must also match in Bugzilla, which will also cascade to IPZilla, and it must be updated in our LDAP directory for password reset and system e-mails.
Comment 1 Denis Roy CLA 2007-04-11 13:55:59 EDT
cc'ing Sharon
Comment 2 Bjorn Freeman-Benson CLA 2007-09-27 14:22:31 EDT
And it should update all the mailing list subscriptions.
Comment 3 Bjorn Freeman-Benson CLA 2007-09-27 14:26:48 EDT
added to IT request queue
Comment 4 Denis Roy CLA 2007-09-28 11:22:13 EDT
The drawback of this automation is that it will be easy for a committer to change employers without us ever knowing about it.  Most committers don't even know that they should tell us.

Currently, a red flag is raised when a committer :
a) asks us to change the e-mail address, as a result of an employer change
b) asks us for a password reset, as a result of not getting password warnings
c) has e-mail bounces, as a result of sending mail to the previous employer's address

I'm not sure if this is something we need to worry about or not.  I'm just putting it out there.
Comment 5 Bjorn Freeman-Benson CLA 2007-10-23 15:49:45 EDT
(In reply to comment #4)
> The drawback of this automation is that it will be easy for a committer to
> change employers without us ever knowing about it.  

When a committer changes their email address, they are asked if they have changed employers. If they say yes, Anne is notified and then she forwards the notification to Sharon, etc.  See the use-case:
https://dev.eclipse.org/portal/myfoundation/tests/swim.php?file=finished/change_personal_address_when_person_is_a_committer.txt

> I'm not sure if this is something we need to worry about or not.  I'm just
> putting it out there.

It (committers changing employers) is definitely something we should worry about, but I think the portal workflow already has it covered.
Comment 6 Denis Roy CLA 2007-10-23 15:58:40 EDT
Can you create a plaintext file (or append to a plaintext file) the list of old,new email addresses that need to be changed? I'll likely need to create a script/cronjob to update all the sources you mention.

My job will delete the plaintext list when it has completed its work.
Comment 7 Sharon Corbett CLA 2007-10-23 16:48:59 EDT
Is there a way to make the employer change step/question mandatory to be answered?

I receive the notifications on these changes and in at least one instance, this question was blank and I had to email the committer.

Thanks,
Sharon
Comment 8 Karl Matthias CLA 2007-11-01 13:10:28 EDT
(In reply to comment #6)
> Can you create a plaintext file (or append to a plaintext file) the list of
> old,new email addresses that need to be changed? I'll likely need to create a
> script/cronjob to update all the sources you mention.
> 
> My job will delete the plaintext list when it has completed its work.

Sure... the portal has direct access to the Foundation DB so it could change it there directly.  So what about perhaps using the Foundation DB change log to track email changes and have the cron job use that as the source of which things need to be updated?  We already write things to the ModLog so it should be no problem to add these when we update the Foundation DB.

(In reply to comment #7)
> Is there a way to make the employer change step/question mandatory to be
> answered?
> 
> I receive the notifications on these changes and in at least one instance, this
> question was blank and I had to email the committer.


Hmm, it's a required field (at least now it is).  Was this recently that you got one without this quetion being answered?
Comment 9 Sharon Corbett CLA 2007-11-01 13:18:12 EDT
October 24, 2007 was the date that I noticed for one committer - Sharon
Comment 10 Karl Matthias CLA 2007-11-01 15:37:18 EDT
(In reply to comment #9)
> October 24, 2007 was the date that I noticed for one committer - Sharon
> 

Is is possible that this person was not a committer?  That's the only case I can see where they wouldn't get a sentence included in the email to you.
Comment 11 Sharon Corbett CLA 2007-11-01 15:43:47 EDT
Nope - checked.  The person has been a committer for quite some time.
Comment 12 Denis Roy CLA 2007-11-01 16:53:51 EDT
(In reply to comment #8)
> So what about perhaps using the Foundation DB change log to
> track email changes and have the cron job use that as the source of which

Sounds good.  If I can query modlog for changes done yesterday where changetype = email, get the old value and set it to the current value in the person table, that would be great.
Comment 13 Bjorn Freeman-Benson CLA 2008-01-16 13:34:43 EST
I'm downgrading the priority on this because it doesn't appear important enough to us to be a P1.
Comment 14 Denis Roy CLA 2008-02-12 15:54:46 EST
I'm writing something now that will compare FoundationDB mail addresses with their LDAP counterparts.  For those that don't match, an email will be sent to webmaster cc SharonC.
Comment 15 Denis Roy CLA 2008-02-12 16:29:31 EST
DB -> LDAP mail addresses are now diffed and emailed nightly to both Sharon and webmaster so they can be synced up.

Committers need to sync their bugs account with the DB for access to IPZilla anyway, and the mailing lists are self-serve.  I honestly don't think there's more to do here.
Comment 16 Bjorn Freeman-Benson CLA 2008-02-17 20:27:06 EST
(In reply to comment #15)
> the mailing lists are self-serve.  

I think that from our customer's point of view (customers = committers), the mailing lists are just part of the service that we offer. It doesn't make sense - from a customer point of view - to have to change my email address in a dozen different places.  As a customer, I have a relationship with Eclipse and when I go to Eclipse and change my email address, I expect all those places that the email address is used to change as well.  It's the same when I go to amazon.com and change my email address: as a customer, I shouldn't care whether they have one back-end database or a dozen.

So I do think that we (the EMO) should update the mailing lists when someone changes their email address.
Comment 17 Karl Matthias CLA 2008-05-09 12:42:30 EDT
We now have a web API to let us update the mailing lists.
Comment 18 Eclipse Webmaster CLA 2009-05-11 14:22:47 EDT
It's been over a year, can we close this as fixed?

-M.
Comment 19 Karl Matthias CLA 2009-05-11 20:04:25 EDT
(In reply to comment #18)
> It's been over a year, can we close this as fixed?
> 
> -M.
> 

No sir.  This is still very much under consideration as it's desperately needed.
Comment 20 Karl Matthias CLA 2009-10-22 19:25:02 EDT
Ok, we now have bugs tracking the other issues, so closing.
Comment 21 Karl Matthias CLA 2009-10-29 19:25:15 EDT
Released or closed for STAGING_324.  Please see final comments for actual closure status.  This message does not imply that any action was taken that has not already been described.