Emails entered in SSO are not available in LP

Thanks for the bug report. There seems to be some inconsistency in the ways login.u.c, login.lp and lp itself handle emails. Here's an example:

I added an unverified email address to my login.u.c account

 * login.u.c: visible
 * login.lp: visible
 * lp itself: not visible

I deleted the email from login.u.c (which actually removes the data from the emailaddress table):

 * login.u.c: not visible
 * login.lp: visible
 * lp itself: not visible

There's obviously something not quite right here. It may be that the email remaining visible in login.lp is due to caching or replication lag. The emails never being visible in lp itself may also be caused by one of these but this obviously requires further investigation. We'll need to install all 3 apps locally and run a comprehensive test of all cases to identify the most likely source of these problems.

Emails created by the code that serves login.u.c don't get their EmailAddress.person set. That's why they don't show up in Launchpad.

To make matters worse, if you set that newly created email as your preferred one, your LP profile will become invalid because it will have no preferred email.

2 scripts are also needed:
One to delete the duplicate emails with as little impact on existing users.
Another to hook up entries in the lp_person table with the accounts created in SSO.

On Fri, 2010-03-05 at 19:27 +0000, Danny Tamez wrote:
> 2 scripts are also needed:
> One to delete the duplicate emails with as little impact on existing users.

This one is for a different bug, no? That one about mixed-case email
addresses...

> Another to hook up entries in the lp_person table with the accounts created in SSO.

I have one which does the latter already. It's at
https://wiki.canonical.com/InformationInfrastructure/OSA/LaunchpadProductionStatus but hasn't been executed yet.

--
Guilherme Salgado <email address hidden>

Thanks Guilherme - I've added a comment for the first script mentioned above to bug #523346

Can this be tested prior to staging? If so, how?

I think you'd have to query the database for a newly created email
address and verify that EmailAddress.person is set -- currently it
isn't.

Needs to be tested on staging in order to tie into lp staging to test for the cross platform breakage.

Steps to reproduce/test:
1. Go to http://www.guerrillamail.com/ and setup a temporary email address
2. Go to https://login.staging.ubuntu.com and log in with your canonical email address and password
3. Click on Add another email and enter your temporary guerillamail email address.
4 Click on Continue
5. Reload the http://www.guerrillamail.com/ page to get your verification email.
6. Click on the link to verify.
7. You'll see that the email has been verified.
8. Log in to https://login.staging.launchpad.net with your canonical email address and password
9. Expected behavior: Your guerilla.com temp email address is listed under your emails.

This mail shows up in staging correctly.

Continuing on from the adding an email account to an existing registered account.

The new account shows up in launchpad correctly also.

Confirming that all my SSO E-Mails are now available in LP.
Thanks!

Cleanup script has been run in production successfully.