| 2011-10-24 18:21:45 |
Curtis Hovey |
bug |
|
|
added bug |
| 2011-10-24 18:23:56 |
Curtis Hovey |
launchpad: status |
New |
Triaged |
|
| 2011-10-24 18:23:58 |
Curtis Hovey |
launchpad: importance |
Undecided |
Critical |
|
| 2011-10-24 18:24:22 |
Curtis Hovey |
tags |
|
merge-deactivate openid regression users |
|
| 2011-11-10 12:16:49 |
Graham Binns |
launchpad: assignee |
|
Graham Binns (gmb) |
|
| 2011-11-11 14:21:23 |
Graham Binns |
launchpad: status |
Triaged |
In Progress |
|
| 2011-11-24 13:46:01 |
Graham Binns |
description |
This looks like bug 644824 (reopned?), though may also be bug 676964. In either case, openid are not matched correctly when the user logins in through SSO. Since both of these bugs were reported, the openididentifier table was created to store multiple ids for a user. Merge may not be dealing with the table correctly.
There have also been many cases where the email address table (used to lookup Persons) has a different account from the account in the person table. This should be an impossibility. Maybe there should be a constraint, or column should be dropped from person, (or less likely emailaddress)
From the original question:
One of our guys just recently merged two launchpad acounts into the account nati-ueno. The merge didn't go all the way through - there are times when the old openid gets referenced.
https://login.launchpad.net/+id/BBze6nw
https://login.launchpad.net/+id/X6dGn6P
X6dGn6P is the correct one. |
This looks like bug 644824 (reopned?), though may also be bug 676964. In either case, openid are not matched correctly when the user logins in through SSO. Since both of these bugs were reported, the openididentifier table was created to store multiple ids for a user. Merge may not be dealing with the table correctly.
There have also been many cases where the email address table (used to lookup Persons) has a different account from the account in the person table. This should be an impossibility. Maybe there should be a constraint, or column should be dropped from person, (or less likely emailaddress).
Notes from gmb, 2011-11-24:
- Dropping account from Person is prohibitively complex (see comments).
- Running the following query:
SELECT COUNT(*) FROM Person, EmailAddress WHERE
EmailAddress.person = Person.id AND
EmailAddress.account <> Person.account;
tells us that there are currently two Persons in the production DB whose Person.account
and EmailAddress.account don't match.
--
From the original question:
One of our guys just recently merged two launchpad acounts into the account nati-ueno. The merge didn't go all the way through - there are times when the old openid gets referenced.
https://login.launchpad.net/+id/BBze6nw
https://login.launchpad.net/+id/X6dGn6P
X6dGn6P is the correct one. |
|
| 2011-11-24 13:49:07 |
Graham Binns |
launchpad: status |
In Progress |
Triaged |
|
| 2012-01-05 21:01:30 |
Graham Binns |
launchpad: assignee |
Graham Binns (gmb) |
|
|
| 2012-02-07 17:38:20 |
Chris Johnston |
bug task added |
|
summit |
|
| 2012-02-07 17:38:30 |
Chris Johnston |
summit: status |
New |
Confirmed |
|
| 2012-02-07 17:38:47 |
Chris Johnston |
summit: importance |
Undecided |
Critical |
|
| 2012-02-14 18:24:35 |
James E. Blair |
bug task added |
|
openstack-ci |
|
| 2012-02-14 18:24:44 |
James E. Blair |
openstack-ci: status |
New |
Confirmed |
|
| 2012-02-14 18:25:04 |
James E. Blair |
openstack-ci: importance |
Undecided |
Critical |
|
| 2012-02-14 18:49:31 |
Michael Hall |
bug task added |
|
canonical-identity-provider |
|
| 2012-03-13 16:05:16 |
Chris Johnston |
bug task added |
|
loco-team-portal |
|
| 2012-03-13 16:05:25 |
Chris Johnston |
loco-team-portal: status |
New |
Confirmed |
|
| 2012-03-13 16:05:29 |
Chris Johnston |
loco-team-portal: importance |
Undecided |
Critical |
|
| 2012-04-03 20:44:39 |
James E. Blair |
bug |
|
|
added subscriber James E. Blair |
| 2012-04-13 13:55:37 |
Ricardo Kirkner |
canonical-identity-provider: status |
New |
Confirmed |
|
| 2012-04-13 13:55:44 |
Ricardo Kirkner |
canonical-identity-provider: importance |
Undecided |
High |
|
| 2012-05-04 16:21:01 |
Steve McIntyre |
bug |
|
|
added subscriber Steve McIntyre |
| 2012-09-13 20:27:38 |
Curtis Hovey |
launchpad: importance |
Critical |
High |
|
| 2012-09-13 20:27:54 |
Curtis Hovey |
tags |
merge-deactivate openid regression users |
api merge-deactivate openid users |
|
| 2012-09-13 20:32:17 |
Curtis Hovey |
description |
This looks like bug 644824 (reopned?), though may also be bug 676964. In either case, openid are not matched correctly when the user logins in through SSO. Since both of these bugs were reported, the openididentifier table was created to store multiple ids for a user. Merge may not be dealing with the table correctly.
There have also been many cases where the email address table (used to lookup Persons) has a different account from the account in the person table. This should be an impossibility. Maybe there should be a constraint, or column should be dropped from person, (or less likely emailaddress).
Notes from gmb, 2011-11-24:
- Dropping account from Person is prohibitively complex (see comments).
- Running the following query:
SELECT COUNT(*) FROM Person, EmailAddress WHERE
EmailAddress.person = Person.id AND
EmailAddress.account <> Person.account;
tells us that there are currently two Persons in the production DB whose Person.account
and EmailAddress.account don't match.
--
From the original question:
One of our guys just recently merged two launchpad acounts into the account nati-ueno. The merge didn't go all the way through - there are times when the old openid gets referenced.
https://login.launchpad.net/+id/BBze6nw
https://login.launchpad.net/+id/X6dGn6P
X6dGn6P is the correct one. |
After users merge Launchpad profiles, they will have multiple OpenId Identifiers from Ubuntu's Single Signon Service. Users might be blocked from using external services because those services are not aware of, or cannot manage multiple identifies per user.
This bug originally described an issue where Launchpad user profiles were associated with a different set of addresses from their accounts. The fix was to never associate email addresses with accounts so that Launchpad is not confused about who the person is. |
|
| 2012-10-14 01:15:52 |
Monty Taylor |
bug task deleted |
openstack-ci |
|
|
| 2012-10-29 08:33:53 |
Ritesh Khadgaray |
bug |
|
|
added subscriber Ritesh Khadgaray |
| 2012-10-29 09:06:46 |
Anthony Wong |
bug |
|
|
added subscriber Anthony Wong |
| 2012-10-29 10:15:35 |
Thomas B. Rücker |
bug |
|
|
added subscriber Thomas B. Rücker |
| 2013-08-09 13:47:55 |
Monty Taylor |
removed subscriber Monty Taylor |
|
|
|
| 2013-08-27 23:18:29 |
Stefano Maffulli |
bug |
|
|
added subscriber Stefano Maffulli |
| 2017-05-15 13:51:41 |
Curtis Hovey |
removed subscriber Curtis Hovey |
|
|
|
| 2021-03-15 22:56:34 |
jace |
canonical-identity-provider: status |
Confirmed |
In Progress |
|
| 2021-03-15 22:56:38 |
jace |
launchpad: status |
Triaged |
Fix Released |
|
| 2021-03-15 22:56:45 |
jace |
loco-team-portal: status |
Confirmed |
Fix Released |
|
| 2021-03-15 22:56:51 |
jace |
summit: status |
Confirmed |
Fix Released |
|
| 2021-03-15 23:46:00 |
Colin Watson |
canonical-identity-provider: status |
In Progress |
Confirmed |
|
| 2021-03-15 23:46:03 |
Colin Watson |
launchpad: status |
Fix Released |
Triaged |
|
| 2021-03-15 23:46:56 |
Haw Loeung |
loco-team-portal: status |
Fix Released |
Confirmed |
|
| 2021-03-15 23:46:59 |
Haw Loeung |
summit: status |
Fix Released |
Confirmed |
|
