Bug 190571

Summary: please merge my email accounts
Product: Services Reporter: Eugene Grosbein <ports>
Component: Bug TrackerAssignee: Eitan Adler <eadler>
Status: Closed FIXED    
Severity: Affects Only Me CC: eadler
Priority: ---    
Version: unspecified   
Hardware: Any   
OS: Any   

Description Eugene Grosbein 2014-06-03 13:27:08 UTC
I contribute to the FreeBSD Project since 1999 by testing and sumbitting problem reports. Since then, I had many email addresses, some of them from mail domains that do not exist today.

GNATS makes it easy to list all my PRs with one search based on my surname:
http://www.freebsd.org/cgi/query-pr-summary.cgi?&text=Grosbein&closedtoo=on

bugs.freebsd.org cannot perform a search based on reporter's name, it can only search for reporter's email. That is a regression.
Comment 1 Eitan Adler freebsd_committer freebsd_triage 2014-06-04 05:29:43 UTC
So, 

this one is a bit odd.

You actually can search by name... but we did not import any real names.

To solve your issue the simplest solution is to 'merge' those accounts.  Doing so is possible, but requires me to run a script.

as a test of this solution, can you list which emails you'd like merged? 

note to others reading: can't promise to do this for everyone if too many people ask, but lets see what happens
Comment 3 Eitan Adler freebsd_committer freebsd_triage 2014-06-04 06:48:45 UTC
We will probably not import 'real names' from GNATS.  It is surprisingly complex.  One issue for example is what to do when the same email has multiple "names" associated with it.
Comment 4 Eitan Adler freebsd_committer freebsd_triage 2014-06-04 06:49:29 UTC
please give me a few days to deal with this.  There is a lot of fallout from the migration and I want to make sure to deal with everything :)
Comment 5 Eitan Adler freebsd_committer freebsd_triage 2014-06-05 04:18:57 UTC
For each user:

OK, records in the 'user_id' column of the 'email_setting' table
have been migrated to the new user account.
OK, records in the 'who' column of the 'cc' table
have been migrated to the new user account.
OK, records in the 'who' column of the 'cc' table
have been migrated to the new user account.
OK, records in the 'watcher' column of the 'watch' table
have been migrated to the new user account.
OK, records in the 'watched' column of the 'watch' table
have been migrated to the new user account.
OK, records in the 'watcher' column of the 'watch' table
have been migrated to the new user account.
OK, records in the 'watched' column of the 'watch' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'reports' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'component_cc' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'component_cc' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'tag' table
have been migrated to the new user account.
OK, records in the 'submitter_id' column of the 'attachments' table
have been migrated to the new user account.
OK, records in the 'who' column of the 'bugs_activity' table
have been migrated to the new user account.
OK, records in the 'setter_id' column of the 'flags' table
have been migrated to the new user account.
OK, records in the 'requestee_id' column of the 'flags' table
have been migrated to the new user account.
OK, records in the 'owner_userid' column of the 'whine_events' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'login_failure' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'audit_log' table
have been migrated to the new user account.
OK, records in the 'userid' column of the 'quips' table
have been migrated to the new user account.
OK, records in the 'userid' column of the 'namedqueries' table
have been migrated to the new user account.
OK, records in the 'userid' column of the 'namedqueries' table
have been migrated to the new user account.
OK, records in the 'mailto' column of the 'whine_schedules' table
have been migrated to the new user account.
Done.